Oracle-L: RE: Rollback segment full

From: Ratnesh Kumar Singh <ratnesh.singh_at_patni.com>
Date: Fri, 01 Nov 2002 02:23:37 -0800
Message-ID: <F001.004F987D.20021101022337@fatcity.com>

3 options

if possible , put a commit in your procedure to reduce load on rollback segs
ask your dba to increase size of rollback segments. Since rollback segment allocation is random, u may have to drop the smaller rbs segs and create new larger segs
increase the maxextents of existing rbs segs

HTH
ratnesh

-----Original Message-----
Sachin (GEP)
Sent: Friday, November 01, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L

Hi all
i am trying to execuate one procedure which upadte the table containing 29443 records. After 2 hours going in loop, procedure returns following error:

SQL> exec test
BEGIN test; END;

*
ERROR at line 1:

ORA-01562: failed to extend rollback segment number 2
ORA-01628: max # extents (249) reached for rollback segment R02
ORA-01562: failed to extend rollback segment number 2
ORA-01628: max # extents (249) reached for rollback segment R02
ORA-06512: at "SA.TEST", line 14
ORA-06512: at line 1

Any help is appreciated.

Regards,
Sachin

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gharat, Sachin (GEP)
  INET: sachin.gharat_at_gepex.ge.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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: Ratnesh Kumar Singh
  INET: ratnesh.singh_at_patni.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Fri Nov 01 2002 - 04:23:37 CST