DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: AWR report

  1. #1
    Join Date
    Feb 2009

    AWR report

    I am looking into having the @$ORACLE_HOME/rdbms/admin/awrrpt.sql
    run automatically.

    I have a few questions:

    1) this report asks for input is there a way I can pass that into the report automatically

    2) It asks for begin and ending snapid is there a way to get those values
    or does this need to be parsed when you enter the number of days

    3) Lastly, is there a shell script that I can use that can parse this output
    that allows me to easily identify problems.

    Thanks to all who answer.

  2. #2
    Join Date
    Jul 2002
    Lake Worth, FL

    Cool AWR report from EM

    You can schedule AWR report automatically using EM: Database -> Maintenance -> Automatic Workload Repository -> Edit.

    There you can set the interval and the retention for the reports.

    Or you can use the PL/SQL package:
    DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS({retention days},{interval minutes});
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.