One of the thoughts on the transaction lock lock mode of oracle database transaction
Summary
Exclusive lock mode is the most powerful, it is exclusive, exclusive access, it occupies table lock resources, other sessions can only wait
Row share (share update) lock mode is relatively mild, it can coexist with all lock modes, but exclusive lock mode is not allowed.
Although share row exclusive lock mode is not as powerful as exclusive lock mode, it can rank as the second strict lock mode, and it can only be compatible with row share (share update) lock mode.
Row exclusive and share lock modes rank after share row exclusive. It is compatible with three lock modes, but not with the remaining two lock modes.
Training courseware
(charge 20 yuan)
Contact information
