Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Monitoring not populating user_tab_modifications Table
Dont Bother...
Its working now
Thanks
Ronnie
"Ronnie Yours" <ronnie_yours_at_yahoo.com> wrote in message
news:aie5ja$7dl$1_at_nntp-m01.news.aol.com...
> Hi,
>
> Yesterday I enabled the Monitoring Clause for one of my Tables which had
> 89856 Records in it.I then analyzed the Table. Then I added 20 records to
> the table taking the total to 89876 Records.
> I read somewhere that smon wakes up every 3 hours and writes a count of
> modifications on the Monitored Table to the user_tab_modifications table.
>
>
> Its been more than 12 hours now and the count has not been updated.
>
> Please suggest.
>
> Thanks
> Ronnie
>
>
Received on Fri Aug 02 2002 - 09:55:24 CDT