Posts tagged Real-Time SQL Monitoring
Real Time SQL Monitoring is more or less old news because it was build-in in Oracle version 184.108.40.206.0. The documentation can be found in the OracleÂ® Database Performance Tuning Guide 11g Release 1 (11.1). To be exact in chapter 10, paragraph 4: Real-Time SQL Monitoring. Output in text or HTML was already available, but now with 220.127.116.11.0, it is also build-in in DB Console (your local OEM).
As said in the very nice and informative post from Greg Rahn, from the Real-World Performance group at Oracle Corporation, in his post: Oracle 11g: Real-Time SQL Monitoring Using DBMS_SQLTUNE.REPORT_SQL_MONITOR; You need to set some parameters to enable this feature + you will have to use a hint ,to actually show the outcome in your DB Console, in de SQL statement you want to monitor :
STATISTICS_LEVEL initialization parameter is either set to ALL or TYPICAL (the default value)
CONTROL_MANAGEMENT_PACK_ACCESS parameter must be set to DIAGNOSTIC+TUNING (the default value)
To enable monitoring on a statement you use the hint MONITOR in your statement and to disable this feature you can enforce no monitoring by using an explicit NO_MONITOR hint.
So if you now would use the hint More >