1. Home
  2. Resources
  3. SAP Tables
  4. STR_UNDOSTAT_SS - Oracle monitoring: structure for GV$UNDOSTAT - stats display

SAP Table STR_UNDOSTAT_SS

Oracle monitoring: structure for GV$UNDOSTAT - stats display

STR_UNDOSTAT_SS (Oracle monitoring: structure for GV$UNDOSTAT - stats display) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link STR_UNDOSTAT_SS to other SAP tables.

Source: STR_UNDOSTAT_SS (Oracle monitoring: structure for GV$UNDOSTAT - stats display)

STR_UNDOSTAT_SS table fields

Field Data element Checktable Datatype Length Decimals
INST_ID Oracle monitor: Instance ID ORA_INST_ID DEC 22 0
DAY_X DATS 8 0
STATS_TEXT CHAR 20 0
UNDOBLKS Oracle monitoring: total number of undo blocks ORA_UNDOBLKS DEC 22 0
TXNCOUNT Oracle monitoring: total number of transactions ORA_TXNCOUNT DEC 22 0
MAXQUERYLEN Oracle monitoring: length of the longest query ORA_MAXQUERYLEN DEC 22 0
MAXCONCURRENCY Oracle monitoring: highest nr of TAs executed concurrently ORA_MAXCONCURRENCY DEC 22 0
UNXPSTEALCNT Oracle monitoring: attempts to obtain undo space ORA_UNXPSTEALCNT DEC 22 0
UNXPBLKRELCNT Oracle monitoring: unexpired undo blocks removed ORA_UNXPBLKRELCNT DEC 22 0
UNXPBLKREUCNT Oracle monitoring: unexpired undo blocks reused ORA_UNXPBLKREUCNT DEC 22 0
EXPSTEALCNT Oracle monitoring: attempts to steal expired undo blocks ORA_EXPSTEALCNT DEC 22 0
EXPBLKRELCNT Oracle monitoring: expired undo blocks stolen from segments ORA_EXPBLKRELCNT DEC 22 0
EXPBLKREUCNT Oracle monitoring: expired undo blocks reused ORA_EXPBLKREUCNT DEC 22 0
SSOLDERRCNT Oracle monitoring: number of times the error ORA-01555 occur ORA_SSOLDERRCNT DEC 22 0
NOSPACEERRCNT Oracle monitoring: number of times space was requested ORA_NOSPACEERRCNT DEC 22 0
NBTRASEC DEC 22 0