Re: Size of transactions

Thank you.

Does it mean if you have unlimited disk space for rollback segments you can have transactions with unlimited size?

Ohter question:
Is each transaction assigned to exactly one rollback segment or could it be that one transaction is distributed to several rollback segments?

Thomas

Ronan Miles wrote:
>
> 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:42:10 CDT