Oracle Database 11g: Performance Tuning (Self-Study Course)

 

Who should attend

  • Database administrators
  • Technical consultants

Prerequisites

  • A general understanding of database administration
  • Skills and knowledge commensurate with Oracle’s Database 11g: Administration Workshop I and Workshop II, or equivalent experience

Product Description

  • Oracle Database 11g: Performance Tuning Methodology and Tools
    • Introduction to Performance Tuning in Oracle Database 11g
    • Performance Tuning Diagnostics and Tools in Oracle Database 11g
  • Oracle Database 11g: Using AWR and Defining Problems
    • Working with the Automatic Workload Repository (AWR)
    • Defining Problems in Oracle Database 11g
  • Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools and Services
    • Metrics, Alerts, Baselines and Thresholds in Oracle Database 11g
    • Using AWR-Based Tools
    • Configuring, Managing, and Implementing Services
  • Oracle Database 11g: Problem SQL Statements and Oracle Optimizer
    • Identifying Problem SQL Statements
    • Influencing the Oracle Query Optimizer
  • Oracle Database 11g: SQL Performance Management and Database Replay
    • Using SQL Performance Analyzer and SQL Performance Management
    • Using Database Replay
  • Oracle Database 11g: Shared Pool and Buffer Cache Tuning
    • Tuning the Buffer Cache
    • Using Automatic Memory Management
  • Oracle Database 11g: Tuning PGA, Temporary Space, and Automatic Memory Managemen
    • Tuning PGA and Temporary Space
    • Using Automatic Memory Management
  • Oracle Database 11g: Segment Space, I/O and Performance Tuning
    • Tuning Segment Space Usage
    • Tuning I/O and Performance Tuning

Price on request