GVD_WPTOTALINFO - Oracle Monitoring: Workprocess Information snapshot table
Oracle Monitoring: Workprocess Information snapshot table information is stored in SAP table GVD_WPTOTALINFO.
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_WPTOTALINFO
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| WP_SERVER | Oracle Monitoring: MSNAME: Servername | X | ORA_MSNAME | CHAR | 20 | |
| WP_NO | Oracle Monitoring: WPNO: Work process number | X | ORA_WPNO | CHAR | 2 | |
| WP_ITYPE | Oracle Monitoring: WPITYPE : Internal work process type | ORA_WPITYPE | INT1 | 1 | ||
| WP_TYP | Oracle Monitoring: WPTYP: Type | ORA_WPTYP | CHAR | 3 | ||
| WP_PID | Oracle Monitoring : WPPID: Work process PID | ORA_WPPID | CHAR | 8 | ||
| WP_ISTATUS | Oracle Monitoring: WPISTATUS: Work process status | ORA_WPISTATUS | INT1 | 1 | ||
| WP_STATUS | Oracle Monitoring: WPSTATUS: Work process status | ORA_WPSTATUS | CHAR | 7 | ||
| WP_IWAIT | Oracle Monitorign: WPIWAITING: Reason for wait | ORA_WPIWAITING | INT1 | 1 | ||
| WP_WAITING | Oracle Monitoring: WPWAITING: Work process is waiting | ORA_WPWAITING | CHAR | 5 | ||
| WP_SEM | Oracle Monitoring: WPSEM: Semaphore, for which the work proc | ORA_WPSEM | CHAR | 2 | ||
| WP_IRESTRT | Oracle Monitoring: WPIRESTART : Restart after error? | ORA_WPIRESTART | INT1 | 1 | ||
| WP_RESTART | Oracle Monitoring: WPRESTART: Restart work process after dum | ORA_WPRESTART | CHAR | 4 | ||
| WP_DUMPS | Oracle Monitoring: WPDUMPS: Number of dumps. | ORA_WPDUMPS | CHAR | 2 | ||
| WP_CPU | Oracle Monitoring: WPCPU: CPU | ORA_WPCPU | CHAR | 8 | ||
| WP_ELTIME | Oracle Monitoring: WPELZEIT: Previous execution time of requ | ORA_WPELZEIT | CHAR | 6 | ||
| WP_MANDT | Client | MANDT | CLNT | 3 | * | |
| WP_BNAME | Oracle Monitoring: WPBNAME: User currently served | ORA_WPBNAME | CHAR | 12 | ||
| WP_REPORT | Oracle Monitoring: WPREPORT: Report currently being executed | ORA_WPREPORT | CHAR | 40 | ||
| WP_IACTION | Oracle Monitoring: WPIACTION: Current activity of the work p | ORA_WPIACTION | INT1 | 1 | ||
| WP_ACTION | Oracle Monitoring: WPACTION: Currently activity of WP | ORA_WPACTION | CHAR | 25 | ||
| WP_TABLE | Oracle Monitoring: WPTABLE: DB table last accessed by the WP | ORA_WPTABLE | CHAR | 30 | ||
| WP_WAITINF | Oracle Monitoring: WPWAITINF: add. wait information | ORA_WPWAITINF | CHAR | 40 | ||
| WP_WAITTIM | Oracle Monitoring: WPWAITTIME: Time when waiting started | ORA_WPWAITTIME | CHAR | 8 | ||
| WP_SEMSTAT | Oracle Monitoring: WPITYPE : Internal work process type | ORA_WPITYPE | INT1 | 1 | ||
| WP_INDEX | Oracle Monitoring: ORA_WPINDEX: Index of work process | ORA_WPINDEX | INT4 | 4 | ||
| STARTDATE | Oracle Monitoring: Start date for dialog step | ORA_WPTOTINFSD | DATS | 8 | ||
| STARTTIME | Oracle Monitoring: Start time for dialog step | ORA_WPTOTINFST | TIMS | 6 | ||
| DYNPRONR | Oracle Monitoring: Screen number or transaction name | ORA_STA_DYNPNO | CHAR | 4 | ||
| TCODE | Oracle Monitoring: Transaction code | ORA_STA_TCODE4 | CHAR | 20 | * | |
| CUAPROGRAM | Oracle Monitoring: CUA program name | ORA_WPTOTINFCP | CHAR | 40 | ||
| FCODE | Oracle Monitoring: WPTOTINFFC:Function code | ORA_WPTOTINFFC | CHAR | 4 | ||
| BTCJOBNAME | Oracle Monitoring:BTCJOB: Background job name | ORA_BTCJOB | CHAR | 32 | ||
| BTCJOBCNT | Oracle Monitoring:_BTCJOBCNT:Job ID | ORA_BTCJOBCNT | CHAR | 8 | ||
| MEMSUM | Oracle Monitoring: MEMSUM: Extended memory | ORA_MEMSUM | DEC | 6 | ||
| PRIVSUM | Oracle Monitoring:Heap (private) Memory | ORA_PRIVSUM | DEC | 6 |