SAP ABAP Table STR_SQL_WA_ACTIV (Oracle monitoring: structure for V$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 STR_SQL_WA_ACTIV   Table Relationship Diagram
Short Description Oracle monitoring: structure for V$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 WORKAREA_ADDRESS ORA_WORKAREA_ADDRESS ORA_RAW_8 RAW 8   0   Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle  
2 OPERATION_TYPE ORA_OPERATION_TYPE ORA_CHAR_20 CHAR 20   0   Oracle Monitoring: OPERATION_TYPE  
3 OPERATION_ID ORA_OPERATION_ID ORA_NUMBER DEC 22   0   Oracle Monitoring: OPERATION_ID  
4 POLICY ORA_POLICY ORA_CHAR_6 CHAR 6   0   Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto)  
5 SID ORA_WAA_SID ORA_SID DEC 22   0   Oracle monitoring: SID  
6 QCINST_ID ORA_QCINST_ID ORA_NUMBER DEC 22   0   Oracle Monitoring: QCINST_ID: Query Coordinator ID  
7 QCSID ORA_QCSID ORA_NUMBER DEC 22   0   Oracle Monitoring: QCSID: Query Coordinator Session ID  
8 ACTIVE_TIME ORA_ACTIVE_TIME ORA_NUMBER DEC 22   0   Oracle Monitoring: ACTIVE_TIME: Average Active Time  
9 WORK_AREA_SIZE ORA_WORK_AREA_SIZE ORA_NUMBER DEC 22   0   Oracle Monitoring: WORK_AREA_SIZE: Maximum Workarea size  
10 EXPECTED_SIZE ORA_EXPECTED_SIZE ORA_NUMBER DEC 22   0   Oracle Monitoring: EXPECTED_SIZE  
11 ACTUAL_MEM_USED ORA_ACTUAL_MEM_USED ORA_NUMBER DEC 22   0   Oracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. used  
12 MAX_MEM_USED ORA_MAX_MEM_USED ORA_NUMBER DEC 22   0   Oracle Monitoring: MAX_MEM_USED  
13 NUMBER_PASSES ORA_NUMBER_PASSES ORA_NUMBER DEC 22   0   Oracle Monitoring: NUMBER_PASSES  
14 TEMPSEG_SIZE ORA_TEMPSEG_SIZE ORA_NUMBER DEC 22   0   Oracle Monitoring: TEMPSEG_SIZE: Size of Temporary Segment  
15 WA_TABLESPACE ORA_TABLESPACE ORA_CHAR_31 CHAR 31   0   Oracle Monitoring: TABLESPACE: TableSpace of Temp. Segment  
16 SEGRFNO ORA_SEGRFNO ORA_NUMBER DEC 22   0   Oracle Monitoring: SEGRFNO#: Rel File # of Tmp Segment  
17 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