Re: tkprof & explain question
- From: amit.poddar@xxxxxxxx
- To: sjaffarhussain@xxxxxxxxx
- Date: Sat, 21 May 2005 12:31:58 -0400
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
Other related posts:
