GVD_PROCESS - Copy of GV$PROCESS
Copy of GV$PROCESS information is stored in SAP table GVD_PROCESS.
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_PROCESS
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 | |
ADDR | Oracle monitoring: ADDR | X | ORA_ADDR | RAW | 8 | |
PID | Oracle monitoring: PID | X | ORA_PID | DEC | 12 | |
SPID | Oracle monitoring: Operating system process identifier | ORA_SPID | CHAR | 12 | ||
USERNAME | Oracle monitoring: USERNAME: Oracle username | ORA_USERNAME | CHAR | 30 | ||
SERIAL | Oracle monitoring: SERIAL#: Session serial number | ORA_SERIAL | DEC | 12 | ||
TERMINAL | Oracle monitoring: MACHINE: Operating system machine name | ORA_TERMINAL | CHAR | 30 | ||
PROGRAM_OS | Oracle monitoring: PROGRAM: Operating system program name | ORA_PROGRAM | CHAR | 48 | ||
TRACEID | Oracle monitoring: Trace file identifier | ORA_TRACEID | CHAR | 255 | ||
BACKGROUND | Oracle monitoring: Background/Normal process | ORA_BACKGROUND | CHAR | 1 | ||
LATCHWAIT | Oracle monitoring: @ of latch the process is waiting for | ORA_LATCHWAIT | CHAR | 8 | ||
LATCHSPIN | Oracle monitoring: @ of latch the process is spinning on | ORA_LATCHSPIN | CHAR | 8 | ||
PGA_USED_MEM | Oracle monitoring: PGA memory currently used by the process | ORA_PGA_USED_MEM | DEC | 12 | ||
PGA_ALLOC_MEM | Oracle monitoring: PGA memory allocated by the process | ORA_PGA_ALLOC_MEM | DEC | 12 | ||
PGA_FREEABLE_MEM | Oracle monitoring: Allocated PGA memory which can be freed | ORA_PGA_FREEABLE_MEM | DEC | 12 | ||
PGA_MAX_MEM | Oracle monitoring: Max PGA memory allocated by the process | ORA_PGA_MAX_MEM | DEC | 12 |