SAP Table GVD_LATCH_MISSES

Copy of GV$LATCH_MISSES

The table GVD_LATCH_MISSES (Copy of GV$LATCH_MISSES) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table	GVD_LATCH_MISSES
Short Text	Copy of GV$LATCH_MISSES
Package	STUN
Table Type	Transparent Table

Fields for Table GVD_LATCH_MISSES

Field Name	Key	Description	Data Element	Type	Length	Check Table
SNAPSHOT_ID	✔	Oracle monitor: snapshot ID	ORA_SNAPSHOT_ID	NUMC	10	*
INST_ID	✔	Oracle monitor: Instance ID	ORA_INST_ID	DEC	22
SAP_LINE_NR	✔	Help field: Line Nr. (to avoid duplicate entries)	ORA_SAPLINENR	INT4	10
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	22
SLEEP_COUNT		Oracle Monitoring: Number of acquisitions causing sleeps	ORA_SLEEP_COUNT	DEC	22
WTR_SLP_COUNT		Oracle Monitoring: Counter	ORA_WTR_SLP_COUNT	DEC	22
LONGHOLD_COUNT		Oracle Monitoring: Counter	ORA_LONGHOLD_COUNT	DEC	22
LOCATION		Oracle Monitoring: Location that attempted to acquire latch	ORA_LOCATION	CHAR	64