• Online, Self-Paced
Course 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)

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


Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.