How To Disable The dbms_auto_index_internal.capture_sts Job (Doc ID 2936842.1)

Last updated on MAY 02, 2024

Applies to:

Goal

The following statement disables automatic indexing in a database, so that no
new auto indexes are created, and the existing auto indexes are disabled:

EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF');

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;

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.