ORA-01595: error freeing extent of rollback segment

  • From: "Roger Xu" <Roger.Xu@xxxxxxxxxxx>
  • To: "Oracle-L@Freelists. Org \(E-mail\)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 18 Sep 2006 10:16:49 -0500

Hi List,
We are on Oracle9i Enterprise Edition Release - 64bit Production.
Anyone ever has this error with AUTO undo-management?
*** 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 
SQL> show parameter undo
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     180
undo_suppress_errors                 boolean     FALSE
undo_tablespace                      string      UNDO

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 

Other related posts: