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 –
Click on said button, and I can see my Degree of Parallelism was DOWNGRADED TO 1!!!
Actually, it’s because of reason 354. You know these by heart, yes?
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.
And finally, the HTML now includes these (the Metrics Graphs) –
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.