DBMS_SQLTUNE

This package provides an interface to tune SQL statements.

Procedures

The most relevant procedures related to the SQL tuning set are:

• CREATE_SQLSET : creates a SQL tuning set object in the database

• DROP_SQLSET : drops a SQL tuning set if not active

• SELECT_SQLSET : collects SQL statements from an existing SQL tuning set

• LOAD_SQLSET: populates the SQL tuning set with a set of selected SQL statements

• SELECT_CURSOR_CACHE : collects SQL statements from the cursor cache

The most relevant procedures to manage SQL tuning tasks are:

• CREATE_TUNING_TASK : creates a tuning of a single statement or tuning set

• EXECUTE_TUNING_TASK : executes a previously created tuning task

• REPORT_TUNING_TASK : displays the results of a tuning task

• INTERRUPT_TUNING_TASK : interrupts the currently executing tuning task

• RESUME_TUNING_TASK : resumes a previously interrupted tuning task