Explain Plan

[newcomer]

Hello,

I need 2 helps. I am presently in a position where I can not access Oracle documents.

1. After applying SET AUTOTRACE ON can I disable the display of the query? What I mean is , I just need the explain plan .... Not the Data.

If yes, How???????????


2. Does anybody has the good explain plan script, which will read from the plan table and properly display the explain plan in formated way?

Can anybody please send me accross the same to viswassumit412@yahoo.com.

I will appreciate your help.

Thanks and Regards
Vis

[vinit]

set autotrace traceonly explain

[stmontgo]

beware of oracle bug 704057 when using
set autotrace traceonly explain on anything less than a 817 client

If you turn this on and execute dml it *may* also execute the statement and not just produce the explain plan.

This has been fixed in 817 client

[marist89]

http://home.adelphia.net/~marist89/scripts/fmtxplan.htm