RE: Rollback segments & Transactions

From: Greg Heath <gheath_at_novagate.com>
Date: 1996/05/12
Message-ID: <01bb4046.ad421c60$2f8a8acd_at_novagate.com.novagate.com>#1/1


If the ability to rollback the transaction is not important. You should be able truncate the table.
On Friday, May 10, 1996, Paul Taylor wrote...
> Hi
>
> I have the following problem, can anyone help?
>
> We are trying to delete the contents of a tables, but it is quite large
> so therefore the rollback segment is either not large enough or I
> require some additional rollback segments.
>
> After looking through Oracle manuals etc. I found that in order to
> estimate the number of rollback segments I should apply the formula
> below:
>
> No. of Transactions/Transactions per rollback segment
>
>
> How do I define a transaction, is it every commit that is made, or is it
> every database command made?
>
> Also, how do I decide upon how large I should make the rollback segment?
>
> Thanks
>
> Paul
>
Received on Sun May 12 1996 - 00:00:00 CEST

Original text of this message