Reactive diagnostic and tracing tools
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 chapter - Events and Tracing: ...
Get Oracle Database 11g—Underground Advice for Database Administrators now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
