SAP ABAP Table GORASESSION_SEL_ST04 (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

Basic Data

Table Category	INTTAB	Structure
Structure	GORASESSION_SEL_ST04	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	SPID	☐	ORASPID	CHAR9	CHAR	9	0	Operating System Process ID
8	PROCPROG	☐			CHAR	64	0
9	PROCESS	☐	ORASPID	CHAR9	CHAR	9	0	Operating System Process ID
10	MACHINE	☐			CHAR	64	0
11	PROGRAM	☐			CHAR	48	0
12	COMMAND	☐			INT4	10	0
13	STATUS	☐	ORASTATUS	CHAR8	CHAR	8	0	Status of Session (Active, Inactive, Killed)
14	TYPE	☐			CHAR	10	0
15	EVENT	☐			CHAR	64	0
16	WAIT_TIME	☐			DEC	22	0
17	SECONDS_IN_WAIT	☐			DEC	16	0
18	P1TEXT	☐			CHAR	64	0
19	P1	☐			CHAR	20	0
20	P2TEXT	☐			CHAR	64	0
21	P2	☐			CHAR	20	0
22	P3TEXT	☐			CHAR	64	0
23	P3	☐			CHAR	20	0
24	.INCLUDE	☐				0	0	Fields of Oracle Tables gv$sess_io
25	BLOCK_GETS	☐			DEC	16	0
26	CONSISTENT_GETS	☐			DEC	16	0
27	LOGICAL_READS	☐			DEC	16	0
28	PHYSICAL_READS	☐			DEC	16	0
29	BLOCK_CHANGES	☐			DEC	16	0
30	CONSISTENT_CHANGES	☐			DEC	16	0
31	SQL_TEXT	☐	ORAPIECETX	CHAR64	CHAR	64	0	Piece of SQL text
32	TRANS_STATUS	☐			CHAR	16	0
33	START_TIME	☐			CHAR	20	0
34	START_SCNB	☐			DEC	31	0
35	START_UEXT	☐			DEC	31	0
36	START_UBAFIL	☐			DEC	31	0
37	START_UBABLK	☐			DEC	31	0
38	START_UBASQN	☐			DEC	31	0
39	START_UBAREC	☐			DEC	31	0
40	UBAFIL	☐			DEC	31	0
41	UBABLK	☐			DEC	31	0
42	UBASQN	☐			DEC	31	0
43	UBAREC	☐			DEC	31	0
44	XIDUSN	☐			DEC	31	0
45	XIDSLOT	☐			DEC	31	0
46	XIDSQN	☐			DEC	31	0
47	DBSERVER	☐			CHAR	64	0

History

Last changed by/on	SAP	20100420
SAP Release Created in	710