Course Details

Previous Page

Oracle 12c Performance Tuning: Performance Tuning Summary

Target Audience
Expected Duration
Lesson Objectives
Course Number

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


Expected Duration (hours)

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: