SAP GVD_PX_SESSION table - Oracle monitoring: Copy of GV$PX_SESSION details in SAP


SAP GVD_PX_SESSION table summary

Object Name: GVD_PX_SESSION
Dictionary Type: Transparent table
Description: Oracle monitoring: Copy of GV$PX_SESSION


Field list for GVD_PX_SESSION table on an S/4 SAP system

Details
GVD_PX_SESSION-SNAPSHOT_ID table field - Oracle monitor: snapshot ID

Description: Oracle monitor: snapshot ID
Field Name: SNAPSHOT_ID
Data Element: ORA_SNAPSHOT_ID
Data Type: NUMC
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: ORA_SNAPSHOT_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPSHOT_ID

GVD_PX_SESSION-INST_ID table field - Oracle monitor: Instance ID

Description: Oracle monitor: Instance ID
Field Name: INST_ID
Data Element: ORA_INST_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_INST_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INST_ID

GVD_PX_SESSION-SADDR table field - Oracle monitoring: Session address

Description: Oracle monitoring: Session address
Field Name: SADDR
Data Element: ORA_SADDR
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_SADDR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SADDR

GVD_PX_SESSION-SID table field - Oracle monitoring: SID (Session)

Description: Oracle monitoring: SID (Session)
Field Name: SID
Data Element: ORA_SID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SID

GVD_PX_SESSION-SERIAL_NR table field - Oracle monitoring: Session serial number

Description: Oracle monitoring: Session serial number
Field Name: SERIAL_NR
Data Element: ORA_SERIAL_NR
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SERIAL_NR

GVD_PX_SESSION-QCSID table field - Oracle Monitoring: QCSID: Query Coordinator Session ID

Description: Oracle Monitoring: QCSID: Query Coordinator Session ID
Field Name: QCSID
Data Element: ORA_QCSID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QCSID

GVD_PX_SESSION-QCSERIAL_NR table field - Oracle monitoring: Session serial nr of the parallel coordin

Description: Oracle monitoring: Session serial nr of the parallel coordin
Field Name: QCSERIAL_NR
Data Element: ORA_QCSERIAL_NR
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QCSERIAL_NR

GVD_PX_SESSION-QCINST_ID table field - Oracle Monitoring: QCINST_ID: Query Coordinator ID

Description: Oracle Monitoring: QCINST_ID: Query Coordinator ID
Field Name: QCINST_ID
Data Element: ORA_QCINST_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QCINST_ID

GVD_PX_SESSION-SERVER_GROUP table field - Oracle monitoring: log. group of servers - DB proc. belongs

Description: Oracle monitoring: log. group of servers - DB proc. belongs
Field Name: SERVER_GROUP
Data Element: ORA_SERVER_GROUP
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SERVER_GROUP

GVD_PX_SESSION-SERVER_SET table field - Oracle monitoring: Log. set of servers

Description: Oracle monitoring: Log. set of servers
Field Name: SERVER_SET
Data Element: ORA_SERVER_SET
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SERVER_SET

GVD_PX_SESSION-SERVER_NR table field - Oracle monitoring: Log. nr. of cluster DB proc. within serv.

Description: Oracle monitoring: Log. nr. of cluster DB proc. within serv.
Field Name: SERVER_NR
Data Element: ORA_SERVER_NR
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SERVER_NR

GVD_PX_SESSION-DEGREE table field - Oracle monitoring: number of threads per instance for scan

Description: Oracle monitoring: number of threads per instance for scan
Field Name: DEGREE
Data Element: ORA_DEGREE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEGREE

GVD_PX_SESSION-REQ_DEGREE table field - Oracle monitoring: degree of parallelism that was requested

Description: Oracle monitoring: degree of parallelism that was requested
Field Name: REQ_DEGREE
Data Element: ORA_REQ_DEGREE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_DEGREE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table