Re: Optimizer Statistics,Histograms and 10.2.0.2

got that done and taken care of. 
any idea what i should pursue next 



----- Original Message ----
From: Wolfgang Breitling <breitliw@centrexcc.com>
To: Fuad Arshad <fuadar@yahoo.com>
Cc: oracle-l@freelists.org
Sent: Friday, November 17, 2006 11:05:04 AM
Subject: Re: Optimizer Statistics,Histograms and 10.2.0.2

At 09:18 AM 11/17/2006, Fuad Arshad wrote:

i used this query to get the result set below 

select * from DBA_OPTSTAT_OPERATIONS 

where operation like '%database%' ;

 

yes the 2 entries are part of the mytery.

i've looked at all parts of the applications and no one has even authority to execute gather_database_stats.

so its something oracle is doing but i cant figure why and how.

the entries are 2 at  a time and are random sometimes 1 week and sometimes 15 days. so i cant come up with a pattern.

can you tell me how i can change the method_opt parameter so it  defaults to size 1 

BEGIN dbms_stats.SET_PARAM(PNAME=>'method_opt',PVAL=>'for all columns size 1'); END;


Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com 
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

--
http://www.freelists.org/webpage/oracle-l