SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set autotrace to explain plan ONLY

537177Feb 22 2007 — edited Feb 22 2007

Hi,

I would like to see explain plan for a long running statement.

Now if I do following:

set autotrace on explain

UPDATE ......-- my statement

I get the plan, but the rows are updated also :-(

Is there a way to tell ORACLE, please show me the explain plan but dio not execute the statement?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2007

Added on Feb 22 2007

5 comments

834 views