It will just do a explain plan and not execute the statement. But why do you need to run it with explain =<> parameter. The actual plan used would be present in tkprof as row source operations anyway amit Quoting The Human Fly <sjaffarhussain@xxxxxxxxx>: > Good Day everyone, > > I have a small doubt about using tkprof with explain parameter. > Say, when we use, set autot trac exp for any insert,update,delete > that command is executed and produces the execution plan. Whereas if > I > use explain plan for insert,update,delete commands, it only gives > the > execution plan without actually executing the command. > I have set instance level tracing with trace leve 1, and wants to > caputre all the statements. 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? > > --=20 > Best Regards, > Jaffar, OCP DBA > Banque Saudi Fransi > Saudi Arabia > ---------------------------------------------------------------------------= > ------------- > "It is your atittude, not your aptitude that determins your > altitude." > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l