SQL tutorial | Interview questions | Oracle
Would you like to react to this message? Create an account in a few clicks or log in to continue.

How Data Locks Are Respected?

Go down

How Data Locks Are Respected? Empty How Data Locks Are Respected?

Post by Micheal Sun Jan 17, 2010 3:39 am

Here are the rules on how data locks are respected:
All statements ignore data locks owned its own transaction.
SELECT query statements ignores data locks owned by any transactions.
INSERT, UPDATE, and DELETE statements in a READ COMMITTED transaction will wait for
data locks on their targeted rows by other transactions to be released.
INSERT, UPDATE, and DELETE statements in a SERIALIZABLE transaction will fail if their
targeted rows has data locks owned by other transactions.

Micheal
Admin

Posts : 243
Join date : 2010-01-10

http://sql-tutorial.co.cc

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum