rtdatabaseopmonitoring
This is an old revision of the document!
Real-Time Database Operation Monitoring
Enabling
The default behaviour is for the database to start tracing an operation only if it is sufficiently expensive.
- SQL Statement that runs in parallel
- SQL Statement that takes more than 5 seconds of CPU or I/O time.
You can however override this by doing the following
- Using the /*+ MONITOR */ hint within any SQL statement
- Set FORCED_TRACKING attribute to Y when using the DBMS_SQL_MONITOR.BEGIN_OPERATION function.
rtdatabaseopmonitoring.1439973750.txt.gz · Last modified: 2025/03/08 22:23 (external edit)