Re: tkprof & explain question

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Sat, 21 May 2005 17:41:54 +0300
Message-ID: <97b7fd2f050521074165fa200a@mail.gmail.com>

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 sqls.

Thanks once again for yor valuable advices.

On 5/21/05, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> When you tkprof a trace, the statements have already been executed. tkpro=
f
> 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=
o
> 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=
as
> used at execution.

>=20

> At 04:20 AM 5/21/2005, The Human Fly wrote:

>=20


> >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

> Regards

>=20

> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com

>=20
>=20

--=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

Received on Sat May 21 2005 - 13:45:28 CDT