SAP ABAP Table ORA_S_GV_ACTIVE_SESSION_HIS (Oracle View: gv$active_session_history)
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 ORA_S_GV_ACTIVE_SESSION_HIS   Table Relationship Diagram
Short Description Oracle View: gv$active_session_history    
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 SAMPLE_ID ORA_SAMPLE_ID ORA_DEC_22 DEC 22   0   Oracle monitoring: Sample ID (ID of sample data)  
3 SAMPLE_TIME ORA_SAMPLE_TIME   CHAR 25   0   Oracle monitoring: Sample timestamp  
4 SESSION_ID ORA_SESSION_ID ORA_DEC_22 DEC 22   0   Oracle monitoring: Session ID  
5 SESSION_SERIAL ORA_SERIAL ORA_SERIAL DEC 22   0   Oracle monitoring: SERIAL#: Session serial number  
6 USER_ID ORA_USER ORA_USER DEC 22   0   Oracle monitoring: USER#: Oracle user identifier  
7 SQL_ID ORA_SQL_ID ORA_SQLID CHAR 13   0   Oracle monitoring: SQL_ID  
8 SQL_STATEMENT ORA_SQLSTRING ORA_SQLSTRING CHAR 64   0   Oracle Monitoring: SQLSTRING  
9 SQL_CHILD_NUMBER ORA_SQLCHILDNUM   INT4 10   0   Oracle monitoring: SQL child number  
10 SQL_PLAN_HASH_VALUE ORA_SQL_HASH_VALUE ORA_SQL_HASH_VALUE DEC 22   0   Oracle monitoring: SQL_HASH_VALUE: SQL statement hash  
11 SQL_OPCODE ORA_OPCODE   INT4 10   0   Oracle Monitoring: Oracle OPCODE  
12 SQL_OPNAME ORA_OPNAME   CHAR 64   0   SQL command name  
13 SQL_PLAN_LINE_ID ORA_SQL_PLAN_LINE_ID   DEC 22   0   SQL plan line ID  
14 SQL_PLAN_OPERATION ORA_SQL_PLAN_OPERATION   CHAR 30   0   Plan operation name  
15 SQL_PLAN_OPTIONS ORA_SQL_PLAN_OPTIONS   CHAR 30   0   Plan operation options  
16 SQL_EXEC_ID ORA_SQL_EXEC_ID   DEC 22   0   SQL execution identifier  
17 SQL_EXEC_START ORA_SQL_EXEC_START   CHAR 30   0   Time when the execution of the SQL started  
18 SERVICE_HASH ORA_SERVICE_HASH ORA_DEC_22 DEC 22   0   Oracle Monitoring: Oracle Service Hash  
19 SESSION_TYPE ORA_SESSION_TYPE   CHAR 10   0   Oracle Monitoring: Oracle Session Type  
20 SESSION_STATE ORA_SESSION_STATE   CHAR 7   0   Oracle Monitoring: Oracle Session State  
21 TOP_LEVEL_SQL_ID ORA_TOP_LEVEL_SQL_ID   CHAR 13   0   SQL identifier of the top level SQL statement  
22 TOP_LEVEL_SQL_OPCODE ORA_TOP_LEVEL_SQL_OPCODE   DEC 22   0   Indicates what phase of operation the top level SQL stmt  
23 QC_SESSION_ID ORA_QC_SESSION_ID ORA_DEC_22 DEC 22   0   Oracle monitoring: Query Coordinator Session ID  
24 QC_INSTANCE_ID ORA_QC_INST_ID ORA_INST_ID DEC 22   0   Oracle monitoring: Query Coordinator Instance ID  
25 BLOCKING_INST_ID ORA_BLOCKING_INST_ID   DEC 22   0   Instance number of the blocker shown in BLOCKING_SESSION  
26 BLOCKING_SESS_ID ORA_BLOCKING_SESS_ID ORA_DEC_22 DEC 22   0   Oracle monitoring: Blocking session ID  
27 BLOCKING_SESS_STATUS ORA_BLOCKING_SESS_STATUS   CHAR 11   0   Oracle Monitoring: Blocking Session Status  
28 BLOCKING_SESS_SERIAL ORA_BLOCKING_SESS_SERIAL ORA_SERIAL DEC 22   0   Oracle monitoring: Blocking session serial number  
29 EVENT ORA_EVENT_NAME   CHAR 64   0   Oracle Monitoring: Oracle Event Name  
30 EVENT_ID ORA_EVENT_ID   CHAR 38   0   Oracle Monitoring: Oracle Event ID  
31 EVENT_NUM ORA_EVENT_NUMBER   INT4 10   0   Oracle Monitoring: Oracle Event Number  
32 SEQ_NUM ORA_SEQ ORA_SEQ DEC 22   0   Oracle monitoring: SEQ#  
33 P1 ORA_P1 ORA_P1 DEC 22   0   Oracle monitoring: ORA_P1: First additional parameter  
34 P2 ORA_P2 ORA_P2 DEC 22   0   Oracle monitoring: ORA_P2: Second additional parameter  
35 P3 ORA_P3 ORA_P3 DEC 22   0   Oracle monitoring: ORA_P3: Third additional parameter  
36 WAIT_CLASS ORA_CLASS_NAME CHAR64 CHAR 64   0   ORA: Wait Class Name  
37 WAIT_CLASS_ID ORA_CLASS ORA_NUM_22 DEC 22   0   Oracle monitor: CLASS  
38 WAIT_TIME ORA_WAIT_TIME ORA_WAIT_TIME DEC 22   0   Oracle monitoring: Latch Wait Time  
39 TIME_WAITED ORA_TIME_WAITED ORA_NUM_22 DEC 22   0   Oracle monitor: TIME_WAITED  
40 CURRENT_OBJ ORA_OBJECT_ID_2 ORA_NUM_22 DEC 22   0   Oracle monitoring: Dictionary object number of the object  
41 OBJECT_NAME ORA_OBJECT_NAME ORA_CHAR_30 CHAR 30   0   Oracle monitoring: Name of the object  
42 CURRENT_FILE ORA_FILE ORA_DEC_22 DEC 22   0   Oracle monitoring: File#  
43 CURRENT_BLOCK ORA_BLOCK_ID ORA_NUM_22 DEC 22   0   Oracle monitoring: Block number  
44 CURRENT_ROW ORA_CURRENT_ROW   DEC 22   0   Row identifier that the session is referencing  
45 IN_CONNECTION_MGMT ORA_IN_CONNECTION_MGMT   CHAR 1   0   Indicates whether the session was doing connection mngmt  
46 IN_PARSE ORA_IN_PARSE   CHAR 1   0   Indicates whether the session was parsing  
47 IN_HARD_PARSE ORA_IN_HARD_PARSE   CHAR 1   0   Indicates whether the session was hard parsing  
48 IN_SQL_EXECUTION ORA_IN_SQL_EXECUTION   CHAR 1   0   Indicates whether the session was executing SQL stmt  
49 IN_PLSQL_EXECUTION ORA_IN_PLSQL_EXECUTION   CHAR 1   0   Indicates whether the session was executing PL/SQL  
50 IN_PLSQL_RPC ORA_IN_PLSQL_RPC   CHAR 1   0   Indicates whether session was executing inbound PL/SQL RPC  
51 IN_PLSQL_COMPILATION ORA_IN_PLSQL_COMPILATION   CHAR 1   0   Indicates whether the session was compiling PL/SQL  
52 IN_JAVA_EXECUTION ORA_IN_JAVA_EXECUTION   CHAR 1   0   Indicates whether the session was executing Java  
53 IN_BIND ORA_IN_BIND   CHAR 1   0   Indicates whether the session was doing bind operations  
54 IN_CURSOR_CLOSE ORA_IN_CURSOR_CLOSE   CHAR 1   0   Indicates whether the session was closing a cursor  
55 IN_SEQUENCE_LOAD ORA_IN_SEQUENCE_LOAD   CHAR 1   0   Indicates whether the session is loading in sequence  
56 TM_DELTA_TIME ORA_TM_DELTA_TIME   DEC 22   0   Time interval (in microseconds)  
57 TM_DELTA_CPU_TIME ORA_TM_DELTA_CPU_TIME   DEC 22   0   Amount of time this session spent on CPU  
58 TM_DELTA_DB_TIME ORA_TM_DELTA_DB_TIME   DEC 22   0   Amount of time spent by this session in database calls  
59 DELTA_TIME ORA_DELTA_TIME   DEC 22   0   Time interval since session was sampled (microsec)  
60 DELTA_READ_IO_REQUESTS ORA_DELTA_READ_IO_REQUESTS   DEC 22   0   Number of read I/O requests made by this session  
61 DELTA_WRITE_IO_REQUESTS ORA_DELTA_WRITE_IO_REQUESTS   DEC 22   0   Number of write I/O requests made by this session  
62 DELTA_READ_IO_BYTES ORA_DELTA_READ_IO_BYTES   DEC 22   0   Number of I/O bytes read by this session  
63 DELTA_WRITE_IO_BYTES ORA_DELTA_WRITE_IO_BYTES   DEC 22   0   Number of I/O bytes written by this session  
64 DELTA_INTERCONNECT_IO_BYTES ORA_DELTA_INTERCONNECT_IO_BYTE   DEC 22   0   Number of I/O bytes sent over the I/O interconnect  
65 PGA_ALLOCATED ORA_PGA_ALLOCATED   DEC 22   0   Amount of PGA memory (in bytes) consumed by this session  
66 TEMP_SPACE_ALLOCATED ORA_TEMP_SPACE_ALLOCATED   DEC 22   0   Amount of TEMP memory (in bytes) consumed by this session  
67 MACHINE ORA_MACHINE ORA_MACHINE CHAR 64   0   Oracle monitoring: MACHINE: Operating system machine name  
68 PORT ORA_PORT   DEC 22   0   Client port number  
69 PROGRAMX ORA_PROGRAM ORA_PROGRAM CHAR 48   0   Oracle monitoring: PROGRAM: Operating system program name  
70 MODULEX ORA_MODULE ORA_MODULE CHAR 48   0   Oracle monitoring: MODULE: currently executing module  
71 ACTION ORA_ACTION ORA_ACTION CHAR 32   0   Oracle monitoring: ACTION: Currently executing action  
72 CLIENT_ID ORA_CLIENT_IDENTIFIER ORA_CLIENT_IDENTIFIER CHAR 64   0   Oracle monitoring: ORA_CLIENT_IDENTIFIER  
73 SAMPLE_TIME_EXT ORA_SAMPLE_TIME   CHAR 25   0   Oracle monitoring: Sample timestamp  
History
Last changed by/on SAP  20130604 
SAP Release Created in 710