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});![]()





Reply With Quote