We introduced the Instance Viewer in v4.1.
We show you in real time what’s happening in your database.
To get there, open your DBA panel. Connect. Then go to the Database Status node.
Open the DBA panel. Lots of cool stuff here.
Storage bits are interesting, but maybe you’re more excited about the specific workload. So in version 4.2, we’ve added a Top SQL panel to the screen.
It auto-refreshes every few seconds, and you can sort it by several different performance metrics.
If you find a SQL you want to know more about, you can drill down into a report.
You can see the query, plan, and bind variables quite easily.
And if you’re so inclined and licensed, you can ask for a SQL Tuning Advisor report and drill into the run time history of the query to see what’s what (requires Tuning and Diagnostic packs respectively.)
You don’t need a blow-by-blow screenshot of this feature – it’s very easy to use. But I will throw in an animated GIF.
If the animation is slow to load, click on the picture.
Pretty colors, plus some interesting bits of data.
Add a Top SQL Report to SQLcl
It’s easy. View > Log > Statements. Grab our SQL. Throw it into ALIAS. Use the repeat command. Voila.
Oracle SQL Developer Tips and Tricks [CON6515] at 1:30 today will ALSO features new tips & tricks for SQLcl! pic.twitter.com/lSs5rKloJx
— SQLcl (@oraclesqlcl) September 21, 2016