SAP ABAP Table STR_UNDOSTAT_SS (Oracle monitoring: structure for GV$UNDOSTAT - stats display)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷
S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors⤷
S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
Basic Data
| Table Category | INTTAB | Structure |
| Structure | STR_UNDOSTAT_SS |
Table Relationship Diagram 
|
| Short Description | Oracle monitoring: structure for GV$UNDOSTAT - stats display |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  INST_ID |
ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
| 2 | DAY_X |
DATS | 8 | 0 | |||||
| 3 | STATS_TEXT |
CHAR | 20 | 0 | |||||
| 4 | UNDOBLKS |
ORA_UNDOBLKS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: total number of undo blocks | ||
| 5 | TXNCOUNT |
ORA_TXNCOUNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: total number of transactions | ||
| 6 | MAXQUERYLEN |
ORA_MAXQUERYLEN | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: length of the longest query | ||
| 7 | MAXCONCURRENCY |
ORA_MAXCONCURRENCY | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: highest nr of TAs executed concurrently | ||
| 8 | UNXPSTEALCNT |
ORA_UNXPSTEALCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: attempts to obtain undo space | ||
| 9 | UNXPBLKRELCNT |
ORA_UNXPBLKRELCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: unexpired undo blocks removed | ||
| 10 | UNXPBLKREUCNT |
ORA_UNXPBLKREUCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: unexpired undo blocks reused | ||
| 11 | EXPSTEALCNT |
ORA_EXPSTEALCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: attempts to steal expired undo blocks | ||
| 12 | EXPBLKRELCNT |
ORA_EXPBLKRELCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: expired undo blocks stolen from segments | ||
| 13 | EXPBLKREUCNT |
ORA_EXPBLKREUCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: expired undo blocks reused | ||
| 14 | SSOLDERRCNT |
ORA_SSOLDERRCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: number of times the error ORA-01555 occur | ||
| 15 | NOSPACEERRCNT |
ORA_NOSPACEERRCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: number of times space was requested | ||
| 16 | NBTRASEC |
DEC | 22 | 0 |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 700 |
