Using the dynamic runtime instrumentation tools architecture (DRITA) v16

The Dynamic Runtime Instrumentation Tools Architecture (DRITA) enables a DBA to query catalog views to determine the wait events that affect the performance of individual sessions or the whole system. DRITA records the number of times each event occurs as well as the time spent waiting. You can use this information to diagnose performance problems.

DRITA compares snapshots to evaluate the performance of a system. A snapshot is a saved set of system performance data at a given point in time. A unique ID number identifies each snapshot. You can use snapshot ID numbers with DRITA reporting functions to return system performance statistics. DRITA consumes minimal system resources.

Taking a snapshot

Describes how to take a snapshot of system performance data

Using DRITA functions

Describes how to use DRITA functions to gather wait information and manage snapshots

Performance tuning recommendations

Explains how to review DRITA reports for performance tuning recommendations

Simulating Statspack AWR reports

Describes how to use DRITA functions to simulate Oracle Statspack Automatic Workload Repository (AWR) reports