Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Size of transactions

Re: Size of transactions

From: Mark D Powell <mark.powell_at_eds.com>
Date: 24 Sep 2001 07:03:29 -0700
Message-ID: <178d2795.0109240603.371e0f21@posting.google.com>


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.)

Received on Mon Sep 24 2001 - 09:03:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US