Using the dynamic runtime instrumentation tools architecture (DRITA) v17
Deprecation
With the release of EPAS 17, the DRITA is being deprecated and will not be included in EPAS 18. This decision follows the introduction of EDB’s PWR and edb_wait_states extensions, which offer improved diagnostic capabilities compared to DRITA. These new extensions provide a diagnostic experience more closely aligned with Oracle’s AWR reports, making DRITA obsolete.
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