ORA-01595: error freeing extent of rollback segment

From: Roger Xu <Roger.Xu_at_dp7upbg.com>
Date: Mon, 18 Sep 2006 10:16:49 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F70C8D419F@irv2kexch01.tx.bg.corp>

Hi List,  

We are on Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production. Anyone ever has this error with AUTO undo-management?  

Thanks,  

• SESSION ID:(5.1) 2006-09-16 14:34:01.693
• 2006-09-16 14:34:01.693 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (7)) ORA-01594: attempt to wrap into rollback segment (7) extent (2) which is being freed

SQL> show parameter undo  

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     180
undo_suppress_errors                 boolean     FALSE
undo_tablespace                      string      UNDO

Roger

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o

---

This email has been scanned for all viruses by the MessageLabs Email Security System.

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

Received on Mon Sep 18 2006 - 10:16:49 CDT