steps:-
1. create plan table (global temporary table) @?/rdbms/admin/catplan
2. populate plan table
Note : 235530.1
SQL> explain plan for
3. Displaying The Execution Plan
SQL> set linesize 150
SQL> select plan_table_output from table(dbms_xplan.display('PLAN_TABLE',null,'ALL'));
or
select * from table(dbms_xplan.display('plan_table',null,'serial'));
or
select * from table(dbms_xplan.display);
or
@?/rdbms/admin/utlxpls
or
More details can be found in $ORACLE_HOME/rdbms/admin/dbmsxpln.sql
or
select * from table(dbms_xplan.display(null, null));
or
select plan_table_output from table(dbms_xplan.display('plan_table',null,'advanced'));
Hope this help! Rupam
