RE: Is it possible to use nolock type of hint in query

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_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: Igor Neyman [mailto:ineyman_at_perceptron.com] Sent: Friday, August 11, 2006 3:50 PM
To: paul.baumgartel_at_credit-suisse.com; 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared Still Sent: Thursday, August 10, 2006 3:20 PM
To: Harvinder.Singh_at_metratech.com
Cc: ORACLE-L
Subject: Re: Is it possible to use nolock type of hint in query

On 8/10/06, Harvinder Singh < Harvinder.Singh_at_metratech.com <mailto:Harvinder.Singh_at_metratech.com> > 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


==============================================================================



--
http://www.freelists.org/webpage/oracle-l