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: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 17 Nov 2006 10:05:04 -0700
Message-Id: <20061117170429.B4BF54B730F@turing.freelists.org>


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:05:04 CST

Original text of this message

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