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.
Received on Tue Sep 14 2004 - 22:01:50 CDT
