Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: tkprof & explain question

Re: tkprof & explain question

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Sat, 21 May 2005 17:01:09 +0200
Message-ID: <c2213f6805052108016d99ab82@mail.gmail.com>


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-l
Received on Sat May 21 2005 - 13:50:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US