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…
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.
I installed a Office Socket Solution with USB and Ethernet Ports to sort that untidy mess on my Desk said
I installed a Office Socket Solution with USB and Ethernet Ports to sort that untidy mess on my Desk…
[...]AWR Formatter 1.6 Released « Tyler Muth’s Blog[...]…
Raheel Syed said
Hi Tyler,
Awesome tool !!
Raheel Syed
linkin khalid said
Hi,
can not download the tool, is that it is possible to email it to me : linkin_khalid@yahoo.fr
linkin
James said
Hi,
I got following message while trying to install the extension. Could you add the app to the Chrome Web Store? Thanks.
Extensions, apps, and user scripts can only be added from the Chrome Web Store.
Timur Akhmadeev said
+1 here. I’ve reloaded work PC to Win 7 and need to install this excellent extension again. Thank you.
Tim said
I’m an oracle DBA and I personally endorse these comments.
Seriously though, I’d love to check it out!
Tyler Muth said
Direct installation of chrome extensions from 3rd party sites (not in the chrome store) was recently disabled by google to protect against malicious extensions. Here’s more information on the change: http://support.google.com/chrome_webstore/bin/answer.py?hl=en&answer=2664769&p=crx_warning
There is a workaround documented on that page:
1. Download the extension file from the website and save it to your computer.
2. Click the wrench icon on the browser toolbar.
3. Select Tools > Extensions.
4. Locate the extension file on your computer and drag the file onto the Extensions page.
5. Review the list of permissions in the dialog that appears. If you would like to proceed, click Install.
I understand and support this move by google in light of the security risks. I will work to get this extension into the chrome web store (for free) next week. I’ve had a few emails asking why I don’t charge for it. While appreciate the compliment, it’s my desire to provide this utility for free to make AWR a bit more approachable. I also have a new version in the works, but there are only so many hours in the day…
Kirill Loifman said
Hi Tyler,
Thanks for such a useful Plugin. It rocks!
Is there a big thing to port it for FireFox?
I think also that Observations section can be improved, and you can use your blog community for that.
As an example from me, I’ve got recently an AWR report with “Parse CPU to Parse Elapsd %: 0.00″ which indicates considerable resource contention while parsing.
Unfortunatelly your pluging did not pick this up.
For this particular issue you can add the following:
“Low Value for this ratio is an indicator of latching problem. Investigate the latch sections in AWR report for contention on library cache and shared pool latches.”
If you agree to implement further suggestion, I’ll share more of them here.
Thanks
– Kirill Loifman, dadbm.com
gram said
hello
Any issue ? or workaround ?
http://support.google.com/chrome_webstore/bin/answer.py?hl=en&answer=2664769&p=crx_warning
/
thanks
gram said
it is ok know.
very nice plugin
thanks
regards
syk said
Thx Very Much. It helps me a lot. Nice Job!
Kavita Dubey said
I cannot install the app. I get this error: ‘Apps, extensions, and user scripts cannot be added from this website.’ I am using Chrome.
Kavita Dubey said
I just saw the thread above to install it. I will follow that and get back.
Dana said
Tyler,
I’ve been using the AWR Formatter constantly since 1.6. I highly recommend Oracle make this a standard feature. The Top SQL Combined tab with the extra pop-ups for manipulating SQL_ID’s has been invaluable. When I think value add tools, this is the best. Well done!!