AWR Formatter 1.6 Released
Posted by Tyler Muth on July 12, 2011
I made some minor updates to my previously released Google Chrome Extension called AWR Formatter. Enhancements include:
- Performance increased by 3x in rendering large AWR reports.
- Added new tabs to SQL Popup for Query Plan, Color SQL, and AWR SQL Report
The new options in the SQL Popup expose features of the AWR repository that I don’t think many people are aware of, but I think are really useful.
Installation
If you already have it installed, it should update automatically and the version will say 1.6. If you do not have it installed:
- 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.
I hope to add support for RAC reports soon…
Advertisement
karlarao said
Hi Tyler,
Can’t get hold of your email add.. but just a suggestion.. would be really nice if you can add an AAS column on the AWR Top Events.. just like what is shown here http://karlarao.tiddlyspot.com/#%5B%5BAAS%20investigation%5D%5D
That’s on the Top Events tab -> Top 5 Timed Foreground Events section of the AWR formatter..
BTW, the updates you’ve done when you click on the SQL TEXT is cool
-Karl
Tyler Muth said
Karl,
I have “DB Time per Second” and “DB Time per Second per CPU” on the “Overview” tab. Would you like those simply copied to the Top Events tab? Maybe with the reads & writes per second stats?
I should probably rename those AAS as I think the term is getting more prevalent.
Tyler
karlarao said
Hi Tyler,
Sorry for the confusion, on the Top Events tab -> Top 5 Timed Foreground Events section of the AWR formatter..
would be nice if you can add an AAS column similar to this.. http://goo.gl/DDOmI
- Karl
Kyle Hailey said
Impressed with the last version so definitely looking forward to checking this version out.
- Kyle Hailey
http://dboptimizer.com
Jigar Doshi said
It was awesome. It just got better. Keep it up.
Vengata said
Hi Tyler,
This is an amazing utility for the DBA who needs to get more and fast out of an AWR reports. Amazing work.
Thanks,
Venky.
MrShh said
Nice work.
But is there a bug with the unit cycler under Load Profile?
It converts the original value for Redo Size pr/second from 1,256,031.1 to 19,2GB ?? It gets the kB right but MB and GB seems wrong.
Am I missing something?
Thanks!
Tyler Muth said
Hmmm, might be. On leave right now but will look at it in a week or so. Thanks.
Amardeep Sidhu said
Tyler,
Great piece of work. Cheers !
One small question. Once i have formatted an AWR report, is there a way to go back to the original html display (ie remove the formatting) ?
I can do that by refreshing the page but is there any other better way ?
Tyler Muth said
Reload is the only way as I’m dramatically changing the HTML of the page. I should make this more clear.
PC said
I downloaded and installed the extension but when I open an AWR report, the extension does not do anything. I dont see any options to convert the report. What am I missing?
Thanks.
Tyler Muth said
See my reply to Nitin to see if that solves it.
PC said
Thanks Tyler. In my case, I think its 3. Will try and let you know. Thanks again.
cstmic said
Hi Tyler,
I downloaded and installed the extension but when I open an AWR report, the extension does not do anything. I dont see any options to convert the report. What am I missing?
Thanks In advance
km
Tyler Muth said
See my reply to Nitin below to see if that solves it.
cstmic said
Hi Tyler,
all works fine.
Many Thanks
km
Nitin said
I am facing same issue, is there anything diff that needs to be done after installation.
Tyler Muth said
Sorry you’re having problems with the extension. Here are a few hints:
1. It only works on local files, ie the URL you see in the bar must say file:///…
If you were to generate an AWR report from em using chrome and open it directly, I don’t think it will be a local file.
2. You have to enable local URL access using a checkbox under Tools > Extensions > AWR Formatter
3. You may need to restart Chrome. I’ve seen this in a few recent builds of Chrome. Odd.
Jerry said
Great tool! I noticed that sorting and filtering on numeric columns in the Top SQL Combined tab don’t work correctly when there’s a value with a comma, such as a total elapsed time of 1,257.73 seconds.
PC said
Thanks. After restarting chrome it works. Great tool!! Thanks again.
Damir said
Nice work!
binaryrage said
Tyler, awesome extension. I’d love to be able to dismiss popups by clicking back to the report, rather than clicking the x and I’ve noticed the table sorts seem wonky. Looking forward to the next version!
binaryrage said
Ah, I should have said: the sort problems occur when values are in millions, they sort out of order, and blank values should be sorted to the bottom of the table to regardless of an ascending or descending sort, the rows of interest are at the top of the table.
Matt said
Excellent tool. Thanks so much for making this utility.
If you plan to make future versions, then here are few features that can be very useful if incorporated:
1. Ability to merge and visualize multiple AWR reports.
2. Selective extraction of data into csvs. For instance, extracting only SQL and FileIO stats.