Oracle Database 12c: Performance Management and Tuning (D79236)

Oracle Database 12c: Performance Management and Tuning (D79236)


Duration: 5 days

In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

  • Use the Oracle tuning methodology.
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues.
  • Use database advisors to proactively correct performance problems.
  • Identify and tune problem SQL statements.
  • Monitor instance performance by using Enterprise Manager.
  • Tune instance components.
  • Gain an understanding of the Oracle Database Cloud Service.


Upon completing this course, the learner will be able to meet these overall objectives:
  • Use the Oracle Database tuning methodology appropriate to the available tools
  • Utilize database advisors to proactively tune an Oracle Database Instance
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Diagnose and tune common SQL related performance problems
  • Diagnose and tune common Instance related performance problems
  • Use Enterprise Manager performance-related pages to monitor an Oracle Database
  • Gain an understanding of the Oracle Database Cloud Service
Module 1: Introduction

Module 2: Basic Tuning Diagnostics

Module 3: Using Automatic Workload Repository

Module 4: Defining the Scope of Performance Issues

Module 5: Using Metrics and Alerts

Module 6: Using Baselines

Module 7: Using AWR-Based Tools

Module 8: Real-Time Database Operation Monitoring

Module 9: Monitoring Applications

Module 10: Identifying Problem SQL Statements

Module 11: Influencing the Optimizer

Module 12: Reducing the Cost of SQL Operations

Module 13: Using SQL Performance Analyzer

Module 14: SQL Performance Management

Module 15: Using Database Replay

Module 16: Tuning the Shared Pool

Module 17: Tuning the Buffer Cache

Module 18: Tuning PGA and Temporary Space

Module 19: Automatic Memory

Module 20: Performance Tuning Summary with Waits

Module 21: Oracle Database Cloud Service: Overview

  • Oracle Database 12c R2: Administration Workshop Ed 3

Suggested Prerequisites:

  • Oracle Database 12c: Install and Upgrade Workshop
Course ID:

Show Schedule for: