Real-Time SQL Monitoring got a lot of air-time when it was released in 11g. I remember being wowed in a number of presentations. What I had failed to notice until recently was a quite interesting update in 11gR2. Previously, the reports always looked a lot prettier in Enterprise Manager than they did in the HTML reports produced by the DBMS_SQLTUNE package. In 11gR2, the introduction of an ACTIVE report means you can now get the EM-style report using the DBMS_SQLTUNE package. Of course, if you are always using EM to look at your SQL monitoring reports, this change is of little value, but if you are using DBMS_SQLTUNE to generate the reports you may want to give it a try because the layout is definitely better. I’ve updated my article on the subject to reflect the changes in 11gR2.
- Real-Time SQL Monitoring using DBMS_SQLTUNE (REPORT_SQL_MONITOR, REPORT_SQL_MONITOR_LIST and REPORT_SQL_DETAIL)
Just goes to show, every time you open the manuals something pops out to make you realize how much you don’t know.