| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> ANSI Isolation Levels
Intro:
There are 4 defined ANSI isolation levels: 1) read uncommitted; 2) read
committed; 3) repeatable read; 4) serializable. By default Oracle implements
the read committed (2) isolation level. Oracle can implement the
serializable isolation level but not the repeatable read isolation level.
Questions:
I'm looking for a summary document of how the various database engines
implement ANSI SQL transaction management. For performance reasons, is the
read committed isolation level the most commonly implemented default by the
various database vendors? (From what I gather it is also the default for
Sybase, SQLServer and PostgreSQL.) Is the read committed isolation level the
most practical? Has anyone ever administered a database or application with
a different isolation level and why? Is there any summary document of
transaction features for all the database vendors?
Theoretically and Academically yours,
Steve Orr
Bozeman, Montana
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
INET: sorr_at_rightnow.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 05 2002 - 14:11:42 CDT
 |
 |