Re: dbms stats

From: agis <stag_at_hq.acn.gr>
Date: Wed, 15 Sep 2004 17:18:18 +0300
Message-ID: <ci9ivc$2734$1@ulysses.noc.ntua.gr>

I use 9ir2 and i use gather auto to gather stats with monitoring on on a 24x7 OLTP.

I am on 9.2.0.4 patch and there are some bugs of the dbms_stats i think solved on 9.2.0.5

"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.
>
>
>
Received on Wed Sep 15 2004 - 09:18:18 CDT