Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: row counts are 0 in execution plan part of tkprof
timed stats is set to true...
Mark D Powell <markp7832_at_my-deja.com> wrote in message
news:8rb3dt$f8m$1_at_nnrp1.deja.com...
> In article <#Mr2lPLLAHA.330_at_cpmsnbbsa09>,
> "jgroff" <jgroff_at_email.msn.com> wrote:
> > I'm attempting to do some SQL tuning on 7.3.3 and the execution plans
are
> > showing 0 row counts for all plans. Statistics table does have values
and
> > they seem reasonable.
> >
> > Anyone have any ideas?
> >
> >
> It has been a long time since I was involved with tkprof but I
> remember that we would get some statistics on one job but the same
> statistics would be missing from a different run. We opened a tar
> report but no solution was ever provided. It seems to me that some of
> the statistics for tkprof are dependent on timed_statistics being set on
> in the init.ora. If you have not set them on, then perhaps that may be
> your problem.
>
> --
> Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 02 2000 - 21:08:25 CDT