RE: ORA-01595: error freeing extent of rollback segment
- From: "Roger Xu" <Roger.Xu@xxxxxxxxxxx>
- To: "Roger Xu" <Roger.Xu@xxxxxxxxxxx>, "Oracle-L@Freelists. Org \(E-mail\)" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Sep 2006 11:13:12 -0500
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:
