RE: Is it possible to use nolock type of hint in query
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <paul.baumgartel@xxxxxxxxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 11 Aug 2006 15:50:10 -0400
Shouldn't SELECT... FOR UPDATE be used in this case (and not "dirty"
reads)?
Igor Neyman
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Baumgartel, Paul
Sent: Friday, August 11, 2006 3:45 PM
To: ORACLE-L
Subject: 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.
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jared Still
Sent: Thursday, August 10, 2006 3:20 PM
To: Harvinder.Singh@xxxxxxxxxxxxx
Cc: ORACLE-L
Subject: Re: Is it possible to use nolock type of hint in query
On 8/10/06, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx>
wrote:
In sql server we can use nolock hint to see the
uncommitted data of the
other sessions. Is their any equivalent hint for query
in Oracle?
I'm curious why you would want to see uncommited changes from
another transaction.
What action can you possibly take based on data that may or may
not be committed
at some point in the future.?
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
========================================================================
======
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
========================================================================
======
Other related posts:
