Home » SQL & PL/SQL » SQL & PL/SQL » NOLOCK?
NOLOCK? [message #238261] Thu, 17 May 2007 04:23 Go to next message
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 Go to previous messageGo to next message
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.
Re: NOLOCK? [message #238266 is a reply to message #238265] Thu, 17 May 2007 04:33 Go to previous message
Superchick
Messages: 5
Registered: May 2007
Location: Singapore
Junior Member
Thank you. That is pretty cool.

Cool
Previous Topic: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Next Topic: Analyze table
Goto Forum:
  


Current Time: Thu Oct 30 18:58:44 CDT 2014

Total time taken to generate the page: 0.09168 seconds