Re: Size of transactions

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 24 Sep 2001 14:48:52 +0100
Message-ID: <3baf39ca$0$227$ed9e5944@reading.news.pipex.net>

Comments embedded
"Thomas Budich" <t.budich_at_gmx.de> wrote in message news:3BAF2A22.A2922B9F_at_gmx.de...
> Thank you.
>
> Does it mean if you have unlimited disk space for rollback segments you
> can have transactions with unlimited size?

There would be an effective limit of (max possible extent size * max possible no of extents for a tablespace) This almost certainly equates to a very very silly number.
>
> Ohter question:
> Is each transaction assigned to exactly one rollback segment or could it
> be that one transaction is distributed to several rollback segments?

Yes. However each rollback segment may (and usually will) contain multiple transactions. Thus you are in practice likely to get snapshot too old errors with very very large, or very very long running transactions.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Mon Sep 24 2001 - 08:48:52 CDT