ORA_S_GV_ACTIVE_SESSION_HIS SAP (Oracle View: gv$active_session_history) Structure details

Dictionary Type: Structure
Description: Oracle View: gv$active_session_history




ABAP Code to SELECT data from ORA_S_GV_ACTIVE_SESSION_HIS
Related tables to ORA_S_GV_ACTIVE_SESSION_HIS
Access table ORA_S_GV_ACTIVE_SESSION_HIS




Structure field list including key, data, relationships and ABAP select examples

ORA_S_GV_ACTIVE_SESSION_HIS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Oracle View: gv$active_session_history" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ORA_S_GV_ACTIVE_SESSION_HIS TYPE ORA_S_GV_ACTIVE_SESSION_HIS.

The ORA_S_GV_ACTIVE_SESSION_HIS table consists of various fields, each holding specific information or linking keys about Oracle View: gv$active_session_history data available in SAP. These include SAMPLE_ID (Oracle monitoring: Sample ID (ID of sample data)), SAMPLE_TIME (Oracle monitoring: Sample timestamp), SESSION_ID (Oracle monitoring: Session ID), SESSION_SERIAL (Oracle monitoring: SERIAL#: Session serial number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ORA_S_GV_ACTIVE_SESSION_HIS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
INST_IDOracle monitor: Instance ID ORA_INST_IDDEC22ORA_INST_ID
SAMPLE_IDOracle monitoring: Sample ID (ID of sample data) ORA_SAMPLE_IDDEC22ORA_DEC_22
SAMPLE_TIMEOracle monitoring: Sample timestamp ORA_SAMPLE_TIMECHAR25
SESSION_IDOracle monitoring: Session ID ORA_SESSION_IDDEC22ORA_DEC_22
SESSION_SERIALOracle monitoring: SERIAL#: Session serial number ORA_SERIALDEC22ORA_SERIAL
USER_IDOracle monitoring: USER#: Oracle user identifier ORA_USERDEC22ORA_USER
SQL_IDOracle monitoring: SQL_ID ORA_SQL_IDCHAR13ORA_SQLID
SQL_STATEMENTOracle Monitoring: SQLSTRING ORA_SQLSTRINGCHAR64ORA_SQLSTRING
SQL_CHILD_NUMBEROracle monitoring: SQL child number ORA_SQLCHILDNUMINT410
SQL_PLAN_HASH_VALUEOracle monitoring: SQL_HASH_VALUE: SQL statement hash ORA_SQL_HASH_VALUEDEC22ORA_SQL_HASH_VALUE
SQL_OPCODEOracle Monitoring: Oracle OPCODE ORA_OPCODEINT410
SQL_OPNAMESQL command name ORA_OPNAMECHAR64
SQL_PLAN_LINE_IDSQL plan line ID ORA_SQL_PLAN_LINE_IDDEC22
SESSION_STATEOracle Monitoring: Oracle Session State ORA_SESSION_STATECHAR7
SQL_PLAN_OPERATIONPlan operation name ORA_SQL_PLAN_OPERATIONCHAR30
QC_SESSION_IDOracle monitoring: Query Coordinator Session ID ORA_QC_SESSION_IDDEC22ORA_DEC_22
SQL_PLAN_OPTIONSPlan operation options ORA_SQL_PLAN_OPTIONSCHAR30
SQL_EXEC_IDSQL execution identifier ORA_SQL_EXEC_IDDEC22
QC_INSTANCE_IDOracle monitoring: Query Coordinator Instance ID ORA_QC_INST_IDDEC22ORA_INST_ID
SQL_EXEC_STARTTime when the execution of the SQL started ORA_SQL_EXEC_STARTCHAR30
BLOCKING_SESS_IDOracle monitoring: Blocking session ID ORA_BLOCKING_SESS_IDDEC22ORA_DEC_22
SERVICE_HASHOracle Monitoring: Oracle Service Hash ORA_SERVICE_HASHDEC22ORA_DEC_22
BLOCKING_SESS_STATUSOracle Monitoring: Blocking Session Status ORA_BLOCKING_SESS_STATUSCHAR11
SESSION_TYPEOracle Monitoring: Oracle Session Type ORA_SESSION_TYPECHAR10
BLOCKING_SESS_SERIALOracle monitoring: Blocking session serial number ORA_BLOCKING_SESS_SERIALDEC22ORA_SERIAL
EVENTOracle Monitoring: Oracle Event Name ORA_EVENT_NAMECHAR64
SESSION_STATEOracle Monitoring: Oracle Session State ORA_SESSION_STATECHAR7
EVENT_IDOracle Monitoring: Oracle Event ID ORA_EVENT_IDCHAR38
TOP_LEVEL_SQL_IDSQL identifier of the top level SQL statement ORA_TOP_LEVEL_SQL_IDCHAR13
EVENT_NUMOracle Monitoring: Oracle Event Number ORA_EVENT_NUMBERINT410
TOP_LEVEL_SQL_OPCODEIndicates what phase of operation the top level SQL stmt ORA_TOP_LEVEL_SQL_OPCODEDEC22
SEQ_NUMOracle monitoring: SEQ# ORA_SEQDEC22ORA_SEQ
QC_SESSION_IDOracle monitoring: Query Coordinator Session ID ORA_QC_SESSION_IDDEC22ORA_DEC_22
P1Oracle monitoring: ORA_P1: First additional parameter ORA_P1DEC22ORA_P1
QC_INSTANCE_IDOracle monitoring: Query Coordinator Instance ID ORA_QC_INST_IDDEC22ORA_INST_ID
P2Oracle monitoring: ORA_P2: Second additional parameter ORA_P2DEC22ORA_P2
BLOCKING_INST_IDInstance number of the blocker shown in BLOCKING_SESSION ORA_BLOCKING_INST_IDDEC22
P3Oracle monitoring: ORA_P3: Third additional parameter ORA_P3DEC22ORA_P3
BLOCKING_SESS_IDOracle monitoring: Blocking session ID ORA_BLOCKING_SESS_IDDEC22ORA_DEC_22
WAIT_TIMEOracle monitoring: Latch Wait Time ORA_WAIT_TIMEDEC22ORA_WAIT_TIME
BLOCKING_SESS_STATUSOracle Monitoring: Blocking Session Status ORA_BLOCKING_SESS_STATUSCHAR11
TIME_WAITEDOracle monitor: TIME_WAITED ORA_TIME_WAITEDDEC22ORA_NUM_22
BLOCKING_SESS_SERIALOracle monitoring: Blocking session serial number ORA_BLOCKING_SESS_SERIALDEC22ORA_SERIAL
EVENTOracle Monitoring: Oracle Event Name ORA_EVENT_NAMECHAR64
CURRENT_OBJOracle monitoring: Dictionary object number of the object ORA_OBJECT_ID_2DEC22ORA_NUM_22
EVENT_IDOracle Monitoring: Oracle Event ID ORA_EVENT_IDCHAR38
OBJECT_NAMEOracle monitoring: Name of the object ORA_OBJECT_NAMECHAR30ORA_CHAR_30
EVENT_NUMOracle Monitoring: Oracle Event Number ORA_EVENT_NUMBERINT410
CURRENT_FILEOracle monitoring: File# ORA_FILEDEC22ORA_DEC_22
SEQ_NUMOracle monitoring: SEQ# ORA_SEQDEC22ORA_SEQ
CURRENT_BLOCKOracle monitoring: Block number ORA_BLOCK_IDDEC22ORA_NUM_22
P1Oracle monitoring: ORA_P1: First additional parameter ORA_P1DEC22ORA_P1
PROGRAMXOracle monitoring: PROGRAM: Operating system program name ORA_PROGRAMCHAR48ORA_PROGRAM
P2Oracle monitoring: ORA_P2: Second additional parameter ORA_P2DEC22ORA_P2
MODULEXOracle monitoring: MODULE: currently executing module ORA_MODULECHAR48ORA_MODULE
P3Oracle monitoring: ORA_P3: Third additional parameter ORA_P3DEC22ORA_P3
ACTIONOracle monitoring: ACTION: Currently executing action ORA_ACTIONCHAR32ORA_ACTION
CLIENT_IDOracle monitoring: ORA_CLIENT_IDENTIFIER ORA_CLIENT_IDENTIFIERCHAR64ORA_CLIENT_IDENTIFIER
WAIT_CLASSORA: Wait Class Name ORA_CLASS_NAMECHAR64CHAR64
WAIT_CLASS_IDOracle monitor: CLASS ORA_CLASSDEC22ORA_NUM_22
SAMPLE_TIME_EXTOracle monitoring: Sample timestamp ORA_SAMPLE_TIMECHAR25
WAIT_TIMEOracle monitoring: Latch Wait Time ORA_WAIT_TIMEDEC22ORA_WAIT_TIME
TIME_WAITEDOracle monitor: TIME_WAITED ORA_TIME_WAITEDDEC22ORA_NUM_22
CURRENT_OBJOracle monitoring: Dictionary object number of the object ORA_OBJECT_ID_2DEC22ORA_NUM_22
OBJECT_NAMEOracle monitoring: Name of the object ORA_OBJECT_NAMECHAR30ORA_CHAR_30
CURRENT_FILEOracle monitoring: File# ORA_FILEDEC22ORA_DEC_22
CURRENT_BLOCKOracle monitoring: Block number ORA_BLOCK_IDDEC22ORA_NUM_22
CURRENT_ROWRow identifier that the session is referencing ORA_CURRENT_ROWDEC22
IN_CONNECTION_MGMTIndicates whether the session was doing connection mngmt ORA_IN_CONNECTION_MGMTCHAR1
IN_PARSEIndicates whether the session was parsing ORA_IN_PARSECHAR1
IN_HARD_PARSEIndicates whether the session was hard parsing ORA_IN_HARD_PARSECHAR1
IN_SQL_EXECUTIONIndicates whether the session was executing SQL stmt ORA_IN_SQL_EXECUTIONCHAR1
IN_PLSQL_EXECUTIONIndicates whether the session was executing PL/SQL ORA_IN_PLSQL_EXECUTIONCHAR1
IN_PLSQL_RPCIndicates whether session was executing inbound PL/SQL RPC ORA_IN_PLSQL_RPCCHAR1
IN_PLSQL_COMPILATIONIndicates whether the session was compiling PL/SQL ORA_IN_PLSQL_COMPILATIONCHAR1
IN_JAVA_EXECUTIONIndicates whether the session was executing Java ORA_IN_JAVA_EXECUTIONCHAR1
IN_BINDIndicates whether the session was doing bind operations ORA_IN_BINDCHAR1
IN_CURSOR_CLOSEIndicates whether the session was closing a cursor ORA_IN_CURSOR_CLOSECHAR1
IN_SEQUENCE_LOADIndicates whether the session is loading in sequence ORA_IN_SEQUENCE_LOADCHAR1
TM_DELTA_TIMETime interval (in microseconds) ORA_TM_DELTA_TIMEDEC22
TM_DELTA_CPU_TIMEAmount of time this session spent on CPU ORA_TM_DELTA_CPU_TIMEDEC22
TM_DELTA_DB_TIMEAmount of time spent by this session in database calls ORA_TM_DELTA_DB_TIMEDEC22
DELTA_TIMETime interval since session was sampled (microsec) ORA_DELTA_TIMEDEC22
DELTA_READ_IO_REQUESTSNumber of read I/O requests made by this session ORA_DELTA_READ_IO_REQUESTSDEC22
DELTA_WRITE_IO_REQUESTSNumber of write I/O requests made by this session ORA_DELTA_WRITE_IO_REQUESTSDEC22
DELTA_READ_IO_BYTESNumber of I/O bytes read by this session ORA_DELTA_READ_IO_BYTESDEC22
DELTA_WRITE_IO_BYTESNumber of I/O bytes written by this session ORA_DELTA_WRITE_IO_BYTESDEC22
DELTA_INTERCONNECT_IO_BYTESNumber of I/O bytes sent over the I/O interconnect ORA_DELTA_INTERCONNECT_IO_BYTEDEC22
PGA_ALLOCATEDAmount of PGA memory (in bytes) consumed by this session ORA_PGA_ALLOCATEDDEC22
TEMP_SPACE_ALLOCATEDAmount of TEMP memory (in bytes) consumed by this session ORA_TEMP_SPACE_ALLOCATEDDEC22
MACHINEOracle monitoring: MACHINE: Operating system machine name ORA_MACHINECHAR64ORA_MACHINE
PORTClient port number ORA_PORTDEC22
PROGRAMXOracle monitoring: PROGRAM: Operating system program name ORA_PROGRAMCHAR48ORA_PROGRAM
MODULEXOracle monitoring: MODULE: currently executing module ORA_MODULECHAR48ORA_MODULE
ACTIONOracle monitoring: ACTION: Currently executing action ORA_ACTIONCHAR32ORA_ACTION
CLIENT_IDOracle monitoring: ORA_CLIENT_IDENTIFIER ORA_CLIENT_IDENTIFIERCHAR64ORA_CLIENT_IDENTIFIER
SAMPLE_TIME_EXTOracle monitoring: Sample timestamp ORA_SAMPLE_TIMECHAR25

Key field Non-key field



How do I retrieve data from SAP structure ORA_S_GV_ACTIVE_SESSION_HIS using ABAP code?

As ORA_S_GV_ACTIVE_SESSION_HIS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ORA_S_GV_ACTIVE_SESSION_HIS as there is no data to select.

How to access SAP table ORA_S_GV_ACTIVE_SESSION_HIS

Within an ECC or HANA version of SAP you can also view further information about ORA_S_GV_ACTIVE_SESSION_HIS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!