"exclusively " locked for you.Only you own it!Ok fine...I mean here if i can login through 2 sessions using same user name...then I think exclusive mode is session dependent ??? (not user dependent)
So in order toMultiple people can sharebly lock means......
preserve ,maximum concurrency oracle puts your table
in the shared lock so that mutiple people can
shareably lock but till the time the DML is going on
thanks aman....A way of letting other sessions know that a session is using the object, so there may be some (self-imposed) restrictions on how others can.should use it.
in what scenarios...share locked mode is used..