SAP ABAP Table STR_PX_SESSION (Oracle monitoring:structure for V$PX_SESSION.)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Basic Data

Table Category	INTTAB	Structure
Structure	STR_PX_SESSION	Table Relationship Diagram
Short Description	Oracle monitoring:structure for V$PX_SESSION.

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	SADDR	☐	ORA_SADDR	ORA_SADDR	RAW	8	0	Oracle monitoring: Session address
2	SID	☐	ORA_SID	ORA_SID	DEC	22	0	Oracle monitoring: SID (Session)
3	SERIAL_NR	☐	ORA_SERIAL_NR	ORA_NUM_22	DEC	22	0	Oracle monitoring: Session serial number
4	QCSID	☐	ORA_QCSID	ORA_NUMBER	DEC	22	0	Oracle Monitoring: QCSID: Query Coordinator Session ID
5	QCSERIAL_NR	☐	ORA_QCSERIAL_NR	ORA_NUM_22	DEC	22	0	Oracle monitoring: Session serial nr of the parallel coordin
6	QCINST_ID	☐	ORA_QCINST_ID	ORA_NUMBER	DEC	22	0	Oracle Monitoring: QCINST_ID: Query Coordinator ID
7	SERVER_GROUP	☐	ORA_SERVER_GROUP	ORA_NUM_22	DEC	22	0	Oracle monitoring: log. group of servers - DB proc. belongs
8	SERVER_SET	☐	ORA_SERVER_SET	ORA_NUM_22	DEC	22	0	Oracle monitoring: Log. set of servers
9	SERVER_NR	☐	ORA_SERVER_NR	ORA_NUM_22	DEC	22	0	Oracle monitoring: Log. nr. of cluster DB proc. within serv.
10	DEGREE	☐	ORA_DEGREE	ORA_DEC_22	DEC	22	0	Oracle monitoring: number of threads per instance for scan
11	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	20070813
SAP Release Created in	700