Data Element list used by SAP ABAP Table ORA_S_GV_ACTIVE_SESSION_HIS (Oracle View: gv$active_session_history)
SAP ABAP Table 
ORA_S_GV_ACTIVE_SESSION_HIS (Oracle View: gv$active_session_history) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
ORA_ACTION | Oracle monitoring: ACTION: Currently executing action | |
| 2 | Data Element |
ORA_BLOCKING_INST_ID | Instance number of the blocker shown in BLOCKING_SESSION | |
| 3 | Data Element |
ORA_BLOCKING_SESS_ID | Oracle monitoring: Blocking session ID | |
| 4 | Data Element |
ORA_BLOCKING_SESS_SERIAL | Oracle monitoring: Blocking session serial number | |
| 5 | Data Element |
ORA_BLOCKING_SESS_STATUS | Oracle Monitoring: Blocking Session Status | |
| 6 | Data Element |
ORA_BLOCK_ID | Oracle monitoring: Block number | |
| 7 | Data Element |
ORA_CLASS | Oracle monitor: CLASS | |
| 8 | Data Element |
ORA_CLASS_NAME | ORA: Wait Class Name | |
| 9 | Data Element |
ORA_CLIENT_IDENTIFIER | Oracle monitoring: ORA_CLIENT_IDENTIFIER | |
| 10 | Data Element |
ORA_CURRENT_ROW | Row identifier that the session is referencing | |
| 11 | Data Element |
ORA_DELTA_INTERCONNECT_IO_BYTE | Number of I/O bytes sent over the I/O interconnect | |
| 12 | Data Element |
ORA_DELTA_READ_IO_BYTES | Number of I/O bytes read by this session | |
| 13 | Data Element |
ORA_DELTA_READ_IO_REQUESTS | Number of read I/O requests made by this session | |
| 14 | Data Element |
ORA_DELTA_TIME | Time interval since session was sampled (microsec) | |
| 15 | Data Element |
ORA_DELTA_WRITE_IO_BYTES | Number of I/O bytes written by this session | |
| 16 | Data Element |
ORA_DELTA_WRITE_IO_REQUESTS | Number of write I/O requests made by this session | |
| 17 | Data Element |
ORA_EVENT_ID | Oracle Monitoring: Oracle Event ID | |
| 18 | Data Element |
ORA_EVENT_NAME | Oracle Monitoring: Oracle Event Name | |
| 19 | Data Element |
ORA_EVENT_NUMBER | Oracle Monitoring: Oracle Event Number | |
| 20 | Data Element |
ORA_FILE | Oracle monitoring: File# | |
| 21 | Data Element |
ORA_INST_ID | Oracle monitor: Instance ID | |
| 22 | Data Element |
ORA_IN_BIND | Indicates whether the session was doing bind operations | |
| 23 | Data Element |
ORA_IN_CONNECTION_MGMT | Indicates whether the session was doing connection mngmt | |
| 24 | Data Element |
ORA_IN_CURSOR_CLOSE | Indicates whether the session was closing a cursor | |
| 25 | Data Element |
ORA_IN_HARD_PARSE | Indicates whether the session was hard parsing | |
| 26 | Data Element |
ORA_IN_JAVA_EXECUTION | Indicates whether the session was executing Java | |
| 27 | Data Element |
ORA_IN_PARSE | Indicates whether the session was parsing | |
| 28 | Data Element |
ORA_IN_PLSQL_COMPILATION | Indicates whether the session was compiling PL/SQL | |
| 29 | Data Element |
ORA_IN_PLSQL_EXECUTION | Indicates whether the session was executing PL/SQL | |
| 30 | Data Element |
ORA_IN_PLSQL_RPC | Indicates whether session was executing inbound PL/SQL RPC | |
| 31 | Data Element |
ORA_IN_SEQUENCE_LOAD | Indicates whether the session is loading in sequence | |
| 32 | Data Element |
ORA_IN_SQL_EXECUTION | Indicates whether the session was executing SQL stmt | |
| 33 | Data Element |
ORA_MACHINE | Oracle monitoring: MACHINE: Operating system machine name | |
| 34 | Data Element |
ORA_MODULE | Oracle monitoring: MODULE: currently executing module | |
| 35 | Data Element |
ORA_OBJECT_ID_2 | Oracle monitoring: Dictionary object number of the object | |
| 36 | Data Element |
ORA_OBJECT_NAME | Oracle monitoring: Name of the object | |
| 37 | Data Element |
ORA_OPCODE | Oracle Monitoring: Oracle OPCODE | |
| 38 | Data Element |
ORA_OPNAME | SQL command name | |
| 39 | Data Element |
ORA_P1 | Oracle monitoring: ORA_P1: First additional parameter | |
| 40 | Data Element |
ORA_P2 | Oracle monitoring: ORA_P2: Second additional parameter | |
| 41 | Data Element |
ORA_P3 | Oracle monitoring: ORA_P3: Third additional parameter | |
| 42 | Data Element |
ORA_PGA_ALLOCATED | Amount of PGA memory (in bytes) consumed by this session | |
| 43 | Data Element |
ORA_PORT | Client port number | |
| 44 | Data Element |
ORA_PROGRAM | Oracle monitoring: PROGRAM: Operating system program name | |
| 45 | Data Element |
ORA_QC_INST_ID | Oracle monitoring: Query Coordinator Instance ID | |
| 46 | Data Element |
ORA_QC_SESSION_ID | Oracle monitoring: Query Coordinator Session ID | |
| 47 | Data Element |
ORA_SAMPLE_ID | Oracle monitoring: Sample ID (ID of sample data) | |
| 48 | Data Element |
ORA_SAMPLE_TIME | Oracle monitoring: Sample timestamp | |
| 49 | Data Element |
ORA_SAMPLE_TIME | Oracle monitoring: Sample timestamp | |
| 50 | Data Element |
ORA_SEQ | Oracle monitoring: SEQ# | |
| 51 | Data Element |
ORA_SERIAL | Oracle monitoring: SERIAL#: Session serial number | |
| 52 | Data Element |
ORA_SERVICE_HASH | Oracle Monitoring: Oracle Service Hash | |
| 53 | Data Element |
ORA_SESSION_ID | Oracle monitoring: Session ID | |
| 54 | Data Element |
ORA_SESSION_STATE | Oracle Monitoring: Oracle Session State | |
| 55 | Data Element |
ORA_SESSION_TYPE | Oracle Monitoring: Oracle Session Type | |
| 56 | Data Element |
ORA_SQLCHILDNUM | Oracle monitoring: SQL child number | |
| 57 | Data Element |
ORA_SQLSTRING | Oracle Monitoring: SQLSTRING | |
| 58 | Data Element |
ORA_SQL_EXEC_ID | SQL execution identifier | |
| 59 | Data Element |
ORA_SQL_EXEC_START | Time when the execution of the SQL started | |
| 60 | Data Element |
ORA_SQL_HASH_VALUE | Oracle monitoring: SQL_HASH_VALUE: SQL statement hash | |
| 61 | Data Element |
ORA_SQL_ID | Oracle monitoring: SQL_ID | |
| 62 | Data Element |
ORA_SQL_PLAN_LINE_ID | SQL plan line ID | |
| 63 | Data Element |
ORA_SQL_PLAN_OPERATION | Plan operation name | |
| 64 | Data Element |
ORA_SQL_PLAN_OPTIONS | Plan operation options | |
| 65 | Data Element |
ORA_TEMP_SPACE_ALLOCATED | Amount of TEMP memory (in bytes) consumed by this session | |
| 66 | Data Element |
ORA_TIME_WAITED | Oracle monitor: TIME_WAITED | |
| 67 | Data Element |
ORA_TM_DELTA_CPU_TIME | Amount of time this session spent on CPU | |
| 68 | Data Element |
ORA_TM_DELTA_DB_TIME | Amount of time spent by this session in database calls | |
| 69 | Data Element |
ORA_TM_DELTA_TIME | Time interval (in microseconds) | |
| 70 | Data Element |
ORA_TOP_LEVEL_SQL_ID | SQL identifier of the top level SQL statement | |
| 71 | Data Element |
ORA_TOP_LEVEL_SQL_OPCODE | Indicates what phase of operation the top level SQL stmt | |
| 72 | Data Element |
ORA_USER | Oracle monitoring: USER#: Oracle user identifier | |
| 73 | Data Element |
ORA_WAIT_TIME | Oracle monitoring: Latch Wait Time |
