• 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 NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration