Re: rollbacks ??

On 02-Jun-98 14:33:34 Ed Lufker wrote:

>Hi all:

> Can anyone give me some tips on how to size my rollback segments
>for both batch and OLTP. I was getting the following error when doing a
>delete last night.

>ORA-1628: max # extents 505 reached for rollback segment R05
>Failure to extend rollback segment 6 because of 1628 condition
>FULL status of rollback segment 6 cleared.

I think a good solution is to have some small rollback segments for OLTP and one big segment for your batches.
In a batch you can issue a command like

set transaction use rollback segment RB_BIG;

This one explicitely selects a specific rollback segment. The command has to be issued immediately after the transaction starts i.e. after the commit or rollback.

>thanks
>eddie lufker

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |