How to run Segment Advisor in versions 7.0.2 or earlier of RSA Identity Governance & Lifecycle
Originally Published: 2020-01-02
Article Number
Applies To
RSA Product/Service Type: Appliance and soft appliance
RSA Version/Condition: 6.x, 7.0.x
Issue
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
- Log into the RSA Identity Governance & Lifecycle Oracle database server.
- Download the attached segmentAdvisor.zip to /home/oracle.
- Create a temporary directory under /home/oracle and move segmentAdvisor.zip to the temporary directory.
cd /home/oracle mkdir tempSA mv segmentAdvisor.zip tempSA
- Go to the temporary directory
- Unzip the zip file. Inside is segmentAdvisor.txt and segmentAdvisor.sql
- Copy segmentAdvisor.txt to segmentAdvisor.sh
cd tempSA unzip segmentAdvisor.zip mv segmentAdvisor.txt segmentAdvisor.sh
- Before running segmentAdvisor.sh, read through the script files (segmentAdvisor.sh and segmentAdvisor.sql) to see what they do. The segmentAdvisor.sh file explains how to run the script for the entire database or one table at a time. It also provides instructions on how to reclaim the freed up space.
- Run segment advisor.
sh segmentAdvisor.sh
- Once the script completes, there will be a file called RESULTS.TXT. Use the below command to see the segment advisor results:
grep -i estimate -A1 -B3 RESULTS.TXT
This last command will tell you the tables that have the most space to reclaim (if any).
- Review the results and follow the instructions in the segmentAdvisor.sh file to reclaim unused space.
NOTE: Reclaim space during slow periods when the database is being minimally used to avoid contention.
Attachments
If the attachment does not open when clicked, please refresh the page and try again. You must be logged into view the file(s).
Related Articles
Authentication Manager 8.1 SP1 conflict between NTP time and VMWare Host time, both set Number of Views Manage the Cloud Connection (RSA Authentication Manager 8.4 Patch 3 and earlier) Number of Views RSA Governance & Lifecycle Recipes: CR Approvals & Activities Trending Number of Views Report preview and/or generation fails with 'java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11Graphic… Number of Views ORA-01652: Unable to extend temp segment by 128 in tablespace TEMP in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?
