DECLARE l_sql_tune_task_id VARCHAR2(100); BEGIN l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task ( sql_id => '6x2xfudxngmmj', scope => DBMS_SQLTUNE.scope_comprehensive, time_limit => 1200, task_name => '6x2xfudxngmmj_AWR_tuning_task', description => 'Tuning task for query 6x2xfudxngmmj in AWR.'); DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id); END; / begin DBMS_SQLTUNE.execute_tuning_task(task_name ...
Blog com dicas, scripts, How-to para DBA´s e Desenvolvedores ORACLE.