D79236 - Oracle Database 12c: Performance Management and Tuning

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.

Duration: 5.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training


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


  • Database Administrators
  • Data Warehouse Administrator


  • Oracle Database 12c R2: Administration Workshop Ed 3

Suggested Prerequisites:

  • Oracle Database 12c: Install and Upgrade Workshop



This course is not associated with any Certification.

Course Benefits

  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses


This training is the first step in mastering MySQL, the world’s most popular open source database.


P10380 - Oracle Database 18c: Administration Workshop


Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.


D83527 - Java SE 8 Fundamentals
Enquire Now
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy