Re: Cursors and SCN : consistent read ??

From: Igor Sereda <sereda_at_spb.runnet.ru>
Date: Wed, 22 Apr 1998 13:43:05 -0400
Message-ID: <353E2C29.854326B7@spb.runnet.ru>

Hi,

you need to issue

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before your transaction begins in order to 'freeze' data for your cursor. See also Oracle Server Concepts, Chapter 10.

Hope this helps,
Igor

philippe wrote:
>
> When I open a cursor, I do see records that where appended by other
> people after I opened I. T thought that Oracle used SCN to provide a
> consistent view of data, i.e a view of data having the correct SCN. Can
> somebody explain this to me ??
>
> Best Regards,
>
> Philippe (philippe_at_arpege.imaginet.fr)
> --- One day I'll be a DBA !!! ---

--
Igor Sereda,
ITC, Russia Received on Wed Apr 22 1998 - 12:43:05 CDT