Oracle 12c Performance Tuning: Performance Tuning Summary Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description
This course concludes the overview of the SGA, focusing on the Automatic Memory Management feature. In this course, we'll examine a series of commonly occurring real-world performance problems, and the typical solutions for those scenarios. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064)
Target Audience
Database Administrators, Application Developers, Technical Consultants
Prerequisites
None
Expected Duration (hours)
1.4
Lesson Objectives Oracle 12c Performance Tuning: Performance Tuning Summary
start the course
describe the concepts of dynamic SGA and memory granules
describe parameters relevant to dynamic SGA and how to increase the size of a SGA component
distinguish between auto-tuned and manually tuned SGA parameters
enable, disable, and monitor Automatic Shared Memory Management (ASMM)
describe Automatic Memory Management (AMM) and how it differs from ASMM
enable and monitor Automatic Memory Management (AMM)
describe a general performance tuning methodology and common symptoms of performance issues
recognize common errors, their diagnosis, and solutions
diagnose and tune CPU-related waits
diagnose and tune redo-related waits
diagnose and tune waits related to the Redo Log
diagnose and tune waits related to the buffer cache
diagnose and tune waits related to the shared and large pools
identify best practices for creating and configuring tablespaces
diagnose and tune waits related to SQL execution
describe the concept of direct I/O and related waits
distinguish between automated and manual statistics gathering, and lock statistics on a table
configure automatic shared memory management
Course Number: od_pmte_a08_it_enus
Expertise Level
Intermediate