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 | 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 | ORABUFFERG | Total number of "buffer gets" | |
5 | Data Element | ORACOMTYPE | Oracle command type definition | |
6 | Data Element | ORADISKR | Sum of all 'disk reads' | |
7 | Data Element | ORAEXECNUM | Total number of executions | |
8 | Data Element | ORAHASHVAL | Hash value of statement | |
9 | Data Element | ORAINVALID | Number of 'invalidations' for all versions | |
10 | Data Element | ORAKEPTVER | Indicator for using DBMS_SHARED_POOL | |
11 | Data Element | ORALOADS | Number of loads or reloads | |
12 | Data Element | ORALOADVER | Loaded cursor versions | |
13 | Data Element | ORALOAD_T | Time SQL statement loaded | |
14 | Data Element | ORAMODULE | Program Name | |
15 | Data Element | ORAMODULEH | Hash value of module | |
16 | Data Element | ORAOPENVER | Number of opened cursor versions | |
17 | Data Element | ORAOPTMODE | Optimizer mode | |
18 | Data Element | ORAPARSEC | Sum of all 'parse calls' | |
19 | Data Element | ORAPARSSCH | Schema ID | |
20 | Data Element | ORAPARSUSR | ID of the user who built this child cursor | |
21 | Data Element | ORAPERSMEM | Total 'persistent memory' | |
22 | Data Element | ORAROWPROC | Number of processed rows | |
23 | Data Element | ORARUNTMEM | Total "runtime memory" | |
24 | Data Element | ORASERIAL | Number of producing ORA-8177 | |
25 | Data Element | ORASHARMEM | Total shareable memory | |
26 | Data Element | ORASORTS | Sum of the number of sorts | |
27 | Data Element | ORASQLTEXT | Start of SQL statement | |
28 | Data Element | ORAUSREXEC | Number of users executing | |
29 | Data Element | ORAUSROPEN | Number of users who have opened cursor version | |
30 | Data Element | ORAVERSCOU | Number of children |