Re: collecting statistics on table those have bulk inserts everyday..
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Apr 2001 16:38:03 +0300
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@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Syed Jaffar Hussain
> Sent: Thursday, April 12, 2001 3:51 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
