About this Course

In this course students will clearly define the various methodologies one can use to tune an Oracle Database. The course covers the various components of an Oracle Database where potential performance bottlenecks could occur and how to monitor and tune them.

Throughout the course, students experience hands-on exercises in tuning a database.

Audience Profile

Oracle Database Administrators (DBAs)

At Course Completion

Upon successful completion of this course, the student will be able to:

• Identify the potential performance bottlenecks in an Oracle database
• Understand which database parameters are important to performance
• Query various data dictionary and dynamic performance views for performance information
• Use various utilities to help diagnose database performance problems
• Understand and use the database advisors
• Set up an Oracle database for efficient performance

Prerequisites

OR5510 Oracle Database Administration or Oracle DBA experience.

Course Outline

• Database Tuning Overview
• Database Architecture
• Automatic Memory Management (AMM and ASMM)
• Tuning the Shared Pool
• Tuning the Buffer Cache
• Tuning PGA and Temporary Space
• Checkpoint and Redo Tuning
• Tuning Block Space Usage
• Statistics and Wait Events
• The Automatic Workload Repository (AWR) and the Advisory Framework
• Additional SQL Tuning Topics
• Miscellaneous Tuning Tips