Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!newsfeed.berkeley.edu!ucberkeley!news.gv.tsc.tdk.com!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
From: ganesh@gtfs-gulf.com (Ganesh Raja)
Newsgroups: comp.databases.oracle.server
Subject: Re: Another angle on this....
Date: 3 Mar 2002 00:29:04 -0800
Organization: http://groups.google.com/
Lines: 23
Message-ID: <a8aed4.0203030029.3cb8975a@posting.google.com>
References: <cb748650.0202180730.2aee50bd@posting.google.com> <3C7144EB.7CA04F3A@ci.seattle.wa.us> <dG5d8.2873$hM6.289452@news6-win.server.ntlworld.com> <II8d8.106169$Pz4.416729@rwcrnsc53> <vT9d8.4259$hM6.513403@news6-win.server.ntlworld.com> <usn7jihpt.fsf@rcn.com>
NNTP-Posting-Host: 195.229.208.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1015144144 1775 127.0.0.1 (3 Mar 2002 08:29:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 3 Mar 2002 08:29:04 GMT
Xref: easynews comp.databases.oracle.server:137295
X-Received-Date: Sun, 03 Mar 2002 01:27:04 MST (news.easynews.com)

Galen Boyer <galenboyer@hotpop.com> wrote in message news:<usn7jihpt.fsf@rcn.com>...
> On Thu, 21 Feb 2002, no.spam@ntlworld.com wrote:
> 
> > The "don't necessarilly see recent commited updates from other users"
> > thing explains more fully
> 
> Can you point me to where this was written about?  I was under the
> impression that once data was committed it was able to be seen by all.
> I'd like to be aware of when this isn't the case.

Take the Case of a Select Stmt that Started at Time A. And an Update
Stmt that Started A+1. The Update Stmt Updated the Records and
commited the same at A+2 Butthe select is still Running and once the
select see the ITL on the Block it goes to The Rollback to get the
Consitent View as of Time A and will not return u the commited record.

This is also given as an example for Ora-01555 Errors that arise out
of select stmts.

HTH

Regards,
Ganesh R