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