Tyler Muth’s Blog

Technology with a focus on Oracle, Application Express and Linux

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

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.

95 Responses to “AWR Formatter”

  1. 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.

  2. 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.

  3. […] awr formatter –  firefox plugin  for AWR browsing – see screencast […]

  4. great work thanks for sharing with community.

  5. orawiss said

    Hello Tyler,
    Thanks so much! But, do you think the plugin will work on Fedora Linux for me?

    Best reagards,
    Wissem

  6. orawiss said

    It’s fedora 14.

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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.

  12. 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!

  13. Jigar said

    Awesome!! Very useful. Thanks a lot.

  14. Alberto said

    Great tool, very very useful…thanks a lot.

  15. 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

  16. Very very useful stuff. Thanks🙂

  17. 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.

  18. […] 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 […]

  19. Hazem Adel said

    This is really useful, great work.

  20. 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!

  21. enrique Ortiz said

    very cool , it explains awr concepts easy !!!!!

  22. 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.

  23. 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!

  24. This is awesome

  25. […] AWR Formatter […]

  26. Suv said

    This is ultimeto :-)…Going to do some more experiments with the tool !

  27. agleite said

    Hi Tyler,

    thank you for this awesome tool. Thanks for sharing with community.

    Alessandro

  28. […] 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: […]

  29. 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?

  30. wordpress business themes,best wordpress business themes,business themes wordpress…

    […]AWR Formatter « Tyler Muth’s Blog[…]…

  31. Chris said

    Need additional places to download the plug-in. Dropbox is blocked by most corporations.

  32. […] https://tylermuth.wordpress.com/2011/04/20/awr-formatter/ […]

  33. […] Druckansicht […]

  34. Very nice tool to work with … thanks for sharing

  35. sandeep said

    How about for the latest Chrome?

  36. 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!

  37. 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

  38. […] Check out the AWR formatter plugin for Chrome: https://tylermuth.wordpress.com/2011/04/20/awr-formatter/ […]

  39. Dana Day said

    AWR Formatter is great. The value of the combined SQL “spreadsheet” should be a standard part of Oracle AWR reporting.

  40. gram said

    Hello

    When i try to install AWR formatter, chrome returns thant plugin is not possible to install…..any ideas ?

    thanks

  41. gram said

    it is ok know.
    very nice plugin🙂
    thanks
    regards

  42. Shyam said

    Tyler,
    Very Handy plugin! Consolidated 360 view. Thank you!!

  43. 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!

  44. 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.

  45. 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.

  46. 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.

  47. 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.

  48. […] awr formatter […]

  49. 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!

  50. 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?

  51. 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

  52. 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

  53. 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

  54. 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

  55. 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.

  56. 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.

  57. […] https://tylermuth.wordpress.com/2011/04/20/awr-formatter/ […]

  58. 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?

  59. 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.

  60. Thanks for sharing your thoughts about precious gifts.
    Regards

  61. 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.

  62. 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.

  63. 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.

  64. 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.

  65. DB said

    What is the status of the version for Oracle RAC?

  66. 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

  67. cash advance payday loan

    AWR Formatter « Tyler Muth’s Blog

  68. 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.

  69. Aastha said

    Hi Tyler

    How can we install in firefox or safari

    Aastha

  70. mira cámaras deportivas para deportes extremos muy baratas

    AWR Formatter « Tyler Muth’s Blog

  71. 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.

  72. 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 !

  73. 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

  74. locuto said

    Hi,

    It works in Opera browser. You only needs check “allow in private mode”.

    Regards,

  75. 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.

  76. 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.

  77. Asking questions are genuinely pleasant thing if you are not understanding something fully, however this piece
    of writing offers nice understanding even.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: