Re: Db2, Oracle, SQL Server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Wed, 09 Feb 2005 17:06:52 -0800
Message-ID: <420AB3AC.50509@comcast.net>

VC wrote:

> Oracle has SNAPSHOT (mis-named SERIALIZABLE) and READ
> COMMITTED. Oracle also has the READ ONLY isolation level , but it's really
> just a subset of SNAPSHOT.

A small nit pick, but this statement is not really correct. Snapshot Isolation (as defined in the paper by Gray et all - ftp://ftp.research.microsoft.com/pub/tr/tr-95-51.pdf) is similar to but not the same as Oracle's MVRC (Multi version read consisitency). Received on Wed Feb 09 2005 - 19:06:52 CST