Oracle sql tuning advisor: differenze tra le versioni

Da Emigar.
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 long 10000000
SET LONGCHUNKSIZE 1000
set longchunksize 1000
SET LINESIZE 200
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