SAP ABAP Table ORASESSION (Basis List "Oracle Session" Structure for the ALV)

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	ORASESSION	Table Relationship Diagram
Short Description	Basis List "Oracle Session" Structure for the ALV

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	SID	☐	ORASID	ORANUMBER4	INT4	10	0	Session ID
2	SPID	☐	ORASPID	CHAR9	CHAR	9	0	Operating System Process ID
3	MACHINE	☐	ORAMACHINE	CHAR30	CHAR	30	0	Operating System Machine Name
4	PROCESS	☐	ORAPROCESS	CHAR9	CHAR	9	0	Operating System Client Process ID
5	STATUS	☐	ORASTATUS	CHAR8	CHAR	8	0	Status of Session (Active, Inactive, Killed)
6	EVENT	☐	ORAEVENT4	CHAR30	CHAR	30	0	Resource or Event That the Session is Waiting For
7	USERNAME	☐	ORAUSER	CHAR10	CHAR	10	0	Column USERNAME in V$SESSION
8	SQL_TEXT	☐	ORASQLTEXT	CHAR60	CHAR	60	0	Start of SQL statement
9	L_READS	☐	ORAL_READS	CHAR14	CHAR	14	0	Total Block and Consistent Gets for the Session
10	P_READS	☐	ORAR_READS	CHAR12	CHAR	12	0	Physical Read Operations for this Session
11	B_CHANGES	☐	ORAB_CHANG	CHAR12	CHAR	12	0	Block Changes for this Sesssion
12	C_CHANGES	☐	ORAC_CHANG	CHAR12	CHAR	12	0	Consistent Changes for this Session
13	SEC_WAIT	☐	ORAS_WAIT	INT4	INT4	10	0	Wait Time in Seconds
14	WAIT_TIME	☐	ORAW_TIME	INT4	INT4	10	0	WAIT_TIME Column of v$session_wait
15	P1TEXT	☐	ORAP1TEXT	CHAR20	CHAR	20	0	Description of First Additional Parameter
16	P1	☐	ORAP1	CHAR11	CHAR	11	0	Parameter value 1
17	P2TEXT	☐	ORAP2TEXT	CHAR20	CHAR	20	0	Description of Second Additional Parameter
18	P2	☐	ORAP2	CHAR11	CHAR	11	0	Parameter value 2
19	P3TEXT	☐	ORAP3TEXT	CHAR20	CHAR	20	0	Description of Third Additional Parameter
20	P3	☐	ORAP3	CHAR11	CHAR	11	0	Parameter value 3
21	TRANS_STATUS	☐			CHAR	16	0
22	START_TIME	☐			CHAR	20	0
23	START_SCNB	☐			DEC	16	0
24	START_UEXT	☐			DEC	16	0
25	START_UBAFIL	☐			DEC	16	0
26	START_UBABLK	☐			DEC	16	0
27	START_UBASQN	☐			DEC	16	0
28	START_UBAREC	☐			DEC	16	0
29	UBAFIL	☐			DEC	16	0
30	UBABLK	☐			DEC	16	0
31	UBASQN	☐			DEC	16	0
32	UBAREC	☐			DEC	16	0
33	XIDUSN	☐			DEC	16	0
34	XIDSLOT	☐			DEC	16	0
35	XIDSQN	☐			DEC	16	0

History

Last changed by/on	SAP	20100420
SAP Release Created in	50A