Re: Get rid of trace files with undo notification

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_at_gmail.com>:
> 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_at_hp00pb0a (TNS V1-V3)
>
> *** 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