exclusive lock mode vs shared lock mode
615452May 17 2008 — edited May 17 2008Hi friends,
I have gone through the oracle documentation...i did not understand properly about these lock mode...
Exclusive lock mode 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.
Share lock mode 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.
can anybody explain me with simle example
thanks in advance