Data Element list used by SAP ABAP Table ORAV_SQL (DDIC Structure According to Oracle Table V$SQL)
SAP ABAP Table 
ORAV_SQL (DDIC Structure According to Oracle Table V$SQL) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
ORAACTION | Action name | |
| 2 | Data Element |
ORAACTIONH | Hash value of action | |
| 3 | Data Element |
ORAADDRESS | Address of statement in the cache | |
| 4 | Data Element |
ORACHILDNU | Number of child cursor | |
| 5 | Data Element |
ORACOMTYPE | Oracle command type definition | |
| 6 | Data Element |
ORACPUTIME | CPU Time in Miroseconds | |
| 7 | Data Element |
ORAELAPSED | Elapsed Time in Microseconds | |
| 8 | Data Element |
ORAHASHVAL | Hash value of statement | |
| 9 | Data Element |
ORAKEPTVER | Indicator for using DBMS_SHARED_POOL | |
| 10 | Data Element |
ORALASTLOA | Last Load Time | |
| 11 | Data Element |
ORALOADS | Number of loads or reloads | |
| 12 | Data Element |
ORALOAD_T | Time SQL statement loaded | |
| 13 | Data Element |
ORAMODULE | Program Name | |
| 14 | Data Element |
ORAMODULEH | Hash value of module | |
| 15 | Data Element |
ORAOPTCOST | Cost of this query | |
| 16 | Data Element |
ORAOPTMODE | Optimizer mode | |
| 17 | Data Element |
ORAPARSSCH | Schema ID | |
| 18 | Data Element |
ORAPARSUSR | ID of the user who built this child cursor | |
| 19 | Data Element |
ORAPLANHAS | Numerical Representation of the SQL Plan | |
| 20 | Data Element |
ORASERIAL | Number of producing ORA-8177 | |
| 21 | Data Element |
ORASQLTEXT | Start of SQL statement | |
| 22 | Data Element |
ORATYPECHK | Descriptor of type | |
| 23 | Data Element |
ORBUFFERG | Buffer gets for this child cursor | |
| 24 | Data Element |
ORDISKR | Disk reads for this child cursor | |
| 25 | Data Element |
OREXECNUM | Number of executions | |
| 26 | Data Element |
ORINVALID | Invalidations for this child cursor | |
| 27 | Data Element |
ORLOADVER | Context heap load flag | |
| 28 | Data Element |
OROPENVER | Flag for child cursors is locked | |
| 29 | Data Element |
ORPARSEC | Parse calls for this child cursor | |
| 30 | Data Element |
ORPERSMEM | Persistent memory | |
| 31 | Data Element |
ORROWPROC | Number of rows parsed | |
| 32 | Data Element |
ORRUNTMEM | Ephemeral frame used | |
| 33 | Data Element |
ORSHARMEM | Shareable memory | |
| 34 | Data Element |
ORSORTS | Number of sorts | |
| 35 | Data Element |
ORUSREXEC | Number of users executing | |
| 36 | Data Element |
ORUSROPEN | Number of users executing the statement |
