Re: dbms_utility and dbms_stats difference

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 Wed Aug 21 2002 - 14:06:46 CDT