SAP Table ORA_S_GV_SQL
Oracle Monitoring: GV$SQL
ORA_S_GV_SQL (Oracle Monitoring: GV$SQL) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ORA_S_GV_SQL to other SAP tables.
ORA_S_GV_SQL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| INST_ID | Oracle monitor: Instance ID | ORA_INST_ID | DEC | 22 | 0 | |||
| SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ORA_SQL_TEXT | LCHR | 1000 | 0 | |||
| SQL_ID | Oracle monitoring: SQL_ID | ORA_SQL_ID | CHAR | 13 | 0 | |||
| SHARABLE_MEM | Oracle Monitoring: SHARABLE_MEM: Shared Memory Used | ORA_SHARABLE_MEM | DEC | 22 | 0 | |||
| PERSISTENT_MEM | Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim | ORA_PERSISTENT_MEM | DEC | 22 | 0 | |||
| RUNTIME_MEM | Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. | ORA_RUNTIME_MEM | DEC | 22 | 0 | |||
| SORTS | Oracle Monitoring: SORTS: Number of Sorts Done for cursor | ORA_SORTS | DEC | 22 | 0 | |||
| LOADED_VERSIONS | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | ORA_LOADED_VERSIONS | DEC | 22 | 0 | |||
| OPEN_VERSIONS | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | ORA_OPEN_VERSIONS | DEC | 22 | 0 | |||
| USERS_OPENING | Oracle Monitoring: USERS_OPENING: # of users executing SQL | ORA_USERS_OPENING | DEC | 22 | 0 | |||
| FETCHES | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | ORA_FETCHES | DEC | 22 | 0 | |||
| EXECUTIONS | Oracle Monitoring: EXECUTIONS: # Executions | ORA_EXECUTIONS | DEC | 22 | 0 | |||
| END_OF_FETCH_COUNT | Oracle montoring: End of Fetch Count | ORA_END_OF_FETCH_COUT | DEC | 22 | 0 | |||
| USERS_EXECUTING | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | ORA_USERS_EXECUTING | DEC | 22 | 0 | |||
| LOADS | Oracle Monitoring: # Times Object was Loaded or Reloaded | ORA_LOADS | DEC | 22 | 0 | |||
| FIRST_LOAD_TIME | Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation | ORA_FIRST_LOAD_TIME | CHAR | 19 | 0 | |||
| INVALIDATIONS | Oracle monitoring: # of times objects were marked invalid | ORA_INVALIDATIONS | DEC | 22 | 0 | |||
| PARSE_CALLS | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | ORA_PARSE_CALLS | DEC | 22 | 0 | |||
| DISK_READS | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | ORA_DISK_READS | DEC | 22 | 0 | |||
| DIRECT_WRITES | Oracle Monitoring: Oracle Direct Writes | ORA_DIRECT_WRITES | DEC | 22 | 0 | |||
| BUFFER_GETS | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | ORA_BUFFER_GETS | DEC | 22 | 0 | |||
| APPLICATION_WAIT_TIME | Oracle Monitoring: Application Wait Time | ORA_APPLICATION_WAIT_TIME | DEC | 22 | 0 | |||
| CONCURRENCY_WAIT_TIME | Oracle Monitoring: Concurrency Wait TIme | ORA_CONCURRENCY_WAIT_TIME | DEC | 22 | 0 | |||
| CLUSTER_WAIT_TIME | Oracle Monitoring: Cluster Wait Time | ORA_CLUSTER_WAIT_TIME | DEC | 22 | 0 | |||
| USER_IO_WAIT_TIME | Oracle Monitoring: User I/O Wait Time | ORA_USER_IO_WAIT_TIME | DEC | 22 | 0 | |||
| PLSQL_EXEC_TIME | Oracle Monitoring: PLSQL Exec Time | ORA_PLSQL_EXEC_TIME | DEC | 22 | 0 | |||
| JAVA_EXEC_TIME | Oracle Monitoring: Java Exec Time | ORA_JAVA_EXEC_TIME | DEC | 22 | 0 | |||
| ROWS_PROCESSED | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | ORA_ROWS_PROCESSED | DEC | 22 | 0 | |||
| COMMAND_TYPE | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | ORA_COMMAND_TYPE | DEC | 22 | 0 | |||
| OPTIMIZER_MODE | Oracle Monitoring: OPTIMIZER_MODE: Mode of SQL Execution | ORA_OPTIMIZER_MODE | CHAR | 10 | 0 | |||
| OPTIMIZER_COST | Oracle Monitoring: OPTIMIZER_COST: Cost of Execution | ORA_OPTIMIZER_COST | DEC | 22 | 0 | |||
| OPTIMIZER_ENV_HASH_VALUE | Oracle Monitoring: Optimizer Env Hash Value | ORA_OPTIMIZER_ENV_HASH_VALUE | DEC | 22 | 0 | |||
| PARSING_USER_ID | Oracle Monitoring: PARSING_USER_ID: 1st User having parsed | ORA_PARSING_USER_ID | DEC | 22 | 0 | |||
| PARSING_SCHEMA_ID | Oracle Monitoring: PARSING_SCHEMA_ID | ORA_PARSING_SCHEMA_ID | DEC | 22 | 0 | |||
| KEPT_VERSIONS | Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept | ORA_KEPT_VERSIONS | DEC | 22 | 0 | |||
| ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ORA_ADDRESS | RAW | 8 | 0 | |||
| TYPE_CHK_HEAP | Oracle Monitoring: TYPE_CHK_HEAP: Type Check Heap Descriptor | ORA_TYPE_CHK_HEAP | RAW | 8 | 0 | |||
| HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ORA_HASH_VALUE | DEC | 22 | 0 | |||
| OLD_HASH_VALUE | Oracle Monitoring: Old Hash Value | ORA_OLD_HASH_VALUE | DEC | 22 | 0 | |||
| PLAN_HASH_VALUE | Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan | ORA_PLAN_HASH_VALUE | DEC | 22 | 0 | |||
| CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ORA_CHILD_NUMBER | DEC | 22 | 0 | |||
| MODULE_NAME | Oracle Monitoring: Module for Version 10 | ORA_MODULE_V10 | CHAR | 64 | 0 | |||
| MODULE_HASH | Oracle monitoring: MODULE_HASH: curr. executing module hash | ORA_MODULE_HASH | DEC | 22 | 0 | |||
| ACTION | Oracle Monitoring: Action version 10 | ORA_ACTION_V10 | CHAR | 64 | 0 | |||
| ACTION_HASH | Oracle monitoring: ACTION: Currently executing action hash | ORA_ACTION_HASH | DEC | 22 | 0 | |||
| SERIALIZABLE_ABORTS | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | ORA_SERIALIZABLE_ABORTS | DEC | 22 | 0 | |||
| OUTLINE_CATEGORY | Oracle Monitoring: OUTLINE_CATEGORY: If outline, its catgory | ORA_OUTLINE_CATEGORY | CHAR | 64 | 0 | |||
| CPU_TIME | Oracle Monitoring: CPU_TIME | ORA_CPU_TIME | DEC | 22 | 0 | |||
| ELAPSED_TIME | Oracle Monitoring: ELAPSED_TIME: in microseconds | ORA_ELAPSED_TIME | DEC | 22 | 0 | |||
| OUTLINE_SID | Oracle Monitoring: OUTLINE_SID: Outline Session ID | ORA_OUTLINE_SID | DEC | 22 | 0 | |||
| CHILD_ADDRESS | Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor | ORA_CHILD_ADDRESS | RAW | 8 | 0 | |||
| SQLTYPE | Oracle Monitoring: SQLTYPE: SQL Version used | ORA_SQLTYPE | DEC | 22 | 0 | |||
| REMOTE | Oracle Monitoring: REMOTE: Is Remote Mapped? | ORA_REMOTE | CHAR | 1 | 0 | |||
| OBJECT_STATUS | Oracle Monitoring: OBJECT_STATUS | ORA_OBJECT_STATUS | CHAR | 19 | 0 | |||
| LITERAL_HASH_VALUE | Oracle Monitoring: LITERAL_HASH_VALUE: H val of replaced lit | ORA_LITERAL_HASH_VALUE | DEC | 22 | 0 | |||
| LAST_LOAD_TIME | Oracle Monitoring: LAST_LOAD_TIME | ORA_LAST_LOAD_TIME | CHAR | 19 | 0 | |||
| IS_OBSOLETE | Oracle Monitoring: IS_OBSOLETE | ORA_IS_OBSOLETE | CHAR | 1 | 0 | |||
| CHILD_LATCH | Oracle Monitoring: CHILD_LATCH: Child Latch Number | ORA_CHILD_LATCH | DEC | 22 | 0 | |||
| SQL_PROFILE | Oracle Monitoring: SQL Profile | ORA_SQL_PROFILE | CHAR | 64 | 0 | |||
| PROGRAM_ID | Oracle Monitoring: Program ID | ORA_PROGRAM_ID | DEC | 22 | 0 | |||
| PROGRAM_LINE_HASH | Oracle Monitoring: Program Line# | ORA_PROGRAM_LINE_HASH | DEC | 22 | 0 | |||
