Oracle 12c Performance Tuning: Performance Tuning Summary

Database Administrators, Application Developers, Technical Consultants

Prerequisite
None

Expected Duration
83 minutes

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)

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.