Re: alter table ... nomonitoring doesn't work??

On Wed, 25 Jul 2007 13:11:10 -0700, Ben <balvey_at_comcast.net> wrote:

>10.2.0.2 EntEd, AIX5L
>
>I had several tables set to nomonitoring in 9.2.0.5 now that I
>upgraded to 10.2.0.2, it turned monitoring on for all tables and I
>can't get it to turn off. Anyone else have this issue?
>
>SQL> alter table proddta.f3411 nomonitoring;
>
>Table altered.
>
>SQL> select owner, table_name, monitoring
> 2 from dba_tables
> 3 where owner = 'PRODDTA'
> 4 and table_name = 'F3411';
>
>OWNER TABLE_NAME MON
>------------------------------ ------------------------------ ---
>PRODDTA F3411 YES
>
>SQL> begin
> 2 dbms_stats.unlock_table_stats(
> 3 ownname => 'PRODDTA',
> 4 tabname => 'F3411');
> 5 end;
> 6 /
>
>PL/SQL procedure successfully completed.
>
>SQL> alter table proddta.f3411 nomonitoring;
>
>Table altered.
>
>SQL> select owner, table_name, monitoring
> 2 from dba_tables
> 3 where owner = 'PRODDTA'
> 4 and table_name = 'F3411';
>
>OWNER TABLE_NAME MON
>------------------------------ ------------------------------ ---
>PRODDTA F3411 YES
>
>SQL>
IIRC this is a documented 10g feature, which is compatible with their automatic statistics gathering job.
Usually features like this are described in the 'New features document' for your release.

-- 
Sybrand Bakker
Senior Oracle DBA