Menu

SAP Table GVD_SQL_WA_ACTIV

Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE

The table GVD_SQL_WA_ACTIV (Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table GVD_SQL_WA_ACTIV
Short Text Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE
Package STUN
Table Type Transparent Table

Fields for Table GVD_SQL_WA_ACTIV

Field Name Key Description Data Element Type Length Check Table
SNAPSHOT_ID Oracle monitor: snapshot ID ORA_SNAPSHOT_ID NUMC 10 *
INST_ID Oracle monitor: Instance ID ORA_INST_ID DEC 22
WORKAREA_ADDRESS Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle ORA_WORKAREA_ADDRESS RAW 8
OPERATION_TYPE Oracle Monitoring: OPERATION_TYPE ORA_OPERATION_TYPE CHAR 20
OPERATION_ID Oracle Monitoring: OPERATION_ID ORA_OPERATION_ID DEC 22
POLICY Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto) ORA_POLICY CHAR 6
SID Oracle monitoring: SID ORA_WAA_SID DEC 22
QCINST_ID Oracle Monitoring: QCINST_ID: Query Coordinator ID ORA_QCINST_ID DEC 22
QCSID Oracle Monitoring: QCSID: Query Coordinator Session ID ORA_QCSID DEC 22
ACTIVE_TIME Oracle Monitoring: ACTIVE_TIME: Average Active Time ORA_ACTIVE_TIME DEC 22
WORK_AREA_SIZE Oracle Monitoring: WORK_AREA_SIZE: Maximum Workarea size ORA_WORK_AREA_SIZE DEC 22
EXPECTED_SIZE Oracle Monitoring: EXPECTED_SIZE ORA_EXPECTED_SIZE DEC 22
ACTUAL_MEM_USED Oracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. used ORA_ACTUAL_MEM_USED DEC 22
MAX_MEM_USED Oracle Monitoring: MAX_MEM_USED ORA_MAX_MEM_USED DEC 22
NUMBER_PASSES Oracle Monitoring: NUMBER_PASSES ORA_NUMBER_PASSES DEC 22
TEMPSEG_SIZE Oracle Monitoring: TEMPSEG_SIZE: Size of Temporary Segment ORA_TEMPSEG_SIZE DEC 22
WA_TABLESPACE Oracle Monitoring: TABLESPACE: TableSpace of Temp. Segment ORA_TABLESPACE CHAR 31
SEGRFNO Oracle Monitoring: SEGRFNO#: Rel File # of Tmp Segment ORA_SEGRFNO DEC 22
SEGBLK Oracle Monitoring: SEGBLK#: Block # of Temp. Segment ORA_SEGBLK DEC 22