Re: commit or not commit inside a cursor loop

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 28 May 2003 22:38:21 +0200
Message-ID: <1e7advsqu9j1k8g4eqikof1r3cv4npl970@4ax.com>

On Wed, 28 May 2003 20:23:27 +0200, "Carsten Saager" <carsten_at_saager.org> wrote:

>choice if you cannot enlarge your RBS/UNDO tablespaces for
>this transaction. The main problem is that Oracle has to maintain the
>read-consistency cursor so you might a receive (randomly) a 1555 anyway if
>other sessions are making changes to the data your cursor relies on.

this just absolute crap and hogwash. Rollback segments can and will be extended automatically if set up appropiately. A transaction is a transaction. Data maintained for read-consistency purposes in a transaction will NEVER been overwritten. Please don't post such rubbish and nonsense

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed May 28 2003 - 15:38:21 CDT