AWR Formatter

I’ve found myself looking at a lot of AWR Reports lately and doing the same calculations on them over and over. Converting gets / reads / bytes to KB / MB / GB / TB, converting seconds to hours minutes and seconds, etc. So, I wrote a few lines (~25) of JavaScript (using jQuery) to do some of this math for me. Like many projects, it quickly grew and grew. So, 2,000+ lines of JavaScript later, I present to you a google chrome plugin I’ve creatively entitled “AWR Formatter”.

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.

Installation

• 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

You can watch a screencast of it in action here. If you need a “demo” AWR Report, you can download this report from an Exadata 1/4 rack. As always, feedback or enhancement requests are welcome. If you want to view the source, just change the file extension from .crx to .zip and unzip it.

About these ads