SAP Table GVD_SQL
Copy of GV$SQL (currently not provided with snapshots)
Unsere Literaturempfehlung
ABAP Workbench - 100 Tipps & Tricks
Es gibt 100 gute Gründe, warum Sie dieses Buch kaufen sollten. Doch die verraten wir Ihnen hier nicht. Nur so viel: Wenn Sie die ABAP Workbench als Ihr zweites Wohnzimmer begreifen, ist dieses Buch genau das richtige für Sie! Die Mini-Tutorials in diesem Buch unterstützen Sie dabei, Software in ABAP effizienter zu entwickeln. Tipps und Tricks, wie Sie sich bei der Bearbeitung von Quelltext das Leben leichter machen, wie Sie häufig wiederkehrende Programmieraufgaben automatisieren oder umständliches Vorgehen früherer Tage endlich über Bord werfen. Sie werden die ABAP Workbench in einem ganz neuen Licht erleben. Eine klare Sprache, Klick-für-Klick-Anleitungen, Zusammenfassungen und Hervorhebungen sorgen dabei für einen schnellen und unkomplizierten Lernerfolg.
Bei amazon.de ansehen →
The table GVD_SQL (Copy of GV$SQL (currently not provided with snapshots)) is a standard table in SAP ERP. It belongs to the package STUN.
Technical Information
| Table | GVD_SQL |
| Short Text | Copy of GV$SQL (currently not provided with snapshots) |
| Package | STUN |
| Table Type | Transparent Table |
Fields for Table GVD_SQL
| 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 | |
| HASH_VALUE | ✔ | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ORA_HASH_VALUE | DEC | 22 | |
| CHILD_ADDRESS | ✔ | Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor | ORA_CHILD_ADDRESS | RAW | 8 | |
| SHARABLE_MEM | Oracle Monitoring: SHARABLE_MEM: Shared Memory Used | ORA_SHARABLE_MEM | DEC | 22 | ||
| PERSISTENT_MEM | Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim | ORA_PERSISTENT_MEM | DEC | 22 | ||
| RUNTIME_MEM | Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. | ORA_RUNTIME_MEM | DEC | 22 | ||
| SORTS | Oracle Monitoring: SORTS: Number of Sorts Done for cursor | ORA_SORTS | DEC | 22 | ||
| LOADED_VERSIONS | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | ORA_LOADED_VERSIONS | DEC | 22 | ||
| OPEN_VERSIONS | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | ORA_OPEN_VERSIONS | DEC | 22 | ||
| USERS_OPENING | Oracle Monitoring: USERS_OPENING: # of users executing SQL | ORA_USERS_OPENING | DEC | 22 | ||
| FETCHES | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | ORA_FETCHES | DEC | 22 | ||
| EXECUTIONS | Oracle Monitoring: EXECUTIONS: # Executions | ORA_EXECUTIONS | DEC | 22 | ||
| USERS_EXECUTING | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | ORA_USERS_EXECUTING | DEC | 22 | ||
| LOADS | Oracle Monitoring: # Times Object was Loaded or Reloaded | ORA_LOADS | DEC | 22 | ||
| FIRST_LOAD_TIME | Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation | ORA_FIRST_LOAD_TIME | CHAR | 19 | ||
| INVALIDATIONS | Oracle monitoring: # of times objects were marked invalid | ORA_SQL_INVALIDATIONS | DEC | 22 | ||
| PARSE_CALLS | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | ORA_PARSE_CALLS | DEC | 22 | ||
| DISK_READS | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | ORA_DISK_READS | DEC | 22 | ||
| BUFFER_GETS | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | ORA_BUFFER_GETS | DEC | 22 | ||
| ROWS_PROCESSED | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | ORA_ROWS_PROCESSED | DEC | 22 | ||
| COMMAND_TYPE | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | ORA_COMMAND_TYPE | DEC | 22 | ||
| OPTIMIZER_MODE | Oracle Monitoring: OPTIMIZER_MODE: Mode of SQL Execution | ORA_OPTIMIZER_MODE | CHAR | 10 | ||
| OPTIMIZER_COST | Oracle Monitoring: OPTIMIZER_COST: Cost of Execution | ORA_OPTIMIZER_COST | DEC | 22 | ||
| PARSING_USER_ID | Oracle Monitoring: PARSING_USER_ID: 1st User having parsed | ORA_PARSING_USER_ID | DEC | 22 | ||
| PARSING_SCHEMA_I | Oracle Monitoring: PARSING_SCHEMA_ID | ORA_PARSING_SCHEMA_ID | DEC | 22 | ||
| KEPT_VERSIONS | Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept | ORA_KEPT_VERSIONS | DEC | 22 | ||
| ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ORA_ADDRESS | RAW | 8 | ||
| TYPE_CHK_HEAP | Oracle Monitoring: TYPE_CHK_HEAP: Type Check Heap Descriptor | ORA_TYPE_CHK_HEAP | RAW | 8 | ||
| PLAN_HASH_VALUE | Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan | ORA_PLAN_HASH_VALUE | DEC | 22 | ||
| CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ORA_CHILD_NUMBER | DEC | 22 | ||
| SQL_MODULE | Oracle Monitoring: MODULE: Name of Module Causing Parsing | ORA_SQL_MODULE | CHAR | 64 | ||
| MODULE_HASH | Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module | ORA_SQL_MODULE_HASH | DEC | 22 | ||
| ACTION | Oracle Monitoring: ACTION | ORA_SQL_ACTION | CHAR | 64 | ||
| ACTION_HASH | Oracle Monitoring: ACTION_HASH: Hash Value of action | ORA_SQL_ACTION_HASH | DEC | 22 | ||
| SERIALIZABLE_ABO | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | ORA_SERIALIZABLE_ABORTS | DEC | 22 | ||
| OUTLINE_CATEGORY | Oracle Monitoring: OUTLINE_CATEGORY: If outline, its catgory | ORA_OUTLINE_CATEGORY | CHAR | 64 | ||
| CPU_TIME | Oracle Monitoring: CPU_TIME | ORA_CPU_TIME | DEC | 22 | ||
| ELAPSED_TIME | Oracle Monitoring: ELAPSED_TIME: in microseconds | ORA_ELAPSED_TIME | DEC | 22 | ||
| OUTLINE_SID | Oracle Monitoring: OUTLINE_SID: Outline Session ID | ORA_OUTLINE_SID | DEC | 22 | ||
| SQLTYPE | Oracle Monitoring: SQLTYPE: SQL Version used | ORA_SQLTYPE | DEC | 22 | ||
| REMOTE | Oracle Monitoring: REMOTE: Is Remote Mapped? | ORA_REMOTE | CHAR | 1 | ||
| OBJECT_STATUS | Oracle Monitoring: OBJECT_STATUS | ORA_OBJECT_STATUS | CHAR | 19 | ||
| LITERAL_HASH_VAL | Oracle Monitoring: LITERAL_HASH_VALUE: H val of replaced lit | ORA_LITERAL_HASH_VALUE | DEC | 22 | ||
| LAST_LOAD_TIME | Oracle Monitoring: LAST_LOAD_TIME | ORA_LAST_LOAD_TIME | CHAR | 19 | ||
| IS_OBSOLETE | Oracle Monitoring: IS_OBSOLETE | ORA_IS_OBSOLETE | CHAR | 1 | ||
| CHILD_LATCH | Oracle Monitoring: CHILD_LATCH: Child Latch Number | ORA_CHILD_LATCH | DEC | 22 | ||
| SQL_TXT_LENGTH | Oracle Monitoring: Field to store length of long char types | ORA_TEXT_LENGTH | INT4 | 10 | ||
| SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ORA_SQL_TEXT | LCHR | 1000 |