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

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBCOCKPIT_ORA (Package) Oracle Monitoring with DBCOCKPIT Framework

Basic Data

Table Category	INTTAB	Structure
Structure	GORASESSION_DBC	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	INST_ID	☐	ORAINST_ID	ORANUMBER	INT4	10	0	Oracle Instance ID
2	SID	☐	ORASID	ORANUMBER4	INT4	10	0	Session ID
3	SPID	☐	ORASPID	CHAR9	CHAR	9	0	Operating System Process ID
4	SAP_INSTANCE	☐	MSNAME	MSNAME	CHAR	20	0	Server Name
5	MACHINE	☐	ORAMACHINE	CHAR30	CHAR	30	0	Operating System Machine Name
6	PROCESS	☐	ORAPROCESS	CHAR9	CHAR	9	0	Operating System Client Process ID
7	STATUS	☐	ORASTATUS	CHAR8	CHAR	8	0	Status of Session (Active, Inactive, Killed)
8	EVENT	☐	ORAEVENT4	CHAR30	CHAR	30	0	Resource or Event That the Session is Waiting For
9	SQL_TEXT	☐	ORASQLTEXT	CHAR60	CHAR	60	0	Start of SQL statement
10	LOGICAL_READS	☐	ORAL_READS	CHAR14	CHAR	14	0	Total Block and Consistent Gets for the Session
11	PHYS_READS	☐	ORAR_READS	CHAR12	CHAR	12	0	Physical Read Operations for this Session
12	BLOCK_CHANGES	☐	ORAB_CHANG	CHAR12	CHAR	12	0	Block Changes for this Sesssion
13	CONSISTENT_CHANGES	☐	ORAC_CHANG	CHAR12	CHAR	12	0	Consistent Changes for this Session
14	SECONDS_IN_WAIT	☐	ORAS_WAIT	INT4	INT4	10	0	Wait Time in Seconds
15	WAIT_TIME	☐	ORAW_TIME	INT4	INT4	10	0	WAIT_TIME Column of v$session_wait
16	P1TEXT	☐	ORAP1TEXT	CHAR20	CHAR	20	0	Description of First Additional Parameter
17	P1	☐	ORAP1	CHAR11	CHAR	11	0	Parameter value 1
18	P2TEXT	☐	ORAP2TEXT	CHAR20	CHAR	20	0	Description of Second Additional Parameter
19	P2	☐	ORAP2	CHAR11	CHAR	11	0	Parameter value 2
20	P3TEXT	☐	ORAP3TEXT	CHAR20	CHAR	20	0	Description of Third Additional Parameter
21	P3	☐	ORAP3	CHAR11	CHAR	11	0	Parameter value 3
22	BLOCK_GETS	☐			DEC	16	0
23	CONSISTENT_GETS	☐			DEC	16	0
24	USERNAME	☐	ORAUSER	CHAR10	CHAR	10	0	Column USERNAME in V$SESSION
25	PGA_USED_MEM	☐			DEC	16	0
26	PGA_ALLOC_MEM	☐			DEC	16	0
27	PGA_FREEABLE_MEM	☐			DEC	16	0
28	PGA_MAX_MEM	☐			DEC	16	0
29	CLIENT_INFO	☐			CHAR	64	0
30	CLIENT_IDENTIFIER	☐			CHAR	64	0
31	WAIT_CLASS	☐			CHAR	64	0

History

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