Re: Restrict Statistics collection - 10g/MMON
- From: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
- To: gkatteri@xxxxxxxxxxx
- Date: Thu, 15 Mar 2007 15:19:09 +0100
Try using dbms_stats.lock_xxx_stats to lock the schema or table stats, so
that the stats will not be re-computed periodically.
On 3/15/07, GovindanK <gkatteri@xxxxxxxxxxx> wrote:
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
