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 - 17:49:34 CDT
