in this email are strictly
> personal.
> >QOTD: Any clod can have facts, having an opinion is
> an art !
> >
> >-Original Message-
> >From: Bob Metelsky
>
[<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED]
> >Sent: Thursday, October 09, 2003 9:4
have any real overhead in a high transaction system?
>
> From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
> Date: 2003/10/09 Thu AM 08:59:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: how to keep statistics up to
is an art !
-Original Message-
From: Wolfgang Breitling
[<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:40 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: how to keep statistics up to date for CBO
One reason to collect index stats separa
Title: RE: how to keep statistics up to date for CBO
So Wolfgang,
in that case, should _wait_ till table stats (which are probably estimate) are complete to perform index stats (which you recommend compute) or can that happen in parallel.
Raj
w to keep statistics up to date for CBO
Thank you very much Tom. That gives me an excellent starting point. I'll
begin to implement this in a devel environment and get a feel for it.
Thanks again!
bob
-Original Message-
Sent: Thursday, October 09, 2003 9:00 AM
To: Multiple recipients of list OR
Title: RE: how to keep statistics up to date for CBO
Likewise all my options are shaken .. not stirred
.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly
Title: RE: how to keep statistics up to date for CBO
Raj,
Of
course you are correct. I didn't see the "cascade" option until just
recently. And I'm a bit lazy. And it's currently working just
fine.
Need
any other lazy-a**ed excuses? :)
Tom Mercadante Orac
Title: RE: how to keep statistics up to date for CBO
Tom,
why would you want to collect table/index stats separately? Any reason? I prefer cascade=>true with mine.
Raj
Rajendra dot Jamadagni at nospamespn
Thank you very much Tom. That gives me an excellent starting point. I'll
begin to implement this in a devel environment and get a feel for it.
Thanks again!
bob
-Original Message-
Sent: Thursday, October 09, 2003 9:00 AM
To: Multiple recipients of list ORACLE-L
Bob,
I do the following:
does monitoring have any real overhead in a high transaction system?
>
> From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
> Date: 2003/10/09 Thu AM 08:59:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: how to keep s
Bob,
I do the following:
First, alter all tables turning monitoring on: alter table {table name}
monitoring;
Monitoring says:
"Specify MONITORING if you want Oracle to collect modification statistics on
table. These statistics are estimates of the number of rows affected by DML
statements over
Bob,
>How does one keep CBO statistics for an applications base tables up to
>date?
>
>We are about to implement the CBO any must read documents.
I wouldn't call it 'must-read', but you can browse my RBO-to-CBO paper at
'http://www.geocities.com/john_sharmila/links.htm' (click on the paper
link).
Title: RE: how to keep statistics up to date for CBO
I like to use a cron job that runs the following in SQL Plus:
begin
dbms_stats.gather_schema_stats(ownname=> 'YOUR_SCHEMA_NAME', options=> 'GATHER AUTO');
end;
You should search the Oracle docs for your ver
13 matches
Mail list logo
