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 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.

Other related posts: