000033860 - How to disable Automated Segment Advisor in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Sep 19, 2016Last modified by RSA Customer Support on Sep 5, 2020
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000033860
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: All
IssueBy default, Oracle comes with a tool called Automated Segment Advisor which is an automated maintenance utility to detect objects in the database where disk space can be reclaimed. RSA recommends that this feature be disabled in RSA Identity Governance & Lifecycle because the job consumes a lot of database resources. For example, if collections are running at night at the same time this job is running, the collections will take longer and could extend into the daytime hours causing additional daytime overhead.

Instead it is recommended to periodically run the Segment Advisor manually as part of Administrative maintenance. See RSA Knowledge Base Article 000038168 -- How to manage database growth in RSA Identity Governance & Lifecycle for more information on running Segment Advisor.
ResolutionTo disable Segment Advisor, run the following PL/SQL as SYSDBA using a tool such as SQL*Plus or SQL Developer:

client_name => 'auto space advisor',
operation => NULL,
window_name => NULL);