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: Rollback problem

RE: Rollback problem

From: Zhou, Tapiwanashe <tzhou_at_border.co.zw>
Date: Tue, 12 Dec 2000 10:55:07 +0200
Message-Id: <10708.124344@fatcity.com>


try increase your initial size

-----Original Message-----
From: Dash, Saroj (CAP,CEF) [mailto:Saroj.Dash_at_gecapital.com] Sent: Tuesday, December 12, 2000 9:40 AM To: Multiple recipients of list ORACLE-L Subject: Rollback problem

Hello All,

This is regarding Rollback segment problem In UNIX platform.

We have one instance In unix sun solaris ,the database is batch oriented .when we are running the batches lots of transaction are going on.

so Our rollback segment size is fulled.In RBS tablespace we have two datafiles. one datafile size is 2048M and another is 1000M.

and one rollback segment is there. whose size Initial is 1M ,next 1M and optimal 500M.

The problem is .
oneday When batch runs then all the RBS datafiles are full.

Please tell me what to do.

Can I Create more rollback segment on RBS tablespace.What could be the soluation for this ??

Regards,
Saroj.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Dash, Saroj (CAP,CEF)
  INET: Saroj.Dash_at_gecapital.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). Received on Tue Dec 12 2000 - 02:55:07 CST

Original text of this message

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