Re: how synchronous is Oracle?

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: 06 Mar 2003 13:07:38 GMT
Message-ID: <Xns9336F2D82BF04Tokenthis@210.49.20.254>

Following up on Tanel Poder, 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.

>
> ..with the exception of already running queries...
>

Sure. But already running queries started *before* the commit was finished.

After the commit ends, the row(s) involved will be immediately visible to any user that starts looking then. That is the correct process in terms of concurrency and Oracle enforces it strictly.

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

Received on Thu Mar 06 2003 - 07:07:38 CST