Re: alter table monitoring

From: Sean Fitzgerald <sfitzgerald_at_centurytel.net>
Date: Wed, 9 Jan 2002 23:08:57 -0800
Message-ID: <dy8%7.13191$Xs4.3131917@feed.centurytel.net>

You need to wait about 3 hours for smon to discover the changes or do a shutdown immediate

After that you will see data in dba_tab_modifications

"a" <dbadba62_at_hotmail.com> wrote in message news:%75%7.22729$tz1.19838_at_nwrddc01.gnilink.net...
> After I alter table monitoring as the owner of the table, I insert one row
> into the table, and then commit. After that, I select count(*) form
> sys.dba_tab_modifications as system, the result is 0.
>
> Is there anything I did wrong? How do you collect the info after you
alter
> table monitoring?
>
> I am using Oracle 817 on Solaris.
>
> Thanks for your help.
>
>
Received on Thu Jan 10 2002 - 01:08:57 CST