SAP TABLES | Basis Components | Use Subcomponents | Oracle Database Monitors(BC-CCM-MON-ORA) SAP BC

STI_SQL_WA_ACTIV SAP Oracle monitoring: structure for GV$SQL_WORKAREA_ACTIVE. Structure and data







STI_SQL_WA_ACTIV is an SAP Structure so does not store data like a database table does but can be used to process "Oracle monitoring: structure for GV$SQL_WORKAREA_ACTIVE." Information within sap ABAP programs. This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_STI_SQL_WA_ACTIV TYPE STI_SQL_WA_ACTIV .

Below is the documentation avaialable and full details of the fields which make up this Structure.

You can view further information about this via relevant transactions such as SE11 or SE80. Also check out the Comments section below to view or add related contributions and example screen shots.



Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Cannot Be Enhanced
See here for more information about this and other SAP enhancement categories


SAP STI_SQL_WA_ACTIV Structure fields within data Dictionary





Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
INST_IDORA_INST_IDDEC22 Oracle monitor: Instance ID
WORKAREA_ADDRESSORA_WORKAREA_ADDRESSRAW8 Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle
OPERATION_TYPEORA_OPERATION_TYPECHAR20 Oracle Monitoring: OPERATION_TYPE
OPERATION_IDORA_OPERATION_IDDEC22 Oracle Monitoring: OPERATION_ID
POLICYORA_POLICYCHAR6 Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto)
SIDORA_WAA_SIDDEC22 Oracle monitoring: SID
QCINST_IDORA_QCINST_IDDEC22 Oracle Monitoring: QCINST_ID: Query Coordinator ID
QCSIDORA_QCSIDDEC22 Oracle Monitoring: QCSID: Query Coordinator Session ID
ACTIVE_TIMEORA_ACTIVE_TIMEDEC22 Oracle Monitoring: ACTIVE_TIME: Average Active Time
WORK_AREA_SIZEORA_WORK_AREA_SIZEDEC22 Oracle Monitoring: WORK_AREA_SIZE: Maximum Workarea size
EXPECTED_SIZEORA_EXPECTED_SIZEDEC22 Oracle Monitoring: EXPECTED_SIZE
ACTUAL_MEM_USEDORA_ACTUAL_MEM_USEDDEC22 Oracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. used
MAX_MEM_USEDORA_MAX_MEM_USEDDEC22 Oracle Monitoring: MAX_MEM_USED
NUMBER_PASSESORA_NUMBER_PASSESDEC22 Oracle Monitoring: NUMBER_PASSES
TEMPSEG_SIZEORA_TEMPSEG_SIZEDEC22 Oracle Monitoring: TEMPSEG_SIZE: Size of Temporary Segment
WA_TABLESPACEORA_TABLESPACECHAR31 Oracle Monitoring: TABLESPACE: TableSpace of Temp. Segment
SEGRFNOORA_SEGRFNODEC22 Oracle Monitoring: SEGRFNO#: Rel File # of Tmp Segment
SEGBLKORA_SEGBLKDEC22 Oracle Monitoring: SEGBLK#: Block # of Temp. Segment



Key field
Non-key field