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_at_fastmail.fm> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 15 2007 - 09:19:09 CDT
