Oracle Database 11g: SQL Performance Management and Database Replay


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
Database Replay allows you to test the impact of a system change by replaying a real-world workload on a test system before it is exposed to a production system. This course demonstrates how to use Database Replay to capture and replay workloads to test the impact of a system change. It also explains how to use SQL Performance Analyzer to ascertain performance gains following a database change and to test the impact of proposed changes. Maintaining SQL performance by managing changes to optimizer statistics, using Automatic SQL Tuning to automate the SQL tuning process, and setting up SQL plan management are also covered.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.5

Lesson Objectives

Oracle Database 11g: SQL Performance Management and Database Replay

  • recognize the steps in the SQL Performance Analyzer process
  • recognize how to use the SQL Performance Analyzer with PL/SQL
  • recognize how to manage changes to optimizer statistics to maintain SQL performance
  • recognize how to use Automatic SQL Tuning to automate the SQL tuning process
  • recognize how to set up SQL plan management
  • seed SQL plan baselines from SQL Performance Analyzer in a given scenario
  • recognize the steps in using Database Replay to test the impact of a system change
  • recognize how to use the Enterprise Manager to capture workloads
  • recognize how to replay workloads using the Enterprise Manager
  • recognize how to use PL/SQL to capture and replay workloads

    • Course Number:
    od_odpt_a05_it_enus