The easy way to do this, just set autotrace on with explain option, make
sure you have the plan_table, if not, you have to create it first:
For example:
Sql> set autotrace on trace only exp;
Sql> run your query from here.

Regards,
Jean
-----Original Message-----
From: quigleyd
[mailto:oracledba-ezmlmshield-x24745281.[Email address protected]
Sent: Monday, July 31, 2006 7:26 AM
To: LazyDBA Discussion
Subject: explain plans




Does anybody have a doc, on how to do explain plans? I havn't done
them for
Oracle, have done, lots for DB2.

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page