ORASESSION SAP (Basis List 'Oracle Session' Structure for the ALV) Structure details

Dictionary Type: Structure
Description: Basis List 'Oracle Session' Structure for the ALV




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




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

ORASESSION 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 "Basis List 'Oracle Session' Structure for the ALV" 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_ORASESSION TYPE ORASESSION.

The ORASESSION table consists of various fields, each holding specific information or linking keys about Basis List 'Oracle Session' Structure for the ALV data available in SAP. These include SPID (Operating System Process ID), MACHINE (Operating System Machine Name), PROCESS (Operating System Client Process ID), STATUS (Status of Session (Active, Inactive, Killed)).. 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: Not classified


SAP ORASESSION 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
SIDSession ID ORASIDINT410ORANUMBER4
SPIDOperating System Process ID ORASPIDCHAR9CHAR9
MACHINEOperating System Machine Name ORAMACHINECHAR30CHAR30
PROCESSOperating System Client Process ID ORAPROCESSCHAR9CHAR9
STATUSStatus of Session (Active, Inactive, Killed) ORASTATUSCHAR8CHAR8
EVENTResource or Event That the Session is Waiting For ORAEVENT4CHAR30CHAR30
USERNAMEColumn USERNAME in V$SESSION ORAUSERCHAR10CHAR10
SQL_TEXTStart of SQL statement ORASQLTEXTCHAR60CHAR60
L_READSTotal Block and Consistent Gets for the Session ORAL_READSCHAR14CHAR14
P_READSPhysical Read Operations for this Session ORAR_READSCHAR12CHAR12
B_CHANGESBlock Changes for this Sesssion ORAB_CHANGCHAR12CHAR12
C_CHANGESConsistent Changes for this Session ORAC_CHANGCHAR12CHAR12
SEC_WAITWait Time in Seconds ORAS_WAITINT410INT4
WAIT_TIMEWAIT_TIME Column of v$session_wait ORAW_TIMEINT410INT4
P1TEXTDescription of First Additional Parameter ORAP1TEXTCHAR20CHAR20
P1Parameter value 1 ORAP1CHAR11CHAR11
P2TEXTDescription of Second Additional Parameter ORAP2TEXTCHAR20CHAR20
P2Parameter value 2 ORAP2CHAR11CHAR11
P3TEXTDescription of Third Additional Parameter ORAP3TEXTCHAR20CHAR20
P3Parameter value 3 ORAP3CHAR11CHAR11
TRANS_STATUS Status0
START_TIME Start time0
START_SCNB Start System Change Number (SCN) Base0
START_UEXT Start Extent Number0
START_UBAFIL Start UBA File Number0
START_UBABLK Start UBA Block Number0
START_UBASQN Start UBA Sequence Number0
START_UBAREC Start UBA Record Number0
UBAFIL Undo Block Address (UBA) File Number0
UBABLK UBA Block Number0
UBASQN UBA Sequence Number0
UBAREC UBA Record Number0
XIDUSN Undo Segment Number0
XIDSLOT Slot Number0
XIDSQN Sequence number0

Key field Non-key field



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

As ORASESSION 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 ORASESSION as there is no data to select.

How to access SAP table ORASESSION

Within an ECC or HANA version of SAP you can also view further information about ORASESSION 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!