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

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