SAP ABAP Table GORASESSION_SELECT (Targ. Struct.for 'Oracle Session' Select (Join of 5 V$ Tabs))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-ORA-SYS (Application Component) Database Interface/DBMS for Oracle
⤷ STUN_ORA (Package) Objects for Performance Analysis (ST04): Oracle DB
⤷ BC-DB-ORA-SYS (Application Component) Database Interface/DBMS for Oracle
⤷ STUN_ORA (Package) Objects for Performance Analysis (ST04): Oracle DB
Basic Data
Table Category | INTTAB | Structure |
Structure | GORASESSION_SELECT | Table Relationship Diagram |
Short Description | Targ. Struct.for 'Oracle Session' Select (Join of 5 V$ Tabs) |
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 | ORAINST_ID | ORANUMBER | INT4 | 10 | 0 | Oracle Instance ID | ||
2 | SID | ORASID | ORANUMBER4 | INT4 | 10 | 0 | Session ID | ||
3 | PADDR | CHAR | 16 | 0 | |||||
4 | USERNAME | DB_USER | CHAR30 | CHAR | 30 | 0 | Database user | ||
5 | SQL_ADDRESS | CHAR | 16 | 0 | |||||
6 | SQL_HASH_VALUE | DEC | 16 | 0 | |||||
7 | SQL_CHILD_NUMBER | DEC | 16 | 0 | |||||
8 | CLIENT_INFO | CHAR | 64 | 0 | |||||
9 | CLIENT_IDENTIFIER | CHAR | 64 | 0 | |||||
10 | SPID | ORASPID | CHAR9 | CHAR | 9 | 0 | Operating System Process ID | ||
11 | PROCPROG | CHAR | 64 | 0 | |||||
12 | PROCESS | ORASPID | CHAR9 | CHAR | 9 | 0 | Operating System Process ID | ||
13 | MACHINE | CHAR | 64 | 0 | |||||
14 | PROGRAM | CHAR | 48 | 0 | |||||
15 | COMMAND | INT4 | 10 | 0 | |||||
16 | STATUS | ORASTATUS | CHAR8 | CHAR | 8 | 0 | Status of Session (Active, Inactive, Killed) | ||
17 | TYPE | CHAR | 10 | 0 | |||||
18 | EVENT | CHAR | 64 | 0 | |||||
19 | WAIT_TIME | DEC | 22 | 0 | |||||
20 | SECONDS_IN_WAIT | DEC | 16 | 0 | |||||
21 | P1TEXT | CHAR | 64 | 0 | |||||
22 | P1 | CHAR | 20 | 0 | |||||
23 | P2TEXT | CHAR | 64 | 0 | |||||
24 | P2 | CHAR | 20 | 0 | |||||
25 | P3TEXT | CHAR | 64 | 0 | |||||
26 | P3 | CHAR | 20 | 0 | |||||
27 | MODULE | ORAMODULE | ORACHAR64 | CHAR | 64 | 0 | Program Name | ||
28 | ACTION | ORAACTION | CHAR64 | CHAR | 64 | 0 | Action name | ||
29 | .INCLUDE | 0 | 0 | Fields of Oracle Tables gv$sess_io | |||||
30 | BLOCK_GETS | DEC | 16 | 0 | |||||
31 | CONSISTENT_GETS | DEC | 16 | 0 | |||||
32 | LOGICAL_READS | DEC | 16 | 0 | |||||
33 | PHYSICAL_READS | DEC | 16 | 0 | |||||
34 | BLOCK_CHANGES | DEC | 16 | 0 | |||||
35 | CONSISTENT_CHANGES | DEC | 16 | 0 | |||||
36 | SQL_TEXT | ORAPIECETX | CHAR64 | CHAR | 64 | 0 | Piece of SQL text | ||
37 | PGA_USED_MEM | DEC | 22 | 0 | |||||
38 | PGA_ALLOC_MEM | DEC | 22 | 0 | |||||
39 | PGA_FREEABLE_MEM | DEC | 22 | 0 | |||||
40 | PGA_MAX_MEM | DEC | 22 | 0 | |||||
41 | ROW_WAIT_OBJ | DEC | 22 | 0 | |||||
42 | ROW_WAIT_FILE | DEC | 22 | 0 | |||||
43 | ROW_WAIT_BLOCK | DEC | 22 | 0 | |||||
44 | ROW_WAIT_ROW | DEC | 22 | 0 | |||||
45 | DBSERVER | CHAR | 64 | 0 | |||||
46 | WAIT_CLASS | CHAR | 64 | 0 |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 710 |