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