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.
Just goes to show, every time you open the manuals something pops out to make you realize how much you don’t know.
Cheers
Tim…
Yeah, this feature’s really nice if you don’t have OEM. You can also mail the reports to people and they get the same active view – very cool. Note it connects to Oracle to pick up widgets etc
Nice article about it here http://www.oracle.com/technetwork/database/focus-areas/manageability/sqlmonitor-084401.html?ssSourceSiteId=otncn
Hi.
It doesn’t have to download the widgets from Oracle every time. You can use local versions of them if you use the BASE_PATH parameter to say where they are locally.
Cheers
Tim…
By the way, I’ve added that link to the bottom of my article. Thanks for that.
Cheers
Tim…
It doesn’t have to download the widgets from Oracle every time. You can use local versions of them if you use the BASE_PATH parameter to say where they are locally.
Cool. I was thinking more of when you mail the reports to people who might never have any kind of Oracle software installed (they must exist, right? ;-)). That was the bit that initially impressed me most.
To be fair, I can’t ever imagine using a local installation of those files. I would not be using this from a machine without internet connectivity (I hope), and if I was I would revert to the HTML report. 🙂
Cheers
Tim…