Data Element list used by SAP ABAP Table GORAV_SQL (Fields of GV$SQL + Derived Values)
SAP ABAP Table 
GORAV_SQL (Fields of GV$SQL + Derived Values) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
ORAACTION | Action name | |
| 2 | Data Element |
ORAACTIONHN | Hash Value of Action (DEC22) | |
| 3 | Data Element |
ORAADDRESS | Address of statement in the cache | |
| 4 | Data Element |
ORABGPERE | Number of 'buffer gets' for each execution | |
| 5 | Data Element |
ORABGPERR | Number of 'buffer gets' for each row | |
| 6 | Data Element |
ORACHILDNU | Number of child cursor | |
| 7 | Data Element |
ORACOLFIEL | Field for controlling colors in ABAP List Viewer | |
| 8 | Data Element |
ORACOMTYPE | Oracle command type definition | |
| 9 | Data Element |
ORACPUTIME | CPU Time in Miroseconds | |
| 10 | Data Element |
ORACTPERE | CPU Time per Execution | |
| 11 | Data Element |
ORADRPERE | Number of 'disk reads' for each execution | |
| 12 | Data Element |
ORAELAPERE | Elapsed Time per Execution | |
| 13 | Data Element |
ORAELAPSED | Elapsed Time in Microseconds | |
| 14 | Data Element |
ORAFETCHES | Total Number of Fetches | |
| 15 | Data Element |
ORAHASHVALN | Hash Value of Statement (DEC22) | |
| 16 | Data Element |
ORAINST_ID | Oracle Instance ID | |
| 17 | Data Element |
ORAKEPTVER | Indicator for using DBMS_SHARED_POOL | |
| 18 | Data Element |
ORALASTLOA | Last Load Time | |
| 19 | Data Element |
ORALOADS | Number of loads or reloads | |
| 20 | Data Element |
ORALOAD_T | Time SQL statement loaded | |
| 21 | Data Element |
ORAMODULE | Program Name | |
| 22 | Data Element |
ORAMODULEHN | Hash Value of Module (DEC22) | |
| 23 | Data Element |
ORAOPTCOST | Cost of this query | |
| 24 | Data Element |
ORAOPTMODE | Optimizer mode | |
| 25 | Data Element |
ORAPARSSCH | Schema ID | |
| 26 | Data Element |
ORAPARSUSR | ID of the user who built this child cursor | |
| 27 | Data Element |
ORAPCPERE | Parse calls per execution | |
| 28 | Data Element |
ORAPLANHAS | Numerical Representation of the SQL Plan | |
| 29 | Data Element |
ORARPPERE | Number of rows processed for each execution | |
| 30 | Data Element |
ORASERIAL | Number of producing ORA-8177 | |
| 31 | Data Element |
ORASQLTEXT | Start of SQL statement | |
| 32 | Data Element |
ORATYPECHK | Descriptor of type | |
| 33 | Data Element |
ORAUSER | Column USERNAME in V$SESSION | |
| 34 | Data Element |
ORAWAITTIM | Wait time | |
| 35 | Data Element |
ORAWTPERE | Wait Time per Execution | |
| 36 | Data Element |
ORBUFFERG | Buffer gets for this child cursor | |
| 37 | Data Element |
ORDISKR | Disk reads for this child cursor | |
| 38 | Data Element |
OREXECNUM | Number of executions | |
| 39 | Data Element |
ORINVALID | Invalidations for this child cursor | |
| 40 | Data Element |
ORLOADVER | Context heap load flag | |
| 41 | Data Element |
OROPENVER | Flag for child cursors is locked | |
| 42 | Data Element |
ORPARSEC | Parse calls for this child cursor | |
| 43 | Data Element |
ORPERSMEM | Persistent memory | |
| 44 | Data Element |
ORROWPROC | Number of rows parsed | |
| 45 | Data Element |
ORRUNTMEM | Ephemeral frame used | |
| 46 | Data Element |
ORSHARMEM | Shareable memory | |
| 47 | Data Element |
ORSORTS | Number of sorts | |
| 48 | Data Element |
ORUSREXEC | Number of users executing | |
| 49 | Data Element |
ORUSROPEN | Number of users executing the statement |
