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

Home -> Community -> Mailing Lists -> Oracle-L -> Restrict Statistics collection - 10g/MMON

Restrict Statistics collection - 10g/MMON

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Thu, 15 Mar 2007 06:42:24 -0700
Message-Id: <1173966144.1148.1179609579@webmail.messagingengine.com> 





10g does auto collection of statistics. It does it when the system is
having less activity. Is there any way i can stop the statistics
collection from taking place for a particular schema? I can run a job to
delete statistics. We are going to upgrade to 10g and the optimizer mode
is going to be the default ALL_ROWS. We are not planning to change it to
RULE since it is de-supported.



Any ideas?



TIA


Govidan

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


Received on Thu Mar 15 2007 - 08:42:24 CDT












Original text of this message













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