Re: tkprof & explain question

  • From: The Human Fly <sjaffarhussain@xxxxxxxxx>
  • To: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • Date: Sat, 21 May 2005 17:41:54 +0300

Thank you all for your advices.

I was really  frogetting about the stat line in the trace file. As I
had enabled level 1 trace, I thought, it won't produce explain plan.

My intention behind using tkprof was to eleminate sys and recursive
calls in the trace and wanted to have most cpu and  elapsed  time

Thanks once again for yor valuable advices.

On 5/21/05, Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote:
> When you tkprof a trace, the statements have already been executed. tkpro=
> with explain will only explain the sql as it encounters them. However,
> unless you are dealing with traces of Oracle 7 systems, there should be n=
> need to use the explain option on tkprof. The trace already contains the
> execution plan in the form of STAT lines and tkprof will format them. The
> explained plan may actually show something different from the plan that w=
> used at execution.
> At 04:20 AM 5/21/2005, The Human Fly wrote:
> >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?
> Regards
> Wolfgang Breitling
> Centrex Consulting Corporation

Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia
"It is your atittude, not your aptitude that determins your altitude."

Other related posts: