Oracle中使用ADVISOR

2010-08-04

4340
0
Oracle
2010-08-10

Oracle中使用ADVISOR

ADVISOR真是oracle中超神奇的東西

不僅可以幫你分析語法，連建議都會跟你講

這邊做一下筆記

沒有權限的話要先建立建立權限

grant ADVISOR to prfuser

建立一個TUNING TASK


   my_task_name   VARCHAR (30);
   my_sqltext     CLOB;
   ouid           VARCHAR (5);
BEGIN
   ouid := 'QC06';
   my_sqltext :=
      'SELECT   *
                    FROM      user.XXX ps
                     INNER JOIN
                        user.YYY pc
                     ON ps.id = pc.id
                    WHERE   ps.id = :id';
   my_task_name := 
      dbms_sqltune.create_tuning_task (
         sql_text      => my_sqltext,
         bind_list      => sql_binds (anydata.convertnumber(9)),
         user_name     => 'USER',
         scope         => 'COMPREHENSIVE',
         time_limit    => 60,
         task_name     => 'sql_tuning_test',
         description   => 'tuning Task'
      );
END;

SELECT看看