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

From: Roger Xu <Roger.Xu_at_dp7upbg.com>
Date: Mon, 18 Sep 2006 11:13:12 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F70AAF280D@irv2kexch01.tx.bg.corp>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu Sent: Monday, September 18, 2006 10:17 AM To: Oracle-L_at_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.

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

Received on Mon Sep 18 2006 - 11:13:12 CDT