GVD_UNDOSTAT - Oracle monitoring: copy of GV$UNDOSTAT

Oracle monitoring: copy of GV$UNDOSTAT information is stored in SAP table GVD_UNDOSTAT.
 It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".

Fields for table GVD_UNDOSTAT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
SNAPSHOT_IDOracle monitor: snapshot IDXORA_SNAPSHOT_IDNUMC10*
INST_IDOracle monitor: Instance IDXORA_INST_IDDEC12
BEGIN_TIME_DOracle monitoring: Begin of time interval (date field)XORA_BEGIN_TIME_DDATS8
BEGIN_TIME_TOracle monitoring: Begin of time interval (time field)XORA_BEGIN_TIME_TTIMS6
END_TIME_DOracle monitoring: End of time interval (date field)XORA_END_TIME_DDATS8
END_TIME_TOracle monitoring: End of time interval (time field)XORA_END_TIME_TTIMS6
UNDOTSNOracle monitoring: last active undo tablespaceORA_UNDOTSNDEC12
UNDOBLKSOracle monitoring: total number of undo blocksORA_UNDOBLKSDEC12
TXNCOUNTOracle monitoring: total number of transactionsORA_TXNCOUNTDEC12
MAXQUERYLENOracle monitoring: length of the longest queryORA_MAXQUERYLENDEC12
MAXCONCURRENCYOracle monitoring: highest nr of TAs executed concurrentlyORA_MAXCONCURRENCYDEC12
UNXPSTEALCNTOracle monitoring: attempts to obtain undo spaceORA_UNXPSTEALCNTDEC12
UNXPBLKRELCNTOracle monitoring: unexpired undo blocks removedORA_UNXPBLKRELCNTDEC12
UNXPBLKREUCNTOracle monitoring: unexpired undo blocks reusedORA_UNXPBLKREUCNTDEC12
EXPSTEALCNTOracle monitoring: attempts to steal expired undo blocksORA_EXPSTEALCNTDEC12
EXPBLKRELCNTOracle monitoring: expired undo blocks stolen from segmentsORA_EXPBLKRELCNTDEC12
EXPBLKREUCNTOracle monitoring: expired undo blocks reusedORA_EXPBLKREUCNTDEC12
SSOLDERRCNTOracle monitoring: number of times the error ORA-01555 occurORA_SSOLDERRCNTDEC12
NOSPACEERRCNTOracle monitoring: number of times space was requestedORA_NOSPACEERRCNTDEC12
Privacy Policy