Discussion Board

Locking mode Oracle uses two modes of locking in a multiuser database. 1. Exclusive lock mode: It prevents the associates resource from being shared. This lock mode is obtained to modify data. The first transaction to lock a resource exclusively is the only transaction that can alter the resource until the exclusive lock is released. 2. Share lock mode: It allows the associated resource to be shared, depending on the operations involved. Multiple users reading data can share the data, holding share locks to prevent concurrent access by a writer (who needs an exclusive lock). Several transactions can acquire share locks on the same resource. Prajakta Pandit 03-2-2017 12:42 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*