Oracle (at least 9i) offlines UNDO segements every 24 hours IIRC. It
might actually give you problems if that happen to be during your peak
time because Oracle will online/offline many UNDO segments in a short
time (pressure on US enqueues).

2006/7/5, Alfonso Le?n <aleon68@(protected)>:
> Hello:
>
> we are getting a lot of traces files with the following information, does
> anybody know why this traces appear and how to supress them?
>
> THanks in Advance
>
> Alfonso Leon
>
> Dump file
> /oracle9i/app/oracle/admin/HPPROD/udump/hpbp_ora_10103.trc
> Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.6.0 - Production
> ORACLE_HOME = /oracle9i/app/oracle/product/9.2
> System name:   HP-UX
> Node name: hp00pb0a
> Release:   B.11.11
> Version:   U
> Machine:   9000/800
> Instance name: HPBP
> Redo thread mounted by this instance: 1
> Oracle process number: 283
> Unix process pid: 10103, image: oracle@(protected))
>
> *** 2006-06-30 09:04:14.779
> *** SESSION ID:(839.28248) 2006-06-30 09:04:14.777
> Undo Segment 21 Onlined
> *** 2006-06-30 09:24:55.046
> Undo Segment 29 Onlined
> *** 2006-06-30 09:38: 10.620
> Undo Segment 35 Onlined
> *** 2006-06-30 10:01:04.099
> Undo Segment 41 Onlined
>
> --
> Alfonso Leon


--
Best regards,
Alex Gorbachev

http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l