EXPLAIN PLAN

There is two way for achieving it.

A.

1. set autotrace traceonly  then run the SQL SCRIPT

2. set autotrace on

3. set autotrace off (to Turn Tracing off)

B. EXPLAIN PLAN FOR and the sql script

Then you have to query PLAN_TABLE

SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());