Oracle Database 11g Release 2: Diagnosability Enhancements


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



Overview/Description
Oracle Database 11g Release 2 offers new diagnosability enhancements to help DBAs in diagnosing, resolving, and preventing problems. These new features include enhancements to problem and incident identification, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently diagnose issues and report problems to Oracle Support, as well as reducing damage and interruptions. This course discusses using Automatic Diagnostic Repository, creating and submitting Incident Packages to Oracle Support, running health checks and viewing the reports. It also demonstrates how to use SQL Repair Advisor and SQL Test Case Builder. This course is one of a series 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)
1.0

Lesson Objectives

Oracle Database 11g Release 2: Diagnosability Enhancements

  • identify the features of Automatic Diagnostic Repository
  • handle critical errors using Enterprise Manager Support Workbench
  • create User-Reported Problems
  • run database health checks
  • use SQL Repair Advisor
  • employ Oracle's improved diagnosis tools
  • Course Number:
    od_onft_a06_it_enus

    Expertise Level
    Intermediate