Oracle SQL Tuning

Select * from Table (dbms_xplan.display_cursor (sql_id = ' 9s7pt2ay4t3jg '));

Declare

L_result_name Varchar2 (30);

L_task_name Varchar2 (£): = ' task_name_9s7pt2ay4t3jg_1 ';

L_sqlid Varchar2 (£): = ' 9S7PT2AY4T3JG ';

Begin

L_result_name: = Dbms_sqltune.create_tuning_task (sql_id = L_sqlid,

Scope = ' comprehensive ',

Time_limit = 60,

Task_name = L_task_name,

Description = ' Task to tune a query on a specified table ');

Dbms_sqltune.set_tuning_task_parameter (Task_name = L_task_name,

Parameter = ' Time_limit ',

Value = 30);

Dbms_sqltune.execute_tuning_task (task_name = l_task_name);

End;

Select dbms_sqltune.report_tuning_task (' Task_name_4hqjc3gc4dwuy ') from Dual;

Select dbms_sqltune.report_tuning_task (' TASK_NAME_5K5FC0V3HKMCR ') from Dual;

Select dbms_sqltune.report_tuning_task (' Task_name_au085h9cz2av0 ') from Dual;

Select dbms_sqltune.report_tuning_task (' Task_name_cwkna4v8r99qu ') from Dual;

Select dbms_sqltune.report_tuning_task (' task_name_9s7pt2ay4t3jg_1 ') from Dual;

Select * from Dba_sql_profiles;

Select * from wh_inventory y Where y.isshort = ' y '

Oracle SQL Tuning