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.
- 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