For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
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.
Owned by SYS with EXECUTE granted to
the DBA role.
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')