RE: ORA-01595: error freeing extent of rollback segment

I think I can ignore this and it is supposed to be fixed in 10g. Thanks!
 
Subject:        With AUM Enabled ORA-01594 and ORA-01595 Found in the alert.log 
         Doc  <https://metalink.oracle.com/help/usaeng/Search/search.html#file> 
ID:     Note:280151.1    Type:  PROBLEM 
         Last Revision Date:    04-JUL-2005      Status:        MODERATED       

In this Document
   Symptoms 
<https://metalink.oracle.com/metalink/plsql/f?p=130:14:1428045839744987791::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,280151.1,1,1,1,helvetica#SYMPTOM>
 
   Cause 
<https://metalink.oracle.com/metalink/plsql/f?p=130:14:1428045839744987791::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,280151.1,1,1,1,helvetica#CAUSE>
 
   Solution 
<https://metalink.oracle.com/metalink/plsql/f?p=130:14:1428045839744987791::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,280151.1,1,1,1,helvetica#FIX>
 
   References 
<https://metalink.oracle.com/metalink/plsql/f?p=130:14:1428045839744987791::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,280151.1,1,1,1,helvetica#REF>
 


  _____  




This document is being delivered to you via Oracle Support's Rapid  
<https://metalink.oracle.com/metalink/plsql/f?p=130:14:1428045839744987791::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,280151.1,1,1,1,helvetica#>
 Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been 
subject to an independent technical review.       



Applies to: 

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 9.2.0.6
This problem can occur on any platform.


Symptoms

The following errors are logged to alert.log:

ORA-01595: error freeing extent (2) of rollback segment (10))
ORA-01594: attempt to wrap into rollback segment (10) extent (2) which is being 
freed

Automatic Undo Management is enabled. 

Cause


The error is signaled because smon is shrinking a rollback segment and this 
fails because we need an extent to store some rollback information. This is a 
failure message for the shrinking. Subsequently smon would succeed in doing 
that. 

Solution

Ignore these error messages.
Normally adding more undo space should solve the problem.

This error message logging is fixed in 10g. 

References


Errors

ORA-1594 
<http://metalink.oracle.com/metalink/plsql/ml2_gui.handleSearchRequest?p_search=Submit&p_text=ORA-1594>
  "attempt to wrap into rollback segment (%s) extent (%s) which i
ORA-1595 
<http://metalink.oracle.com/metalink/plsql/ml2_gui.handleSearchRequest?p_search=Submit&p_text=ORA-1595>
  error freeing extent <num> of rollback segment <name>


Key Facts 


' ROLLBACK~SEGMENT 
<http://metalink.oracle.com/metalink/plsql/ml2_gui.handleSearchRequest?p_search=Submit&p_text='KEYWORD:ROLLBACK~SEGMENT'>
 '   

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Roger Xu
Sent: Monday, September 18, 2006 10:17 AM
To: Oracle-L@Freelists. Org (E-mail)
Subject: ORA-01595: error freeing extent of rollback segment


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.



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: