GVD_DATABASE - Copy of GV$DATABASE (currently not provided with snapshots)
Copy of GV$DATABASE (currently not provided with snapshots) information is stored in SAP table GVD_DATABASE.
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_DATABASE
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 | |
| DBID | Oracle monitoring: database id | X | ORA_DBID | DEC | 12 | |
| 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 | 12 | ||
| 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 | 12 | ||
| 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 | 12 | ||
| ARCHIVE_CHANGE | Oracle monitoring: archive change number | ORA_ARCHIVE_CHANGE | DEC | 12 | ||
| 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 | 12 | ||
| CONTROLFILE_CHAN | Oracle monitoring: controlfile change number | ORA_CONTROLFILE_CHANGE | DEC | 12 | ||
| 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 | 12 | ||
| DATABASE_ROLE | Oracle monitoring: database role | ORA_DATABASE_ROLE | CHAR | 16 | ||
| ARCHIVELOG_CHANG | Oracle monitoring: db archivelog chg nb | ORA_ARCHIVELOG_CHANGE | DEC | 12 | ||
| 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 |