SAP ABAP Table STI_SQL_WA_ACTIV (Oracle monitoring: structure for GV$SQL_WORKAREA_ACTIVE.)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
Basic Data
Table Category INTTAB    Structure 
Structure STI_SQL_WA_ACTIV   Table Relationship Diagram
Short Description Oracle monitoring: structure for GV$SQL_WORKAREA_ACTIVE.    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 INST_ID ORA_INST_ID ORA_INST_ID DEC 22   0   Oracle monitor: Instance ID  
2 WORKAREA_ADDRESS ORA_WORKAREA_ADDRESS ORA_RAW_8 RAW 8   0   Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle  
3 OPERATION_TYPE ORA_OPERATION_TYPE ORA_CHAR_20 CHAR 20   0   Oracle Monitoring: OPERATION_TYPE  
4 OPERATION_ID ORA_OPERATION_ID ORA_NUMBER DEC 22   0   Oracle Monitoring: OPERATION_ID  
5 POLICY ORA_POLICY ORA_CHAR_6 CHAR 6   0   Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto)  
6 SID ORA_WAA_SID ORA_SID DEC 22   0   Oracle monitoring: SID  
7 QCINST_ID ORA_QCINST_ID ORA_NUMBER DEC 22   0   Oracle Monitoring: QCINST_ID: Query Coordinator ID  
8 QCSID ORA_QCSID ORA_NUMBER DEC 22   0   Oracle Monitoring: QCSID: Query Coordinator Session ID  
9 ACTIVE_TIME ORA_ACTIVE_TIME ORA_NUMBER DEC 22   0   Oracle Monitoring: ACTIVE_TIME: Average Active Time  
10 WORK_AREA_SIZE ORA_WORK_AREA_SIZE ORA_NUMBER DEC 22   0   Oracle Monitoring: WORK_AREA_SIZE: Maximum Workarea size  
11 EXPECTED_SIZE ORA_EXPECTED_SIZE ORA_NUMBER DEC 22   0   Oracle Monitoring: EXPECTED_SIZE  
12 ACTUAL_MEM_USED ORA_ACTUAL_MEM_USED ORA_NUMBER DEC 22   0   Oracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. used  
13 MAX_MEM_USED ORA_MAX_MEM_USED ORA_NUMBER DEC 22   0   Oracle Monitoring: MAX_MEM_USED  
14 NUMBER_PASSES ORA_NUMBER_PASSES ORA_NUMBER DEC 22   0   Oracle Monitoring: NUMBER_PASSES  
15 TEMPSEG_SIZE ORA_TEMPSEG_SIZE ORA_NUMBER DEC 22   0   Oracle Monitoring: TEMPSEG_SIZE: Size of Temporary Segment  
16 WA_TABLESPACE ORA_TABLESPACE ORA_CHAR_31 CHAR 31   0   Oracle Monitoring: TABLESPACE: TableSpace of Temp. Segment  
17 SEGRFNO ORA_SEGRFNO ORA_NUMBER DEC 22   0   Oracle Monitoring: SEGRFNO#: Rel File # of Tmp Segment  
18 SEGBLK ORA_SEGBLK ORA_NUMBER DEC 22   0   Oracle Monitoring: SEGBLK#: Block # of Temp. Segment  
History
Last changed by/on SAP  20070813 
SAP Release Created in 700