Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Vs. SQL Server on NT

Re: Oracle Vs. SQL Server on NT

From: Ori Geva <orige_at_origeva.co.il>
Date: 1998/04/06
Message-ID: <35280124.C1B2FCFD@origeva.co.il>#1/1

Hi,

About:
--How does SQL Server 6.5 handle isolation between transactions? Which
--of the following levels of isolation defined by the SQL standard is
--the default?
--
--. Read uncommited
--. Read commited (Oracle's default)
--. Repeatable read
--. Serializable

SQL Server 6.5 supports all four in terms of syntax. however, the Repeatable read and searializeable are implemented as one - Serializeable. One should take care that the implementation of Read commited is via locks and not using before image page reconstruction like in other DB's (which do not need locks) - this may reduce concurrency since readers could be blocked by updaters.

Hope it helps,

Ori Geva
Ori Geva - Information Objects Received on Mon Apr 06 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US