Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is it possible to use nolock type of hint in query

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

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 11 Aug 2006 01:11:37 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF61522A@MSXVS04.trivadis.com>


Hi

> 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?

IMHO the only way to get uncommitted data of another session is to dump the information from either the buffer cache or the datafile.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 10 2006 - 18:11:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US