GVD_LATCH_PARENT - Copy of GV$LATCH_PARENT (currently not provided with snaps)
Copy of GV$LATCH_PARENT (currently not provided with snaps) information is stored in SAP table GVD_LATCH_PARENT.
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_PARENT
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 | |
| ADDR | Oracle monitoring: ADDR | X | ORA_ADDR | RAW | 8 | |
| LATCH | Oracle monitoring: Latch# | X | ORA_LATCH | DEC | 12 | |
| LATCH_LEVEL | Oracle monitoring: Level | ORA_LEVEL | DEC | 12 | ||
| NAME | Oracle monitoring: Name | ORA_NAME | CHAR | 64 | ||
| GETS | Oracle monitoring: Latch Gets | ORA_GETS | DEC | 12 | ||
| MISSES | Oracle monitoring: Latch Misses | ORA_MISSES | DEC | 12 | ||
| SLEEPS | Oracle monitoring: Latch Sleeps | ORA_SLEEPS | DEC | 12 | ||
| IMMEDIATE_GETS | Oracle monitoring: Latch Immediate Gets | ORA_IMMEDIATE_GETS | DEC | 12 | ||
| IMMEDIATE_MISSES | Oracle monitoring: Latch Immediate Misses | ORA_IMMEDIATE_MISSES | DEC | 12 | ||
| WAITERS_WOKEN | Oracle monitoring: Latch Waiters Woken | ORA_WAITERS_WOKEN | DEC | 12 | ||
| WAITS_HOLD_LTCH | Oracle monitoring: Latch: Waits Holding Latch | ORA_WAITS_HOLDING_LATCH | DEC | 12 | ||
| SPIN_GETS | Oracle monitoring: Latch Spin Gets | ORA_SPIN_GETS | DEC | 12 | ||
| SLEEP1 | Oracle monitoring: Latch Sleep 1 | ORA_SLEEP1 | DEC | 12 | ||
| SLEEP2 | Oracle monitoring: Latch Sleep 2 | ORA_SLEEP2 | DEC | 12 | ||
| SLEEP3 | Oracle monitoring: Latch Sleep 3 | ORA_SLEEP3 | DEC | 12 | ||
| SLEEP4 | Oracle monitoring: Latch Sleep 4 | ORA_SLEEP4 | DEC | 12 | ||
| SLEEP5 | Oracle monitoring: Latch Sleep 5 | ORA_SLEEP5 | DEC | 12 | ||
| SLEEP6 | Oracle monitoring: Latch Sleep 6 | ORA_SLEEP6 | DEC | 12 | ||
| SLEEP7 | Oracle monitoring: Latch Sleep 7 | ORA_SLEEP7 | DEC | 12 | ||
| SLEEP8 | Oracle monitoring: Latch Sleep 8 | ORA_SLEEP8 | DEC | 12 | ||
| SLEEP9 | Oracle monitoring: Latch Sleep 9 | ORA_SLEEP9 | DEC | 12 | ||
| SLEEP10 | Oracle monitoring: Latch Sleep 10 | ORA_SLEEP10 | DEC | 12 | ||
| SLEEP11 | Oracle monitoring: Latch Sleep 11 | ORA_SLEEP11 | DEC | 12 | ||
| WAIT_TIME | Oracle monitoring: Latch Wait Time | ORA_WAIT_TIME | DEC | 12 |