SAP ABAP Table GORASESSION (Target Structure for Oracle Session (Join of 5 V$ Tables))

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	Table Relationship Diagram
Short Description	Target Structure for Oracle Session (Join of 5 V$ Tables)

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	SESSPROG	☐			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	SESS_IO	☐	GORASESS_IO		STRU	0	0
22	BLOCK_GETS	☐			DEC	16	0
23	CONSISTENT_GETS	☐			DEC	16	0
24	LOGICAL_READS	☐			DEC	16	0
25	PHYSICAL_READS	☐			DEC	16	0
26	BLOCK_CHANGES	☐			DEC	16	0
27	CONSISTENT_CHANGES	☐			DEC	16	0
28	SQL_TEXT_TAB	☐	ORAPIECETX_T		TTYP	0	0
29	P1TEXT	☐			CHAR	64	0
30	P1	☐			CHAR	20	0
31	P2TEXT	☐			CHAR	64	0
32	P2	☐			CHAR	20	0
33	P3TEXT	☐			CHAR	64	0
34	P3	☐			CHAR	20	0
35	MODULE	☐	ORAMODULE	ORACHAR64	CHAR	64	0	Program Name
36	ACTION	☐	ORAACTION	CHAR64	CHAR	64	0	Action name
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	WAIT_CLASS	☐			CHAR	64	0

History

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