GVD_SQL_WA_ACTIV - Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE

Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE information is stored in SAP table GVD_SQL_WA_ACTIV.
 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_SQL_WA_ACTIV

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
WORKAREA_ADDRESSOracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handleXORA_WORKAREA_ADDRESSRAW8
OPERATION_TYPEOracle Monitoring: OPERATION_TYPEORA_OPERATION_TYPECHAR20
OPERATION_IDOracle Monitoring: OPERATION_IDORA_OPERATION_IDDEC12
POLICYOracle Monitoring: POLICY: Sizing Policy (Manual or Auto)ORA_POLICYCHAR6
SIDOracle monitoring: SIDORA_WAA_SIDDEC12
QCINST_IDOracle Monitoring: QCINST_ID: Query Coordinator IDORA_QCINST_IDDEC12
QCSIDOracle Monitoring: QCSID: Query Coordinator Session IDORA_QCSIDDEC12
ACTIVE_TIMEOracle Monitoring: ACTIVE_TIME: Average Active TimeORA_ACTIVE_TIMEDEC12
WORK_AREA_SIZEOracle Monitoring: WORK_AREA_SIZE: Maximum Workarea sizeORA_WORK_AREA_SIZEDEC12
EXPECTED_SIZEOracle Monitoring: EXPECTED_SIZEORA_EXPECTED_SIZEDEC12
ACTUAL_MEM_USEDOracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. usedORA_ACTUAL_MEM_USEDDEC12
MAX_MEM_USEDOracle Monitoring: MAX_MEM_USEDORA_MAX_MEM_USEDDEC12
NUMBER_PASSESOracle Monitoring: NUMBER_PASSESORA_NUMBER_PASSESDEC12
TEMPSEG_SIZEOracle Monitoring: TEMPSEG_SIZE: Size of Temporary SegmentORA_TEMPSEG_SIZEDEC12
WA_TABLESPACEOracle Monitoring: TABLESPACE: TableSpace of Temp. SegmentORA_TABLESPACECHAR31
SEGRFNOOracle Monitoring: SEGRFNO#: Rel File # of Tmp SegmentORA_SEGRFNODEC12
SEGBLKOracle Monitoring: SEGBLK#: Block # of Temp. SegmentORA_SEGBLKDEC12
Privacy Policy