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