SAP Table GVD_UNDOSTAT
Oracle monitoring: copy of GV$UNDOSTAT
Unsere Literaturempfehlung
SAP-Änderungs- und Transportmanagement: Architektur und Wartung der SAP-Systemlandschaft
Das Standardwerk zum Änderungs- und Transportmanagement in der 4. Auflage! In diesem Buch finden Sie alle Informationen, die Sie zum Planen, Implementieren und Warten von Systemlandschaften benötigen. Sie lernen die Grundlagen und die Bedienung aller relevanten Werkzeuge und erhalten detaillierte Anleitungen zur Änderungs- und Transportverwaltung. Diese Neuauflage berücksichtigt Neuerungen in den Bereichen SAP NetWeaver AS Java und Development Infrastructure, CTS+, SAP Solution Manager und Enhancement Packages. Bringen Sie ihr Wissen auf den neuesten Stand!
Bei amazon.de ansehen →
The table GVD_UNDOSTAT (Oracle monitoring: copy of GV$UNDOSTAT) is a standard table in SAP ERP. It belongs to the package STUN.
Technical Information
| Table | GVD_UNDOSTAT |
| Short Text | Oracle monitoring: copy of GV$UNDOSTAT |
| Package | STUN |
| Table Type | Transparent Table |
Fields for Table GVD_UNDOSTAT
| 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 | |
| BEGIN_TIME_D | ✔ | Oracle monitoring: Begin of time interval (date field) | ORA_BEGIN_TIME_D | DATS | 8 | |
| BEGIN_TIME_T | ✔ | Oracle monitoring: Begin of time interval (time field) | ORA_BEGIN_TIME_T | TIMS | 6 | |
| END_TIME_D | ✔ | Oracle monitoring: End of time interval (date field) | ORA_END_TIME_D | DATS | 8 | |
| END_TIME_T | ✔ | Oracle monitoring: End of time interval (time field) | ORA_END_TIME_T | TIMS | 6 | |
| UNDOTSN | Oracle monitoring: last active undo tablespace | ORA_UNDOTSN | DEC | 22 | ||
| UNDOBLKS | Oracle monitoring: total number of undo blocks | ORA_UNDOBLKS | DEC | 22 | ||
| TXNCOUNT | Oracle monitoring: total number of transactions | ORA_TXNCOUNT | DEC | 22 | ||
| MAXQUERYLEN | Oracle monitoring: length of the longest query | ORA_MAXQUERYLEN | DEC | 22 | ||
| MAXCONCURRENCY | Oracle monitoring: highest nr of TAs executed concurrently | ORA_MAXCONCURRENCY | DEC | 22 | ||
| UNXPSTEALCNT | Oracle monitoring: attempts to obtain undo space | ORA_UNXPSTEALCNT | DEC | 22 | ||
| UNXPBLKRELCNT | Oracle monitoring: unexpired undo blocks removed | ORA_UNXPBLKRELCNT | DEC | 22 | ||
| UNXPBLKREUCNT | Oracle monitoring: unexpired undo blocks reused | ORA_UNXPBLKREUCNT | DEC | 22 | ||
| EXPSTEALCNT | Oracle monitoring: attempts to steal expired undo blocks | ORA_EXPSTEALCNT | DEC | 22 | ||
| EXPBLKRELCNT | Oracle monitoring: expired undo blocks stolen from segments | ORA_EXPBLKRELCNT | DEC | 22 | ||
| EXPBLKREUCNT | Oracle monitoring: expired undo blocks reused | ORA_EXPBLKREUCNT | DEC | 22 | ||
| SSOLDERRCNT | Oracle monitoring: number of times the error ORA-01555 occur | ORA_SSOLDERRCNT | DEC | 22 | ||
| NOSPACEERRCNT | Oracle monitoring: number of times space was requested | ORA_NOSPACEERRCNT | DEC | 22 |