Oracle Version 11g Performance and Tuning for Database Administrators

    

Summary:
The Oracle version 11g Performance and Tuning for database administrators class provides the students with a detailed understanding of the methods that can be used to provide for the most effective performance of their Oracle version 11g relational database management systems. Students will be presented with numerous step by step procedures to implement in order to obtain the most efficient processing of the Oracle 11g server.

Duration:
5 days/Lecture & Lab

Audience:
This course is specifically recommended for database administrators who require an in-depth understanding of the means by which to tune their Oracle version 11g servers.

Topics:

• Oracle 11g architecture
• Managing tablespaces and schemas
• Tuning Oracle memory
• Using automatic memory management
• Monitoring with automatic statistics collection
• Managing automatic undo
• Automatic segment management
• The approach to tuning
• Evaluating system performance
• Measuring I/O performance
• Measuring instance performance
• Using the automatic workload repository
• Using the automatic database diagnostic monitor
• Using the sql advisors
• Cost based optimization processing
• Influencing the optimizer
• Improving SQL query optimizations
• Partitioned tables
• Compression techniques
• Materialized views
• SQL plan management
• Tracing tools and capabilities
• Results cache processing
• Flashback processing
• Grid technology features
• The oracle data pump utility

Prerequisites:
Students should have at least 3 months experience as an Oracle database administrator. Knowledge of Oracle version 10g is useful, but not required.

Last Update: May 23, 2012