STR_SESSION SAP (Oracle monitoring: structure for V$SESSION.) Structure details

Dictionary Type: Structure
Description: Oracle monitoring: structure for V$SESSION.




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




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

STR_SESSION 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 monitoring: structure for V$SESSION." 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_STR_SESSION TYPE STR_SESSION.

The STR_SESSION table consists of various fields, each holding specific information or linking keys about Oracle monitoring: structure for V$SESSION. data available in SAP. These include SID (Oracle monitoring: SID (Session)), SERIAL (Oracle monitoring: SERIAL#: Session serial number), AUDSID (Oracle monitoring: AUDSID: Auditing session ID), PADDR (Oracle monitoring: PADDR: Address of proc. owning the sess.).. 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 STR_SESSION 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
SADDROracle monitoring: Session address ORA_SADDRRAW8ORA_SADDR
SIDOracle monitoring: SID (Session) ORA_SIDDEC22ORA_SID
SERIALOracle monitoring: SERIAL#: Session serial number ORA_SERIALDEC22ORA_SERIAL
AUDSIDOracle monitoring: AUDSID: Auditing session ID ORA_AUDSIDDEC22ORA_AUDSID
PADDROracle monitoring: PADDR: Address of proc. owning the sess. ORA_PADDRRAW8ORA_PADDR
OUSEROracle monitoring: USER#: Oracle user identifier ORA_USERDEC22ORA_USER
USERNAMEOracle monitoring: USERNAME: Oracle username ORA_USERNAMECHAR30ORA_USERNAME
COMMANDOracle monitoring: COMMAND: Command in progress ORA_COMMANDDEC22ORA_COMMAND
OWNERIDOracle monitoring: OWNERID: session owner ORA_OWNERIDDEC22ORA_OWNERID
TADDROracle monitoring: TADDR: Address of transaction state obj. ORA_TADDRCHAR16ORA_TADDR
LOCKWAITOracle monitoring: LOCKWAIT: Address of lock waiting for ORA_LOCKWAITCHAR16ORA_LOCKWAIT
STATUSOracle monitoring: STATUS: Status of the session ORA_SSTATUSCHAR8ORA_SSTATUS
SERVEROracle monitoring: SERVER: Server type ORA_SERVERCHAR9ORA_SERVER
OSCHEMAOracle monitoring: SCHEMA#: Schema user identifier ORA_SCHEMADEC22ORA_SCHEMA
SCHEMANAMEOracle monitoring: SCHEMANAME: Schema user name ORA_SCHEMANAMECHAR30ORA_SCHEMANAME
OSUSEROracle monitoring: OSUSER: Operating system client user name ORA_OSUSERCHAR30ORA_OSUSER
PROCESSOracle monitoring: OS Process Id ORA_PROCESSCHAR12ORA_PROCESS
MACHINEOracle monitoring: MACHINE: Operating system machine name ORA_MACHINECHAR64ORA_MACHINE
TERMINALOracle monitoring: MACHINE: Operating system machine name ORA_TERMINALCHAR30ORA_TERMINAL
OPROGRAMOracle monitoring: PROGRAM: Operating system program name ORA_PROGRAMCHAR48ORA_PROGRAM
TYPEOracle monitoring: TYPE: Session type ORA_STYPECHAR10ORA_STYPE
SQL_ADDRESSOracle monitoring: SQL_ADDRESS: SQL Statement ID ORA_SQL_ADDRESSRAW8ORA_SQL_ADDRESS
SQL_HASH_VALUEOracle monitoring: SQL_HASH_VALUE: SQL statement hash ORA_SQL_HASH_VALUEDEC22ORA_SQL_HASH_VALUE
PREV_SQL_ADDROracle monitoring: PREV_SQL_ADDR: Prev. SQL Statement ID ORA_PREV_SQL_ADDRRAW8ORA_PREV_SQL_ADDR
PREV_HASH_VALUEOracle monitoring: PREV_HASH_VALUE: Prev. SQL Statement hash ORA_PREV_HASH_VALUEDEC22ORA_PREV_HASH_VALUE
OMODULEOracle monitoring: MODULE: currently executing module ORA_MODULECHAR48ORA_MODULE
MODULE_HASHOracle monitoring: MODULE_HASH: curr. executing module hash ORA_MODULE_HASHDEC22ORA_MODULE_HASH
ACTIONOracle monitoring: ACTION: Currently executing action ORA_ACTIONCHAR32ORA_ACTION
ACTION_HASHOracle monitoring: ACTION: Currently executing action hash ORA_ACTION_HASHDEC22ORA_ACTION_HASH
CLIENT_INFOOracle monitoring: CLIENT_INFO ORA_CLIENT_INFOCHAR64ORA_CLIENT_INFO
FIXED_TABLE_SEQUOracle monitoring: ORA_FIXED_TABLE_SEQUENCE ORA_FIXED_TABLE_SEQUENCEDEC22ORA_FIXED_TABLE_SEQUENCE
ROW_WAIT_OBJOracle monitoring: ROW_WAIT_OBJ ORA_ROW_WAIT_OBJDEC22ORA_ROW_WAIT_OBJ
ROW_WAIT_FILEOracle monitoring: ROW_WAIT_FILE ORA_ROW_WAIT_FILEDEC22ORA_ROW_WAIT_FILE
ROW_WAIT_BLOCKOracle monitoring: ROW_WAIT_BLOCK ORA_ROW_WAIT_BLOCKDEC22ORA_ROW_WAIT_BLOCK
ROW_WAIT_ROWOracle monitoring: ROW_WAIT_ROW ORA_ROW_WAIT_ROWDEC22ORA_ROW_WAIT_ROW
LOGON_TIMEOracle monitoring: LOGON_TIME (Time): Time of logon ORA_LOGON_TIMETIMS6ORA_TIME
LAST_CALL_ETOracle monitoring:LAST_CALL_ET: The last call ORA_LAST_CALL_ETDEC22ORA_LAST_CALL_ET
PDML_ENABLEDOracle monitoring: PDML_ENABLED ORA_PDML_ENABLEDCHAR3ORA_PDML_ENABLED
FAILOVER_TYPEOracle monitoring: FAILOVER_TYPE: Failover type for session ORA_FAILOVER_TYPECHAR13ORA_FAILOVER_TYPE
FAILOVER_METHODOracle monitoring: FAILOVER_METHO: Failover method for sess. ORA_FAILOVER_METHODCHAR10ORA_FAILOVER_METHOD
FAILED_OVEROracle monitoring: FAILED_OVER: Sess. in Failover Mode ORA_FAILED_OVERCHAR3ORA_FAILED_OVER
RESOURCE_CONSUMEOracle monitoring: RESOURCE_CONSUMER_GROUP ORA_RESOURCE_CONSUMER_GROUPCHAR32ORA_RESOURCE_CONSUMER_GROUP
PDML_STATUSOracle monitoring: PDML_STATUS: Parallel DML status ORA_PDML_STATUSCHAR8ORA_PDML_STATUS
PDDL_STATUSOracle monitoring: PDML_STATUS: Parallel DDL status ORA_PDDL_STATUSCHAR8ORA_PDDL_STATUS
PQ_STATUSOracle monitoring: PDML_STATUS: Parallel QUERY status ORA_PQ_STATUSCHAR8ORA_PQ_STATUS
CURRENT_QUEUE_DUOracle monitoring: CURRENT_QUEUE_DURATION ORA_CURRENT_QUEUE_DURATIONDEC22ORA_CURRENT_QUEUE_DURATION
CLIENT_IDENTIFIEOracle monitoring: ORA_CLIENT_IDENTIFIER ORA_CLIENT_IDENTIFIERCHAR64ORA_CLIENT_IDENTIFIER

Key field Non-key field



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

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

How to access SAP table STR_SESSION

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