Data Element list used by SAP ABAP Table ORASQLAREA (DDIC Structure According to Oracle Table V$SQLAREA)
SAP ABAP Table 
ORASQLAREA (DDIC Structure According to Oracle Table V$SQLAREA) 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 |
ORABGPERE | Number of 'buffer gets' for each execution | |
| 5 | Data Element |
ORABGPERR | Number of 'buffer gets' for each row | |
| 6 | Data Element |
ORABUFFERG | Total number of "buffer gets" | |
| 7 | Data Element |
ORACHILDLA | Child Latch Number | |
| 8 | Data Element |
ORACOLFIEL | Field for controlling colors in ABAP List Viewer | |
| 9 | Data Element |
ORACOMTYPE | Oracle command type definition | |
| 10 | Data Element |
ORACPUTIME | CPU Time in Miroseconds | |
| 11 | Data Element |
ORACTPERE | CPU Time per Execution | |
| 12 | Data Element |
ORADISKR | Sum of all 'disk reads' | |
| 13 | Data Element |
ORADRPERE | Number of 'disk reads' for each execution | |
| 14 | Data Element |
ORAELAPERE | Elapsed Time per Execution | |
| 15 | Data Element |
ORAELAPSED | Elapsed Time in Microseconds | |
| 16 | Data Element |
ORAEXECNUM | Total number of executions | |
| 17 | Data Element |
ORAHASHVAL | Hash value of statement | |
| 18 | Data Element |
ORAINVALID | Number of 'invalidations' for all versions | |
| 19 | Data Element |
ORAKEPTVER | Indicator for using DBMS_SHARED_POOL | |
| 20 | Data Element |
ORALOADS | Number of loads or reloads | |
| 21 | Data Element |
ORALOADVER | Loaded cursor versions | |
| 22 | Data Element |
ORALOAD_T | Time SQL statement loaded | |
| 23 | Data Element |
ORAMODULE | Program Name | |
| 24 | Data Element |
ORAMODULEH | Hash value of module | |
| 25 | Data Element |
ORAOPENVER | Number of opened cursor versions | |
| 26 | Data Element |
ORAOPTMODE | Optimizer mode | |
| 27 | Data Element |
ORAPARSEC | Sum of all 'parse calls' | |
| 28 | Data Element |
ORAPARSSCH | Schema ID | |
| 29 | Data Element |
ORAPARSUSR | ID of the user who built this child cursor | |
| 30 | Data Element |
ORAPCPERE | Parse calls per execution | |
| 31 | Data Element |
ORAPERSMEM | Total 'persistent memory' | |
| 32 | Data Element |
ORAROWPROC | Number of processed rows | |
| 33 | Data Element |
ORARPPERE | Number of rows processed for each execution | |
| 34 | Data Element |
ORARUNTMEM | Total "runtime memory" | |
| 35 | Data Element |
ORASERIAL | Number of producing ORA-8177 | |
| 36 | Data Element |
ORASHARMEM | Total shareable memory | |
| 37 | Data Element |
ORASORTS | Sum of the number of sorts | |
| 38 | Data Element |
ORASQLTEXT | Start of SQL statement | |
| 39 | Data Element |
ORAUSER | Column USERNAME in V$SESSION | |
| 40 | Data Element |
ORAUSREXEC | Number of users executing | |
| 41 | Data Element |
ORAUSROPEN | Number of users who have opened cursor version | |
| 42 | Data Element |
ORAVERSCOU | Number of children | |
| 43 | Data Element |
ORAWAITTIM | Wait time | |
| 44 | Data Element |
ORAWTPERE | Wait Time per Execution |
