This advisor requires that you identify a SQL workload, which is a representative set of SQL statenments that access the schema. You can select you workload from different sources including current and recent SQL activity, a SQL repository, or a user-defined workload such as from a development environment.
The SQL Access Advisor may make recommendations such as creating indexes or materialized views to improve your query performance for the given workload.

The DBMS_ADVISOR package contains all constants and procedure declarations for all advisor modules. You can use this package to execute tasks via command line.
To execute advisor procedures, you must be granted the ADVISOR privilege. The ADVISOR privilege permits full access to the advisor procedures and views.

Procedures:

• CREATE_TASK
• DELTE_TASK
• EXECUTE_TASK
• INTERRUPT_TASK
• GET_TASK_REPORT
• RESUME_TASK
• UPDATE_TASK_ATTRIBUTES
• SET-TASK_PARAMETER
• MARK_RECOMMENDATION
• GET_TASK_SCRIPT