Re: tkprof & explain question

From: <amit.poddar_at_yale.edu>
Date: Sat, 21 May 2005 12:31:58 -0400
Message-ID: <1116693118.428f627e25423@www.mail.yale.edu>

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_at_gmail.com>:

> 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."
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat May 21 2005 - 14:09:30 CDT