Data Element list used by SAP ABAP Table ORASAREA_A (Structure for Field Catalog Creation "Cursor Cache Stats")
SAP ABAP Table
ORASAREA_A (Structure for Field Catalog Creation "Cursor Cache Stats") is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ORABGPERE | Number of 'buffer gets' for each execution | ||
| 2 | ORABGPERR | Number of 'buffer gets' for each row | ||
| 3 | ORABUFFERG | Total number of "buffer gets" | ||
| 4 | ORACPUTIME | CPU Time in Miroseconds | ||
| 5 | ORACTPERE | CPU Time per Execution | ||
| 6 | ORACURREX | Number of users executing this cursor | ||
| 7 | ORADISKR | Sum of all 'disk reads' | ||
| 8 | ORADRPERE | Number of 'disk reads' for each execution | ||
| 9 | ORAELAPERE | Elapsed Time per Execution | ||
| 10 | ORAELAPSED | Elapsed Time in Microseconds | ||
| 11 | ORAEXECNUM | Total number of executions | ||
| 12 | ORAINVALID | Number of 'invalidations' for all versions | ||
| 13 | ORALOADS | Number of loads or reloads | ||
| 14 | ORALOADVER | Loaded cursor versions | ||
| 15 | ORALOAD_T | Time SQL statement loaded | ||
| 16 | ORAMODULE | Program Name | ||
| 17 | ORAOPENVER | Number of opened cursor versions | ||
| 18 | ORAPARSEC | Sum of all 'parse calls' | ||
| 19 | ORAPERSMEM | Total 'persistent memory' | ||
| 20 | ORAROWPROC | Number of processed rows | ||
| 21 | ORARPPERE | Number of rows processed for each execution | ||
| 22 | ORARUNTMEM | Total "runtime memory" | ||
| 23 | ORASHARMEM | Total shareable memory | ||
| 24 | ORASQLSORT | Sort orders | ||
| 25 | ORASQLTEXT | Start of SQL statement | ||
| 26 | ORAUSER | Column USERNAME in V$SESSION | ||
| 27 | ORAUSROPEN | Number of users who have opened cursor version | ||
| 28 | ORAWAITTIM | Wait time | ||
| 29 | ORAWTPERE | Wait Time per Execution |