The utilities listed below may or may not be applicable, depending on your database version, operating system, Oracle support agreement, and/or management packs licensed. While several of these were listed in the proactive section above, they are still applicable for use when diagnosing a performance problem. The GUI OEM console has both real-time and historical charting capabilities that are valuable for both proactive and reactive activities.
The utilities native to Oracle Database or located in $ORACLE_HOME
are as follows:
PL/SQL Profiler: Discovering which PL/SQL line takes the most time—
DBMS_PROFILER
STATSPACK: Snapshots (
spreport.sql
)—check out the Statspack section in this chapterEvents and Tracing: See the Tracing and Diagnostic Events Section
Error/Crash Issues: Automatic Diagnostic Repository, Support Workbench, Advisors, and Checkers