GVD_SESSION_WAIT - Oracle monitoring: Copy of GV$SESSION_WAIT

Oracle monitoring: Copy of GV$SESSION_WAIT information is stored in SAP table GVD_SESSION_WAIT.
 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_SESSION_WAIT

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
SIDOracle monitoring: SID (Session)XORA_SIDDEC12
SEQOracle monitoring: SEQ#XORA_SEQDEC12
EVENTOracle monitor: EVENTORA_EVENTCHAR64
P1TEXTOracle monitoring: ORA_P1TEXT: Description of 1. param.ORA_P1TEXTCHAR64
P1Oracle monitoring: ORA_P1: First additional parameterORA_P1DEC12
P1RAWOracle monitoring: ORA_P1: First additional parameterORA_P1RAWRAW8
P2TEXTOracle monitoring: ORA_P1TEXT: Description of 2. param.ORA_P2TEXTCHAR64
P2Oracle monitoring: ORA_P2: Second additional parameterORA_P2DEC12
P2RAWOracle monitoring: ORA_P1: 2nd additional parameterORA_P2RAWRAW8
P3TEXTOracle monitoring: ORA_P1TEXT: Description of 3. param.ORA_P3TEXTCHAR64
P3Oracle monitoring: ORA_P3: Third additional parameterORA_P3DEC12
P3RAWOracle monitoring: ORA_P1: 3rd additional parameterORA_P3RAWRAW8
WAIT_TIMEOracle monitoring: Latch Wait TimeORA_WAIT_TIMEDEC12
SECONDS_IN_WAITOracle monitoring: SECONDS_IN_WAIT:ORA_SECONDS_IN_WAITDEC12
STATEOracle monitoring: STATE: Session wait stateORA_STATECHAR19
Privacy Policy