Re: Get rid of trace files with undo notification

["Alex Gorbachev" <gorbyx@xxxxxxxxx>]

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@xxxxxxxxx>:
> 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@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

• References:
  • Get rid of trace files with undo notification
    • From: Alfonso León

Other related posts:

Get rid of trace files with undo notification

Re: Get rid of trace files with undo notification

Re: Get rid of trace files with undo notification

Re: Get rid of trace files with undo notification

Re: Get rid of trace files with undo notification

Re: Get rid of trace files with undo notification