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 |
No comments:
Post a Comment