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: Bernard, Gilbert <Gilbert.Bernard_at_caissedesdepots.fr>
Date: Thu, 23 May 2002 06:43:33 -0800
Message-ID: <F001.00469229.20020523064333@fatcity.com>


50K

	-----Message d'origine-----
	De:	Mark Leith [mailto:mark_at_cool-tools.co.uk]
	Date:	jeudi 23 mai 2002 15:59
	:	Multiple recipients of list ORACLE-L
	Objet:	RE: ORA-01595

	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).
-- 
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).
Received on Thu May 23 2002 - 09:43:33 CDT

Original text of this message

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