|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle |
RSA Product/Service Type: Appliance and soft appliance
RSA Version/Condition: 6.x, 7.0.x
|Issue||This article explains how to run segment advisor on RSA Identity Governance & Lifecycle 7.0.2 and earlier for RSA-supplied databases. If you have a non-RSA supplied database, please contact your Oracle DBA for assistance in running segment advisor. |
If you are on RSA Identity Governance & Lifecycle 7.1.0 or above, please see the section entitled Database Segment Maintenance on page 32 of the RSA Identity Governance & Lifecycle Database Setup and Management Guide for V7.1.1 for instructions on running segment advisor. (Note: Even if you are on 7.1.0, use the 7.1.1 guide.)
Please see RSA Knowledge Base Article 000038168 -- How to manage database growth in RSA Identity Governance & Lifecycle for an explanation on when to use segment advisor
|Resolution||NOTE: The segment advisor script file runs as the SYS user. Make sure you have are able to connect to the database as the SYS user before performing these steps.|
This last command will tell you the tables that have the most space to reclaim (if any).
NOTE: Reclaim space during slow periods when the database is being minimally used to avoid contention.