Re: Creating Histograms

Comments as always
On Thu, 22 Jul 2004 10:37:21 -0400, Freeman, Donald <dofreeman_at_state.pa.us> wrote:
> OK, I understand your point about gathering on schedule. I'm moving into =
> taking over a turn-key contractor developed system. We are doing =
> stats/computed every day. We only add, at most, a few thousand records =
> a day. This is much, much less than 10%. We converted a few million =
> records, about five years worth of records, from four or five other =
> public health databases but our daily accrual is relatively small. I =
> probably wouldn't have to run stats once in a month.

take note of how many records you add to relatively *small* tables. 13 rows added to one of our tables caused hell until we gathered stats again (and it took ages for anyone to admit that anything ahd changed). That would be 13 rows in the sense of another financial year to add to the 2 existing ones - so hardly significant at all :).

I guess I'm saying different objects might have different stats needs.

>We also don't =
> collect system stats. I'm hoping to get enough information here to 'have =
> a meeting' and get all of that changed, the method and rate of =
> collection.

Test system stats carefully (I'm probably too cautious on this), but system stats are likely to make quite a noticeable difference to execution times. It is, I'm increasingly convinced, the *right* thing to do. It doesn't mean that you may not have adverse effects. Overall system stats have been positive for our test financial environmentenough  so that they get introduced with the next software upgrade that is running there - but there has been the odd hiccup.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
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
-----------------------------------------------------------------