Lock Modes | ||||
Lock | Row/Table | Prevent | Allows | Acquiring Statements |
RS (Row Share) | Row or Table | X, RX on the locked rows | RS, S, SRX, RX on the rows not locked | SELECT … FOR UPDATE LOCK TABLE |
RX (Row Exclusive) | Row or Table | X, SRX, S, RX on the locked rows | RS, RX on the rows not locked | INSERT |
UPDATE | ||||
DELETE | ||||
LOCK TABLE | ||||
S (Share) | Table | X, SRX, RX | RS, S | LOCK TABLE |
SRX (Share Row Exclusive) | Table | X, SRX, S, RX | RS | LOCK TABLE |
X (Exclusive) | Table | X, SRX, S, RX, RS | LOCK TABLE |
DML Statement | Row Locks? | Mode of Table Lock |
SELECT ... FROM table | ||
INSERT INTO table ... | X | RX |
UPDATE table ... | X | RX |
DELETE FROM table ... | X | RX |
SELECT ... FROM table ... FOR UPDATE OF ... | X | RS |
LOCK TABLE table IN ... | ||
ROW SHARE MODE | RS | |
ROW EXCLUSIVE MODE | RX | |
SHARE MODE | S | |
SHARE EXCLUSIVE MODE | SRX | |
EXCLUSIVE MODE | X |
TX锁时V$LOCK视图中ID1列和V$TRANSACTION的关系:
XIDUSN = TRUNC(ID1/POWER(2,16))
XIDSLOT = MOD(ID1,POWER(2,16))
http://www.itpub.net/270059.html
http://space.itpub.net/13095417/viewspace-172810
http://space.itpub.net/13095417/viewspace-171152
http://www.cnblogs.com/caizhanshu/articles/1180966.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/339291/viewspace-448754/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/339291/viewspace-448754/