Oracle Database 11g Release 2: Diagnosability Enhancements

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

Please contact us for information about prerequisites.

Expected Duration
60 minutes

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.


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





Multi-license discounts available for Annual and Monthly subscriptions.