Re: dbms_utility and dbms_stats difference

Hi, Svend,

 Thanks for your clarification and experience.

I am not sure whether dbms_utility gathers stats for partitions of table.

Thanks again,

chuan

Svend Jensen <svend.jensen_at_it.dk> wrote in message news:<3D63E4C6.3090008_at_it.dk>...
> chuan wrote:
>
> > Hi, All,
> >
> > What is the difference between dbms_utility and dbms_stats in terms of
> > statistics gathering?
> >
> > Much appreciated for your clues
> >
> > Chuan
> >
> DBMS_UTIL is more like a framework on base of analyze table ...
>
> and gathers only global statistics (ie. no partition information et.al.)
>
> DBMS_STATS is a larger framework build from anew and is hence faster and
> can gather stats global, partition, subpartition on tables and indexes.
> Moreover it is capable of 'conserving' the old statistics and restore
> them in case new stats make things run poorly. It can also export
> statistics from a production system to be imported on the often much
> smaller development machine, and get that small environment act as if it
> had the size of a production system. Furthermore it can sample stats for
> table, index or both, schema(s) and database.
> It doesn't collect index data as analyze validate structure (depth,
> del_rows...). Heavily recommended.
> My production uses a homegrown package framework on top of dbms_stats to
> save and collect statistics regularly, kicked off by the job queue.
> Never failed.
Received on Fri Aug 23 2002 - 00:06:30 CDT