SAP Table GVD_DATABASE
Copy of GV$DATABASE (currently not provided with snapshots)
Unsere Literaturempfehlung
ABAP Workbench - 100 Tipps & Tricks
Es gibt 100 gute Gründe, warum Sie dieses Buch kaufen sollten. Doch die verraten wir Ihnen hier nicht. Nur so viel: Wenn Sie die ABAP Workbench als Ihr zweites Wohnzimmer begreifen, ist dieses Buch genau das richtige für Sie! Die Mini-Tutorials in diesem Buch unterstützen Sie dabei, Software in ABAP effizienter zu entwickeln. Tipps und Tricks, wie Sie sich bei der Bearbeitung von Quelltext das Leben leichter machen, wie Sie häufig wiederkehrende Programmieraufgaben automatisieren oder umständliches Vorgehen früherer Tage endlich über Bord werfen. Sie werden die ABAP Workbench in einem ganz neuen Licht erleben. Eine klare Sprache, Klick-für-Klick-Anleitungen, Zusammenfassungen und Hervorhebungen sorgen dabei für einen schnellen und unkomplizierten Lernerfolg.
Bei amazon.de ansehen →
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 |