SAP Table GVD_DATABASE

Copy of GV$DATABASE (currently not provided with snapshots)

The table GVD_DATABASE (Copy of GV$DATABASE (currently not provided with snapshots)) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table	GVD_DATABASE
Short Text	Copy of GV$DATABASE (currently not provided with snapshots)
Package	STUN
Table Type	Transparent Table

Fields for Table GVD_DATABASE

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
DBID	✔	Oracle monitoring: database id	ORA_DBID	DEC	22
NAME		Oracle monitoring: database name	ORA_NAME_DB	CHAR	9
CREATED_D		Oracle monitoring: db creation date	ORA_CREATED	DATS	8
CREATED_T		Oracle monitoring: db creation time	ORA_CREATET	TIMS	6
RESETLOGS_CHANGE		Oracle monitoring: resetlogs change number	ORA_RESETLOGS_CHANGE	DEC	22
RESETLOGS_DATE		Oracle monitoring: resetlogs date	ORA_RESETLOGS_DATE	DATS	8
RESETLOGS_TIME		Oracle monitoring: resetlogs time	ORA_RESETLOGS_TIME	TIMS	6
PR_RESETLGS_CHG		Oracle monitoring: prior resetlogs change number	ORA_PRIOR_RESETLOGS_CHANGE	DEC	22
PR_RESETLGS_DATE		Oracle monitoring: prior resetlogs date	ORA_PRIOR_RESETLOGS_DATE	DATS	8
PR_RESETLGS_TIME		Oracle monitoring: prior resetlogs time	ORA_PRIOR_RESETLOGS_TIME	TIMS	6
LOG_MODE		Oracle monitoring: db log mode	ORA_LOG_MODE	CHAR	12
CHECKPOINT_CHANG		Oracle Monitoring: checkpoint change#	ORA_CHECKPOINT_CHANGE	DEC	22
ARCHIVE_CHANGE		Oracle monitoring: archive change number	ORA_ARCHIVE_CHANGE	DEC	22
CONTROLFILE_TYPE		Oracle monitoring: db controlfile type	ORA_CONTROLFILE_TYPE	CHAR	7
CONTROLFILE_CR_D		Oracle monitoring: db controlfile creation date	ORA_CONTROLFILE_CREATED	DATS	8
CONTROLFILE_CR_T		Oracle monitoring: db controlfile creation time	ORA_CONTROLFILE_CREATET	TIMS	6
CONTROLFILE_SEQU		Oracle monitoring: db controlfile sequence number	ORA_CONTROLFILE_SEQUENCE	DEC	22
CONTROLFILE_CHAN		Oracle monitoring: controlfile change number	ORA_CONTROLFILE_CHANGE	DEC	22
CONTROLFILE_TIMD		Oracle monitoring: db controlfile time (date value)	ORA_CONTROLFILE_TIMD	DATS	8
CONTROLFILE_TIMT		Oracle monitoring: db controlfile time	ORA_CONTROLFILE_TIME	TIMS	6
OPEN_RESETLOGS		Oracle monitoring: db open reset logs	ORA_OPEN_RESETLOGS	CHAR	11
VERSION_TIME_D		Oracle monitoring: db version time (date value)	ORA_VERSION_TIMD	DATS	8
VERSION_TIME_T		Oracle monitoring: db version time	ORA_VERSION_TIME	TIMS	6
OPEN_MODE		Oracle monitoring: db open mode	ORA_OPEN_MODE	CHAR	10
PROTECTION_MODE		Oracle monitoring: db protection mode	ORA_PROTECTION_MODE	CHAR	20
PROTECTION_LEVEL		Oracle monitoring: db protection level	ORA_PROTECTION_LEVEL	CHAR	20
REMOTE_ARCHIVE		Oracle monitoring: db remote archive	ORA_REMOTE_ARCHIVE	CHAR	8
ACTIVATION		Oracle monitoring: db activation number	ORA_ACTIVATION	DEC	22
DATABASE_ROLE		Oracle monitoring: database role	ORA_DATABASE_ROLE	CHAR	16
ARCHIVELOG_CHANG		Oracle monitoring: db archivelog chg nb	ORA_ARCHIVELOG_CHANGE	DEC	22
SWITCHOVER_STATU		Oracle monitoring: db switchover status	ORA_SWITCHOVER_STATUS	CHAR	18
DATAGUARD_BROKER		Oracle monitoring: db dataguard broker	ORA_DATAGUARD_BROKER	CHAR	8
GUARD_STATUS		Oracle monitoring: db guard status	ORA_GUARD_STATUS	CHAR	7
SUPP_LG_DATA_MIN		Oracle monitoring: db supplemental log data min	ORA_SUPPLEMENTAL_LOG_DATA_MIN	CHAR	3
SUPP_LOG_DATA_PK		Oracle monitoring: db supplemental log data pk	ORA_SUPPLEMENTAL_LOG_DATA_PK	CHAR	3
SUPP_LOG_DATA_UI		Oracle monitoring: db log data ui	ORA_LOG_DATA_UI	CHAR	3
FORCE_LOGGING		Oracle monitoring: db force logging	ORA_FORCE_LOGGING	CHAR	3