Data Element list used by SAP ABAP Table ORSQLAREA (DDIC Structure According to Oracle Table V$SQLAREA)
SAP ABAP Table
ORSQLAREA (DDIC Structure According to Oracle Table V$SQLAREA) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ORAACTION | Action name | ||
| 2 | ORAACTIONH | Hash value of action | ||
| 3 | ORAADDRESS | Address of statement in the cache | ||
| 4 | ORABUFFERG | Total number of "buffer gets" | ||
| 5 | ORACOMTYPE | Oracle command type definition | ||
| 6 | ORADISKR | Sum of all 'disk reads' | ||
| 7 | ORAEXECNUM | Total number of executions | ||
| 8 | ORAHASHVAL | Hash value of statement | ||
| 9 | ORAINVALID | Number of 'invalidations' for all versions | ||
| 10 | ORAKEPTVER | Indicator for using DBMS_SHARED_POOL | ||
| 11 | ORALOADS | Number of loads or reloads | ||
| 12 | ORALOADVER | Loaded cursor versions | ||
| 13 | ORALOAD_T | Time SQL statement loaded | ||
| 14 | ORAMODULE | Program Name | ||
| 15 | ORAMODULEH | Hash value of module | ||
| 16 | ORAOPENVER | Number of opened cursor versions | ||
| 17 | ORAOPTMODE | Optimizer mode | ||
| 18 | ORAPARSEC | Sum of all 'parse calls' | ||
| 19 | ORAPARSSCH | Schema ID | ||
| 20 | ORAPARSUSR | ID of the user who built this child cursor | ||
| 21 | ORAPERSMEM | Total 'persistent memory' | ||
| 22 | ORAROWPROC | Number of processed rows | ||
| 23 | ORARUNTMEM | Total "runtime memory" | ||
| 24 | ORASERIAL | Number of producing ORA-8177 | ||
| 25 | ORASHARMEM | Total shareable memory | ||
| 26 | ORASORTS | Sum of the number of sorts | ||
| 27 | ORASQLTEXT | Start of SQL statement | ||
| 28 | ORAUSREXEC | Number of users executing | ||
| 29 | ORAUSROPEN | Number of users who have opened cursor version | ||
| 30 | ORAVERSCOU | Number of children |