GVD_SQL - Copy of GV$SQL (currently not provided with snapshots)
Copy of GV$SQL (currently not provided with snapshots) information is stored in SAP table GVD_SQL.
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_SQL
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 | |
| HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | X | ORA_HASH_VALUE | DEC | 12 | |
| CHILD_ADDRESS | Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor | X | ORA_CHILD_ADDRESS | RAW | 8 | |
| SHARABLE_MEM | Oracle Monitoring: SHARABLE_MEM: Shared Memory Used | ORA_SHARABLE_MEM | DEC | 12 | ||
| PERSISTENT_MEM | Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim | ORA_PERSISTENT_MEM | DEC | 12 | ||
| RUNTIME_MEM | Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. | ORA_RUNTIME_MEM | DEC | 12 | ||
| SORTS | Oracle Monitoring: SORTS: Number of Sorts Done for cursor | ORA_SORTS | DEC | 12 | ||
| LOADED_VERSIONS | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | ORA_LOADED_VERSIONS | DEC | 12 | ||
| OPEN_VERSIONS | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | ORA_OPEN_VERSIONS | DEC | 12 | ||
| USERS_OPENING | Oracle Monitoring: USERS_OPENING: # of users executing SQL | ORA_USERS_OPENING | DEC | 12 | ||
| FETCHES | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | ORA_FETCHES | DEC | 12 | ||
| EXECUTIONS | Oracle Monitoring: EXECUTIONS: # Executions | ORA_EXECUTIONS | DEC | 12 | ||
| USERS_EXECUTING | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | ORA_USERS_EXECUTING | DEC | 12 | ||
| LOADS | Oracle Monitoring: # Times Object was Loaded or Reloaded | ORA_LOADS | DEC | 12 | ||
| 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 | 12 | ||
| PARSE_CALLS | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | ORA_PARSE_CALLS | DEC | 12 | ||
| DISK_READS | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | ORA_DISK_READS | DEC | 12 | ||
| BUFFER_GETS | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | ORA_BUFFER_GETS | DEC | 12 | ||
| ROWS_PROCESSED | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | ORA_ROWS_PROCESSED | DEC | 12 | ||
| COMMAND_TYPE | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | ORA_COMMAND_TYPE | DEC | 12 | ||
| 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 | 12 | ||
| PARSING_USER_ID | Oracle Monitoring: PARSING_USER_ID: 1st User having parsed | ORA_PARSING_USER_ID | DEC | 12 | ||
| PARSING_SCHEMA_I | Oracle Monitoring: PARSING_SCHEMA_ID | ORA_PARSING_SCHEMA_ID | DEC | 12 | ||
| KEPT_VERSIONS | Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept | ORA_KEPT_VERSIONS | DEC | 12 | ||
| 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 | 12 | ||
| CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ORA_CHILD_NUMBER | DEC | 12 | ||
| 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 | 12 | ||
| ACTION | Oracle Monitoring: ACTION | ORA_SQL_ACTION | CHAR | 64 | ||
| ACTION_HASH | Oracle Monitoring: ACTION_HASH: Hash Value of action | ORA_SQL_ACTION_HASH | DEC | 12 | ||
| SERIALIZABLE_ABO | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | ORA_SERIALIZABLE_ABORTS | DEC | 12 | ||
| 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 | 12 | ||
| ELAPSED_TIME | Oracle Monitoring: ELAPSED_TIME: in microseconds | ORA_ELAPSED_TIME | DEC | 12 | ||
| OUTLINE_SID | Oracle Monitoring: OUTLINE_SID: Outline Session ID | ORA_OUTLINE_SID | DEC | 12 | ||
| SQLTYPE | Oracle Monitoring: SQLTYPE: SQL Version used | ORA_SQLTYPE | DEC | 12 | ||
| 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 | 12 | ||
| 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 | 12 | ||
| SQL_TXT_LENGTH | Oracle Monitoring: Field to store length of long char types | ORA_TEXT_LENGTH | INT4 | 4 | ||
| SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ORA_SQL_TEXT | LCHR | 1000 |