SAP ABAP Table GVD_PX_SESSION (Oracle monitoring: Copy of GV$PX_SESSION)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	GVD_PX_SESSION	Table Relationship Diagram
Short Description	Oracle monitoring: Copy of GV$PX_SESSION

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SNAPSHOT_ID	☑	ORA_SNAPSHOT_ID	ORA_SNAPSHOT_ID	NUMC	10	0	Oracle monitor: snapshot ID	*
2	INST_ID	☑	ORA_INST_ID	ORA_INST_ID	DEC	22	0	Oracle monitor: Instance ID
3	SADDR	☑	ORA_SADDR	ORA_SADDR	RAW	8	0	Oracle monitoring: Session address
4	SID	☑	ORA_SID	ORA_SID	DEC	22	0	Oracle monitoring: SID (Session)
5	SERIAL_NR	☐	ORA_SERIAL_NR	ORA_NUM_22	DEC	22	0	Oracle monitoring: Session serial number
6	QCSID	☐	ORA_QCSID	ORA_NUMBER	DEC	22	0	Oracle Monitoring: QCSID: Query Coordinator Session ID
7	QCSERIAL_NR	☐	ORA_QCSERIAL_NR	ORA_NUM_22	DEC	22	0	Oracle monitoring: Session serial nr of the parallel coordin
8	QCINST_ID	☐	ORA_QCINST_ID	ORA_NUMBER	DEC	22	0	Oracle Monitoring: QCINST_ID: Query Coordinator ID
9	SERVER_GROUP	☐	ORA_SERVER_GROUP	ORA_NUM_22	DEC	22	0	Oracle monitoring: log. group of servers - DB proc. belongs
10	SERVER_SET	☐	ORA_SERVER_SET	ORA_NUM_22	DEC	22	0	Oracle monitoring: Log. set of servers
11	SERVER_NR	☐	ORA_SERVER_NR	ORA_NUM_22	DEC	22	0	Oracle monitoring: Log. nr. of cluster DB proc. within serv.
12	DEGREE	☐	ORA_DEGREE	ORA_DEC_22	DEC	22	0	Oracle monitoring: number of threads per instance for scan
13	REQ_DEGREE	☐	ORA_REQ_DEGREE	ORA_NUM_22	DEC	22	0	Oracle monitoring: degree of parallelism that was requested

History

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