SAP Table STI_SESSION
Oracle monitoring: structure for GV$SESSION.
STI_SESSION (Oracle monitoring: structure for GV$SESSION.) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link STI_SESSION to other SAP tables.
STI_SESSION table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| INST_ID | Oracle monitor: Instance ID | ORA_INST_ID | DEC | 22 | 0 | |||
| SADDR | Oracle monitoring: Session address | ORA_SADDR | RAW | 8 | 0 | |||
| SID | Oracle monitoring: SID (Session) | ORA_SID | DEC | 22 | 0 | |||
| SERIAL | Oracle monitoring: SERIAL#: Session serial number | ORA_SERIAL | DEC | 22 | 0 | |||
| AUDSID | Oracle monitoring: AUDSID: Auditing session ID | ORA_AUDSID | DEC | 22 | 0 | |||
| PADDR | Oracle monitoring: PADDR: Address of proc. owning the sess. | ORA_PADDR | RAW | 8 | 0 | |||
| OUSER | Oracle monitoring: USER#: Oracle user identifier | ORA_USER | DEC | 22 | 0 | |||
| USERNAME | Oracle monitoring: USERNAME: Oracle username | ORA_USERNAME | CHAR | 30 | 0 | |||
| COMMAND | Oracle monitoring: COMMAND: Command in progress | ORA_COMMAND | DEC | 22 | 0 | |||
| OWNERID | Oracle monitoring: OWNERID: session owner | ORA_OWNERID | DEC | 22 | 0 | |||
| TADDR | Oracle monitoring: TADDR: Address of transaction state obj. | ORA_TADDR | CHAR | 16 | 0 | |||
| LOCKWAIT | Oracle monitoring: LOCKWAIT: Address of lock waiting for | ORA_LOCKWAIT | CHAR | 16 | 0 | |||
| STATUS | Oracle monitoring: STATUS: Status of the session | ORA_SSTATUS | CHAR | 8 | 0 | |||
| SERVER | Oracle monitoring: SERVER: Server type | ORA_SERVER | CHAR | 9 | 0 | |||
| OSCHEMA | Oracle monitoring: SCHEMA#: Schema user identifier | ORA_SCHEMA | DEC | 22 | 0 | |||
| SCHEMANAME | Oracle monitoring: SCHEMANAME: Schema user name | ORA_SCHEMANAME | CHAR | 30 | 0 | |||
| OSUSER | Oracle monitoring: OSUSER: Operating system client user name | ORA_OSUSER | CHAR | 30 | 0 | |||
| PROCESS | Oracle monitoring: OS Process Id | ORA_PROCESS | CHAR | 12 | 0 | |||
| MACHINE | Oracle monitoring: MACHINE: Operating system machine name | ORA_MACHINE | CHAR | 64 | 0 | |||
| TERMINAL | Oracle monitoring: MACHINE: Operating system machine name | ORA_TERMINAL | CHAR | 30 | 0 | |||
| OPROGRAM | Oracle monitoring: PROGRAM: Operating system program name | ORA_PROGRAM | CHAR | 48 | 0 | |||
| TYPE | Oracle monitoring: TYPE: Session type | ORA_STYPE | CHAR | 10 | 0 | |||
| SQL_ADDRESS | Oracle monitoring: SQL_ADDRESS: SQL Statement ID | ORA_SQL_ADDRESS | RAW | 8 | 0 | |||
| SQL_HASH_VALUE | Oracle monitoring: SQL_HASH_VALUE: SQL statement hash | ORA_SQL_HASH_VALUE | DEC | 22 | 0 | |||
| PREV_SQL_ADDR | Oracle monitoring: PREV_SQL_ADDR: Prev. SQL Statement ID | ORA_PREV_SQL_ADDR | RAW | 8 | 0 | |||
| PREV_HASH_VALUE | Oracle monitoring: PREV_HASH_VALUE: Prev. SQL Statement hash | ORA_PREV_HASH_VALUE | DEC | 22 | 0 | |||
| OMODULE | Oracle monitoring: MODULE: currently executing module | ORA_MODULE | CHAR | 48 | 0 | |||
| MODULE_HASH | Oracle monitoring: MODULE_HASH: curr. executing module hash | ORA_MODULE_HASH | DEC | 22 | 0 | |||
| ACTION | Oracle monitoring: ACTION: Currently executing action | ORA_ACTION | CHAR | 32 | 0 | |||
| ACTION_HASH | Oracle monitoring: ACTION: Currently executing action hash | ORA_ACTION_HASH | DEC | 22 | 0 | |||
| CLIENT_INFO | Oracle monitoring: CLIENT_INFO | ORA_CLIENT_INFO | CHAR | 64 | 0 | |||
| FIXED_TABLE_SEQU | Oracle monitoring: ORA_FIXED_TABLE_SEQUENCE | ORA_FIXED_TABLE_SEQUENCE | DEC | 22 | 0 | |||
| ROW_WAIT_OBJ | Oracle monitoring: ROW_WAIT_OBJ | ORA_ROW_WAIT_OBJ | DEC | 22 | 0 | |||
| ROW_WAIT_FILE | Oracle monitoring: ROW_WAIT_FILE | ORA_ROW_WAIT_FILE | DEC | 22 | 0 | |||
| ROW_WAIT_BLOCK | Oracle monitoring: ROW_WAIT_BLOCK | ORA_ROW_WAIT_BLOCK | DEC | 22 | 0 | |||
| ROW_WAIT_ROW | Oracle monitoring: ROW_WAIT_ROW | ORA_ROW_WAIT_ROW | DEC | 22 | 0 | |||
| LOGON_TIME | Oracle monitoring: LOGON_TIME (Time): Time of logon | ORA_LOGON_TIME | TIMS | 6 | 0 | |||
| LAST_CALL_ET | Oracle monitoring:LAST_CALL_ET: The last call | ORA_LAST_CALL_ET | DEC | 22 | 0 | |||
| PDML_ENABLED | Oracle monitoring: PDML_ENABLED | ORA_PDML_ENABLED | CHAR | 3 | 0 | |||
| FAILOVER_TYPE | Oracle monitoring: FAILOVER_TYPE: Failover type for session | ORA_FAILOVER_TYPE | CHAR | 13 | 0 | |||
| FAILOVER_METHOD | Oracle monitoring: FAILOVER_METHO: Failover method for sess. | ORA_FAILOVER_METHOD | CHAR | 10 | 0 | |||
| FAILED_OVER | Oracle monitoring: FAILED_OVER: Sess. in Failover Mode | ORA_FAILED_OVER | CHAR | 3 | 0 | |||
| RESOURCE_CONSUME | Oracle monitoring: RESOURCE_CONSUMER_GROUP | ORA_RESOURCE_CONSUMER_GROUP | CHAR | 32 | 0 | |||
| PDML_STATUS | Oracle monitoring: PDML_STATUS: Parallel DML status | ORA_PDML_STATUS | CHAR | 8 | 0 | |||
| PDDL_STATUS | Oracle monitoring: PDML_STATUS: Parallel DDL status | ORA_PDDL_STATUS | CHAR | 8 | 0 | |||
| PQ_STATUS | Oracle monitoring: PDML_STATUS: Parallel QUERY status | ORA_PQ_STATUS | CHAR | 8 | 0 | |||
| CURRENT_QUEUE_DU | Oracle monitoring: CURRENT_QUEUE_DURATION | ORA_CURRENT_QUEUE_DURATION | DEC | 22 | 0 | |||
| CLIENT_IDENTIFIE | Oracle monitoring: ORA_CLIENT_IDENTIFIER | ORA_CLIENT_IDENTIFIER | CHAR | 64 | 0 | |||
