Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Size of transactions
Thomas Budich <t.budich_at_gmx.de> wrote in message news:<3BAEF126.64CFC8F2_at_gmx.de>...
> 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
Thomas, the transaction size is basically limited by the size a rollback segment may grow to, and by how long the application can function in an acceptable manner with the large transaction holding locked rows (that is preventing any other session from updating the same data.)
![]() |
![]() |