SAP ABAP Table STR_UNDOSTAT_CALC (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

Basic Data

Table Category	INTTAB	Structure
Structure	STR_UNDOSTAT_CALC	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
19	NBTRASEC	☐			DEC	22	0

History

Last changed by/on	SAP	20070813
SAP Release Created in	700