With some excellent feedback from our friends on the In-Memory and Real World Performance tuning groups here, we made the following improvements to the SQL Monitoring interface in SQL Developer:

  • Availability of Other stats now indicated with a button on the report grid
  • In-memory stats available, shown in a different color and an expanded toolbar message
  • Columnar encodings stats from xml now included

And, because we knew we needed to, we got the Performance Charts added to the HTML report exports.

When we know there’s more information available, we indicate that with a little camera button –

When there’s more info available, we’ll mark it with that button highlighted above.

Click on said button, and I can see my Degree of Parallelism was DOWNGRADED TO 1!!!

downgrade reason: your query sucks!
Downgrade reason: your query sucks!

Actually, it’s because of reason 354. You know these by heart, yes?

Thanks Yasin for this query.

The query (as that’s not a fun one to type, and yeah x$ – you’ll need high privs to see this, but you already need high privs to run these reports, so hopefully it’s OK):

SELECT	qksxareasons,indx		
FROM	x$qksxa_reason		
WHERE	qksxareasons LIKE '%downgrade%';

Nicer, more complete HTML exports.

Now when you use the Save button, you have the option for HTML (no flash!), a screenshot, or the raw XML you need to do a transform. 99% of you will be fine with the HTML.

Pick your poison.

And finally, the HTML now includes these (the Metrics Graphs) –

Ta-da…again.

Remember folks – this feature requires the Tuning Pack.

I show you the features, but you need to know when/where you can use them. If in doubt, check with your Oracle account manager BEFORE you start running these reports.

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

3 Comments

  1. Do you think you’ll add a filter option the Realtime SQL monitor in the future?
    Standard filtering on user, status, duration, starttime and endtime would be nice and hopefully it might help performance.

    Best regards

  2. It’s a very cool feature but you may want to put the note about Tuning Pack requirement at the beginning. Many people will pull this up and follow step by step to see how it works and then they’d be responsible for the costs of using the Tuning Pack when Oracle comes in for an audit. Just my 2 cents.

    Still a cool feature – especially the reports.

    • thatjeffsmith

      The tool warns you when you open it for the first time. And I do bring this up, or try to, every time i show, demo, blog, video it. But yeah.

      Same thing could be said for partitions, compression, so many things.

Write A Comment