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.

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});

---

:p