| NOLOCK? [message #238261] |
Thu, 17 May 2007 04:23  |
Superchick
Messages: 5
Registered: May 2007
Location: Singapore
|
Junior Member |
|
|
Hi guys,
I'm new to Oracle, and I come from a SQL Server background.
Could anyone please tell me if Oracle has an equivalent for the SQL Server optimizer hint NOLOCK.
Thank you.
|
|
|
|
| Re: NOLOCK? [message #238265 is a reply to message #238261] |
Thu, 17 May 2007 04:32  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Not only is there no equivalent to NOLOCK, there is no need for it.
In Oracle, there is no conflict between reads and writes.
When you select data from a table that someone else is amending, Oracle will use the rollback created by the other users changes to reconstruct what the data should look like for your session.
It is not possible (at all) for you to see uncommited changes from another users session.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
