AWR Formatter

Submitted by Oscar_Paredes on 11 June, 2011 - 13:06

Anyone who usually look at AWR performance reports to analyze Oracle performance problems, often have their own reading process and approach to all data that shows this report, but I always missed a tool that make easier reading all data.

 

I've found! "AWR Formatter" developed by the DBA Tyler Muth facilitates this reading. Fantastic, you must try.

 

AWR Formatter is an extension of Chrome (file with. Crx) free once installed in the browser, each time you view an AWR report in HTML, gives you the option to format to help you see all your information. Once formatted text, HTML is seen in browser in different tabs. Highlight the following features that gives you the added format:

  • Possibility of performing conversions dynamically KB / MB / GB / TB in the various indicators
  • Possibility of searching the meaning of a pending event, parameter, etc ... (this is really useful)
  • Formatted tables sortable, much like an Excel ...
  • Ability to view the text of the SQL command's ...

AWR Formatter

 

 

Overall, nothing compared to the large standard html file ... wonderful. You can download it free from the following link:

http://dl.dropbox.com/u/4131944/AWR-Format/AWR-Format.crx

 

A tab called "Observations", aims to give reading indications reading of the report, but it is a first approach, and of course, each DBA should follow it as their responsibility.

 

Hope you enjoy,

Oscar Paredes - oscar.paredes@dataprix.com

 

Hey thanks for the info. But

Submitted by aayesha189 on 14 October, 2011 - 09:22.

Hey thanks for the info. But you can add the more screenshots of awr. but happy to see this post.

Aayesha from Offshore Software Outsourcing

The AWR looks like a great

Submitted by lisa on 8 November, 2011 - 15:20.

The AWR looks like a great way to read all of your data and stored information.  Do you know if anyone has ever used AWR for ediscovery purposes? I really like the way that AWR presents the data.

I think It's going to have

Submitted by basson123 on 30 March, 2012 - 21:50.

I think It's going to have high impact on me, because before I couldn't be Dress Shop as active as I can now. I couldn't attend all LAN events I would liked to, Bride Dresses but now it's going to change. With Team Menace on my side, I can attend LAN events more often and have formal dress shop good motivation that helps me on my training sessions. Just knowing that I don't semi formal dress shop have to do all casual dresses the math that comes from travelling helps me a lot, so I can just relax and try my best.

Good post but you can

Submitted by stevensmith on 3 April, 2012 - 08:46.

Good post but you can ellobrate about awr formatter little more deep.

 

Steven Smith from iPhone Application Development

Giving Thanks

Submitted by RobartDisuza on 27 February, 2013 - 13:30.

This is a nice post for this extension which we can use in Chrome and also esasy to understand for me the AWR report as it's in HTML, thanks for this post. If you anyone ask about Android application development, Let me know.

 A tab called "Observations",

Submitted by roberttom432 on 23 April, 2013 - 02:25.

 A tab called "Observations", aims to give reading indications reading of the report, but it is a first approach, and of course, each DBA should follow it as their responsibility.

 

Cheap Air Tickets

Google
 
     

Similar entries

  • Oracle RAC One Node

    In Oracle 11g release 2, Oracle introduced a new product Oracle Real Application Clusters One Node (Oracle RAC One Node)

    This product is an Oracle RAC' s instance but executed in one single node. May be run on different physical servers, not only one (this is common) but a database instance is running only on the same node 
    simultaneously  (* but we'll see later that this is not completely true).

     

  • HP makes a formal complaint to Oracle for Itanium case

    In mid March of this year, Oracle announced that will stop developing products for Itanium processor platforms. Noted that other manufacturers were already doing it (Red Hat and Microsoft), and referenced conversations with Intel to justify its decision..

     

  • Encrypted Tablespaces in Oracle 11g

    Since the release 1 of Oracle 11g, Oracle provides the ability to encrypt tablespaces in full, to protect sensitive data inside and accessible from the OS. That is, the objective of this new functionality is not to protect sensitive data of users of the database, but to protect the information of the tablespace datafiles.

     

    To explain the usefulness of this feature, it is best to explain situations in which our data without this functionality would be vulnerable. For example, in the case file of a physical backup of a database tablespace were to wrong hands, could see some data "clear" without problems. For example, a single edition of tablespace (or a simple "cat") containing the Employees table, we show clear varchar2 fields can extract sensitive data (you do not believe, try it!).

  • What's New in IBM Cognos 10 in the IBM Cognos Performance 2010

    IBM cognos 2010This week I attended the IBM Cognos Performance 2010 in Barcelona with the main objective to know more about the new features of IBM Cognos 10, the new version of this suite of Business Intelligence.

    The event had as main thread presenting this new version of IBM Cognos, but also included broader sessions, with topics such as corporate performance management, analysis, 'What-if' and other arrangements under financial, Business Insight and predictive analytics, and case studies.

    After the initial presentation, two meetings were progressing in parallel, one oriented to technology and other business. There was a choice and I really would have liked to attend a further meeting. Specifically, I would have liked to be also in the 'What's new in IBM Cognos BI Authoring' and the SPSS Predictive Analytics..

     

  • Oracle BI Publisher

    We show a summary of capabilities of this tool integrated in the Oracle BI suite including the features included in version 11g.