SQLPlus AutoTrace is a very simple and convenient tool for analyzing SQL execution plan, performing efficiency, in most cases, is also very useful tools. 1. How to set up and use AUTOTRACE SQL> connect / as sysdba SQL> @ / rdbms / admin / utlxplan.sql Table created SQL> create public synonym plan_table for plan_table;?. Synonym created SQL> grant select, update, insert, delete on plan_table. To public successded. SQL> @? / sqlplus / admin / plustrce.sql sql> grant plustrace to public. 2. Understand and use autotrace for SQL adjustment, using autotrace is the easiest way, we only need to do: SQL > Set autotrace ON We can see our SQL execution plan, perform cost (Physical Read / Consistent Read ...) plus Set Timing ON or SET TIME ON, we can get a lot of data we need.
Then press Ctrl E in Toad to press Ctrl E to see the execution plan of this statement.
