What is an AWR?

Posted on 2011-05-01
Last Modified: 2012-05-11
What is an AWR? How this can be used? What privileges are necessary to execute this?
Question by:sakthikumar
    LVL 4

    Accepted Solution

    AWR is Automatic Workload Repository

    The AWR is used to collect performance statistics including:

    •Wait events used to identify performance problems.
    •Time model statistics indicating the amount of DB time associated with a process from the V$SESS_TIME_MODEL and V$SYS_TIME_MODEL views.
    •Active Session History (ASH) statistics from the V$ACTIVE_SESSION_HISTORY view.
    •Some system and session statistics from the V$SYSSTAT and V$SESSTAT views.
    •Object usage statistics.
    •Resource intensive SQL statements.
    The repository is a source of information for several other Oracle 10g features including:

    •Automatic Database Diagnostic Monitor
    •SQL Tuning Advisor
    •Undo Advisor
    •Segment Advisor

    Administrator or Enterprise manager access is required for running AWR.
    LVL 7

    Assisted Solution

    Hi sakthikumar,

    When I see your recent questions, I feel you are new to oracle. I strongly suggest you to have a look to the oracle official concepts doc :

    It is a very good introduction to oracle and it links to detailed documentation for all subjects...

    LVL 23

    Assisted Solution

    - in general, AWR is a function in oracle database that collect and utilize performance statistics for problem detection and tuning purposes. you need to create and manage AWR snapshots, and using snapshots to generate periodic AWR reports and used it for performance tuning. you can either write a script (use any available scripts by googgling around) or using Oracle Enterprise Manager to view the reports.

    - you need DBA role granted to use AWR.

    - the link provided by Piloute and specific on AWR below are among other documentations available around to start with:
    LVL 47

    Assisted Solution

    Oracle collects and keeps a lot of data in regard of the productivity, performance, waits of the Data base.

    All of them are kept in the internal views.

    They all are accessible using SELECT statements, but this is very hard task.

    Also the data changes in different periods of time.

    AWR is a periodically (by default hourly) report in readable and well collected data about the performance and load events of the database. In addition it gives us advices how to improve the performance.

    It is collected automatically and there are easy methods to get these reports.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video shows how to recover a database from a user managed backup
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now