SAP Table STR_SQL_WA_ACTIV
Oracle monitoring: structure for V$SQL_WORKAREA_ACTIVE.
STR_SQL_WA_ACTIV (Oracle monitoring: structure for V$SQL_WORKAREA_ACTIVE.) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link STR_SQL_WA_ACTIV to other SAP tables.
STR_SQL_WA_ACTIV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| WORKAREA_ADDRESS | Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle | ORA_WORKAREA_ADDRESS | RAW | 8 | 0 | |||
| OPERATION_TYPE | Oracle Monitoring: OPERATION_TYPE | ORA_OPERATION_TYPE | CHAR | 20 | 0 | |||
| OPERATION_ID | Oracle Monitoring: OPERATION_ID | ORA_OPERATION_ID | DEC | 22 | 0 | |||
| POLICY | Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto) | ORA_POLICY | CHAR | 6 | 0 | |||
| SID | Oracle monitoring: SID | ORA_WAA_SID | DEC | 22 | 0 | |||
| QCINST_ID | Oracle Monitoring: QCINST_ID: Query Coordinator ID | ORA_QCINST_ID | DEC | 22 | 0 | |||
| QCSID | Oracle Monitoring: QCSID: Query Coordinator Session ID | ORA_QCSID | DEC | 22 | 0 | |||
| ACTIVE_TIME | Oracle Monitoring: ACTIVE_TIME: Average Active Time | ORA_ACTIVE_TIME | DEC | 22 | 0 | |||
| WORK_AREA_SIZE | Oracle Monitoring: WORK_AREA_SIZE: Maximum Workarea size | ORA_WORK_AREA_SIZE | DEC | 22 | 0 | |||
| EXPECTED_SIZE | Oracle Monitoring: EXPECTED_SIZE | ORA_EXPECTED_SIZE | DEC | 22 | 0 | |||
| ACTUAL_MEM_USED | Oracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. used | ORA_ACTUAL_MEM_USED | DEC | 22 | 0 | |||
| MAX_MEM_USED | Oracle Monitoring: MAX_MEM_USED | ORA_MAX_MEM_USED | DEC | 22 | 0 | |||
| NUMBER_PASSES | Oracle Monitoring: NUMBER_PASSES | ORA_NUMBER_PASSES | DEC | 22 | 0 | |||
| TEMPSEG_SIZE | Oracle Monitoring: TEMPSEG_SIZE: Size of Temporary Segment | ORA_TEMPSEG_SIZE | DEC | 22 | 0 | |||
| WA_TABLESPACE | Oracle Monitoring: TABLESPACE: TableSpace of Temp. Segment | ORA_TABLESPACE | CHAR | 31 | 0 | |||
| SEGRFNO | Oracle Monitoring: SEGRFNO#: Rel File # of Tmp Segment | ORA_SEGRFNO | DEC | 22 | 0 | |||
| SEGBLK | Oracle Monitoring: SEGBLK#: Block # of Temp. Segment | ORA_SEGBLK | DEC | 22 | 0 | |||
