Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-01595

RE: ORA-01595

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Thu, 23 May 2002 05:58:32 -0800
Message-ID: <F001.00469102.20020523055832@fatcity.com>


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:mark_at_cool-tools.co.uk]
	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:DWILLIAMS_at_LIFETOUCH.COM] 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. dwilliams_at_lifetouch.com
-----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: Gilbert.Bernard_at_caissedesdepots.fr 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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM 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: ListGuru_at_fatcity.com (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: Gilbert.Bernard_at_caissedesdepots.fr 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: ListGuru_at_fatcity.com (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: mark_at_cool-tools.co.uk 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: ListGuru_at_fatcity.com (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: Gilbert.Bernard_at_caissedesdepots.fr

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: ListGuru_at_fatcity.com (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: mark_at_cool-tools.co.uk

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: ListGuru_at_fatcity.com (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).
Received on Thu May 23 2002 - 08:58:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US