Lock table activity (_ActLock)
- Last Updated: March 28, 2024
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
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 released exclusive find locks |
| _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 lock requests |
| _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 |