How To Disable The dbms_auto_index_internal.capture_sts Job
(Doc ID 2936842.1)
Last updated on MAY 16, 2023
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
The following statement disables automatic indexing in a database, so that no
new auto indexes are created, and the existing auto indexes are disabled:
After disabling the auto indexing feature，the customer found that the following job is still running automatically. So the customer want to stop/disable below job.
begin /*KAPI:capture*/ dbms_auto_index_internal.capture_sts; end;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document