Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Vs. SQL Server on NT
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