STR_SESSION SAP (Oracle monitoring: structure for V$SESSION.) Structure details
Description: Oracle monitoring: structure for V$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 |
SADDR | Oracle monitoring: Session address | ORA_SADDR | RAW | 8 | ORA_SADDR | ||||
SID | Oracle monitoring: SID (Session) | ORA_SID | DEC | 22 | ORA_SID | ||||
SERIAL | Oracle monitoring: SERIAL#: Session serial number | ORA_SERIAL | DEC | 22 | ORA_SERIAL | ||||
AUDSID | Oracle monitoring: AUDSID: Auditing session ID | ORA_AUDSID | DEC | 22 | ORA_AUDSID | ||||
PADDR | Oracle monitoring: PADDR: Address of proc. owning the sess. | ORA_PADDR | RAW | 8 | ORA_PADDR | ||||
OUSER | Oracle monitoring: USER#: Oracle user identifier | ORA_USER | DEC | 22 | ORA_USER | ||||
USERNAME | Oracle monitoring: USERNAME: Oracle username | ORA_USERNAME | CHAR | 30 | ORA_USERNAME | ||||
COMMAND | Oracle monitoring: COMMAND: Command in progress | ORA_COMMAND | DEC | 22 | ORA_COMMAND | ||||
OWNERID | Oracle monitoring: OWNERID: session owner | ORA_OWNERID | DEC | 22 | ORA_OWNERID | ||||
TADDR | Oracle monitoring: TADDR: Address of transaction state obj. | ORA_TADDR | CHAR | 16 | ORA_TADDR | ||||
LOCKWAIT | Oracle monitoring: LOCKWAIT: Address of lock waiting for | ORA_LOCKWAIT | CHAR | 16 | ORA_LOCKWAIT | ||||
STATUS | Oracle monitoring: STATUS: Status of the session | ORA_SSTATUS | CHAR | 8 | ORA_SSTATUS | ||||
SERVER | Oracle monitoring: SERVER: Server type | ORA_SERVER | CHAR | 9 | ORA_SERVER | ||||
OSCHEMA | Oracle monitoring: SCHEMA#: Schema user identifier | ORA_SCHEMA | DEC | 22 | ORA_SCHEMA | ||||
SCHEMANAME | Oracle monitoring: SCHEMANAME: Schema user name | ORA_SCHEMANAME | CHAR | 30 | ORA_SCHEMANAME | ||||
OSUSER | Oracle monitoring: OSUSER: Operating system client user name | ORA_OSUSER | CHAR | 30 | ORA_OSUSER | ||||
PROCESS | Oracle monitoring: OS Process Id | ORA_PROCESS | CHAR | 12 | ORA_PROCESS | ||||
MACHINE | Oracle monitoring: MACHINE: Operating system machine name | ORA_MACHINE | CHAR | 64 | ORA_MACHINE | ||||
TERMINAL | Oracle monitoring: MACHINE: Operating system machine name | ORA_TERMINAL | CHAR | 30 | ORA_TERMINAL | ||||
OPROGRAM | Oracle monitoring: PROGRAM: Operating system program name | ORA_PROGRAM | CHAR | 48 | ORA_PROGRAM | ||||
TYPE | Oracle monitoring: TYPE: Session type | ORA_STYPE | CHAR | 10 | ORA_STYPE | ||||
SQL_ADDRESS | Oracle monitoring: SQL_ADDRESS: SQL Statement ID | ORA_SQL_ADDRESS | RAW | 8 | ORA_SQL_ADDRESS | ||||
SQL_HASH_VALUE | Oracle monitoring: SQL_HASH_VALUE: SQL statement hash | ORA_SQL_HASH_VALUE | DEC | 22 | ORA_SQL_HASH_VALUE | ||||
PREV_SQL_ADDR | Oracle monitoring: PREV_SQL_ADDR: Prev. SQL Statement ID | ORA_PREV_SQL_ADDR | RAW | 8 | ORA_PREV_SQL_ADDR | ||||
PREV_HASH_VALUE | Oracle monitoring: PREV_HASH_VALUE: Prev. SQL Statement hash | ORA_PREV_HASH_VALUE | DEC | 22 | ORA_PREV_HASH_VALUE | ||||
OMODULE | Oracle monitoring: MODULE: currently executing module | ORA_MODULE | CHAR | 48 | ORA_MODULE | ||||
MODULE_HASH | Oracle monitoring: MODULE_HASH: curr. executing module hash | ORA_MODULE_HASH | DEC | 22 | ORA_MODULE_HASH | ||||
ACTION | Oracle monitoring: ACTION: Currently executing action | ORA_ACTION | CHAR | 32 | ORA_ACTION | ||||
ACTION_HASH | Oracle monitoring: ACTION: Currently executing action hash | ORA_ACTION_HASH | DEC | 22 | ORA_ACTION_HASH | ||||
CLIENT_INFO | Oracle monitoring: CLIENT_INFO | ORA_CLIENT_INFO | CHAR | 64 | ORA_CLIENT_INFO | ||||
FIXED_TABLE_SEQU | Oracle monitoring: ORA_FIXED_TABLE_SEQUENCE | ORA_FIXED_TABLE_SEQUENCE | DEC | 22 | ORA_FIXED_TABLE_SEQUENCE | ||||
ROW_WAIT_OBJ | Oracle monitoring: ROW_WAIT_OBJ | ORA_ROW_WAIT_OBJ | DEC | 22 | ORA_ROW_WAIT_OBJ | ||||
ROW_WAIT_FILE | Oracle monitoring: ROW_WAIT_FILE | ORA_ROW_WAIT_FILE | DEC | 22 | ORA_ROW_WAIT_FILE | ||||
ROW_WAIT_BLOCK | Oracle monitoring: ROW_WAIT_BLOCK | ORA_ROW_WAIT_BLOCK | DEC | 22 | ORA_ROW_WAIT_BLOCK | ||||
ROW_WAIT_ROW | Oracle monitoring: ROW_WAIT_ROW | ORA_ROW_WAIT_ROW | DEC | 22 | ORA_ROW_WAIT_ROW | ||||
LOGON_TIME | Oracle monitoring: LOGON_TIME (Time): Time of logon | ORA_LOGON_TIME | TIMS | 6 | ORA_TIME | ||||
LAST_CALL_ET | Oracle monitoring:LAST_CALL_ET: The last call | ORA_LAST_CALL_ET | DEC | 22 | ORA_LAST_CALL_ET | ||||
PDML_ENABLED | Oracle monitoring: PDML_ENABLED | ORA_PDML_ENABLED | CHAR | 3 | ORA_PDML_ENABLED | ||||
FAILOVER_TYPE | Oracle monitoring: FAILOVER_TYPE: Failover type for session | ORA_FAILOVER_TYPE | CHAR | 13 | ORA_FAILOVER_TYPE | ||||
FAILOVER_METHOD | Oracle monitoring: FAILOVER_METHO: Failover method for sess. | ORA_FAILOVER_METHOD | CHAR | 10 | ORA_FAILOVER_METHOD | ||||
FAILED_OVER | Oracle monitoring: FAILED_OVER: Sess. in Failover Mode | ORA_FAILED_OVER | CHAR | 3 | ORA_FAILED_OVER | ||||
RESOURCE_CONSUME | Oracle monitoring: RESOURCE_CONSUMER_GROUP | ORA_RESOURCE_CONSUMER_GROUP | CHAR | 32 | ORA_RESOURCE_CONSUMER_GROUP | ||||
PDML_STATUS | Oracle monitoring: PDML_STATUS: Parallel DML status | ORA_PDML_STATUS | CHAR | 8 | ORA_PDML_STATUS | ||||
PDDL_STATUS | Oracle monitoring: PDML_STATUS: Parallel DDL status | ORA_PDDL_STATUS | CHAR | 8 | ORA_PDDL_STATUS | ||||
PQ_STATUS | Oracle monitoring: PDML_STATUS: Parallel QUERY status | ORA_PQ_STATUS | CHAR | 8 | ORA_PQ_STATUS | ||||
CURRENT_QUEUE_DU | Oracle monitoring: CURRENT_QUEUE_DURATION | ORA_CURRENT_QUEUE_DURATION | DEC | 22 | ORA_CURRENT_QUEUE_DURATION | ||||
CLIENT_IDENTIFIE | Oracle monitoring: ORA_CLIENT_IDENTIFIER | ORA_CLIENT_IDENTIFIER | CHAR | 64 | ORA_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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects