Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is it possible to use nolock type of hint in query
>>> The example I heard in a presentation about SQL Server isolation
levels was an airline seat reservation system: you wouldn't consider as
available a seat that had been reserved by another session, whether
committed or not. Dubious, probably just a way to cast SQL Server's
inferior read consistency model in a positive light, but there it is.
...har har...reminds me of the weak documented reasons Informix bothered with Dirty Read (ANSI Read Uncommitted):
ANSI Read Uncommitted or Informix Dirty Read is the most efficient isolation level.
The reading program never waits and never makes another program wait. It is the
preferred level in any of the following cases:
So, it is the most efficient...
We hear that one on occasion about features introduced from 8i
forward...
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 11 2006 - 14:55:52 CDT
![]() |
![]() |