Article Content
Article Number | 000029937 |
Applies To | RSA Product Set: RSA Identity Governance & Lifecycle RSA Version/Condition: All Platform (Other): Oracle 11, 12 |
Issue | The RSA Identity Governance & Lifecycle DB Statistics Refresh job under the Collectors > Scheduling > Tasks tab runs nightly database statistics optimized for the RSA Identity Governance & Lifecycle application. Database statistics results are saved for a certain number of days defined by Oracle's statistics history retention value. The Oracle statistics history retention value is set to 31 days by default. Some customers have found that the SYSAUX tablespace has space issues due to the large amounts of space consumed by 31 days of database statistics. The purpose of this RSA Knowledge Base Article is to provide instructions for reducing the default statistics history retention setting. However, the same steps may be used to increase the default statistics history retention setting if desired. |
Resolution | Here are the steps to determine the existing value for the Oracle statistics history retention setting and how to modify that value.
Sample output:
Sample output:
Sample output:
For example, to change the history retention to 15 days execute:
|