Oracle Database 11g: Performance Tuning DBA (D50317)

Oracle Database 11g: Performance Tuning DBA (D50317)


Duration: 5 days

This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You’ll then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them.

Learn To:

  • Describe Oracle tuning methodology.
  • Use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues.
  • Use database advisors to correct performance problems proactively.
  • Identify problem SQL statements & tune SQL performance problems.
  • Monitor the Instance Performance using Enterprise Manager.
  • Tune instance components, primarily using Instance parameters.


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
Module 1: Introduction

Module 2: Monitoring With Basic Tools

Module 3: Using Automatic Workload Repository

Module 4: Identifying the Problem

Module 5: Identifying Problem SQL Statements

Module 6: Influencing the Optimizer

Module 7: SQL Plan Management

Module 8: Change Management

Module 9: Using Metrics and Alerts

Module 10: Using AWR Based Tools

Module 11: Monitoring an Application (Using Services)

Module 12: Baselines

Module 13: Tuning the Shared Pool

Module 14: Tuning the Buffer Cache

Module 15: Tuning PGA and Temporary Space

Module 16: Automatic Memory Management

Module 17: Tuning Block Space Usage

Module 18: Tuning I/O

Module 19: Performance Tuning: Summary

Module 20: Using Statspack
  • Oracle Database 11g: Administration Workshop I Release 2
  • Oracle Database 11g: Administration Workshop II Release 2
Course ID:

Show Schedule for: