Re: SMON oflining

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Tue, 06 Jul 2004 23:59:16 GMT
Message-ID: <o1HGc.940$j21.712@newsfe4-gui.ntli.net>

"Gordon" <gordon_t_wu_at_hotmail.com> wrote in message news:g5GGc.567$Ny6.1461_at_mencken.net.nih.gov...
> Platform: Oracle 10g on RedHat Adv Server 3.
>
> A snapshoot of the alert log:
>
> SMON offlining US=12
> Freeing IMU pool for usn 12
> SMON offlining US=13
> Freeing IMU pool for usn 13
>
> Can anyone tell me what does the above msg mean?
> Google seems to be telling me that this is another form of ORA-1555
> (snapshot too old).
> However, I do not believe I have roll-back segment problem.
>
> I am using automatic undo managment, and a query on v$undostat shows that
> expired blocks (unxpblkreucnt) are consistently 0.
>
> Thanks
>
> Gordon
>
>

dont worry about it, just smon offlining some undo segments which arent needed. It is normal

When it need them they will come online Received on Tue Jul 06 2004 - 18:59:16 CDT