9 Managing Diagnostic Data

Beginning with Release 11g, Oracle Database includes an advanced fault diagnosability infrastructure for collecting and managing diagnostic data. Diagnostic data includes the trace files, dumps, and core files that are also present in previous releases, plus new types of diagnostic data that enable customers and Oracle Support to identify, investigate, track, and resolve problems quickly and effectively.

In this chapter:

• About the Oracle Database Fault Diagnosability Infrastructure

• Investigating, Reporting, and Resolving a Problem

• Viewing Problems with the Enterprise Manager Support Workbench

• Creating a User-Reported Problem

• Viewing the Alert Log

• Finding Trace Files

• Running Health Checks with Health Monitor

• Repairing SQL Failures with the SQL Repair Advisor

• Repairing Data Corruptions with the Data Recovery Advisor

• Creating, Editing, and Uploading Custom Incident Packages