RE: tkprof & explain question

Jaffar

>However,  my question is, when I am using
>tkprof with explain parameter, if there are any insert,update or
>delete statements in my trace file, are they going execute or just
>produces explain plan wihtout executing them?

TKPROF executes an EXPLAIN PLAN statement, not the DDL statement.

Be careful that EXPLAIN PLAN can return a "wrong" execution plan, i.e. =
not the execution plan that was executed and generated all other =
statistics the you see in the TKPROF output.


HTH
Chris

--
http://www.freelists.org/webpage/oracle-l

Other related posts: