FreeLists / oracle-l / Re: Get rid of trace files with undo notification

["Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>]

> we are getting a lot of traces files with the following information, does
> anybody know why this traces appear and how to supress them?

I remember there was a bug (and possible instance hang) that I suppose has 
already been fixed (9.2.0.7/10g?), but you could get rid of the continuous 
undo offlining/onliing with event 10511, level 2.

<quote>
Solution
Prevent SMON from offlining idle Undo Segments using event 10511.
Set the following parameter in init.ora/spfile

event="10511 trace name context forever, level 2"

Then restart the database.

After the first onlinining of an Undo Segment, it will never be offlined and
re-onlined.
So we will only get the "US" serialization once (on the first online after a
db restart.)

</quote>


Regards
Dimitre 

--
http://www.freelists.org/webpage/oracle-l