Shulou(Shulou.com)06/01 Report--

1.drop tuning task if task exists (delete previous optimization tasks, if any)

Sqlplus / as sysdba

Exec DBMS_SQLTUNE.DROP_TUNING_TASK ('zhangx_tune_taks');' zhangx_tune_taks',time_limit = > 600 'ProvideSQLID')

END

/

3.exec tuning task BEGIN DBMS_SQLTUNE.EXECUTE_TUNING_TASK (task_name = > 'zhangx_tune_taks'); END

/

4.check tuning finding set lines 999 set long 100000 set longchunksize 100000 select dbms_sqltune.report_tuning_task ('zhangxiong_tune_taks') from dual

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.