SAP Table GVD_LATCH

Copy of GV$LATCH

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

Technical Information

Table	GVD_LATCH
Short Text	Copy of GV$LATCH
Package	STUN
Table Type	Transparent Table

Fields for Table GVD_LATCH

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
ADDR	✔	Oracle monitoring: ADDR	ORA_ADDR	RAW	8
LATCH	✔	Oracle monitoring: Latch#	ORA_LATCH	DEC	22
LATCH_LEVEL		Oracle monitoring: Level	ORA_LEVEL	DEC	22
NAME		Oracle monitoring: Name	ORA_NAME	CHAR	64
GETS		Oracle monitoring: Latch Gets	ORA_GETS	DEC	22
MISSES		Oracle monitoring: Latch Misses	ORA_MISSES	DEC	22
SLEEPS		Oracle monitoring: Latch Sleeps	ORA_SLEEPS	DEC	22
IMMEDIATE_GETS		Oracle monitoring: Latch Immediate Gets	ORA_IMMEDIATE_GETS	DEC	22
IMMEDIATE_MISSES		Oracle monitoring: Latch Immediate Misses	ORA_IMMEDIATE_MISSES	DEC	22
WAITERS_WOKEN		Oracle monitoring: Latch Waiters Woken	ORA_WAITERS_WOKEN	DEC	22
WAITS_HOLD_LTCH		Oracle monitoring: Latch: Waits Holding Latch	ORA_WAITS_HOLDING_LATCH	DEC	22
SPIN_GETS		Oracle monitoring: Latch Spin Gets	ORA_SPIN_GETS	DEC	22
SLEEP1		Oracle monitoring: Latch Sleep 1	ORA_SLEEP1	DEC	22
SLEEP2		Oracle monitoring: Latch Sleep 2	ORA_SLEEP2	DEC	22
SLEEP3		Oracle monitoring: Latch Sleep 3	ORA_SLEEP3	DEC	22
SLEEP4		Oracle monitoring: Latch Sleep 4	ORA_SLEEP4	DEC	22
SLEEP5		Oracle monitoring: Latch Sleep 5	ORA_SLEEP5	DEC	22
SLEEP6		Oracle monitoring: Latch Sleep 6	ORA_SLEEP6	DEC	22
SLEEP7		Oracle monitoring: Latch Sleep 7	ORA_SLEEP7	DEC	22
SLEEP8		Oracle monitoring: Latch Sleep 8	ORA_SLEEP8	DEC	22
SLEEP9		Oracle monitoring: Latch Sleep 9	ORA_SLEEP9	DEC	22
SLEEP10		Oracle monitoring: Latch Sleep 10	ORA_SLEEP10	DEC	22
SLEEP11		Oracle monitoring: Latch Sleep 11	ORA_SLEEP11	DEC	22
WAIT_TIME		Oracle monitoring: Latch Wait Time	ORA_WAIT_TIME	DEC	22