GVD_SESSION_EVT - Oracle monitoring: copy of GV$SESSION_EVENT
Oracle monitoring: copy of GV$SESSION_EVENT information is stored in SAP table GVD_SESSION_EVT.
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".
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_EVT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
SAP_LINE_NR | Help field: Line Nr. (to avoid duplicate entries) | X | ORA_SAPLINENR | INT4 | 4 | |
SID | Oracle monitoring: SID (Session) | ORA_SID | DEC | 12 | ||
EVENT | Oracle monitor: EVENT | ORA_EVENT | CHAR | 64 | ||
TOTAL_WAITS | Oracle monitor: ORA_TOTAL_WAITS | ORA_TOTAL_WAITS | DEC | 12 | ||
TOTAL_TIMEOUTS | Oracle monitor: TOTAL_TIMEOUTS | ORA_TOTAL_TIMEOUTS | DEC | 12 | ||
TIME_WAITED | Oracle monitor: TIME_WAITED | ORA_TIME_WAITED | DEC | 12 | ||
AVERAGE_WAIT | Oracle monitor: AVERAGE_WAIT | ORA_AVERAGE_WAIT | DEC | 12 | ||
MAX_WAIT | Oracle monitoring: maximum time waited for event | ORA_MAX_WAIT | DEC | 12 | ||
TIME_WAITED_MIC | Oracle monitoring: time waited micro | ORA_TIME_WAITED_M | DEC | 12 |