Performance Tuning Oracle Database 11gR2

    

Summary:
This class is designed for the DBA, system administrator, developer, or technical consultant who wishes to learn how to tune Oracle databases on the Linux or UNIX operating systems for maximum performance. Students will become proficient in all aspects of Oracle database performance tuning. This includes database and instance tuning, and SQL tuning. The hardware and software interactions that affect Oracle database performance are also covered in this course and include tuning the operating system, Oracle I/O and storage area networks. Hands-on lab exercises will be used to reinforce key Oracle performance tuning concepts.

Duration:
4 Days/Lecture & Lab

Audience:
This class is designed for the DBA, system administrator, developer, or technical consultant who wishes to learn how to tune Oracle databases on the Linux or UNIX operating systems for maximum performance.

Topics:

• Overview of Oracle Database Performance Tuning
• Defining an Effective Tuning Strategy
• Linux Configuration and Tuning for Oracle
• Tuning SAN I/O for Oracle
• Diagnostic and Tuning Tools
• Oracle Memory Management
• Tuning the Oracle Shared Server
• Optimizing Sort Operations
• Using Resource Manager and Instance Caging (11gR2)
• SQL Statement Tuning
• Optimizer Operations
• Managing Statistics
• Using Oracle Blocks Efficiently
• Using Oracle Blocks Efficiently
• Using Oracle Data Storage Structures Efficiently
• Tuning Indexes
• Application Tuning
• Using Materialized Views
• Monitoring and Detecting Lock Contention
• Tuning Workshop
• Using OEM Grid Control for Performance Tuning

Prerequisites:
Successful completion of an Oracle Administration class and previous Oracle SQL training is recommended.

Last Update: May 22, 2013