Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. How to run an AWR report

    How to run an AWR report

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local

     


    Question    
    How can an Oracle AWR report be run (for the purpose of analyzing Oracle behavior within a certain timeframe)? This can be useful when there is an indication that the Oracle process(es) may be the cause of overall product performance issues. These reports can be sent to DBAs for analysis.

     

    Answer    
    Sign on to the server: 

    1- grep ora /etc/passw (to find the relevant Oracle Unix user) 
    2- sudo su - oracle* (*- the suffix of the relevant Unix Oracle user . From a user with sudo rights: ) 
    3- cd $ORACLE_HOME/rdbms/admin 
    4- sqlplus '/as sysdba' 
    5- set pause off 
    6- @awrrpt 
    7- You will then be prompted for the type of report (html or text) 
    8- You will then be prompted for the number of days back, in which you will see a list of relevant hours for generating the report. Choose the number of days back, and you will see a list of hours from the number of days back until the present time. Each hour has a unique identifier number in the left. Enter the identifier of the relevant hour from which you would like the report to start. 
    9- Enter the identifier number of the hour that you would like the report to complete (Keep in mind that these reports are very verbose) 
    10 - you will be prompted to Enter value for report_name (file name) 
    11- Once the report is complete, you will be able to find the report file under $ORACLE_HOME/rdbms/admin/

     

     


    • Article last edited: 6-Jun-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to run adam-01 and adam-02 services
      • How to run ARC Incremental ETL
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. AWR
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved