oracle sql调优

从表(dbms_xplan

Select *。display_cursor (sql_id=> ' 9 s7pt2ay4t3jg '));

声明l_Result_Name Varchar2 (30);

l_Task_Name Varchar2 (36):=癟ask_Name_9s7pt2ay4t3jg_1”;

l_Sqlid Varchar2 (36):=9 s7pt2ay4t3jg的;

l_Result_Name:=Dbms_Sqltune。Create_Tuning_Task (Sql_Id=> l_Sqlid

=>“全面”范围,

Time_Limit 60=>,

Task_Name=> l_Task_Name,=>

描述的任务来优化查询指定表”),

Dbms_Sqltune。Set_Tuning_Task_Parameter (Task_Name=> l_Task_Name=>

参数“TIME_LIMIT”,

Value=> 30);

Dbms_Sqltune。Execute_Tuning_Task (Task_Name=> l_Task_Name);

,

选择Dbms_Sqltune.Report_Tuning_Task从双(Task_Name_4hqjc3gc4dwuy);

选择Dbms_Sqltune.Report_Tuning_Task从双(Task_Name_5k5fc0v3hkmcr);

选择Dbms_Sqltune.Report_Tuning_Task从双(Task_Name_au085h9cz2av0);

选择Dbms_Sqltune.Report_Tuning_Task从双(Task_Name_cwkna4v8r99qu);

选择Dbms_Sqltune.Report_Tuning_Task从双(Task_Name_9s7pt2ay4t3jg_1);

Select * From dba_sql_profiles;

Select * From wh_inventory y, y。isshort=' Y '

oracle sql调优