SAP Table GORAV_SQL
Fields of GV$SQL + Derived Values
GORAV_SQL (Fields of GV$SQL + Derived Values) 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 GORAV_SQL to other SAP tables.
GORAV_SQL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| INST_ID | Oracle Instance ID | ORAINST_ID | INT4 | 10 | 0 | |||
| SQL_TEXT | Start of SQL statement | ORASQLTEXT | CHAR | 60 | 0 | |||
| SHARABLE_MEM | Shareable memory | ORSHARMEM | INT4 | 10 | 0 | |||
| PERSISTENT_MEM | Persistent memory | ORPERSMEM | INT4 | 10 | 0 | |||
| RUNTIME_MEM | Ephemeral frame used | ORRUNTMEM | INT4 | 10 | 0 | |||
| SORTS | Number of sorts | ORSORTS | INT4 | 10 | 0 | |||
| LOADED_VERSIONS | Context heap load flag | ORLOADVER | INT4 | 10 | 0 | |||
| OPEN_VERSIONS | Flag for child cursors is locked | OROPENVER | INT4 | 10 | 0 | |||
| USERS_OPENING | Number of users executing the statement | ORUSROPEN | INT4 | 10 | 0 | |||
| EXECUTIONS | Number of executions | OREXECNUM | DEC | 31 | 0 | |||
| FETCHES | Total Number of Fetches | ORAFETCHES | DEC | 31 | 0 | |||
| USERS_EXECUTING | Number of users executing | ORUSREXEC | INT4 | 10 | 0 | |||
| LOADS | Number of loads or reloads | ORALOADS | INT4 | 10 | 0 | |||
| FIRST_LOAD_TIME | Time SQL statement loaded | ORALOAD_T | CHAR | 19 | 0 | |||
| INVALIDATIONS | Invalidations for this child cursor | ORINVALID | INT4 | 10 | 0 | |||
| PARSE_CALLS | Parse calls for this child cursor | ORPARSEC | INT4 | 10 | 0 | |||
| DISK_READS | Disk reads for this child cursor | ORDISKR | DEC | 31 | 0 | |||
| BUFFER_GETS | Buffer gets for this child cursor | ORBUFFERG | DEC | 31 | 0 | |||
| ROWS_PROCESSED | Number of rows parsed | ORROWPROC | DEC | 31 | 0 | |||
| COMMAND_TYPE | Oracle command type definition | ORACOMTYPE | INT4 | 10 | 0 | |||
| OPTIMIZER_MODE | Optimizer mode | ORAOPTMODE | CHAR | 10 | 0 | |||
| OPTIMIZER_COST | Cost of this query | ORAOPTCOST | INT4 | 10 | 0 | |||
| PARSING_USER_ID | ID of the user who built this child cursor | ORAPARSUSR | INT4 | 10 | 0 | |||
| PARSING_SCHEMA_ID | Schema ID | ORAPARSSCH | INT4 | 10 | 0 | |||
| KEPT_VERSIONS | Indicator for using DBMS_SHARED_POOL | ORAKEPTVER | INT4 | 10 | 0 | |||
| ADDRESS | Address of statement in the cache | ORAADDRESS | CHAR | 16 | 0 | |||
| TYPE_CHK_HEAP | Descriptor of type | ORATYPECHK | RAW | 4 | 0 | |||
| HASH_VALUE | Hash Value of Statement (DEC22) | ORAHASHVALN | DEC | 22 | 0 | |||
| PLAN_HASH_VALUE | Numerical Representation of the SQL Plan | ORAPLANHAS | INT4 | 10 | 0 | |||
| CHILD_NUMBER | Number of child cursor | ORACHILDNU | INT4 | 10 | 0 | |||
| MODULE | Program Name | ORAMODULE | CHAR | 64 | 0 | |||
| MODULE_HASH | Hash Value of Module (DEC22) | ORAMODULEHN | DEC | 22 | 0 | |||
| ACTION | Action name | ORAACTION | CHAR | 64 | 0 | |||
| ACTION_HASH | Hash Value of Action (DEC22) | ORAACTIONHN | DEC | 22 | 0 | |||
| SERIALIZABLE_ABORTS | Number of producing ORA-8177 | ORASERIAL | INT4 | 10 | 0 | |||
| CPU_TIME | CPU Time in Miroseconds | ORACPUTIME | DEC | 31 | 0 | |||
| ELAPSED_TIME | Elapsed Time in Microseconds | ORAELAPSED | DEC | 31 | 0 | |||
| DB_USER | Column USERNAME in V$SESSION | ORAUSER | CHAR | 10 | 0 | |||
| OUTLINE_CATEGORY | CHAR | 64 | 0 | |||||
| OUTLINE_SID | FLTP | 16 | 16 | |||||
| LAST_LOAD_TIME | Last Load Time | ORALASTLOA | CHAR | 19 | 0 | |||
| END_FETCH_CNT | DEC | 31 | 0 | |||||
| PLSQL_EXEC_TIME | DEC | 31 | 0 | |||||
| DIRECT_WRITES | DEC | 31 | 0 | |||||
| SQL_ID | CHAR | 13 | 0 | |||||
| LAST_ACTIVE_TIME | CHAR | 19 | 0 | |||||
| APPLICATION_WAIT_TIME | DEC | 31 | 0 | |||||
| CONCURRENCY_WAIT_TIME | DEC | 31 | 0 | |||||
| CLUSTER_WAIT_TIME | DEC | 31 | 0 | |||||
| USER_IO_WAIT_TIME | DEC | 31 | 0 | |||||
| SQL_FULLTEXT | STRG | 0 | 0 | |||||
| DISK_READS_PER_EXEC | Number of 'disk reads' for each execution | ORADRPERE | DEC | 31 | 1 | |||
| BUFFER_GETS_PER_EXEC | Number of 'buffer gets' for each execution | ORABGPERE | DEC | 31 | 1 | |||
| PARSE_CALLS_PER_EXEC | Parse calls per execution | ORAPCPERE | DEC | 31 | 1 | |||
| ROWS_PROCESSED_PER_EXEC | Number of rows processed for each execution | ORARPPERE | DEC | 31 | 1 | |||
| BUFFER_GETS_PER_ROW | Number of 'buffer gets' for each row | ORABGPERR | DEC | 31 | 1 | |||
| WAIT_TIME | Wait time | ORAWAITTIM | DEC | 31 | 0 | |||
| CPU_TIME_PER_EXEC | CPU Time per Execution | ORACTPERE | DEC | 31 | 1 | |||
| ELAPSED_TIME_PER_EXEC | Elapsed Time per Execution | ORAELAPERE | DEC | 31 | 1 | |||
| WAIT_TIME_PER_EXEC | Wait Time per Execution | ORAWTPERE | DEC | 31 | 1 | |||
| APPL_WAIT_TIME_PER_EXEC | DEC | 31 | 0 | |||||
| CONC_WAIT_TIME_PER_EXEC | DEC | 31 | 0 | |||||
| CLUST_WAIT_TIME_PER_EXEC | DEC | 31 | 0 | |||||
| USER_IO_WAIT_TIME_PER_EXEC | DEC | 31 | 0 | |||||
| PLSQL_TIME_PER_EXEC | DEC | 31 | 0 | |||||
| COLFIELD | Field for controlling colors in ABAP List Viewer | ORACOLFIEL | CHAR | 3 | 0 | |||
