Obtaining Execution Plans
- Execute the SQL statement EXPLAIN PLAN,and then query the table where the output was written.
- Query a dynamic performance view showing the execution plans cached in the library cache.
- Query an Automatic Workload Repository or Statspack table, showing the execution plans stored in the repository.
- Activate a tracing facility providing execution plans.
plan_table Position : $ORACLE_HOME/rdbms/admin/ultxplan.sql