VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

Reasons that a TX lock may be requested in S mode

Posted by admin on 4th December 2011

Oracle中的锁,一共有6种模式:

0:none
1:null 空
2:Row-S 行共享(RS):共享表锁,sub share
3:Row-X 行独占(RX):用于行的修改,sub exclusive
4:Share 共享锁(S):阻止其他DML操作,share
5:S/Row-[……]

Read more

Tags:
Posted in Oracle Experience | 2 Comments »