[20230203]建立完善sp1x.sql脚本.txt

[20230203]建立完善sp1x.sql脚本.txt --//sql profile run standby database.使用database_link_to参数,我不知道我的测试为什么带入的参数要大写. --//另外注意一点,如果原始sql语句执行很慢,可能使用它优化会非常慢.你可以修改time_limit参数设置更小的时间.单位是秒. $ cat sp1x.sql set verify off set long 20000000 set longchunksize  20000000 column report_tuning_task format a300 declare   a varchar2(200); begin   a := dbms_sqltune.create_tuning_task(task_name=>'tuning &1',description=>'tuning sql_id=&1 over dg',scope=>dbms_sqltune.scope_comprehensive,time_limit=>1800,sql_id=>'&1',database_link_to => upper('&2')); --  dbms_sqltune.execute_tuning_task( a );   dbms_sqltune.execute_tuning_task( task_name=>'tuning &1' ,database_link_to => upper('&2') ); end; / prompt prompt ================================================================================================================================================= prompt tuning sql_id=&1 : report prompt ================================================================================================================================================= select dbms_sqltune.report_tuning_task('tuning &1') report_tuning_task FROM dual; prompt ================================================================================================================================================= prompt if finished,drop tuning task , run: prompt execute dbms_sqltune.drop_tuning_task('tuning &1') prompt if accept sql profile, run: prompt execute dbms_sqltune.accept_sql_profile(task_name => 'tuning &1', replace => TRUE ,name=>'tuning &1');; prompt execute dbms_sqltune.accept_sql_profile(task_name => 'tuning &1', replace => TRUE, name=>'tuning &1', FORCE_MATCH=>True) prompt if drop or alter sql profile ,run : prompt execute dbms_sqltune.drop_sql_profile(name => 'tuning &1') prompt execute dbms_sqltune.alter_sql_profile(name => 'tuning &1',attribute_name=>'STATUS',value=>'DISABLED') prompt ================================================================================================================================================= prompt display SYS_AUTO_SQL_TUNING_TASK : report prompt select dbms_sqltune.report_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK' ) report from dual;; prompt set serveroutput off