Re: uncommitted reads

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 22 May 2003 23:55:58 +0100
Message-ID: <3ecd5a8b$2_1@mk-nntp-1.news.uk.worldonline.com>

"Lanying & Manfred Chen-Fischer" <manfis_at_t-online.de> wrote in message news:bad30g$7cs$04$1_at_news.t-online.com...
> Hi
>
> 1. is there any chance to have an ancommitted read in Oracle?
>
> ManFis
>

Yes. the session involved can read its own. Other sessions see only committed.

But I'd be glad to have this explained:

I have observed that if you do some DML over a db link, and commit, then a different session sees the data as before the commit. Tested in 8.1.7.0.0 on hpux only. Effect is only for a few seconds. Is this because it's waiting for the two-phase?

Regards,
Paul Received on Thu May 22 2003 - 17:55:58 CDT