 |
|
Oracle
dbms_advisor quick_tune option
Oracle Tips by Burleson Consulting |
Using the dbms_advisor quick_tune option
The dbms_advisor package has a
procedure called
dbms_advisor.quick_tune that allows the DBA
to quickly tune a single SQL statement with a single procedure call.
This procedure performs all of the stages described above that are
necessary to launch the SQLAccess Advisor,
e.g. creating a task, creating and populating a workload, and
executing the task. The sample call of this procedure is as follows:
VARIABLE task_name VARCHAR2(255);
VARIABLE sql_stmt VARCHAR2(4000);
exec :sql_stmt := 'SELECT COUNT(*) FROM all_objects WHERE
object_type = ‘VIEW’;
exec:task_name := 'MY_QUICKTUNE_TASK';
exec DBMS_advisor.quick_tune (dbms_advisor.sqlaccess_advisor, :task_name,
:sql_stmt);
The dbms_advisor
package provides a rich collection of managing tasks, workloads, and
recommendations. These examples should give an overview of how to
work with SQLAccess Advisor. Once armed with
this information, the DBA should be able to be more flexible in the
creation and configuration of tuning sessions.
SEE CODE DEPOT FOR FULL SCRIPTS
 |
This is an excerpt from my latest book "Oracle
Tuning: The Definitive Reference".
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts: |
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm
|
