V$LATCHHOLDER displays information about the current latch holders.
| Column | Datatype | Description |
|---|---|---|
PID |
NUMBER |
Identifier of the process holding the latch |
SID |
NUMBER |
Identifier of the session that owns the latch |
LADDR |
RAW(4 | 8) |
Latch address |
NAME |
VARCHAR2(64) |
Name of the latch being held |
GETS |
NUMBER |
Number of times that the latch was obtained in either wait mode or no-wait mode |