giovedì 31 dicembre 2015

Oracle get the access plan

From sqlplus, execute the following commands:
SQL> spool accessplan.txt
SQL> set autotrace on
SQL> set wrap off
SQL> set linesize 120
SQL> write here the query you need to get the access plan
SQL> spool off

accessplan.txt will be located in the directory where you launch sqlplus

Nessun commento:

Posta un commento