Posted by Tyler Muth on April 20, 2011
It will not tune your database nor end world hunger, it just makes AWRs a lot easier to read. I did attempt to make some “observations”, but I certainly want to be careful with these. Currently it works with 10.2+ (maybe 10.1) single-node reports. It does not work on RAC / Global reports or on compare period reports but I’m going to start on those soon.
Thanks to Tom Kyte, Graham Wood, Robert Freeman and Tom Roach for your contributions.
- Open this URL in Google Chrome: http://dl.dropbox.com/u/4131944/AWR-Format/AWR-Format.crx
- Choose “Install”
- Go to Tools > Extensions and check the “Allow access to file URLs” box. This is critical as it only works on local files.
Features (screencast at the end)
- “Smart Text” conversion of gets / reads / bytes to KB / MB / GB / TB. You can click the orange text to cycle through these units
- Medium size tables are sortable
- Large tables are searchable
- All documented wait events are “hot” and local definitions are included
- Nicely formatted SQL Full text popup
- Combined view of key Top SQL sections
- “Observations” including:
- Time period of AWR > 60 minutes
- Hidden / undocumented parameter use
- Highlight memory recommendations from AWR
- Link to MOS note for “PX” events
- Link to documentation for ”gc” events
- I/O Graphs of tablespace activity
- Updates to the extension are delivered automatically as I release new versions
- I am not collecting any data or sending any data to myself or anywhere else. You can review the code anytime via the instructions in the last paragraph