Advisors

SQL Access Advisor

This advisor mainly provides advice on creating new indexes, materialized views, or materialized view logs. Provide the advisor with a representative workload in order to get its advice.

Space-Related Advisors

Segment Advisor allows for performing growth-trend analyses on various database objects. This advisor helps you perform object shrinkage, thus helping reclaim unused space in the database. The Segment Advisor automatically runs during the maintenance window and recommends candidate objects for shrinking.

Undo Advisor bases its activities on system usage statistics, including the length of the queries as well as the rate of undo generation. The Undo Advisor facilitates Oracle’s Automatic Undo Management (AUM) feature. It helps you to correctly size your undo tablespace and to correctly size the undo retention interval.