Progress
Database Administration
Guide and Reference
Activity Displays>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.
Figure A–27 shows a sample Lock Table Activity display.
Figure A–27: PROMON Lock Table Activity Display
The display lists the following operations:
- Share requests — The number of user requests for share locks.
- Exclusive requests — The number of user requests for exclusive locks.
- Upgrade requests — The number of requests to upgrade a lock from shared lock to exclusive lock.
- Rec Get requests — The number of granted record get locks.
- Share grants — The number of granted share lock requests.
- Exclusive grants — The number of granted exclusive lock requests.
- Upgrade grants — The number of granted requests for lock upgrades.
- Rec Get grants — The number of granted requests for record get locks.
- Share waits — The number of times processes waited for share lock.
- Exclusive waits — The number of times processes waited for an exclusive lock.
- Upgrade waits — The number of times processes waited for upgrades.
- Rec Get waits — The number of times processes waited for record gets.
- Requests cancelled — The number of lock requests that were cancelled.
- Downgrades — The number of locks downgraded.
- Redundant requests — The number of requests for a lock already held.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |