Re: rollbacks ??

From: David Ng <david_ng_at_attmysite.com>
Date: Fri, 12 Jun 1998 15:26:18 +0800
Message-ID: <6lql0e$paq$1@m5.att.net.hk>

One way to get around this is to create some huge rollback segment for batch processing. You can specify the huge rollback segment in your batch to avoid overflow.

David Ng

Ed Lufker wrote in message <6l0uve$nah$1_at_sloth.swcp.com>...
>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.
>
>thanks
>eddie lufker
>
Received on Fri Jun 12 1998 - 02:26:18 CDT