SAP ABAP Table GVD_SQL_WA_ACTIV (Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English
Basic Data
Table Category TRANSP    Transparent table 
Transparent table GVD_SQL_WA_ACTIV   Table Relationship Diagram
Short Description Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
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 SNAPSHOT_ID ORA_SNAPSHOT_ID ORA_SNAPSHOT_ID NUMC 10   0   Oracle monitor: snapshot ID *
2 INST_ID ORA_INST_ID ORA_INST_ID DEC 22   0   Oracle monitor: Instance ID  
3 WORKAREA_ADDRESS ORA_WORKAREA_ADDRESS ORA_RAW_8 RAW 8   0   Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle  
4 OPERATION_TYPE ORA_OPERATION_TYPE ORA_CHAR_20 CHAR 20   0   Oracle Monitoring: OPERATION_TYPE  
5 OPERATION_ID ORA_OPERATION_ID ORA_NUMBER DEC 22   0   Oracle Monitoring: OPERATION_ID  
6 POLICY ORA_POLICY ORA_CHAR_6 CHAR 6   0   Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto)  
7 SID ORA_WAA_SID ORA_SID DEC 22   0   Oracle monitoring: SID  
8 QCINST_ID ORA_QCINST_ID ORA_NUMBER DEC 22   0   Oracle Monitoring: QCINST_ID: Query Coordinator ID  
9 QCSID ORA_QCSID ORA_NUMBER DEC 22   0   Oracle Monitoring: QCSID: Query Coordinator Session ID  
10 ACTIVE_TIME ORA_ACTIVE_TIME ORA_NUMBER DEC 22   0   Oracle Monitoring: ACTIVE_TIME: Average Active Time  
11 WORK_AREA_SIZE ORA_WORK_AREA_SIZE ORA_NUMBER DEC 22   0   Oracle Monitoring: WORK_AREA_SIZE: Maximum Workarea size  
12 EXPECTED_SIZE ORA_EXPECTED_SIZE ORA_NUMBER DEC 22   0   Oracle Monitoring: EXPECTED_SIZE  
13 ACTUAL_MEM_USED ORA_ACTUAL_MEM_USED ORA_NUMBER DEC 22   0   Oracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. used  
14 MAX_MEM_USED ORA_MAX_MEM_USED ORA_NUMBER DEC 22   0   Oracle Monitoring: MAX_MEM_USED  
15 NUMBER_PASSES ORA_NUMBER_PASSES ORA_NUMBER DEC 22   0   Oracle Monitoring: NUMBER_PASSES  
16 TEMPSEG_SIZE ORA_TEMPSEG_SIZE ORA_NUMBER DEC 22   0   Oracle Monitoring: TEMPSEG_SIZE: Size of Temporary Segment  
17 WA_TABLESPACE ORA_TABLESPACE ORA_CHAR_31 CHAR 31   0   Oracle Monitoring: TABLESPACE: TableSpace of Temp. Segment  
18 SEGRFNO ORA_SEGRFNO ORA_NUMBER DEC 22   0   Oracle Monitoring: SEGRFNO#: Rel File # of Tmp Segment  
19 SEGBLK ORA_SEGBLK ORA_NUMBER DEC 22   0   Oracle Monitoring: SEGBLK#: Block # of Temp. Segment  
History
Last changed by/on SAP  20130604 
SAP Release Created in 700