Total Locks per User

Database Administration

Reference : PROMON Utility : R&D Other Displays : Total Locks per User

Displays, for each user, the total number of locks and a count of the various types of locks.

PROMON Total Locks per User display

The following figure shows a sample Total Locks per User display.

08/05/15 Status: Total Locks per User by user number
16:24:21
Usr:Ten Name Domain Type PID TTY Total Table Partition Record Purge RecGet SHR EXCL IS IX SIX

5:0 ees -3 SELF/ABL 5688 CON: 4 1 1 2 0 0 3 1 0 2 0
6:0 abs -3 SELF/ABL 1696 CON: 2 0 0 2 0 0 1 1 0 0 0