SAP Table GVD_SQL_WORKAREA
Oracle Monitoring: Copy of GV$SQL_WORKAREA
Unsere Literaturempfehlung
Kundeneigene Erweiterungen mit ABAP: User-Exits, klassische und neue BAdIs, Switch und Enhancement Framework
Alle Technologien in einem Band! Ob Sie zukunftssichere Erweiterungen programmieren oder mit den Modifikationen in Ihren SAP-Systemen aufräumen möchten – hier erhalten Sie das erforderliche Wissen. Jede Methode wird ausführlich und mit Codebeispielen erläutert: User-Exits, klassische und neue BAdIs, Business Transaction Events, implizite und explizite Erweiterungspunkte u. v. m.
Bei amazon.de ansehen →
The table GVD_SQL_WORKAREA (Oracle Monitoring: Copy of GV$SQL_WORKAREA) is a standard table in SAP ERP. It belongs to the package STUN.
Technical Information
| Table | GVD_SQL_WORKAREA |
| Short Text | Oracle Monitoring: Copy of GV$SQL_WORKAREA |
| Package | STUN |
| Table Type | Transparent Table |
Fields for Table GVD_SQL_WORKAREA
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | ✔ | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | ✔ | Oracle monitor: Instance ID | ORA_INST_ID | DEC | 22 | |
| WORKAREA_ADDRESS | ✔ | Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle | ORA_WORKAREA_ADDRESS | RAW | 8 | |
| ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ORA_ADDRESS | RAW | 8 | ||
| HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ORA_HASH_VALUE | DEC | 22 | ||
| CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ORA_CHILD_NUMBER | DEC | 22 | ||
| OPERATION_TYPE | Oracle Monitoring: OPERATION_TYPE | ORA_OPERATION_TYPE | CHAR | 20 | ||
| OPERATION_ID | Oracle Monitoring: OPERATION_ID | ORA_OPERATION_ID | DEC | 22 | ||
| POLICY | Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto) | ORA_POLICY | CHAR | 6 | ||
| ESTIMATED_OPTIMA | Oracle Monitoring: ESTIMATED_OPTIMAL_SIZE | ORA_ESTIMATED_OPTIMAL_SIZE | DEC | 22 | ||
| ESTIMATED_ONEPAS | Oracle Monitoring: ESTIMATED_ONEPASS_SIZE | ORA_ESTIMATED_ONEPASS_SIZE | DEC | 22 | ||
| LAST_MEMORY_USED | Oracle Monitoring: LAST_MEMORY_USED: Mem used for last exec | ORA_LAST_MEMORY_USED | DEC | 22 | ||
| LAST_EXECUTION | Oracle Monitoring: LAST_EXECUTION | ORA_LAST_EXECUTION | CHAR | 10 | ||
| LAST_DEGREE | Oracle Monitoring: LAST_DEGREE: Deg of Parallelism of last | ORA_LAST_DEGREE | DEC | 22 | ||
| TOTAL_EXECUTIONS | Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass | ORA_TOTAL_EXECUTIONS | DEC | 22 | ||
| OPTIMAL_EXECUTIO | Oracle Monitoring: OPTIMAL_EXECUTIONS | ORA_OPTIMAL_EXECUTIONS | DEC | 22 | ||
| ONEPASS_EXECUTIO | Oracle Monitoring: ONEPASS_EXECUTIONS | ORA_ONEPASS_EXECUTIONS | DEC | 22 | ||
| MULTIPASSES_EXEC | Oracle Monitoring: MULTIPASSES_EXECUTIONS | ORA_MULTIPASSES_EXECUTIONS | DEC | 22 | ||
| ACTIVE_TIME | Oracle Monitoring: ACTIVE_TIME: Average Active Time | ORA_ACTIVE_TIME | DEC | 22 | ||
| MAX_TEMPSEG_SIZE | Oracle Monitoring: MAX_TEMPSEG_SIZE | ORA_MAX_TEMPSEG_SIZE | DEC | 22 | ||
| LAST_TEMPSEG_SIZ | Oracle Monitoring: LAST_TEMPSEG_SIZE | ORA_LAST_TEMPSEG_SIZE | DEC | 22 |