View Oracle Execution Plan

1. PL/SQL Interpretation Plan window

Advantages: Aspects

Cons: See limited information

2. Explain_plan for

Easier to optimize for a sentence

3, Sqlplus

Enter the command in Sqlplus:

Set Autotrace on

SELECT * from EMP;

After the data is displayed, follow the execution plan:

The advantage of this statement is its disadvantage, so that when you use this method to view a long-executing SQL statement, you need to wait for the statement to execute successfully before returning to the execution plan, which greatly increases the period of optimization.

If you do not want to execute the statement and just want to get an execution plan can take:

Set Autotrace traceonly

If you encounter insufficient permissions to execute the statement, the workaround is:

Login with SYS user

Sqlplus > @ sqlplus\admin\plustrce.sql

Sqlplus > Grant plustrace to user_name;

--User_name is the analysis user described above

Cond...

View Oracle Execution Plan