Try OpenEdge Now
skip to main content
Database Administration
Reference : PROMON Utility : R&D Activity Displays : Lock Table
 
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