Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Sat May 21 2005 - 12:49:23 CDT
![]() |
![]() |