GVD_LATCH_MISSES - Copy of GV$LATCH_MISSES
Copy of GV$LATCH_MISSES information is stored in SAP table GVD_LATCH_MISSES.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table GVD_LATCH_MISSES
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
| SAP_LINE_NR | Help field: Line Nr. (to avoid duplicate entries) | X | ORA_SAPLINENR | INT4 | 4 | |
| PARENT_NAME | Oracle monitoring: Latch name of a parent latch | ORA_PARENT_NAME | CHAR | 50 | ||
| WHERE_LATCH | Oracle monitoring: Latch - only for compatibility | ORA_WHERE | CHAR | 64 | ||
| NWFAIL_COUNT | Oracle Monitoring: Number of failed latch acquisition | ORA_NWFAIL_COUNT | DEC | 12 | ||
| SLEEP_COUNT | Oracle Monitoring: Number of acquisitions causing sleeps | ORA_SLEEP_COUNT | DEC | 12 | ||
| WTR_SLP_COUNT | Oracle Monitoring: Counter | ORA_WTR_SLP_COUNT | DEC | 12 | ||
| LONGHOLD_COUNT | Oracle Monitoring: Counter | ORA_LONGHOLD_COUNT | DEC | 12 | ||
| LOCATION | Oracle Monitoring: Location that attempted to acquire latch | ORA_LOCATION | CHAR | 64 |