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: <prabhu.srinivasan_at_ap.abnamro.com>
Date: Wed, 13 Dec 2000 11:10:38 +0800
Message-Id: <10708.124410@fatcity.com>


$)C
Saroj,

One more suggestion...

(1) Add a datafile(more than the size specified) with autoextend on and
next 10M
(2) Alter the rollback segment with maxextents unlimited and next < 10M
(but >1M altleast).

If you've encountered this previously, then based on that experience and the amount of free disk space you can set the size accordingly. Whatever I've mentioned is just an approximate estimate. If its a one-time operation you can keep a big rollback segment for this purpose and use it when required.

Prabhu

RROGERS_at_galottery.org_at_fatcity.com on 12/12/2000 09:26:12 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: Re: Rollback problem

Saroj.
 If there is space in the tablespace when the RBS is at max then you should create another RBS for the instance to use. Use the "create rollback..."statement to create the new rollback segment. "Alter rollback..." to bring it online.
update your init.ora to let your instance know about the new rollback segment if you shutdown and restart your instance.

ROR m(#"/(#m

>>> Saroj.Dash_at_gecapital.com 12/12/00 02:40AM >>> 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: RROGERS_at_galottery.org 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
Received on Tue Dec 12 2000 - 21:10:38 CST

Original text of this message

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