AWR Formatter
Posted by Tyler Muth on April 20, 2011
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
David Mann said
Fantastic idea. Lots of usability features that will help keep my eyes from crossing while scouring AWR reports. Can’t wait to check this out.
Niall Litchfield said
Excellent work Tyler. I have a couple of observations
First – it turned my laptop into an Exadata box, which is nice but unlikely. It appears that on 11.2.0.2 on windows at least cellInterconnectBytes gets populated for non exadata databases (I have a vague memory that this might be a known bug).
Second it would be nice to exclude the findings about hidden parameters that take their default values – i.e are not user set, again 11.2.0.2 on windows.
very nice work though.
Geoff Grandstaff said
Thanks and nice work, Tyler. Going to test it out now.
» Best Oracle Peformance Tools? said
[…] awr formatter – firefox plugin for AWR browsing – see screencast […]
Coskan Gundogar said
great work thanks for sharing with community.
orawiss said
Hello Tyler,
Thanks so much! But, do you think the plugin will work on Fedora Linux for me?
Best reagards,
Wissem
orawiss said
It’s fedora 14.
Tom said
I use it on Ubuntu/Chrome so can’t imagine why it wouldn’t work on Fedora. Just make sure you go to “Wrench>Tools>Extension” to enable local file access for the plugin.
It works for me on Linux and should work for you.
orawiss said
Thank you Tom, I will try it.
Cheers,
Wissem
orawiss said
After installation of google chrome, I received an error “google chrome error Invalid value for permissions[1]” When installing the plugin.
After updating Google chrome with the command “yum update google-chrome” as a root, the installation of the plugin works perfectly.
Thanks
Jishar said
Great tool…keep it up…Good work.
Can you let me know once the tool ready for RAC.
email id: jisharibrahim@gmail.com
Donat Callens said
Hi,
For a neat trick to convert bytes information into KB, MB… up to YB, please refer to my following (updated) blog post:
http://raptorreports.blogspot.com/2010/07/bytes-converter-sql-to-convert-bytes-to.html
it is pure SQL and easy to integrate into your existing SQL reports. I make extensive use of it in mine.
Donat
Tyler Muth said
@Donat,
While you have come up with a creative solution for SQL, unfortunately this plugin doesn’t use any SQL at all. It’s 100% JavaScript (with jQuery).
Regards,
Tyler
Tyler Muth said
Updated yesterday and today (1.2 > 1.3 > 1.4). Added CSV Export (needed for a current project) and enqueue wait definitions (took ~3 minutes thanks to previous design decision + this post: http://venzi.wordpress.com/2010/12/10/oracle-11gr2-enqueue-waits to find the definitions.
Enjoy!
Tyler
Timur Akhmadeev said
Hi Tyler,
thank you for this awesome tool. I’ve been using it for a week now and all I can say is why nobody didn’t this earlier. Thanks a lot and please keep it going.
Jan Schnackenberg said
This is wonderful. Just by a quick test with an old AWR Report on my disk I was amazed by how much easier I would have come to the same conclusion, had this tool been available when I needed to analyze this report.
Thanks for your work!
Jigar said
Awesome!! Very useful. Thanks a lot.
Alberto said
Great tool, very very useful…thanks a lot.
Nitin said
Hi tyler,
i am unable to install that extension .
I am getting following error .
” Invalid value for ‘Permission[1]’ “
orawiss said
Please see my comment above “After updating Google chrome with the command “yum update google-chrome” as a root, the installation of the plugin works perfectly.
“
orawiss said
Please see my comment above “After updating Google chrome with the command “yum update google-chrome” as a root, the installation of the plugin works perfectly.
“
Wissem
Amardeep Sidhu said
Very very useful stuff. Thanks 🙂
Senthil said
Great Work! Any plans to make this plug-in available for other browsers like IE and FireFox?
Senthil
Tom said
The plugin source code is available and you can create a plugin for those with this. It probably won’t be as easy as Google Chrome. In addition I doubt it will perform as well as Google Chrome because of how well it handles javascript.
Tom said
Meant FF and IE doesn’t handle javascript as well (fast) as Chrome does.
AWR Made Easy « Oracle Database 101 said
[…] the opportunity a while ago to meet Tyler Muth and he really knows his stuff. He recently made a Chrome plugin that makes reading and filtering AWR reports a breeze. Highly recommend […]
Hazem Adel said
This is really useful, great work.
Uwe Hesse said
Thank you very much, Tyler, for this useful tool! As Timur said already: Wonder why nobody did that earlier. Keep up the good work!
enrique Ortiz said
very cool , it explains awr concepts easy !!!!!
Arun Gupta said
Thanks Tyler for this great utility. I have noticed an issue.
01. Open AWR report in a tab.
02. Open a second tab and navigate to any website.
03. Go back to AWR report tab.
04. The formatting is completely messed up.
05. I have to close the second tab and reformat report.
Since no one else has reported this, I am not sure if it is something specific to my desktop. Chrome version 11.0.696.71 running on Windows XP.
Arun Gupta said
Please ignore the issue. It seems Chrome doesn’t play well with firewalls and proxy authentication.
oraculix said
This
is
AWESOME!
I liked it when I first checked it out shortly after you posted it. Today I gave it a longer try for an in-depth analysis of a busy DWH and started to love how it rids me from scrolling up and down the reports all the time.
Thank you for your great efforts, Tyler!
Darius Zanganeh said
This is awesome
AWR Formatter 1.6 Released « Tyler Muth’s Blog said
[…] AWR Formatter […]
Suv said
This is ultimeto :-)…Going to do some more experiments with the tool !
agleite said
Hi Tyler,
thank you for this awesome tool. Thanks for sharing with community.
Alessandro
Blog Flávio Soares » AWR Formatter said
[…] no próprio site do Tyler como instalar e configurar: https://tylermuth.wordpress.com/2011/04/20/awr-formatter/ Share this:FacebookEmailPrint análise de awr, awr, awr formatter, formato awr, oracle Address: […]
Joe Khoo said
Excellent tool and thanks for sharing this with the community.
This reminds me of the guy who create the NMON Analyzer thingy.
We’ll probably see this as one of the staple tools for many DBAs. At least I am gonna make sure those from by company will start using this.
May I ask, how many hours actually went into the creation of this thing?
Just an idea, how about expanding this so that it can summarize the details from several AWR reports?
Or making it a community project kind of thing?
wordpress business themes,best wordpress business themes,business themes wordpress said
wordpress business themes,best wordpress business themes,business themes wordpress…
[…]AWR Formatter « Tyler Muth’s Blog[…]…
Chris said
Need additional places to download the plug-in. Dropbox is blocked by most corporations.
AWR Formatting. « Oracle Mine…. said
[…] https://tylermuth.wordpress.com/2011/04/20/awr-formatter/ […]
Musikdemos MP3 - AT Ambient,Chill,Goa,Trance - Index said
[…] Druckansicht […]
database services said
Very nice tool to work with … thanks for sharing
sandeep said
How about for the latest Chrome?
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…
Venkatesh Naicker said
Hi Tyler, did you get a chance to upload the extension into chrome web store. If yes, what’s the name of the extension? Thanks!
joao said
Great tool, I have a doubt.
In the video appears the example of units “Physical reads – Per second” …
the original value is 206,326.4 but translated to GB appears 3,380,402,585.6.
Why? Should not to be 0,0002 GB?
What did I lose?
Sorry my bad english
http://dboptimizer.com/tools-2/ | xfang said
[…] Check out the AWR formatter plugin for Chrome: https://tylermuth.wordpress.com/2011/04/20/awr-formatter/ […]
Dana Day said
AWR Formatter is great. The value of the combined SQL “spreadsheet” should be a standard part of Oracle AWR reporting.
gram said
Hello
When i try to install AWR formatter, chrome returns thant plugin is not possible to install…..any ideas ?
thanks
gram said
it is ok know.
very nice plugin 🙂
thanks
regards
Shyam said
Tyler,
Very Handy plugin! Consolidated 360 view. Thank you!!
santa barbara curacao said
Whats up are using WordPress for your blog platform?
I’m new to the blog world but I’m trying to get started and set up my own.
Do you require any html coding expertise to make your own
blog? Any help would be greatly appreciated!
online form builder said
You may notice that the concept of compensation plan may seem to be common
in the networking industry. For professional web site builders
extra complex laptop software program for net design is needed.
Once safely at Thebes, though, the obelisks were brought to the temple at Karnak with much fanfare.
online form builder said
Make sure you put your keyword in the web page title,
first paragraph and once or twice in the main body. He knew the system well enough to not
pay many of his suppliers and sub-contractors, then would cover it up up by handing out fake lien releases
to make it look like they were paid. The specific combination
of reps, sets, exercises, and weight depends upon the desires of the body builder.
online Form generator said
You may notice that the concept of compensation plan
may seem to be common in the networking industry.
For professional web site builders extra complex laptop software program for
net design is needed. If a picture is worth a thousand words
then you can just image how much you will absorb
by browsing this site.
online form generator said
You may notice that the concept of compensation plan may seem to be common in the networking industry.
There are many web designers who charge huge amount of money to do
this job for you. Therefore it’s better to always do the intelligent point and take these tips.
Kyle Hailey » Best Oracle Performance Tools said
[…] awr formatter […]
Johnny said
My programmer is trying to persuade me to move to .net from PHP.
I have always disliked the idea because of the expenses. But he’s
tryiong none the less. I’ve been using Movable-type on a variety of websites for about a year
and am worried about switching to another platform. I have heard fantastic things
about blogengine.net. Is there a way I can transfer all my wordpress content into it?
Any help would be really appreciated!
Jan Schnackenberg (RTFMSnake) said
As much as I love this add-on, as of today it’s unusable for me, since chrome does not allow add-ons that aren’t in the app store.
Do you have any plans on updating this and getting it into the app-store?
Srinivas said
Not able to use this app any more as it is not part of app-store.
Please make this available as part of app-store.
Thanks
Ben said
I love this extentsion, but I’m not able anymore to use this in Chrome because it’s not part of app-store.
Any plans to make it available?
Thanks
Ben
Ana said
I also loved this extension and I’m no longer able to use it because it’s not in the app-store.
It would be awesome if you could add it to the app-store :).
Thanks,
Ana
Tyler Muth said
Thanks for all of the feedback on this plugin. In the short-term, I’ll either get it in the chrome store or offer another option (can’t elaborate now). There are also some very cool, long-term plans for the “spirit” of this plugin, but I really can’t elaborate on that and I will stress “long-term”. My schedule is full the beginning of next week but hopefully I’ll get a chance to work on this late next week. Thanks for your patience.
Tyler
steveski said
Thanks, I hope you get it in the web store soon. Your extension has become so useful I almost forgot how to read an unformatted awr report.
SteveSki
www.slideshare.net said
Good day cool website! Gentleman. Excellent. Great. I’m going to take note of your web site and also use the rss feeds also? We are happy to search out plenty of useful information and facts right here in the send, you want workout a lot more techniques this particular reverence, many thanks for spreading.
Create Website said
First of all I would like to say wonderful blog! I had a quick question that I’d like to ask if you don’t mind. I was interested to find out how you center yourself and clear your head before writing. I’ve had difficulty clearing my mind in getting my thoughts out. I do take pleasure in writing but it just seems like the first 10 to 15 minutes are usually lost just trying to figure out how to begin. Any suggestions or tips? Kudos! All tips and triks to creat a WordPress Blog or website can see here 4buildwebsite.blogspot.com.
AWR Formatter Tool | my experiences with Oracle! said
[…] https://tylermuth.wordpress.com/2011/04/20/awr-formatter/ […]
http://www.nailsalonmanhattan.com said
I was wondering if you ever thought of changing the layout of your site?
Its very well written; I love what youve got to
say. But maybe you could a little more in the way of content so people could connect with it better.
Youve got an awful lot of text for only having one or 2 images.
Maybe you could space it out better?
html text editor said
It’s awesome to paay a visit this site and reading
the views oof all friends regarding this article, while I am also keen of getting know-how.
costumes costumes said
Thanks for sharing your thoughts about precious gifts.
Regards
muscle revolution pro amazon said
I’m gone to convey my little brother, that he should also pay a visit this weblog on regular basis to get updated from most up-to-date news.
Addict Him To You Mirabelle Summers said
I know all you racists wish to keep away from the race card however this case is principally a he mentioned – they mentioned” scenario.
I do know in your coronary heart you racists need this killing to be
justified but the facts aren’t in your side. You only get residue once you shoot a gun.
Uwe M. Küchler said
Oh, Righteous Indignation SPAM? Now that’s something new… 😉
Perhaps Bill Hicks saw that one coming: http://youtu.be/J14O05N4g2A
Lovie Waska said
Hi my friend! I wish to say that this article is awesome, nice written and include approximately
all vital infos. I would like to see more posts like this.
Weligton Pinto said
I am trying to install using Chrome version 39.0.2171.95 (64-bit), and a fail showed to me “Package is invalid. Details: ‘Could not load icon ‘icon.png’ for browser action Reload or Close”. I did not get success to install awr format. some one Could help me on that ? I will be very thank full.
Thanks in Advanced,
Wp
Jack said
I have the same problem. AWR Formater is very useful utility so every inconvenience created by google is very annoying.
Jack said
@Weligton Pinto you could install Chrome Canary (any version even the newest) and you could install any extension and use it.
Someone said
IT’s not true, I tried chrome canary as well and it kept on failing with same error Package is invalid. Details: ‘Could not load icon ‘icon.png’
Did anyone try recently installing this extension? Any help would be appreciated to figure out how to install this extension on chrome.
DB said
What is the status of the version for Oracle RAC?
Dave Herrington said
Thanks for sharing this, Tyler. Very useful!
Also, Chrome has made it more difficult to install your plugin, but there is a way, described here: https://support.google.com/chrome_webstore/answer/2664769?p=crx_warning&rd=1. The instructions are hidden under “(+) Steps on adding extensions from other websites”.
-Dave H. at RhinoSource
cash advance payday loan said
cash advance payday loan
AWR Formatter « Tyler Muths Blog
own design t-shirt printing said
Quality articles or reviews is the key to be a focus for the
viewers to pay a visit the site, that’s what this website is providing.
Aastha said
Hi Tyler
How can we install in firefox or safari
Aastha
mira cámaras deportivas para deportes extremos muy baratas said
mira cámaras deportivas para deportes extremos muy baratas
AWR Formatter « Tyler Muths Blog
chandra said
Hi Sir,
i am not able to install AWR formatter in Google Chrome.
Could please give the steps anyone.
Jan Schnackenberg said
The current version of Chrome does not allow you to simply install extensions. Even the workaround to use drag and drop from a local filesystem will not work anymore. You need a chrome installation from the developer series for this.
chandra said
How and where to download sir?
Thiago Zerbinato said
Hi guys … any solution for “Package is invalid. Details: ‘Could not load icon ‘icon.png’ for browser action Reload or Close” ? Thank you !
Bruno Costa said
Same problem here…
Thiago Zerbinato said
December 15, 2015 at 7:08 am
Hi guys … any solution for “Package is invalid. Details: ‘Could not load icon ‘icon.png’ for browser action Reload or Close” ? Thank you !
Reply
locuto said
Hi,
It works in Opera browser. You only needs check “allow in private mode”.
Regards,
Kristen said
I’ve been surfing online more than 3 hours as of late, but I never found any interesting article like yours.
It is lovely price sufficient for me. In my opinion, if all
website owners and bloggers made just right content as you
did, the web shall be much more useful than ever before.
Anjul said
Thanks Tyler for the great plugin. I have modified a little bit (added manifest_version=2 in the manifest.json file) to get it working in latest Chrome version.
thiagomz said
Could you release this version ?
Mario said
Could you release this new version?
cracked seo tools said
Asking questions are genuinely pleasant thing if you are not understanding something fully, however this piece
of writing offers nice understanding even.
George Zhou said
the link doesn’t work anymore? https://tylermuth.wordpress.com/category/oracle/awr/
George Zhou said
https://dl.dropbox.com/u/4131944/AWR-Format/AWR-Format.crx not working