View the Oracle Execution Plan and the oracle execution plan

View the Oracle Execution Plan and the oracle execution plan
1. PL/SQL explain Plan window

Advantages:

Disadvantage: limited information

2. explain_plan

It is easier to optimize a sentence.

3. sqlplus

Run the following 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. When you use this method to view SQL statements that have been executed for a long time, you must wait until the statement is successfully executed before returning the execution plan, this greatly increases the optimization cycle.

If you do not want to execute the statement but want to execute the plan, you can use:

Set autotrace traceonly

If you encounter an insufficient permission error when executing this statement, the solution is:

Log in with sys user

Sqlplus> @? Sqlplus \ admin \ plustrce. SQL

Sqlplus> grant plustrace to user_name;

--User_name is the analysis user mentioned above.

To be continued...