Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Automatically generate awr in html/text format

YoavNov 26 2011 — edited Nov 27 2011
Hi,
I am going to be part of a poc that will take a week.
I would like to generate AUTOMATICALLY an AWR for each and every hour in this poc without the need to execute manualy:
sqlplus / as sysdba
@?/rdbms/admin/awrrpt.sql
....
Enter value for report_type: text
...
Enter value for num_days: 1
...
Enter value for begin_snap:...

...
Enter value for end_snap:...
Any advice how to do it ?
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2011
Added on Nov 26 2011
2 comments
942 views