People seemed to like the Instance Viewer we built for version 4.1.
So we wanted to use similar technology (Java FX) to build a new interface for the Oracle Database Tuning Pack’s Real Time SQL Monitor.
So we did.
If you don’t have EM Express or Enterprise Manager available or handy, you can get the report in all it’s live, refreshing glory, in SQL Developer’s DBA Panel. It’s also on the Tools menu.
A Quick Demo
We sort the queries by run time, so the most recent, and currently running ones should be up top.
We also make the SQL in question easily accessible – and readable – by giving you the formatted SQL text on a mouse-hover bubble window.