SAP ABAP Table STI_SESSION (Oracle monitoring: structure for GV$SESSION.)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
Basic Data
Table Category | INTTAB | Structure |
Structure | STI_SESSION | Table Relationship Diagram |
Short Description | Oracle monitoring: structure for GV$SESSION. |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | INST_ID | ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
2 | SADDR | ORA_SADDR | ORA_SADDR | RAW | 8 | 0 | Oracle monitoring: Session address | ||
3 | SID | ORA_SID | ORA_SID | DEC | 22 | 0 | Oracle monitoring: SID (Session) | ||
4 | SERIAL | ORA_SERIAL | ORA_SERIAL | DEC | 22 | 0 | Oracle monitoring: SERIAL#: Session serial number | ||
5 | AUDSID | ORA_AUDSID | ORA_AUDSID | DEC | 22 | 0 | Oracle monitoring: AUDSID: Auditing session ID | ||
6 | PADDR | ORA_PADDR | ORA_PADDR | RAW | 8 | 0 | Oracle monitoring: PADDR: Address of proc. owning the sess. | ||
7 | OUSER | ORA_USER | ORA_USER | DEC | 22 | 0 | Oracle monitoring: USER#: Oracle user identifier | ||
8 | USERNAME | ORA_USERNAME | ORA_USERNAME | CHAR | 30 | 0 | Oracle monitoring: USERNAME: Oracle username | ||
9 | COMMAND | ORA_COMMAND | ORA_COMMAND | DEC | 22 | 0 | Oracle monitoring: COMMAND: Command in progress | ||
10 | OWNERID | ORA_OWNERID | ORA_OWNERID | DEC | 22 | 0 | Oracle monitoring: OWNERID: session owner | ||
11 | TADDR | ORA_TADDR | ORA_TADDR | CHAR | 16 | 0 | Oracle monitoring: TADDR: Address of transaction state obj. | ||
12 | LOCKWAIT | ORA_LOCKWAIT | ORA_LOCKWAIT | CHAR | 16 | 0 | Oracle monitoring: LOCKWAIT: Address of lock waiting for | ||
13 | STATUS | ORA_SSTATUS | ORA_SSTATUS | CHAR | 8 | 0 | Oracle monitoring: STATUS: Status of the session | ||
14 | SERVER | ORA_SERVER | ORA_SERVER | CHAR | 9 | 0 | Oracle monitoring: SERVER: Server type | ||
15 | OSCHEMA | ORA_SCHEMA | ORA_SCHEMA | DEC | 22 | 0 | Oracle monitoring: SCHEMA#: Schema user identifier | ||
16 | SCHEMANAME | ORA_SCHEMANAME | ORA_SCHEMANAME | CHAR | 30 | 0 | Oracle monitoring: SCHEMANAME: Schema user name | ||
17 | OSUSER | ORA_OSUSER | ORA_OSUSER | CHAR | 30 | 0 | Oracle monitoring: OSUSER: Operating system client user name | ||
18 | PROCESS | ORA_PROCESS | ORA_PROCESS | CHAR | 12 | 0 | Oracle monitoring: OS Process Id | ||
19 | MACHINE | ORA_MACHINE | ORA_MACHINE | CHAR | 64 | 0 | Oracle monitoring: MACHINE: Operating system machine name | ||
20 | TERMINAL | ORA_TERMINAL | ORA_TERMINAL | CHAR | 30 | 0 | Oracle monitoring: MACHINE: Operating system machine name | ||
21 | OPROGRAM | ORA_PROGRAM | ORA_PROGRAM | CHAR | 48 | 0 | Oracle monitoring: PROGRAM: Operating system program name | ||
22 | TYPE | ORA_STYPE | ORA_STYPE | CHAR | 10 | 0 | Oracle monitoring: TYPE: Session type | ||
23 | SQL_ADDRESS | ORA_SQL_ADDRESS | ORA_SQL_ADDRESS | RAW | 8 | 0 | Oracle monitoring: SQL_ADDRESS: SQL Statement ID | ||
24 | SQL_HASH_VALUE | ORA_SQL_HASH_VALUE | ORA_SQL_HASH_VALUE | DEC | 22 | 0 | Oracle monitoring: SQL_HASH_VALUE: SQL statement hash | ||
25 | PREV_SQL_ADDR | ORA_PREV_SQL_ADDR | ORA_PREV_SQL_ADDR | RAW | 8 | 0 | Oracle monitoring: PREV_SQL_ADDR: Prev. SQL Statement ID | ||
26 | PREV_HASH_VALUE | ORA_PREV_HASH_VALUE | ORA_PREV_HASH_VALUE | DEC | 22 | 0 | Oracle monitoring: PREV_HASH_VALUE: Prev. SQL Statement hash | ||
27 | OMODULE | ORA_MODULE | ORA_MODULE | CHAR | 48 | 0 | Oracle monitoring: MODULE: currently executing module | ||
28 | MODULE_HASH | ORA_MODULE_HASH | ORA_MODULE_HASH | DEC | 22 | 0 | Oracle monitoring: MODULE_HASH: curr. executing module hash | ||
29 | ACTION | ORA_ACTION | ORA_ACTION | CHAR | 32 | 0 | Oracle monitoring: ACTION: Currently executing action | ||
30 | ACTION_HASH | ORA_ACTION_HASH | ORA_ACTION_HASH | DEC | 22 | 0 | Oracle monitoring: ACTION: Currently executing action hash | ||
31 | CLIENT_INFO | ORA_CLIENT_INFO | ORA_CLIENT_INFO | CHAR | 64 | 0 | Oracle monitoring: CLIENT_INFO | ||
32 | FIXED_TABLE_SEQU | ORA_FIXED_TABLE_SEQUENCE | ORA_FIXED_TABLE_SEQUENCE | DEC | 22 | 0 | Oracle monitoring: ORA_FIXED_TABLE_SEQUENCE | ||
33 | ROW_WAIT_OBJ | ORA_ROW_WAIT_OBJ | ORA_ROW_WAIT_OBJ | DEC | 22 | 0 | Oracle monitoring: ROW_WAIT_OBJ | ||
34 | ROW_WAIT_FILE | ORA_ROW_WAIT_FILE | ORA_ROW_WAIT_FILE | DEC | 22 | 0 | Oracle monitoring: ROW_WAIT_FILE | ||
35 | ROW_WAIT_BLOCK | ORA_ROW_WAIT_BLOCK | ORA_ROW_WAIT_BLOCK | DEC | 22 | 0 | Oracle monitoring: ROW_WAIT_BLOCK | ||
36 | ROW_WAIT_ROW | ORA_ROW_WAIT_ROW | ORA_ROW_WAIT_ROW | DEC | 22 | 0 | Oracle monitoring: ROW_WAIT_ROW | ||
37 | LOGON_TIME | ORA_LOGON_TIME | ORA_TIME | TIMS | 6 | 0 | Oracle monitoring: LOGON_TIME (Time): Time of logon | ||
38 | LAST_CALL_ET | ORA_LAST_CALL_ET | ORA_LAST_CALL_ET | DEC | 22 | 0 | Oracle monitoring:LAST_CALL_ET: The last call | ||
39 | PDML_ENABLED | ORA_PDML_ENABLED | ORA_PDML_ENABLED | CHAR | 3 | 0 | Oracle monitoring: PDML_ENABLED | ||
40 | FAILOVER_TYPE | ORA_FAILOVER_TYPE | ORA_FAILOVER_TYPE | CHAR | 13 | 0 | Oracle monitoring: FAILOVER_TYPE: Failover type for session | ||
41 | FAILOVER_METHOD | ORA_FAILOVER_METHOD | ORA_FAILOVER_METHOD | CHAR | 10 | 0 | Oracle monitoring: FAILOVER_METHO: Failover method for sess. | ||
42 | FAILED_OVER | ORA_FAILED_OVER | ORA_FAILED_OVER | CHAR | 3 | 0 | Oracle monitoring: FAILED_OVER: Sess. in Failover Mode | ||
43 | RESOURCE_CONSUME | ORA_RESOURCE_CONSUMER_GROUP | ORA_RESOURCE_CONSUMER_GROUP | CHAR | 32 | 0 | Oracle monitoring: RESOURCE_CONSUMER_GROUP | ||
44 | PDML_STATUS | ORA_PDML_STATUS | ORA_PDML_STATUS | CHAR | 8 | 0 | Oracle monitoring: PDML_STATUS: Parallel DML status | ||
45 | PDDL_STATUS | ORA_PDDL_STATUS | ORA_PDDL_STATUS | CHAR | 8 | 0 | Oracle monitoring: PDML_STATUS: Parallel DDL status | ||
46 | PQ_STATUS | ORA_PQ_STATUS | ORA_PQ_STATUS | CHAR | 8 | 0 | Oracle monitoring: PDML_STATUS: Parallel QUERY status | ||
47 | CURRENT_QUEUE_DU | ORA_CURRENT_QUEUE_DURATION | ORA_CURRENT_QUEUE_DURATION | DEC | 22 | 0 | Oracle monitoring: CURRENT_QUEUE_DURATION | ||
48 | CLIENT_IDENTIFIE | ORA_CLIENT_IDENTIFIER | ORA_CLIENT_IDENTIFIER | CHAR | 64 | 0 | Oracle monitoring: ORA_CLIENT_IDENTIFIER |
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 700 |