Re: Oracle Isolation Levels
From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Thu, 20 Feb 2014 12:37:20 -0600
Message-ID: <CA+fnDAbi7J9HRWz39nqZ9UAaVDk-GPLn2pxZB=VxSe7YzN=ZAg_at_mail.gmail.com>
On Thu, Feb 20, 2014 at 10:43 AM, David Fitzjarrell <oratune_at_yahoo.com>wrote:
Date: Thu, 20 Feb 2014 12:37:20 -0600
Message-ID: <CA+fnDAbi7J9HRWz39nqZ9UAaVDk-GPLn2pxZB=VxSe7YzN=ZAg_at_mail.gmail.com>
On Thu, Feb 20, 2014 at 10:43 AM, David Fitzjarrell <oratune_at_yahoo.com>wrote:
>
> Phantom reads occur when uncommitted data is returned to the querying
> session and Oracle doesn't allow that to happen.
>
David, I believe you're describing a "dirty read" not a "phantom read".
references:
http://www.cs.umb.edu/~poneil/iso.pdf
http://www.oracle.com/technetwork/issue-archive/2005/05-nov/o65asktom-082389.html
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 20 2014 - 19:37:20 CET