oracle 19c new features

source : Refer http://dineshbandelkar.com/oracle-database-19c-new-features/

Automatic Indexing

The automatic indexing feature automates the index management tasks in an Oracle database. Automatic indexing automatically creates, rebuilds, and drops indexes in a database based on the changes in application workload, thus improving database performance. The automatically managed indexes are known as auto indexes.

 col DESCRIPTION for a30

 col ADVISOR_NAME for a25

 col task_name for a30

 select TASK_NAME,DESCRIPTION,ADVISOR_NAME,CREATED,LAST_MODIFIED,LAST_EXECUTION,EXECUTION_START,EXECUTION_END,STATUS,PROGRESS_METRIC

 from dba_advisor_tasks;

 Task Run for Every 15 minutes

 col TASK_NAME for a30

 col EXECUTION_NAME for a30

 set lines 200 pages 5000

 select TASK_NAME,EXECUTION_NAME,EXECUTION_START,EXECUTION_END,STATUS,REQUESTED_DOP,ACTUAL_DOP

 from dba_advisor_executions 

 where TASK_NAME in ('SYS_AUTO_INDEX_TASK','SYS_AI_SPM_EVOLVE_TASK','SYS_AI_VERIFY_TASK')

 order by EXECUTION_START;