Data Element list used by SAP ABAP Table STR_SQL_WA_ACTIV (Oracle monitoring: structure for V$SQL_WORKAREA_ACTIVE.)
SAP ABAP Table
STR_SQL_WA_ACTIV (Oracle monitoring: structure for V$SQL_WORKAREA_ACTIVE.) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ORA_ACTIVE_TIME | Oracle Monitoring: ACTIVE_TIME: Average Active Time | ||
| 2 | ORA_ACTUAL_MEM_USED | Oracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. used | ||
| 3 | ORA_EXPECTED_SIZE | Oracle Monitoring: EXPECTED_SIZE | ||
| 4 | ORA_MAX_MEM_USED | Oracle Monitoring: MAX_MEM_USED | ||
| 5 | ORA_NUMBER_PASSES | Oracle Monitoring: NUMBER_PASSES | ||
| 6 | ORA_OPERATION_ID | Oracle Monitoring: OPERATION_ID | ||
| 7 | ORA_OPERATION_TYPE | Oracle Monitoring: OPERATION_TYPE | ||
| 8 | ORA_POLICY | Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto) | ||
| 9 | ORA_QCINST_ID | Oracle Monitoring: QCINST_ID: Query Coordinator ID | ||
| 10 | ORA_QCSID | Oracle Monitoring: QCSID: Query Coordinator Session ID | ||
| 11 | ORA_SEGBLK | Oracle Monitoring: SEGBLK#: Block # of Temp. Segment | ||
| 12 | ORA_SEGRFNO | Oracle Monitoring: SEGRFNO#: Rel File # of Tmp Segment | ||
| 13 | ORA_TABLESPACE | Oracle Monitoring: TABLESPACE: TableSpace of Temp. Segment | ||
| 14 | ORA_TEMPSEG_SIZE | Oracle Monitoring: TEMPSEG_SIZE: Size of Temporary Segment | ||
| 15 | ORA_WAA_SID | Oracle monitoring: SID | ||
| 16 | ORA_WORKAREA_ADDRESS | Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle | ||
| 17 | ORA_WORK_AREA_SIZE | Oracle Monitoring: WORK_AREA_SIZE: Maximum Workarea size |