Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segment problem

Re: Rollback segment problem

From: Stephen Kraus <skraus_at_cisco.com>
Date: 1998/01/14
Message-ID: <34BD7921.12E0@cisco.com>#1/1

Supian Zainuddin wrote:

> We have 2 servers allocated for the project i.e. development and system
> server. Both with Oracle 7.1.3 installed and an application kit ( same
> on both servers ).
>
> Upon executing the application ( both sides ), a batch job is launched
> with the same user name ( having the same authoristaion and allocated
> parameters ) targetting on the specific server.
>
> The system server managed to complete but the development gave an error
> of rollback segment too small.
>
> Both DB on both servers were allocated the same rollback segment size,
> therefore in theory this should not have happened.
>
> The only difference that we could detect is that the tablespace sizes
> are slightly different, will this have an impact on the rolback segment
 

> I appreciate any tips from anyone who have had the same problem, or
> whoever that knows where the problem might be, or any tip whatsoever.
>
> Does anybody have any real documentation on rollback segment that you
> could forward that might help.

You might consider specifically stating which rollback segment to use:

set transaction use rollback segment ROLLBACK_SEGMENT_NAME;

This way, you will know which one from the outset is causing a problem and it gives some more control. Otherwise, it could change each time (unless you only have one rollback segment) which can confuse things.

If the tablespace sizes differed, one rollback segment might not have been able to extend. Also, other users may have also been using the same rollback segment at the same time, taking up some of the space needed.

I also would suggest either Oracle error number or text would be useful to include in the future to avoid any misinterpretations. Incidentally, 7.1.3 is a pretty old version. You might consider upgrading. Received on Wed Jan 14 1998 - 00:00:00 CST

Original text of this message

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