 |
» |
|
|
|
This screen lists the number of locks allocated to each session according
to the lock granularity.
To invoke the Lock Memory screen, use the m command from the Lock subsystem or the /loc m command from other subsystems. Field Definitions | |
- REFRESH
The screen refresh rate, in seconds.
- SESSIONS
The number of DBEnvironment sessions.
- SORTLOCK
An indicator of how the sessions are sorted.
The sessions are sorted in descending order by the value
in the column indicated by the asterisk.
In the example above, the sessions are sorted by MAXTOTAL values.
For more information, see the description of the SET SORTLOCK command.
- PID
The HP-UX
process identification number of the DBEnvironment session. - TABLE
The number of table locks allocated to the session.
This number includes locks that have been granted,
locks the session is waiting to acquire,
and locks the session is waiting to convert.
- PAGE
The number of page locks allocated to the session.
This number includes locks that have been granted,
locks the session is waiting to acquire,
and locks the session is waiting to convert.
- ROW
The number of row locks allocated to the session.
This number includes locks that have been granted,
locks the session is waiting to acquire,
and locks the session is waiting to convert.
- TOTAL
The total number of locks allocated to the session,
calculated as follows:
TOTAL = TABLE + PAGE + ROW
|
- MAXTOTAL
The maximum number of TOTAL locks allocated to the session
since it was attached to the DBEnvironment.
Related SET Commands | |
The SET commands in the following table affect this screen. | Command | Description | Example |
|---|
| SET REFRESH | Controls the refresh rate of the screen. | SET REFRESH 5 | | SET SORTLOCK | Sorts sessions in descending order according to the value
of the specified column. | SET SORTLOCK 2 | | SET TOP | Limits the number of sessions displayed. | SET TOP 10
|
|
![[memory]](img/memory.gif)
