Lock Table
Displays information about Lock Table Activity. The database engine stores record locks in the lock table. If a user tries to acquire a lock on a record, and the lock table overflows, the server aborts.
PROMON Lock Table Activity display
The following figure shows a sample Lock Table Activity display.
04/29/04 Activity: Lock Table
15:11:21 04/29/04 15:05 to 04/29/04 15:10 (5 min 14 sec)
Total Per Min Per Sec Per Tx
Requests:
Share 3715 710 11.83 61.92
Intent Share 0 0 0.00 0.00
Exclusive 8 2 0.03 0.13
Intent Exclusive 0 0 0.00 0.00
Share Intent Excl 0 0 0.00 0.00
Upgrade 0 0 0.00 0.00
Record Get Lock 3505 670 11.16 58.42
Table Lock 20 4 0.06 0.33
Record Lock 198 38 0.63 3.30
Grants:
Share 3715 710 11.83 61.92
Intent Share 0 0 0.00 0.00
Exclusive 8 2 0.03 0.13
Intent Exclusive 0 0 0.00 0.00
Share Intent Excl 0 0 0.00 0.00
Upgrade 0 0 0.00 0.00
Record Get Lock 3505 670 11.16 58.42
Table Lock 20 4 0.06 0.33
Record Lock 198 38 0.63 3.30
Waits:
Share 0 0 0.00 0.00
Intent Share 0 0 0.00 0.00
Exclusive 0 0 0.00 0.00
Intent Exclusive 0 0 0.00 0.00
Share Intent Excl 0 0 0.00 0.00
Upgrade 0 0 0.00 0.00
Record Get Lock 0 0 0.00 0.00
Table Lock 0 0 0.00 0.00
Record Lock 0 0 0.00 0.00
Requests Cancelled 0 0 0.00 0.00
Downgrades 0 0 0.00 0.00
Shared Find 0 0 0.00 0.00
Exclusive Find 0 0 0.00 0.00
The display lists the following operations:
Requests
Share — The number of user requests for a share lock
Intent Share — The number of user requests for an intent share lock
Exclusive — The number of user requests for an exclusive lock
Intent Exclusive — The number of user requests for an intent exclusive lock
Share Intent Exclusive — The number of user requests for a shared lock with intent exclusive
Upgrade — The number of user requests to upgrade a lock from shared lock to exclusive lock
Record Get Lock — The number of user requests for a record get lock
Table Lock — The number of user requests for a table lock
Record Lock — The number of user requests for a record lock
Grants
Share — The number of granted share lock requests
Intent Share — The number of granted intent share lock requests
Exclusive — The number of granted exclusive lock requests
Intent Exclusive — The number of granted intent exclusive lock requests
Share Intent Exclusive — The number of granted share lock with intent exclusive requests
Upgrade — The number of granted requests for lock upgrades
Record Get Lock — The number of granted requests for record get locks
Table Lock — The number of granted requests for table locks
Record Lock — The number of granted requests for record locks
Waits
Share — The number of times users waited for a share lock
Intent Share — The number of times users waited for an intent share lock
Exclusive — The number of times users waited for an exclusive lock
Intent Exclusive — The number of times users waited for an intent exclusive lock
Share Intent Exclusive — The number of times users waited for a share lock with exclusive intent
Upgrade — The number of times users waited for a lock upgrade
Record Get Lock — The number of times users waited for a record get lock
Table Lock — The number of times users waited for a table lock
Record Lock — The number of times users waited a record lock
Requests cancelled — The number of lock requests that were cancelled
Downgrades — The number of locks downgraded