Re: Restrict Statistics collection - 10g/MMON

for stopping statistic collection

exec DBMS_STATS.LOCK_SCHEMA_STATS(schema_name)

for re enabling it

exec DBMS_STATS.UNLOCK_SCHEMA_STATS(schema_name)

for a particular table and its indexes

exec DBMS_STATS.LOCK_TABLE_STATS ('schema_name','table_name');

exec DBMS_STATS.UNLOCK_TABLE_STATS ('schema_name','table_name');

Be careful when locking schema if you have unlock a table because locking schema overrides unlocking tables

good luck

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