Lockstat Command Output – Statistics by Lock Type
The "Statistics by lock type" subsection of the Locking System Statistics provides a breakdown of statistics by resource type, whereas the Locking System Summary is an accretion of statistics for all resource types. Only resource types on which lock requests were made are shown.
Here is sample output from this section:
Statistics by lock type:
DATABASE Request lock 10 Re-request lock 0
Convert lock 0 Release lock 8
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
TABLE Request lock 50 Re-request lock 19
Convert lock 0 Release lock 0
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
PAGE Request lock 679 Re-request lock 34
Convert lock 0 Release lock 546
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
BM_PAGE Request lock 239 Re-request lock 0
Convert lock 1102 Release lock 13
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
CREATE Request lock 121 Re-request lock 3
Convert lock 0 Release lock 0
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
CONFIG Request lock 131 Re-request lock 0
Convert lock 0 Release lock 123
Lock wait 6 Convert wait 0
Deadlock 0 Convert deadlock 0
DB_TEMP_ID Request lock 8 Re-request lock 1
Convert lock 1 Release lock 7
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
SV_DATABASE Request lock 8 Re-request lock 0
Convert lock 14 Release lock 7
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
SV_TABLE Request lock 36 Re-request lock 0
Convert lock 0 Release lock 36
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
TBL_CONTROL Request lock 18 Re-request lock 0
Convert lock 0 Release lock 18
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
JOURNAL Request lock 8 Re-request lock 0
Convert lock 0 Release lock 7
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
OPEN_DB Request lock 17 Re-request lock 0
Convert lock 17 Release lock 15
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
CKP_DB Request lock 178 Re-request lock 26
Convert lock 0 Release lock 0
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
BM_DATABASE Request lock 2 Re-request lock 0
Convert lock 14 Release lock 0
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
BM_TABLE Request lock 15 Re-request lock 0
Convert lock 57 Release lock 0
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
CONTROL Request lock 7 Re-request lock 1
Convert lock 2 Release lock 2
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
EVCONNECT Request lock 1 Re-request lock 0
Convert lock 0 Release lock 0
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
ONLN_MDFY Request lock 1 Re-request lock 0
Convert lock 0 Release lock 0
Lock wait 0 Convert wait 0
Deadlock 0 Convert deadlock 0
Fields are as follows:
Request lock, Re-request lock, Convert lock, Release lock, Lock wait, Convert wait, Deadlock, and Convert deadlock are described under
Lockstat Command Output – Locking System Statistics.
DATABASE
Database locks
TABLE
Table locks
PAGE
Page locks
BM_PAGE
Database page cache locks
CREATE
Create table
CONFIG
Database configuration file
DB_TEMP_ID
Temporary table ID generation
SV_DATABASE
Server database lock
SV_TABLE
Server table lock
TBL_CONTROL
Table DDL lock
JOURNAL
Database journal lock
OPEN_DB
Database open lock
CKP_DB
Database checkpoint
BM_DATABASE
Database cache lock
BM_TABLE
Table cache lock
CONTROL
Miscellaneous server control locks
EVCONNECT
Server-server events
ONLN_MDFY
Online modify
Other possible resource types:
CKP_CLUSTER
Checkpoints in a cluster
BM_LOCK
Shared cache lock
AUDIT
C2 security
ROW
Row lock
CKP_TXN
Database checkpoint synchronization
VAL_LOCK
Value lock
SEQUENCE
Sequence generator
XA_CONTROL
XA Distributed transactions
CSP
Cluster lock
CMO
Cluster management
MSG
Cluster messaging
TBL_MVCC
MVCC Table lock