Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Lock table activity (_ActLock)
 
Lock table activity (_ActLock)
The _ActLock VST displays lock table activity, including the number of share, exclusive, upgrade, Rec Get, and redundant requests; the number of exclusive, Rec Get, share, and upgrade grants; the number of exclusive, Rec Get, share, and upgrade waits; the number of downgrades, transactions committed, cancelled requests, and database up time.
Field name
Data type
Description
_Lock-CanclReq
INTEGER
Number of lock requests that were cancelled
_Lock-Downgrade
INTEGER
Number of locks that were downgraded
_Lock-ExclFind
INT64
Number of exclusive find requests granted
_Lock-ExclLock
INTEGER
Number of exclusive lock requests
_Lock-ExclReq
INTEGER
Number of requests for exclusive locks granted
_Lock-ExclWait
INTEGER
Number of times processes waited for an exclusive lock
_Lock-RecGetLock
INTEGER
Number of requests for record get locks granted
_Lock-RecGetReq
INTEGER
Number of record get locks granted
_Lock-RecGetWait
INTEGER
Number of times processes waited for record gets
_Lock-RedReq
INTEGER
Number of duplicate requests granted
_Lock-ShrFind
INT64
Number of share find requests granted
_Lock-ShrLock
INTEGER
Number of share lock requests granted
_Lock-ShrReq
INTEGER
Number of requests for share locks
_Lock-ShrWait
INTEGER
Number of times processes waited for share lock
_Lock-Trans
INT64
Number of transactions committed
_Lock-UpgLock
INTEGER
Number of requests for lock upgrades granted
_Lock-UpgReq
INTEGER
Number of requests to upgrade a lock from shared lock to exclusive lock
_Lock-UpgWait
INTEGER
Number of times processes waited for upgrades
_Lock-UpTime
INTEGER
Number of seconds the database was up