Oracle Database 11gR2 Performance Tuning Cookbook

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 ...