Table/Structure Field list used by SAP ABAP TYPE ORAS (ORAS)
SAP ABAP TYPE 
ORAS (ORAS) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
ORASESSION - STATUS | Status of Session (Active, Inactive, Killed) | |
| 2 | Table/Structure Field |
ORASQLADER - BUFFGPER_E | Number of 'buffer gets' for each execution | |
| 3 | Table/Structure Field |
ORASQLADER - BUFFGPER_R | Number of 'buffer gets' for each row | |
| 4 | Table/Structure Field |
ORASQLADER - CPU_TIME_E | CPU Time per Execution | |
| 5 | Table/Structure Field |
ORASQLADER - DISKRPER_E | Number of 'disk reads' for each execution | |
| 6 | Table/Structure Field |
ORASQLADER - ELAPSEDTIE | Elapsed Time per Execution | |
| 7 | Table/Structure Field |
ORASQLADER - PARSCPER_E | Parse calls per execution | |
| 8 | Table/Structure Field |
ORASQLADER - ROWSPPER_E | Number of rows processed for each execution | |
| 9 | Table/Structure Field |
ORASQLADER - WAITTIME_E | Wait Time per Execution | |
| 10 | Table/Structure Field |
ORASQLADER - WAIT_TIME | Wait time | |
| 11 | Table/Structure Field |
ORASQLAREA - ROWSPPER_E | Number of rows processed for each execution | |
| 12 | Table/Structure Field |
ORASQLAREA - MODULE | Program Name | |
| 13 | Table/Structure Field |
ORASQLAREA - PERSISTENT | Total 'persistent memory' | |
| 14 | Table/Structure Field |
ORASQLAREA - PARSING_US | ID of the user who built this child cursor | |
| 15 | Table/Structure Field |
ORASQLAREA - PARSING_SC | Schema ID | |
| 16 | Table/Structure Field |
ORASQLAREA - PARSE_CALL | Sum of all 'parse calls' | |
| 17 | Table/Structure Field |
ORASQLAREA - PARSCPER_E | Parse calls per execution | |
| 18 | Table/Structure Field |
ORASQLAREA - OPTIM_MODE | Optimizer mode | |
| 19 | Table/Structure Field |
ORASQLAREA - OPEN_VERSI | Number of opened cursor versions | |
| 20 | Table/Structure Field |
ORASQLAREA - MODULE_HAS | Hash value of module | |
| 21 | Table/Structure Field |
ORASQLAREA - SORTS | Sum of the number of sorts | |
| 22 | Table/Structure Field |
ORASQLAREA - ROWS_PROCE | Number of processed rows | |
| 23 | Table/Structure Field |
ORASQLAREA - RUNTIME_ME | Total "runtime memory" | |
| 24 | Table/Structure Field |
ORASQLAREA - SERIALIZAB | Number of producing ORA-8177 | |
| 25 | Table/Structure Field |
ORASQLAREA - SHARABLE_M | Total shareable memory | |
| 26 | Table/Structure Field |
ORASQLAREA - SQL_TEXT | Start of SQL statement | |
| 27 | Table/Structure Field |
ORASQLAREA - USERS_EXEC | Number of users executing | |
| 28 | Table/Structure Field |
ORASQLAREA - USERS_OPEN | Number of users who have opened cursor version | |
| 29 | Table/Structure Field |
ORASQLAREA - VERSION_CO | Number of children | |
| 30 | Table/Structure Field |
ORASQLAREA - WAITTIME_E | Wait Time per Execution | |
| 31 | Table/Structure Field |
ORASQLAREA - WAIT_TIME | Wait time | |
| 32 | Table/Structure Field |
ORASQLAREA - LOADED_VER | Loaded cursor versions | |
| 33 | Table/Structure Field |
ORASQLAREA - LOADS | Number of loads or reloads | |
| 34 | Table/Structure Field |
ORASQLAREA - ACTION | Action name | |
| 35 | Table/Structure Field |
ORASQLAREA - ACTION_HAS | Hash value of action | |
| 36 | Table/Structure Field |
ORASQLAREA - ADDRESS | Address of statement in the cache | |
| 37 | Table/Structure Field |
ORASQLAREA - BUFFER_GET | Total number of "buffer gets" | |
| 38 | Table/Structure Field |
ORASQLAREA - BUFFGPER_E | Number of 'buffer gets' for each execution | |
| 39 | Table/Structure Field |
ORASQLAREA - BUFFGPER_R | Number of 'buffer gets' for each row | |
| 40 | Table/Structure Field |
ORASQLAREA - CHILD_LATC | Child Latch Number | |
| 41 | Table/Structure Field |
ORASQLAREA - COMMAND_TY | Oracle command type definition | |
| 42 | Table/Structure Field |
ORASQLAREA - CPU_TIME | CPU Time in Miroseconds | |
| 43 | Table/Structure Field |
ORASQLAREA - CPU_TIME_E | CPU Time per Execution | |
| 44 | Table/Structure Field |
ORASQLAREA - DISKRPER_E | Number of 'disk reads' for each execution | |
| 45 | Table/Structure Field |
ORASQLAREA - DB_USER | Column USERNAME in V$SESSION | |
| 46 | Table/Structure Field |
ORASQLAREA - KEPT_VERSI | Indicator for using DBMS_SHARED_POOL | |
| 47 | Table/Structure Field |
ORASQLAREA - INVALIDATI | Number of 'invalidations' for all versions | |
| 48 | Table/Structure Field |
ORASQLAREA - HASH_VALUE | Hash value of statement | |
| 49 | Table/Structure Field |
ORASQLAREA - FIRST_LOAD | Time SQL statement loaded | |
| 50 | Table/Structure Field |
ORASQLAREA - EXECUTIONS | Total number of executions | |
| 51 | Table/Structure Field |
ORASQLAREA - ELAPSED_TI | Elapsed Time in Microseconds | |
| 52 | Table/Structure Field |
ORASQLAREA - ELAPSEDTIE | Elapsed Time per Execution | |
| 53 | Table/Structure Field |
ORASQLAREA - DISK_READS | Sum of all 'disk reads' | |
| 54 | Table/Structure Field |
ORAV_SQL - OPEN_VERSI | Flag for child cursors is locked | |
| 55 | Table/Structure Field |
ORAV_SQL - OPTIM_COST | Cost of this query | |
| 56 | Table/Structure Field |
ORAV_SQL - OPTIM_MODE | Optimizer mode | |
| 57 | Table/Structure Field |
ORAV_SQL - PARSE_CALL | Parse calls for this child cursor | |
| 58 | Table/Structure Field |
ORAV_SQL - PARSING_SC | Schema ID | |
| 59 | Table/Structure Field |
ORAV_SQL - PARSING_US | ID of the user who built this child cursor | |
| 60 | Table/Structure Field |
ORAV_SQL - PERSISTENT | Persistent memory | |
| 61 | Table/Structure Field |
ORAV_SQL - PLAN_HASH_ | Numerical Representation of the SQL Plan | |
| 62 | Table/Structure Field |
ORAV_SQL - ROWS_PROCE | Number of rows parsed | |
| 63 | Table/Structure Field |
ORAV_SQL - ELAPSED_TI | Elapsed Time in Microseconds | |
| 64 | Table/Structure Field |
ORAV_SQL - RUNTIME_ME | Ephemeral frame used | |
| 65 | Table/Structure Field |
ORAV_SQL - SERIALIZAB | Number of producing ORA-8177 | |
| 66 | Table/Structure Field |
ORAV_SQL - SHARABLE_M | Shareable memory | |
| 67 | Table/Structure Field |
ORAV_SQL - SORTS | Number of sorts | |
| 68 | Table/Structure Field |
ORAV_SQL - SQL_TEXT | Start of SQL statement | |
| 69 | Table/Structure Field |
ORAV_SQL - TYPE_CHK_H | Descriptor of type | |
| 70 | Table/Structure Field |
ORAV_SQL - USERS_EXEC | Number of users executing | |
| 71 | Table/Structure Field |
ORAV_SQL - USERS_OPEN | Number of users executing the statement | |
| 72 | Table/Structure Field |
ORAV_SQL - MODULE | Program Name | |
| 73 | Table/Structure Field |
ORAV_SQL - ACTION | Action name | |
| 74 | Table/Structure Field |
ORAV_SQL - ACTION_HAS | Hash value of action | |
| 75 | Table/Structure Field |
ORAV_SQL - ADDRESS | Address of statement in the cache | |
| 76 | Table/Structure Field |
ORAV_SQL - BUFFER_GET | Buffer gets for this child cursor | |
| 77 | Table/Structure Field |
ORAV_SQL - CHILD_NUMB | Number of child cursor | |
| 78 | Table/Structure Field |
ORAV_SQL - COMMAND_TY | Oracle command type definition | |
| 79 | Table/Structure Field |
ORAV_SQL - CPU_TIME | CPU Time in Miroseconds | |
| 80 | Table/Structure Field |
ORAV_SQL - DISK_READS | Disk reads for this child cursor | |
| 81 | Table/Structure Field |
ORAV_SQL - EXECUTIONS | Number of executions | |
| 82 | Table/Structure Field |
ORAV_SQL - FIRST_LOAD | Time SQL statement loaded | |
| 83 | Table/Structure Field |
ORAV_SQL - INVALIDATI | Invalidations for this child cursor | |
| 84 | Table/Structure Field |
ORAV_SQL - KEPT_VERSI | Indicator for using DBMS_SHARED_POOL | |
| 85 | Table/Structure Field |
ORAV_SQL - LAST_LOAD_ | Last Load Time | |
| 86 | Table/Structure Field |
ORAV_SQL - LOADED_VER | Context heap load flag | |
| 87 | Table/Structure Field |
ORAV_SQL - LOADS | Number of loads or reloads | |
| 88 | Table/Structure Field |
ORAV_SQL - MODULE_HAS | Hash value of module | |
| 89 | Table/Structure Field |
ORAV_SQLTX - ADDRESS | Address of statement in the cache | |
| 90 | Table/Structure Field |
ORAV_SQLTX - COMMAND_TY | Oracle command type definition | |
| 91 | Table/Structure Field |
ORAV_SQLTX - PIECE | Number of piece of SQL text | |
| 92 | Table/Structure Field |
ORAV_SQLTX - SQL_TEXT | Piece of SQL text |
