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