|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Product/Service Type: Appliance
RSA Version/Condition: 7.x
Platform (Other): Oracle 12.x
|Issue||The Oracle and RSA Identity Governance & Lifecycle default retention period for the Automatic Workload Repository (AWR) is eight days.This article describes how to modify the Automatic Workload Repository (AWR) retention period on an appliance. For a customer-supplied database, please contact the DBA.|
For more information on the Automatic Workload Repository (AWR), please see RSA Knowledge Base Article 000037779 -- How to generate an Oracle Automatic Workload Repository (AWR) report for RSA Identity Governance & Lifecycle.
Check the current retention period setting
The current retention period can be checked by running the below query as SYSDBA. In this example, the system shows a retention period of eight days.
Modify the current retention period setting
The retention period parameter is defined in minutes and the minimum retention period is one day. To change the retention period to a different number of days, first determine how many minutes that would be. For example, to change the retention period to four days, calculate the value as 5760 minutes (4 days x 24 hours x 60 minutes.)
If this error occurs, the window baseline size needs to be set lower than the retention size.
The window baseline size needs to be changed from 8 days to 4 days using the following sequence of commands as SYSDBA.
|Notes||The AWR data resides in tablespace SYSAUX. If you need to increase the AWR retention period significantly, the SYSAUX tablespace should be monitored by executing the below query as SYSDBA. |
If you would like to purge the AWR data in the SYSAUX tablespace, please open a support case with RSA Identity Governance & Lifecycle Support and refer to this RSA Knowledge Base Article ID 35405 for reference. Please also attach the results of the above query to the case. The long term solution would be to periodically purge the space or reduce the retention period setting.