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
This blog covers different aspects around software development and test. There are also general information useful for who needs to test performances and needs to analyze bottlenecks on application servers and databases. Disclaimer: test before you implement any advice, no warranty is provided. Before use the software mentioned in this blog read and understand all licenses agreements. Use of the information contained in this blog is under your own responsibility.
Nessun commento:
Posta un commento