Explain share and exclusive type of lock.

hmounir

 Profile Answers by hmounir Questions by hmounir

• Jan 25th, 2010

Oracle uses two modes of locking in a multi-user database:Exclusive lock mode (X) prevents the associates resource from being shared. This lock mode is obtained to modify data. The first transaction t...

rahulmca

 Profile Answers by rahulmca Questions by rahulmca

• Jan 24th, 2010

The two basic types of locks are DML (table) locks, and DDL (dictionary) locks. DML locks are designed to guarantee data integrity in a multi-user environment. DML locks prevent conflicting DML and DD...

Answer Question  Select Best Answer