ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
firstname.lastname@example.org. Request a Workshop for
your organization today.
The Oracle Database periodically runs a task, SYS_AUTO_INDEX_TASK that monitors
the system and creates indexes based on workload running in the system. This package contains subprograms that display the report of the task, configure task execution and behavior.
Drops indexes that are not used for constraints for given (optional) schema and table. If no schema is given, all indexes which the user has priviledges on will be dropped.
If no table is given, all indexes within the given schema will be dropped.
ownname IN VARCHAR2 DEFAULT NULL,
tabname IN VARCHAR2 DEFAULT NULL);
Reports the results of auto index executions between specified activity_start and activity_end
activity_start IN TIMESTAMP WITH TIME ZONE := SYSTIMESTAMP - 1,
activity_end IN TIMESTAMP WITH TIME ZONE := SYSTIMESTAMP,
type IN VARCHAR2 := 'TEXT',
section IN VARCHAR2 := 'ALL',
level IN VARCHAR2 := 'TYPICAL')