Real Time SQL Monitoring is more or less old news because it was build-in in Oracle version 11.1.0.6.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 11.1.0.7.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 >