What is the DBMS_ADVISOR package?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is the DBMS_ADVISOR package?

Rating:

The DBMS_ADVISOR package is new to Oracle 10g. It is used to provide the PL/SQL application programming interface (API), which manages all the advisors. The DBMS_ADVISOR package is also used to create and execute any advisor tasks, including SQL Access Advisor tasks. There are many procedures available for the package, as given below:

Procedure name	Description
CREATE_TASK	Creates a new advisor task in the repository.
SET_TASK_PARAMETER	Modifies a user parameter within a task (a task can only be modified if it is in the initial state).
EXECUTE_TASK	Executes the specified task (analysis task in the asked case).
GET_TASK_REPORT	Creates and returns an XML report for the specified task.
DELETE_TASK	Deletes the specified advisor task.
CANCEL_TASK	Cancels a currently executing task.
INTERRUPT_TASK	Stops the currently executing task, with normal exit.
RESUME_TASK	Resumes an interrupted task.
RESET_TASK	Resets a task to its original state.
UPDATE_TASK_ATTRIBUTES	Changes various attributes of a task.
MARK_RECOMMENDATION	Accepts, rejects, or ignores a recommendation.
GET_TASK_SCRIPT	Creates a SQL*Plus-compatible SQL script of all the recommendations that are accepted from a specified task.
CREATE_FILE	Creates an external file from a PL/SQL CLOB variable, used for creating scripts and reports.
QUICK_TIME	Analyzes and generates recommendations for a single SQL statement.

Rating: