SAP ABAP Table GVD_SESSION (Oracle monitoring: Snapshot table for GV$SESSION)
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_SESSION   Table Relationship Diagram
Short Description Oracle monitoring: Snapshot table for GV$SESSION    
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 SADDR ORA_SADDR ORA_SADDR RAW 8   0   Oracle monitoring: Session address  
4 SID ORA_SID ORA_SID DEC 22   0   Oracle monitoring: SID (Session)  
5 SERIAL ORA_SERIAL ORA_SERIAL DEC 22   0   Oracle monitoring: SERIAL#: Session serial number  
6 AUDSID ORA_AUDSID ORA_AUDSID DEC 22   0   Oracle monitoring: AUDSID: Auditing session ID  
7 PADDR ORA_PADDR ORA_PADDR RAW 8   0   Oracle monitoring: PADDR: Address of proc. owning the sess.  
8 OUSER ORA_USER ORA_USER DEC 22   0   Oracle monitoring: USER#: Oracle user identifier  
9 USERNAME ORA_USERNAME ORA_USERNAME CHAR 30   0   Oracle monitoring: USERNAME: Oracle username  
10 COMMAND ORA_COMMAND ORA_COMMAND DEC 22   0   Oracle monitoring: COMMAND: Command in progress  
11 OWNERID ORA_OWNERID ORA_OWNERID DEC 22   0   Oracle monitoring: OWNERID: session owner  
12 TADDR ORA_TADDR ORA_TADDR CHAR 16   0   Oracle monitoring: TADDR: Address of transaction state obj.  
13 LOCKWAIT ORA_LOCKWAIT ORA_LOCKWAIT CHAR 16   0   Oracle monitoring: LOCKWAIT: Address of lock waiting for  
14 STATUS ORA_SSTATUS ORA_SSTATUS CHAR 8   0   Oracle monitoring: STATUS: Status of the session  
15 SERVER ORA_SERVER ORA_SERVER CHAR 9   0   Oracle monitoring: SERVER: Server type  
16 OSCHEMA ORA_SCHEMA ORA_SCHEMA DEC 22   0   Oracle monitoring: SCHEMA#: Schema user identifier  
17 SCHEMANAME ORA_SCHEMANAME ORA_SCHEMANAME CHAR 30   0   Oracle monitoring: SCHEMANAME: Schema user name  
18 OSUSER ORA_OSUSER ORA_OSUSER CHAR 30   0   Oracle monitoring: OSUSER: Operating system client user name  
19 PROCESS ORA_PROCESS ORA_PROCESS CHAR 12   0   Oracle monitoring: OS Process Id  
20 MACHINE ORA_MACHINE ORA_MACHINE CHAR 64   0   Oracle monitoring: MACHINE: Operating system machine name  
21 TERMINAL ORA_TERMINAL ORA_TERMINAL CHAR 30   0   Oracle monitoring: MACHINE: Operating system machine name  
22 OPROGRAM ORA_PROGRAM ORA_PROGRAM CHAR 48   0   Oracle monitoring: PROGRAM: Operating system program name  
23 TYPE ORA_STYPE ORA_STYPE CHAR 10   0   Oracle monitoring: TYPE: Session type  
24 SQL_ADDRESS ORA_SQL_ADDRESS ORA_SQL_ADDRESS RAW 8   0   Oracle monitoring: SQL_ADDRESS: SQL Statement ID  
25 SQL_HASH_VALUE ORA_SQL_HASH_VALUE ORA_SQL_HASH_VALUE DEC 22   0   Oracle monitoring: SQL_HASH_VALUE: SQL statement hash  
26 PREV_SQL_ADDR ORA_PREV_SQL_ADDR ORA_PREV_SQL_ADDR RAW 8   0   Oracle monitoring: PREV_SQL_ADDR: Prev. SQL Statement ID  
27 PREV_HASH_VALUE ORA_PREV_HASH_VALUE ORA_PREV_HASH_VALUE DEC 22   0   Oracle monitoring: PREV_HASH_VALUE: Prev. SQL Statement hash  
28 OMODULE ORA_MODULE ORA_MODULE CHAR 48   0   Oracle monitoring: MODULE: currently executing module  
29 MODULE_HASH ORA_MODULE_HASH ORA_MODULE_HASH DEC 22   0   Oracle monitoring: MODULE_HASH: curr. executing module hash  
30 ACTION ORA_ACTION ORA_ACTION CHAR 32   0   Oracle monitoring: ACTION: Currently executing action  
31 ACTION_HASH ORA_ACTION_HASH ORA_ACTION_HASH DEC 22   0   Oracle monitoring: ACTION: Currently executing action hash  
32 CLIENT_INFO ORA_CLIENT_INFO ORA_CLIENT_INFO CHAR 64   0   Oracle monitoring: CLIENT_INFO  
33 FIXED_TABLE_SEQU ORA_FIXED_TABLE_SEQUENCE ORA_FIXED_TABLE_SEQUENCE DEC 22   0   Oracle monitoring: ORA_FIXED_TABLE_SEQUENCE  
34 ROW_WAIT_OBJ ORA_ROW_WAIT_OBJ ORA_ROW_WAIT_OBJ DEC 22   0   Oracle monitoring: ROW_WAIT_OBJ  
35 ROW_WAIT_FILE ORA_ROW_WAIT_FILE ORA_ROW_WAIT_FILE DEC 22   0   Oracle monitoring: ROW_WAIT_FILE  
36 ROW_WAIT_BLOCK ORA_ROW_WAIT_BLOCK ORA_ROW_WAIT_BLOCK DEC 22   0   Oracle monitoring: ROW_WAIT_BLOCK  
37 ROW_WAIT_ROW ORA_ROW_WAIT_ROW ORA_ROW_WAIT_ROW DEC 22   0   Oracle monitoring: ROW_WAIT_ROW  
38 LOGON_TIME ORA_LOGON_TIME ORA_TIME TIMS 6   0   Oracle monitoring: LOGON_TIME (Time): Time of logon  
39 LAST_CALL_ET ORA_LAST_CALL_ET ORA_LAST_CALL_ET DEC 22   0   Oracle monitoring:LAST_CALL_ET: The last call  
40 PDML_ENABLED ORA_PDML_ENABLED ORA_PDML_ENABLED CHAR 3   0   Oracle monitoring: PDML_ENABLED  
41 FAILOVER_TYPE ORA_FAILOVER_TYPE ORA_FAILOVER_TYPE CHAR 13   0   Oracle monitoring: FAILOVER_TYPE: Failover type for session  
42 FAILOVER_METHOD ORA_FAILOVER_METHOD ORA_FAILOVER_METHOD CHAR 10   0   Oracle monitoring: FAILOVER_METHO: Failover method for sess.  
43 FAILED_OVER ORA_FAILED_OVER ORA_FAILED_OVER CHAR 3   0   Oracle monitoring: FAILED_OVER: Sess. in Failover Mode  
44 RESOURCE_CONSUME ORA_RESOURCE_CONSUMER_GROUP ORA_RESOURCE_CONSUMER_GROUP CHAR 32   0   Oracle monitoring: RESOURCE_CONSUMER_GROUP  
45 PDML_STATUS ORA_PDML_STATUS ORA_PDML_STATUS CHAR 8   0   Oracle monitoring: PDML_STATUS: Parallel DML status  
46 PDDL_STATUS ORA_PDDL_STATUS ORA_PDDL_STATUS CHAR 8   0   Oracle monitoring: PDML_STATUS: Parallel DDL status  
47 PQ_STATUS ORA_PQ_STATUS ORA_PQ_STATUS CHAR 8   0   Oracle monitoring: PDML_STATUS: Parallel QUERY status  
48 CURRENT_QUEUE_DU ORA_CURRENT_QUEUE_DURATION ORA_CURRENT_QUEUE_DURATION DEC 22   0   Oracle monitoring: CURRENT_QUEUE_DURATION  
49 CLIENT_IDENTIFIE ORA_CLIENT_IDENTIFIER ORA_CLIENT_IDENTIFIER CHAR 64   0   Oracle monitoring: ORA_CLIENT_IDENTIFIER  
History
Last changed by/on SAP  20130604 
SAP Release Created in 700