Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback problem
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