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: Ramamohan B N <ramamohan.bn_at_tatainfotech.com>
Date: Tue, 12 Dec 2000 16:07:07 -0800
Message-Id: <10708.124297@fatcity.com>


Hi Saroj,

You may have to add more space (datafile) OR you have to use intermediate commits.

Regards,
Mohan

"Dash, Saroj (CAP,CEF)" wrote:
>
> 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 ??
Received on Tue Dec 12 2000 - 18:07:07 CST

Original text of this message

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