GVD_PX_SESSION - Oracle monitoring: Copy of GV$PX_SESSION
Oracle monitoring: Copy of GV$PX_SESSION information is stored in SAP table GVD_PX_SESSION.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table GVD_PX_SESSION
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
| SADDR | Oracle monitoring: Session address | X | ORA_SADDR | RAW | 8 | |
| SID | Oracle monitoring: SID (Session) | X | ORA_SID | DEC | 12 | |
| SERIAL_NR | Oracle monitoring: Session serial number | ORA_SERIAL_NR | DEC | 12 | ||
| QCSID | Oracle Monitoring: QCSID: Query Coordinator Session ID | ORA_QCSID | DEC | 12 | ||
| QCSERIAL_NR | Oracle monitoring: Session serial nr of the parallel coordin | ORA_QCSERIAL_NR | DEC | 12 | ||
| QCINST_ID | Oracle Monitoring: QCINST_ID: Query Coordinator ID | ORA_QCINST_ID | DEC | 12 | ||
| SERVER_GROUP | Oracle monitoring: log. group of servers - DB proc. belongs | ORA_SERVER_GROUP | DEC | 12 | ||
| SERVER_SET | Oracle monitoring: Log. set of servers | ORA_SERVER_SET | DEC | 12 | ||
| SERVER_NR | Oracle monitoring: Log. nr. of cluster DB proc. within serv. | ORA_SERVER_NR | DEC | 12 | ||
| DEGREE | Oracle monitoring: number of threads per instance for scan | ORA_DEGREE | DEC | 12 | ||
| REQ_DEGREE | Oracle monitoring: degree of parallelism that was requested | ORA_REQ_DEGREE | DEC | 12 |