Modifying AWR Snapshot Frequency and Retention

ADDM analysis is based on AWR snapshots, which have a default frequency of once each hour and a default retention period of 8 days.

Note: The snapshot retention period does not apply to preserved snapshots, which are retained forever. A preserved snapshot set is typically created to define a reference period for performance analysis.

You can view and alter these AWR snapshot settings.

To modify AWR snapshot frequency and retention:

Go to the Database Home page.

See "Accessing the Database Home Page".
At the top of the page, click Server to display the Server page.
In the Statistics Management section, click Automatic Workload Repository.

The Automatic Workload Repository page appears.
Click Edit.

The Edit Settings page appears.
Enter new snapshot retention settings or new snapshot collections settings, and then click OK.

Modifying AWR Snapshot Frequency and Retention

Related Topics