How large are the rollback segments?
The ORA-01594 error states:
attempt to wrap into rollback segment (string) extent (string) which is
being freed
Cause: Undo generated to free a rollback segment extent is attempting to
write
into the same extent due to small extents and/or there are too many extents
to
free.
Action: The rollback segment shrinking will be rolled back by the system;
increase the optimal size of the rollback segment.
Can you try increasing the OPTIMAL parameter for the SYSTEM rollback
segment? Typically the SYSTEM rollback segment is created much smaller than
the "public" rollback segments..
1 select segment_name,
2 initial_extent,
3 next_extent,
4 status
5* from dba_rollback_segs
sales>/
SEGMENT_NAME INITIAL_EXTENT NEXT_EXTENT STATUS
------------------------------ -------------- ----------- ------
SYSTEM 57344 57344 ONLINE
RBS0 524288 524288 ONLINE
RBS1 524288 524288 ONLINE
RBS2 524288 524288 ONLINE
RBS3 524288 524288 ONLINE
RBS4 524288 524288 ONLINE
RBS5 524288 524288 ONLINE
RBS6 524288 524288 ONLINE
alter rollback segment system storage(optimal 'X'M)
HTH
Mark
-----Original Message-----
Gilbert
Sent: 23 May 2002 14:18
To: Multiple recipients of list ORACLE-L
I am trying to do this.
alter rollback segment SYSTEM shrink;
alter rollback segment R01 shrink;
alter rollback segment R02 shrink;
alter rollback segment R03 shrink;
alter rollback segment R04 shrink;
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1) which is
being
freed
And only on rollback system I got an error. There are no transcations in
this RBS.
Any Idea.
-----Message d'origine-----
De: Mark Leith [mailto:[EMAIL PROTECTED]]
Date: jeudi 23 mai 2002 13:33
À: Multiple recipients of list ORACLE-L
Objet: RE: ORA-01595
It looks like you only have 1 extent within the system rollback
segment
anyway?
Why are you trying to shrink it? Do you have other rollback segments
in
place?
-----Original Message-----
Gilbert
Sent: 23 May 2002 11:48
To: Multiple recipients of list ORACLE-L
The accompanying messgage is
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1)
which is
being
freed
-----Message d'origine-----
De: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Date: mercredi 22 mai 2002 16:29
À: Multiple recipients of list ORACLE-L
Objet: RE: ORA-01595
Gilbert - The oerr utility says the key part is the
accompanying
message.
Can you forward the accompanying messgage?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Wednesday, May 22, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L
ORA-01595 error freeing extent (string) of rollback segment
(string))
I got this error when I tryed to shrink the rollback segment
system,
What can I do to solve this problem, optiman does'nt solve
it.
thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing
Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing
Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
