RE: Is it possible to use nolock type of hint in query
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 11 Aug 2006 21:09:08 +0100
That's what I would do. It's why I called the example "dubious"!
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: Igor Neyman [mailto:ineyman@xxxxxxxxxxxxxx]
Sent: Friday, August 11, 2006 3:50 PM
To: paul.baumgartel@xxxxxxxxxxxxxxxxx; ORACLE-L
Subject: RE: Is it possible to use nolock type of hint in query
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
<mailto: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
==============================================================================
==============================================================================
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:
