12-21. The DBMS_ADVISOR Package

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