LOCKWAIT 过程 - 生成当前锁定等待的报告
“锁定等待”报告包含有关当前正在进行的每个锁定等待的信息。详细信息包括有关锁定持有者和请求者及所持有锁定和所请求锁定的特征的信息。
语法
权限
需要以下特权：
- 对 MONREPORT 模块的 EXECUTE 特权
以下示例演示调用 LOCKWAIT 过程的各种方法：
call monreport.lockwait;call 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 ================================================================================
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