| 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: Optimizer Statistics,Histograms and 10.2.0.2
For those who noticed that I acn't count, I say in my defence that I
decided late to separate the second point into (b) and (c).
At 08:48 AM 11/17/2006, Wolfgang Breitling wrote:
>Fuad,
>
>Two things:
>
>(a) In addition to disabling the auto-gather job I would also (and
>have on "my" Oracle 10 systems) change the method_opt parameter
>default from 'for all columns size auto' back to 'for all columns
>size 1' so that if anyone or anything submits a dbms_stats.gather
>request without specifying method_opt you don't get any unwanted histograms.
>
>(b) Where did you get that list from? From optstat_tab_history? How
>come there are two gather_database_stats entries for each day
>shortly after each other? Or is that part of the mystery?
>
>(c) I noticed that the time jumped by one hour when daylight savings
>time ended. That leads me to believe that the origin is not within
>Oracle since that would keep the same time-of-day even after the
>DT-ST and vice versa switch. I have noticed that shift by 1 hour in
>weblogic appservers that I had set up to start a new log at
>midnight. After daylight savings kicked in the logs switched an hour
>earlier (or later, I forgot which).
>
>At 08:21 AM 11/17/2006, Fuad Arshad wrote:
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 17 2006 - 10:00:29 CST
 |
 |