j简易STA优化sql

最新推荐文章于 2024-10-10 05:00:00 发布

原创最新推荐文章于 2024-10-10 05:00:00 发布 · 146 阅读

0 ·

CC 4.0 BY-SA版权

使用简易的STA优化方式如下：

declare
my_task_name varchar2(1000);
my_sqltext clob;
begin
SELECT sql_fulltext INTO my_sqltext FROM v$sql where sql_id='f8za0xgm6hrpd' AND ROWNUM<2;
my_task_name:=dbms_sqltune.create_tuning_task(sql_text => my_sqltext,user_name => 'NPMDB',scope => 'COMPREHENSIVE',time_limit => 200,task_name => 'sql_tuning_task0C',description => 'sql');
dbms_sqltune.execute_tuning_task(task_name => 'sql_tuning_task0C');
end;
/





SET LONG 1000000
select dbms_sqltune.report_tuning_task('sql_tuning_task01') from dual;