Re: Size of transactions

From: Ronan Miles <ronan.miles_at_bt.com>
Date: Mon, 24 Sep 2001 13:10:29 +0100
Message-ID: <3BAF22B5.990BBBB7@bt.com>

Transaction size is a function of rollback segment size. Fill your rollback segment and that is the end of that transaction. I have a hazy recollection that later versions of Oracle offer the ability to suspend pending adding to the rollback segment.

Regards,
Ronan.

Thomas Budich wrote:

> Hi,
>
> does any body know a limit of transaction size in Oracle8i? Is there
> limit of row number, duration or disk size? Has any body experience with
> huge transactions?
>
> Thanx, Thomas
Received on Mon Sep 24 2001 - 07:10:29 CDT