Re: how synchronous is Oracle?

I used a similar technique for queueing slow jobs with Oracle 7.1.4 and 8.0 5 and both worked flawlessly.
Logically speaking, if there was a potential delay between the commit and the data actually appearing in the database, there would be all kinds of issues with autonomous transactions.

If you are talking about distributed databases it might be another issue, but theoretically it would make no difference.

ETA "Robert A.M. van Lopik" <lopik_at_mail.telepac.pt> wrote in message news:<3e66fee5$0$10173$a729d347_at_news.telepac.pt>...
> 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
Received on Thu Mar 06 2003 - 11:33:35 CST