Re: ACID
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Wed, 24 Aug 2011 01:27:54 -0700 (PDT)
Message-ID: <1314174474.34826.YahooMailNeo_at_web65907.mail.ac4.yahoo.com>
What if Oracle really execute sql queries as of COMMIT (on disk) SCN at that point in time instead of current SCN (for select queries only, but not for inserts/updates/deletes and select for updates), which is what it should be doing in the first place anyway? Then this problem wouldn't occur. Any thoughts from others on this? I've also added this to my blog entry. Thanks, Sai http://sai-oracle.blogspot.com
Date: Wed, 24 Aug 2011 01:27:54 -0700 (PDT)
Message-ID: <1314174474.34826.YahooMailNeo_at_web65907.mail.ac4.yahoo.com>
What if Oracle really execute sql queries as of COMMIT (on disk) SCN at that point in time instead of current SCN (for select queries only, but not for inserts/updates/deletes and select for updates), which is what it should be doing in the first place anyway? Then this problem wouldn't occur. Any thoughts from others on this? I've also added this to my blog entry. Thanks, Sai http://sai-oracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 24 2011 - 03:27:54 CDT