Re: DBMS_STATS compared to the analyze command: weird!

There is a (generic) bug for which I installed a patch:

Patch 1407738
Description DBMS_STATS.GATHER_SCHEMA_STATS GIVES ORA-6502 WITH STALE/EMPTY

It does not mean the stats are incorrect or that one should stay away from DBMS_STATS though.

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de
news:1077818071.139873_at_yasure...


> Cookie Monster wrote:

>

> > As a point of interest we had a consultant from Oracle in for a few days

to


> > tune our 8.1.7 database on solaris and he told us NOT to use the

DBMS_STATS


> > package to analyze the scheme.  He pointed to a number of bugs and

problems


> > and suggested we continue to use the analyze table method for statistic

> > gathering (seems problems are resolved in later releases).  I do this

using


> > a stored procedure.  Maybe you want to consider that??

> >

> > Regards,

> > Cookie.

>

> I've seen no evidence that your consultant's advice is correct. Can

> you point to anything specific?

>

> -- 

> Daniel Morgan

> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp

> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

> damorgan_at_x.washington.edu

> (replace 'x' with a 'u' to reply)

>