Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-01595
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) extentsubscribing).
(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
-- 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-LReceived on Thu May 23 2002 - 09:43:33 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |