I am also interested in EXPLAIN PLAN.
I have created a table plan_table in my schema.
I run this query say:
EXPLAIN PLAN
for
select * from test
where rownum=1;

And then do the select * from plan_table..
But I do not get the details in the format that you got..
and I also do not see all the details that you got in there.
I have been trying to find the help on this for a long time.
I also tried online help for the concept manual. It doesn't tell this.
Can you help me please ?
Can you send me the script that you ran to get these results.

Thanks, my email id
[email protected]