SAP Table GVD_INSTANCE

Copy of GV$INSTANCE

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

Technical Information

Table	GVD_INSTANCE
Short Text	Copy of GV$INSTANCE
Package	STUN
Table Type	Transparent Table

Fields for Table GVD_INSTANCE

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
INSTANCE_NUMBER		Oracle monitoring: instance number	ORA_INSTANCE_NUMBER	DEC	22
INSTANCE_NAME		Oracle monitoring: instance_name	ORA_INSTANCE_NAME	CHAR	48
HOST_NAME		Oracle monitoring: host_name	ORA_HOST_NAME	CHAR	64
VERSION		Oracle monitoring: version	ORA_VERSION	CHAR	17
STARTUP_DATE		Oracle monitoring: instance startup time (date value)	ORA_STARTUP_DATE	DATS	8
STARTUP_TIME		Oracle monitoring: instance startup time	ORA_STARTUP_TIME	TIMS	6
STATUS		Oracle monitoring: instance status	ORA_STATUS_INST	CHAR	12
PARALLEL		Oracle monitoring: parallel	ORA_PARALLEL	CHAR	3
THREAD		Oracle monitoring: thread_inst	ORA_THREAD_INST	DEC	22
ARCHIVER		Oracle monitoring: archiver	ORA_ARCHIVER	CHAR	7
LOG_SWITCH_WAIT		Oracle monitoring: instance log switch wait	ORA_LOG_SWITCH_WAIT	CHAR	11
LOGINS		Oracle monitoring: instance logins	ORA_LOGINS	CHAR	10
SHUTDOWN_PENDING		Oracle monitoring: shutdown_pending	ORA_SHUTDOWN_PENDING	CHAR	3
DATABASE_STATUS		Oracle monitoring: database status	ORA_DATABASE_STATUS	CHAR	17
INSTANCE_ROLE		Oracle monitoring: instance role	ORA_INSTANCE_ROLE	CHAR	18
ACTIVE_STATE		Oracle monitoring: active state	ORA_ACTIVE_STATE	CHAR	9