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