Enterprise DBA Part 2: Performance and Tuning

Aims and Objectives
Understand steps for outlining a tuning methodology.
Use Oracle tools to diagnose performance problems.
Reconfigure file structures for performance and other considerations.
Identify and resolve I/O, data storage and database configuration problems.
Configure memory and disk resources to optimise sort operations.

Target Audiences
This course is intended for Network Administrators, Database Administrators, Technical Support Professionals, System Administrators, Application Developers and MIS Managers who are responsible for managing an Oracle8 or 8i Database.

Prerequisites
Delegates should have attended DBA1A (Enterprise DBA Part 1A: Architecture and Administration)

Course Content
Module 1: Oracle Performance Tuning Methodology
Module 2: Oracle Alert and Trace Files
Module 3: Utilities and Dynamic Performance Views
Module 4: Tuning the Shared Pool
Module 5: Tuning the Buffer Cache
Module 6: Tuning the Redo Log Buffer
Module 7: Database Configuration and I/O Issues
Module 8: Using Oracle Blocks Efficiently
Module 9: Optimising Sort Operations Rollback Segment Tuning
Module 10: Monitoring and Detecting Lock Contention
Module 11: SQL Issues and Tuning Considerations for Different Applications
Module 12: Managing Mixed Workload Overview
Module 13: Tuning with Oracle Expert
Module 14: Use a tuning methodology to diagnose and resolve performance tuning issues