rtdatabaseopmonitoring
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| rtdatabaseopmonitoring [2015/08/19 08:42] – z0hpvk | rtdatabaseopmonitoring [2025/03/08 22:24] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 8: | Line 8: | ||
| * Using the /*+ MONITOR */ hint within any SQL statement | * Using the /*+ MONITOR */ hint within any SQL statement | ||
| * Set FORCED_TRACKING attribute to Y when using the DBMS_SQL_MONITOR.BEGIN_OPERATION function. | * Set FORCED_TRACKING attribute to Y when using the DBMS_SQL_MONITOR.BEGIN_OPERATION function. | ||
| + | |||
| + | NOTE: The following 2 parameters must also be set (These are currently default in 12cR1) | ||
| + | * STATISTICS_LEVEL = TYPICAL (or ALL) | ||
| + | * CONTROL_MANAGEMENT_PACK_ACCESS = DIAGNOSTICS+TUNING | ||
| + | |||
| + | |||
rtdatabaseopmonitoring.1439973750.txt.gz · Last modified: 2025/03/08 22:23 (external edit)