Course Details

Previous Page


Oracle 12c Performance Tuning: Performance Tuning Summary


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



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