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