Re: Oracle out the door

  • From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
  • To: jkstill@xxxxxxxxx
  • Date: Wed, 30 Apr 2008 23:06:46 +0300

2008/4/30, Jared Still <jkstill@xxxxxxxxx>:
> Due to SQL Server being unable to do consistent reads.
> Just had this conversation with a (very good) developer the other day.
> He was quite surprised that no temp tables were required in Oracle
> for the purpose of providing a consistent view of the data.

What version is he using? SQL Server 2005 has new isolation level
snapshot isolation that more or less deals with that. AFAIK it works
e.g. resolved one of our apps deadlocking problem on quite highly
volatile table.

Gints Plivna
http://www.gplivna.eu
--
//www.freelists.org/webpage/oracle-l


Other related posts: