Data Element list used by SAP ABAP Table GORAV_SQL_SELECT (Structure Corresponding to Oracle Table GV$SQL)
SAP ABAP Table
GORAV_SQL_SELECT (Structure Corresponding to Oracle Table GV$SQL) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ORAACTION | Action name | ||
| 2 | ORAADDRESS | Address of statement in the cache | ||
| 3 | ORACPUTIME | CPU Time in Miroseconds | ||
| 4 | ORAELAPSED | Elapsed Time in Microseconds | ||
| 5 | ORAFETCHES | Total Number of Fetches | ||
| 6 | ORAHASHVAL | Hash value of statement | ||
| 7 | ORAINST_ID | Oracle Instance ID | ||
| 8 | ORALASTLOA | Last Load Time | ||
| 9 | ORALOADS | Number of loads or reloads | ||
| 10 | ORALOAD_T | Time SQL statement loaded | ||
| 11 | ORAMODULE | Program Name | ||
| 12 | ORAPARSUSR | ID of the user who built this child cursor | ||
| 13 | ORASQLTEXT | Start of SQL statement | ||
| 14 | ORBUFFERG | Buffer gets for this child cursor | ||
| 15 | ORDISKR | Disk reads for this child cursor | ||
| 16 | OREXECNUM | Number of executions | ||
| 17 | ORINVALID | Invalidations for this child cursor | ||
| 18 | ORLOADVER | Context heap load flag | ||
| 19 | OROPENVER | Flag for child cursors is locked | ||
| 20 | ORPARSEC | Parse calls for this child cursor | ||
| 21 | ORPERSMEM | Persistent memory | ||
| 22 | ORROWPROC | Number of rows parsed | ||
| 23 | ORRUNTMEM | Ephemeral frame used | ||
| 24 | ORSHARMEM | Shareable memory | ||
| 25 | ORSORTS | Number of sorts | ||
| 26 | ORUSREXEC | Number of users executing | ||
| 27 | ORUSROPEN | Number of users executing the statement |