Oracle sql tuning advisor: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con " DECLARE my_task_name VARCHAR2(30); BEGIN my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK( sql_id => '&1', scope => 'COMPREHENSIVE', time_limit => 3600, task_nam...") |
Nessun oggetto della modifica |
||
Riga 18: | Riga 18: | ||
/ |
/ |
||
set long 10000000 |
|||
set longchunksize 1000 |
|||
set linesize 200 |
|||
set pagesize 400 |
set pagesize 400 |
||
set trim on |
set trim on |
Versione delle 15:39, 17 mar 2020
DECLARE my_task_name VARCHAR2(30); BEGIN my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK( sql_id => '&1', scope => 'COMPREHENSIVE', time_limit => 3600, task_name => '&2-&1', description => 'processo &2 &1'); end; /
BEGIN DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name => '&2-&1'); end; /
set long 10000000 set longchunksize 1000 set linesize 200 set pagesize 400 set trim on set trims on set autotrace off
spool &2-&1..txt SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK( '&2-&1') from DUAL; spool off
spool &2-&1..long.txt SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK( '&2-&1','TEXT','ALL','ALL') from DUAL; spool off