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

Thread: AWR report

Hybrid View

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    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
    Location
    Lake Worth, FL
    Posts
    1,492

    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:
    Code:
    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