Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Updating system statistics

Re: Updating system statistics

From: Don Seiler <don_at_seiler.us>
Date: Tue, 12 Dec 2006 13:36:09 -0600
Message-ID: <716f7a630612121136s3a9eb7eew1d269af81fb89cfd@mail.gmail.com>


Forgot to note that this is on 10.2.0.2, 32-bit RHEL3.

So gathering system stats to the user table won't alter CBO behavior then? I assume I have to create that table with dbms_stats.create_stat_table() function.

Don.

On 12/12/06, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
> Hi
>
> > Now I want to gather statistics on the production server over a
> > decent interval (90 minutes?) to put them on development. Is
> > there a way to gather statistics and get the numbers without
> > actually changing the in-place production stats?
>
> If you specify STATTAB and STATOWN you can gather the statistics in a
> user-defined table (i.e. not in the DD).
>
> I usually suggest gathering them over 60 minutes every hour for one week
> or two (you have to specify a unique STATID to avoid replacing already
> available stats). Then a quick analysis in Excel may give you
> interesting information on how to set the values in production.
>
>
> HTH
> Chris
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 12 2006 - 13:36:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US