Re: COMMIT inside CURSOR-FOR-LOOP

From: Robbie <rob_at_dsdelft.nl>
Date: 1997/08/16
Message-ID: <01bcaa43$ac810a80$ecf56cc3@127.0.0.1>#1/1

> But i am told that COMMIT inside a fetch-loop for a CURSOR even if the
> SELECT does not have FOR UPDATE is not a good practise as there is
> problem with rollback segment if the data handled by the SELECT is
> huge..
>
> I am not very clear about the above.. Any further clarifications, ideas
> welcome..
>
> Rajesh
>

I think you are refering to problems with 'read consistency' here. If you are updating and commiting the table you are refering to in your cursor the committed data is not relaesed from you rollbacksegments. To try to avoid the error message 'snapshot too old' committing not to often.

Robbie. Received on Sat Aug 16 1997 - 00:00:00 CDT