SAP ABAP Table GVD_UNDOSTAT (Oracle monitoring: copy of GV$UNDOSTAT)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
⤷ STUN (Package) DBA: All the rest in English
⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
⤷ STUN (Package) DBA: All the rest in English
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | GVD_UNDOSTAT | Table Relationship Diagram |
Short Description | Oracle monitoring: copy of GV$UNDOSTAT |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | L | Table for storing temporary data, delivered empty |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | SNAPSHOT_ID | ORA_SNAPSHOT_ID | ORA_SNAPSHOT_ID | NUMC | 10 | 0 | Oracle monitor: snapshot ID | * | |
2 | INST_ID | ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
3 | BEGIN_TIME_D | ORA_BEGIN_TIME_D | ORA_DATE | DATS | 8 | 0 | Oracle monitoring: Begin of time interval (date field) | ||
4 | BEGIN_TIME_T | ORA_BEGIN_TIME_T | ORA_TIME | TIMS | 6 | 0 | Oracle monitoring: Begin of time interval (time field) | ||
5 | END_TIME_D | ORA_END_TIME_D | ORA_DATE | DATS | 8 | 0 | Oracle monitoring: End of time interval (date field) | ||
6 | END_TIME_T | ORA_END_TIME_T | ORA_TIME | TIMS | 6 | 0 | Oracle monitoring: End of time interval (time field) | ||
7 | UNDOTSN | ORA_UNDOTSN | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: last active undo tablespace | ||
8 | UNDOBLKS | ORA_UNDOBLKS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: total number of undo blocks | ||
9 | TXNCOUNT | ORA_TXNCOUNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: total number of transactions | ||
10 | MAXQUERYLEN | ORA_MAXQUERYLEN | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: length of the longest query | ||
11 | MAXCONCURRENCY | ORA_MAXCONCURRENCY | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: highest nr of TAs executed concurrently | ||
12 | UNXPSTEALCNT | ORA_UNXPSTEALCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: attempts to obtain undo space | ||
13 | UNXPBLKRELCNT | ORA_UNXPBLKRELCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: unexpired undo blocks removed | ||
14 | UNXPBLKREUCNT | ORA_UNXPBLKREUCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: unexpired undo blocks reused | ||
15 | EXPSTEALCNT | ORA_EXPSTEALCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: attempts to steal expired undo blocks | ||
16 | EXPBLKRELCNT | ORA_EXPBLKRELCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: expired undo blocks stolen from segments | ||
17 | EXPBLKREUCNT | ORA_EXPBLKREUCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: expired undo blocks reused | ||
18 | SSOLDERRCNT | ORA_SSOLDERRCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: number of times the error ORA-01555 occur | ||
19 | NOSPACEERRCNT | ORA_NOSPACEERRCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: number of times space was requested |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 700 |