Oracle - Course Details

OraDPerform11g Oracle Database 11g: Performance Tuning DBA Release 2

Oracle Course Description:
This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You'll then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them.
Learn To:
  • Describe Oracle tuning methodology.
  • Use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues.
  • Use database advisors to correct performance problems proactively.
  • Identify problem SQL statements & tune SQL performance problems.
  • Monitor the Instance Performance using Enterprise Manager.
  • Tune instance components, primarily using Instance parameters.
Oracle Course Duration:
5 Days Training
Oracle Course Target Audience:
Database Administrators,Support Engineer
Oracle Course Prerequisite:
None
Course Content:
  • Basic Tuning Tools

  • Using Automatic Workload Repository

  • Defining Problems

  • Using Metrics and Alerts

  • Using Baselines

  • Using AWR Based Tools

  • Monitoring an Application

  • Identifying Problem SQL Statements

  • Influencing the Optimizer

  • Using SQL Performance Analyzer

  • SQL Performance Management

  • Using Database Replay

  • Tuning the Shared Pool

  • Tuning the Buffer Cache

  • Tuning PGA and Temporary Space

  • Automatic Memory Management

  • Tuning Segment Space Usage

  • Tuning I/O