LOCKWAIT 过程 - 生成当前锁定等待的报告 “锁定等待”报告包含有关当前正在进行的每个锁定等待的信息。 详细信息包括有关锁定持有者和请求者及所持有锁定和所请求锁定的特征的信息。 语法MONREPORT.LOCKWAIT( ) 权限需要以下特权: 对 MONREPORT 模块的 EXECUTE 特权 以下示例演示调用 LOCKWAIT 过程的各种方法:call monreport.lockwait;call monreport.lockwait(); 图 1。 样本 MONREPORT.LOCKWAIT 输出 - 摘要部分 -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- Monitoring report - current lock waits -------------------------------------------------------------------------------- Database: SAMPLE Generated: 08/28/2009 07:16:26 ================================================================================ Part 1 - Summary of current lock waits -------------------------------------------------------------------------------- REQ_APPLICATION LOCK_MODE HLD_APPLICATION LOCK_ LOCK_OBJECT_TYPE # HANDLE REQUESTED _HANDLE MODE ---- --------------- --------- --------------- ----- ---------------------- 1 26 U 21 U ROW 2 25 U 21 U ROW 3 24 U 21 U ROW 4 23 U 21 U ROW 5 22 U 21 U ROW 6 27 U 21 U ROW ================================================================================ ... 390 record(s) selected. Return Status = 0 图 2。 样本 MONREPORT.LOCKWAIT 输出 - 详细信息部分 ================================================================================ Part 2: Details for each current lock wait lock wait #:1 -------------------------------------------------------------------------------- -- Lock details -- LOCK_NAME = 04000500040000000000000052 LOCK_WAIT_START_TIME = 2009-08-28-07.15.31.013802 LOCK_OBJECT_TYPE = ROW TABSCHEMA = TRIPATHY TABNAME = INVENTORY ROWID = 4 LOCK_STATUS = W LOCK_ATTRIBUTES = 0000000000000000 ESCALATION = N -- Requestor and holder application details -- Attributes Requestor Holder ------------------- ----------------------------- ---------------------------- APPLICATION_HANDLE 26 21 APPLICATION_ID *LOCAL.tripathy.090828111531 *LOCAL.tripathy.090828111435 APPLICATION_NAME java java SESSION_AUTHID TRIPATHY TRIPATHY MEMBER 0 0 LOCK_MODE - U LOCK_MODE_REQUESTED U - -- Lock holder current agents -- AGENT_TID = 41 REQUEST_TYPE = FETCH EVENT_STATE = IDLE EVENT_OBJECT = REQUEST EVENT_TYPE = WAIT ACTIVITY_ID = UOW_ID = -- Lock holder current activities -- ACTIVITY_ID = 1 UOW_ID = 1 LOCAL_START_TIME = 2009-08-28-07.14.31.079757 ACTIVITY_TYPE = READ_DML ACTIVITY_STATE = IDLE STMT_TEXT = select * from inventory for update -- Lock requestor waiting agent and activity -- AGENT_TID = 39 REQUEST_TYPE = FETCH ACTIVITY_ID = 1 UOW_ID = 1 LOCAL_START_TIME = 2009-08-28-07.15.31.012935 ACTIVITY_TYPE = READ_DML ACTIVITY_STATE = EXECUTING STMT_TEXT = select * from inventory for update