step 1: create the tuning task for the sql idSQL> declaresql_tune_task_id varchar2(100);beginl_sql_tune_task_id := dbms_sqltune.create_tuning_task (begin_snap => 41062,end_snap => 44516,sql_id => ‘2mjr0fw17sjuh’,scope => dbms_sqltune.scope_comprehensive,time_limit => 10800,task_name => ‘2mjr0fw17sjuh_tuning_task’,description => ‘tuning_in_OLBUI’);dbms_output.put_line(‘l_sql_tune_task_id: ‘ || l_sql_tune_task_id);end; DECLARE sql_tune_task_id VARCHAR2(100);BEGIN sql_tune_task_id := DBMS_SQLTUNE.CREATE_TUNING_TASK ( sql_id => ‘2mjr0fw17sjuh’, begin_snap => 41062, end_snap […]
Read More