Re: Use Large Rollback Segment

Any transaction uses a single rollback segment, it cannot use more than one rollback segment. For your large transactions, you need  to explicitly assign it to your big rollback segment:    begin transaction using rollback segment xxx

        do your work here
   commit

(check the manual for the exact syntax, but this is pretty close)

Sue B

 At 08:51 AM 2/2/96 +0800, you wrote:
>According to Oracle Manual, we should use a small rollback segment for optimal
> performance. So we
>use several rollback segment. The first four rollback segments are small ones
> and the last one is
> a large one. But when we perform a massive update, it somestimes fail with a
> message that Oracle
> cannot extend the first four small rollback segments and fail to perform the
> updates. It seems
>that it cannot use the last large rollback segment.
>
>Could anybody have any ideas about that ?
>
>
Received on Thu Feb 01 1996 - 20:19:15 CST