Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing isolation level?
Hemant Shah wrote:
>
> While stranded on information super highway mcstock wrote:
> :)refer to the SET TRANSACTION statement in the SQL Reference manual
> :)
> :)relevant options are: ISOLATION LEVEL SERIALIZABLE and ISOLATION LEVEL READ
> :)COMMITTED (default)
> :)
> :)doesn't look like ISOLATION LEVEL SERIALIZABLE does what you want
> :)
> :)
> :)you'll also want to carefully review the sections on Data Concurrency and
> :)Consistency in the Concepts manual
> :)
>
> As others have mentioned, none of the isolation level will block readers.
> I will have to find some other way.
>
Oracle des have IPC, pipes and other mechanisms to allow you to force sync. Might help in this case. Received on Wed Dec 03 2003 - 03:38:12 CST