Re: how synchronous is Oracle?

Following up on Robert A.M. van Lopik, 06 Mar 2003:

> The question is: does Oracle guarantee that committed inserts are
> "immediately" visible to other users,

Yes. Absolutely. If it is committed, it is visible to others.

> 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?
>

No, not at all. Other products indeed may suffer from that problem due to their locking model. Not Oracle.

> rule out the possibility that records would not be immediately visible,
> or learn how to make this happen if the guarantee is not there.

Just make sure you committ. They will be visible, no matter what.

> B.T.W. The concrete question is about Oracle Version 8.1.7
>

Makes absolutely no difference since Version 4.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam