老实人做网站,做网站如何上传,网站建设超链接字体变色代码,wordpress主页显示博客v$lock视图
v$lock视图列出当前系统持有的或正在申请的所有锁的情况#xff0c;其主要字段说明如下#xff1a;
11g如下#xff1a;
字段名称类型说明ADDRRAW(8)锁定状态对象的地址KADDRRAW(8)锁的地址SIDNUMBER会话#xff08;SESSION#xff09;标识#xff1b;TYPE…v$lock视图
v$lock视图列出当前系统持有的或正在申请的所有锁的情况其主要字段说明如下
11g如下
字段名称类型说明ADDRRAW(8)锁定状态对象的地址KADDRRAW(8)锁的地址SIDNUMBER会话SESSION标识TYPEVARCHAR2区分该锁保护对象的类型ID1NUMBER锁标识1ID2NUMBER锁标识2LMODENUMBER锁模式0None1null,2row share, 3row exclusive,4 share,5share row exclusive,6exclusiveREQUESTNUMBER申请的锁模式具体值同上面的LMODECTIMENUMBER已持有或等待锁的时间BLOCKNUMBER是否阻塞其它锁申请
12c如下
字段名称类型说明ADDRRAW(8)锁定状态对象的地址KADDRRAW(8)锁的地址SIDNUMBER会话SESSION标识TYPEVARCHAR2区分该锁保护对象的类型ID1NUMBER锁标识1ID2NUMBER锁标识2LMODENUMBER锁模式0None1null,2row share, 3row exclusive,4 share,5share row exclusive,6exclusiveREQUESTNUMBER申请的锁模式具体值同上面的LMODECTIMENUMBER已持有或等待锁的时间BLOCKNUMBER是否阻塞其它锁申请CON_IDNUMBER所属容器标识
英文
字段名称类型说明ADDRRAW(8)Address of lock state objectKADDRRAW(8)Address of lockSIDNUMBERIdentifier for session holding or acquiring the lockTYPEVARCHAR2Type of user or system lockThe locks on the user types are obtained by user applications. Any process that is blocking others is likely to be holding one of these locks. The user type locks are:TM - DML enqueueTX - Transaction enqueueUL - User suppliedID1NUMBERLock identifier #1 (depends on type)ID2NUMBERLock identifier #2 (depends on type)LMODENUMBERLock mode in which the session holds the lock:0 - none1 - null (NULL)2 - row-S (SS)3 - row-X (SX)4 - share (S)5 - S/Row-X (SSX)6 - exclusive (X)REQUESTNUMBERLock mode in which the process requests the lock:0 - none1 - null (NULL)2 - row-S (SS)3 - row-X (SX)4 - share (S)5 - S/Row-X (SSX)6 - exclusive (X)CTIMENUMBERTime since current mode was grantedBLOCKNUMBERIndicates whether the lock in question is blocking other processes. The possible values are:0 - The lock is not blocking any other processes1 - The lock is blocking other processes2 - The lock is not blocking any blocked processes on the local node, but it may or may not be blocking processes on remote nodes. This value is used only in Oracle Real Application Clusters (Oracle RAC) configurations (not in single instance configurations).CON_IDNUMBERThe ID of the container to which the data pertains. Possible values include:0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.1: This value is used for rows containing data that pertain to only the rootn: Where n is the applicable container ID for the rows containing data
其中在TYPE字段的取值中本文只关心TM、TX两种DML锁类型
关于ID1、ID2TYPE取值不同其含义也有所不同
TYPEID1ID2TM被修改表的标识object_id0TX以十进制数值表示该事务所占用的回滚段号与该事务在该回滚段的事务表Transaction table中所占用的槽号slot number可理解为记录号。其组成形式为 0xRRRRSSSS ( RRRR RBS number, SSSS slot )。以十进制数值表示环绕wrap次数即该槽slot被重用的次数
v$locked_object视图
v$locked_object视图列出当前系统中哪些对象正被锁定其主要字段说明如下 11g如下
字段名称类型说明XIDUSNNUMBER回滚段号XIDSLOTNUMBER槽号XIDSQNNUMBER序列号OBJECT_IDNUMBER被锁对象标识SESSION_IDNUMBER持有锁的会话SESSION标识ORACLE_USERNAMEVARCHAR230持有该锁的Oracle用户名OS_USER_NAMEVARCHAR230持有该锁的操作系统用户名PROCESSVARCHAR224操作系统的进程号LOCKED_MODENUMBER锁模式
12c如下
字段名称类型说明XIDUSNNUMBER回滚段号XIDSLOTNUMBER槽号XIDSQNNUMBER序列号OBJECT_IDNUMBER被锁对象标识SESSION_IDNUMBER持有锁的会话SESSION标识ORACLE_USERNAMEVARCHAR2128持有该锁的Oracle用户名OS_USER_NAMEVARCHAR2128持有该锁的操作系统用户名PROCESSVARCHAR224操作系统的进程号LOCKED_MODENUMBER锁模式CON_IDNUMBER所属容器标识
英文
ColumnDatatypeDescriptionXIDUSNNUMBERUndo segment numberXIDSLOTNUMBERSlot numberXIDSQNNUMBERSequence numberOBJECT_IDNUMBERObject ID being lockedSESSION_IDNUMBERSession IDORACLE_USERNAMEVARCHAR2128Oracle user nameOS_USER_NAMEVARCHAR2128Operating system user namePROCESSVARCHAR224Operating system process IDLOCKED_MODENUMBERLock mode. The numeric values for this column map to these text values for the lock modes for table locks:0 - NONE: lock requested but not yet obtained1 - NULL2 - ROWS_S (SS): Row Share Lock3 - ROW_X (SX): Row Exclusive Table Lock4 - SHARE (S): Share Table Lock5 - S/ROW-X (SSX): Share Row Exclusive Table Lock6 - Exclusive (X): Exclusive Table LockSee Also: Oracle Database Concepts for more information about lock modes for table locksCON_IDNUMBERThe ID of the container to which the data pertains. Possible values include:0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.1: This value is used for rows containing data that pertain to only the rootn: Where n is the applicable container ID for the rows containing data 参考链接https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/V-LOCK.html#GUID-87D76889-832C-4BFC-B8B0-154A22721781
