| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: collecting statistics on table those have bulk inserts everyday..
Williams,
I can understand that, the thing is, there are some queries which always scan those heavy inserts tables regularly. I have thought from this point view that if those quieries didn't get the fresh statistics on the tables, it might produce not reliable explain plans.
Thanks for your time
Jaffar
----- Original Message -----
From: "DENNIS WILLIAMS" <DWILLIAMS_at_LIFETOUCH.COM>
To: <oracle-l_at_freelists.org>
Sent: Monday, April 12, 2004 3:33 PM
Subject: RE: collecting statistics on table those have bulk inserts
everyday..
> Syed
> What is your purpose in collecting statistics? So the CBO can make
> accurate decisions based on the fresh statistics? Then the question is how
> much will the table change before the CBO is likely to make a different
> decision. You must make that judgement. Also, be aware that when the CBO
> makes a different decision based on the fresh statistics, it may take a
> different path that may produce worse performance at an unpredictable
time.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Syed Jaffar Hussain
> Sent: Thursday, April 12, 2001 3:51 AM
> To: oracle-l_at_freelists.org
> Subject: collecting statistics on table those have bulk inserts
> everyday..
>
>
> Hi List,
> We have some tables which have heavy insets everyday, can any one please
> hint me how often do I have to collect statistics on these tables?
Normally,
> I collect statistics every alternative day. We are using Oracle 8i not 9i,
I
> know there is a feature in 9i to collect statistics automatially for
regular
> inserts tables. Unfortunately, we are still using oracle 8i.
>
> Best Regards,
> Syed Jaffar Hussain
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Apr 12 2004 - 08:43:05 CDT
 |
 |