Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
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.
dbms_auto_index.drop_secondary_indexes(
ownname IN VARCHAR2 DEFAULT NULL,
tabname IN VARCHAR2 DEFAULT NULL);
Reports the results of auto index executions between specified activity_start and activity_end
dbms_auto_index.report_activity(
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')
RETURN CLOB);