Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Optimizer Statistics,Histograms and 10.2.0.2

Re: Optimizer Statistics,Histograms and 10.2.0.2

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Fri, 17 Nov 2006 09:49:53 -0800 (PST)
Message-ID: <20061117174953.15648.qmail@web82101.mail.mud.yahoo.com>

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
Received on Fri Nov 17 2006 - 11:49:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US