SAP Table GVD_UNDOSTAT
Oracle monitoring: copy of GV$UNDOSTAT
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
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 |