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 |