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)
Learning Objectives
Using Automatic Memory Management
- 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)
Common Resolutions to CPU and Redo Waits
- 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
Resolutions to SGA and SQL Execution Waits
- 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
Practice: Using Automatic Memory Management
- configure automatic shared memory management