Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: tkprof & explain question
10046 doesn't change behavior of server process (only adds small
overhead). So answer to you Q is - your statements will be executed in
the same way as without tracing.
2005/5/21, The Human Fly <sjaffarhussain_at_gmail.com>:
> 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,
Alex Gorbachev
-- http://www.freelists.org/webpage/oracle-lReceived on Sat May 21 2005 - 13:50:52 CDT