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

3 years ago

Originally Published: 2016-08-24

Article Number

000059331

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: All

Issue

By 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.

Resolution

To disable Segment Advisor, run the following PL/SQL as SYSDBA using a tool such as SQL*Plus or SQL Developer:

BEGIN
dbms_auto_task_admin.disable(
client_name => 'auto space advisor',
operation => NULL,
window_name => NULL);
END;
/

Don't see what you're looking for?

Related Articles

Trending Articles