Databases Reference
In-Depth Information
Procedures
The most relevant procedures are:
F
EXECUTE
: executes a cursor
F
OPEN_CURSOR
: returns the cursor ID number of the new cursor
F
PARSE
: parses the given statement
F
BIND_VARIABLE
: binds a given value to a given variable
F
CLOSE_CURSOR
: closes a given cursor and frees associated memory
DBMS_SQLTUNE
This package provides an interface to tune SQL statements.
Procedures
The most relevant procedures related to the SQL tuning set are:
F
CREATE_SQLSET
: creates a SQL tuning set object in the database
F
DROP_SQLSET
: drops a SQL tuning set if not active
F
SELECT_SQLSET
: collects SQL statements from an existing SQL tuning set
F
LOAD_SQLSET
: populates the SQL tuning set with a set of selected SQL statements
F
SELECT_CURSOR_CACHE
: collects SQL statements from the cursor cache
The most relevant procedures to manage SQL tuning tasks are:
F
CREATE_TUNING_TASK
: creates a tuning of a single statement or tuning set
F
EXECUTE_TUNING_TASK
: executes a previously created tuning task
F
REPORT_TUNING_TASK
: displays the results of a tuning task
F
INTERRUPT_TUNING_TASK
: interrupts the currently executing tuning task
F
RESUME_TUNING_TASK
: resumes a previously interrupted tuning task
DBMS_STATS
This package allows you to view and modify optimizer statistics.