asked on
declare
my_task_name VARCHAR2(30);
begin
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
sql_id => '50d2sfn999phq',
scope => 'COMPREHENSIVE',
time_limit => 3600,
task_name => 'sql_tuning_task_50d2sfn999phq',
description => 'Task to tune query 50d2sfn999phq');
DBMS_OUTPUT.PUT_LINE(my_task_name);
end;
/
begin
DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name => 'sql_tuning_task_50d2sfn999phq');
end;
SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK( 'sql_tuning_task_50d2sfn999phq') from DUAL;