My Oracle Support Banner

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

Last updated on MAY 02, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 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

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