Re: dbms stats

"Oradba Linux" <techiey2k3_at_comcast.net> wrote in message news:<ygO1d.93386$3l3.17986_at_attbi_s03>...
> I am curious about how dbms_stats is implemented in real life on oltp and
> datawarehouses.
> In more details , how successful is using dbms_stats.gather_schema_stats to
> gather statistics for all objects. dbms_stats.gather_table_stats
> to gather histograms on selected columns. Turn on monitoring. Then gather
> stale statistics only on a regular schedule like weekly or monthly. I would
> like to know any interesting problems faced during the implementation of
> dbms_stats. We are on oracle 9iR2.

http://www.orafaq.com/maillist/oracle-l/2004/01/07/1405.htm

jg

--
@home.com is bogus.
"Interesting" things happen when insiders get options: 
http://www.signonsandiego.com/uniontrib/20040915/news_1b15oracle.html