Oracle Database 11g Release 2: Using Change Management Solutions


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Oracle Database 11g Release 2 is designed for data center environments that are rapidly evolving and changing to keep up with business demands, enabling DBAs to manage change effectively and efficiently. Oracle Database 11g Release 2 offers significant advances in the areas of automatic diagnostics, supportability, and change management. It can be expensive for organizations to evaluate and implement changes to their data center infrastructure, and Oracle addresses this issue with a collection of solutions under the umbrella of Change Management. These consist of SQL Performance Analyzer, SQL Plan Management, and Database Replay. This course identifies each of these change management solutions and demonstrates how to use them to analyze SQL statements, test upgrades, and capture and analyze workloads. It is one of a series of courses in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g Release 2: Using Change Management Solutions

  • identify the phases of the lifecycle of change management
  • recognize the features of SQL Performance Analyzer
  • use SQL Performance Analyzer to measure database performance
  • recognize the features of SQL Plan Management
  • migrate stored outlines to SQL Plan baselines
  • identify how Database Replay can capture and process a workload
  • identify the features of workload filters and replay analysis
  • identify how to use Database Replay
  • plan for and test the effectiveness of a change in data center infrastructure
  • Course Number:
    od_onft_a04_it_enus

    Expertise Level
    Intermediate