Re: how synchronous is Oracle?

"Robert A.M. van Lopik" wrote:

> Consider the following scenario:
> I have two processes, A and B. process A logs on to the database, inserts a
> record into a table, logs of and signals (one way or another) process B.
> Process B was already logged on and does a select that should retrieve the
> record just inserted.
> The question is: does Oracle guarantee that committed inserts are
> "immediately" visible to other users, or is there a possibility, e.g. on a
> heavily loaded system, that proces B will not retrieve the record, although
> it will see it at a somewhat later time?
>
> I found a thread in this forum about serializability around 1999, but that
> was too theoretical for my liking. For now I just would like to rule out the
> possibility that records would not be immediately visible, or learn how to
> make this happen if the guarantee is not there.
>
> B.T.W. The concrete question is about Oracle Version 8.1.7
>
> Thanks,
> Rob van Lopik

The other answers are good. For more go to http://tahiti.oracle.com and look up "read consistency". Pay special attention to the listings under CONCEPTS and APPLICATION DEVELOPER'S GUIDE. Daniel Morgan Received on Thu Mar 06 2003 - 10:50:25 CST