SAP ABAP Table STI_UNDOSTAT (Oracle monitoring: structure for GV$UNDOSTAT.)
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
⤷ 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 | STI_UNDOSTAT | Table Relationship Diagram |
Short Description | Oracle monitoring: structure for GV$UNDOSTAT. |
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 | BEGIN_TIME_D | ORA_BEGIN_TIME_D | ORA_DATE | DATS | 8 | 0 | Oracle monitoring: Begin of time interval (date field) | ||
3 | BEGIN_TIME_T | ORA_BEGIN_TIME_T | ORA_TIME | TIMS | 6 | 0 | Oracle monitoring: Begin of time interval (time field) | ||
4 | END_TIME_D | ORA_END_TIME_D | ORA_DATE | DATS | 8 | 0 | Oracle monitoring: End of time interval (date field) | ||
5 | END_TIME_T | ORA_END_TIME_T | ORA_TIME | TIMS | 6 | 0 | Oracle monitoring: End of time interval (time field) | ||
6 | UNDOTSN | ORA_UNDOTSN | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: last active undo tablespace | ||
7 | UNDOBLKS | ORA_UNDOBLKS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: total number of undo blocks | ||
8 | TXNCOUNT | ORA_TXNCOUNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: total number of transactions | ||
9 | MAXQUERYLEN | ORA_MAXQUERYLEN | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: length of the longest query | ||
10 | MAXCONCURRENCY | ORA_MAXCONCURRENCY | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: highest nr of TAs executed concurrently | ||
11 | UNXPSTEALCNT | ORA_UNXPSTEALCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: attempts to obtain undo space | ||
12 | UNXPBLKRELCNT | ORA_UNXPBLKRELCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: unexpired undo blocks removed | ||
13 | UNXPBLKREUCNT | ORA_UNXPBLKREUCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: unexpired undo blocks reused | ||
14 | EXPSTEALCNT | ORA_EXPSTEALCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: attempts to steal expired undo blocks | ||
15 | EXPBLKRELCNT | ORA_EXPBLKRELCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: expired undo blocks stolen from segments | ||
16 | EXPBLKREUCNT | ORA_EXPBLKREUCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: expired undo blocks reused | ||
17 | SSOLDERRCNT | ORA_SSOLDERRCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: number of times the error ORA-01555 occur | ||
18 | NOSPACEERRCNT | ORA_NOSPACEERRCNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: number of times space was requested |
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 700 |