948287 wrote: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.
what is shared lock in oracle ?? when it comes to play? why it is called read lock ? i go through a lots of docs but still i am not clear about this.
please guide me