Re: ACID

  • From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
  • To: free <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 24 Aug 2011 01:27:54 -0700 (PDT)

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

Other related posts: