SAP Table ORASQLAREA
DDIC Structure According to Oracle Table V$SQLAREA
ORASQLAREA (DDIC Structure According to Oracle Table V$SQLAREA) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ORASQLAREA to other SAP tables.
ORASQLAREA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| SQL_TEXT | Start of SQL statement | ORASQLTEXT | CHAR | 60 | 0 | |||
| SHARABLE_M | Total shareable memory | ORASHARMEM | DEC | 31 | 0 | |||
| PERSISTENT | Total 'persistent memory' | ORAPERSMEM | INT4 | 10 | 0 | |||
| RUNTIME_ME | Total "runtime memory" | ORARUNTMEM | INT4 | 10 | 0 | |||
| SORTS | Sum of the number of sorts | ORASORTS | INT4 | 10 | 0 | |||
| VERSION_CO | Number of children | ORAVERSCOU | INT4 | 10 | 0 | |||
| LOADED_VER | Loaded cursor versions | ORALOADVER | INT4 | 10 | 0 | |||
| OPEN_VERSI | Number of opened cursor versions | ORAOPENVER | INT4 | 10 | 0 | |||
| USERS_OPEN | Number of users who have opened cursor version | ORAUSROPEN | INT4 | 10 | 0 | |||
| EXECUTIONS | Total number of executions | ORAEXECNUM | DEC | 31 | 0 | |||
| USERS_EXEC | Number of users executing | ORAUSREXEC | INT4 | 10 | 0 | |||
| LOADS | Number of loads or reloads | ORALOADS | INT4 | 10 | 0 | |||
| FIRST_LOAD | Time SQL statement loaded | ORALOAD_T | CHAR | 19 | 0 | |||
| INVALIDATI | Number of 'invalidations' for all versions | ORAINVALID | INT4 | 10 | 0 | |||
| PARSE_CALL | Sum of all 'parse calls' | ORAPARSEC | INT4 | 10 | 0 | |||
| DISK_READS | Sum of all 'disk reads' | ORADISKR | DEC | 31 | 0 | |||
| BUFFER_GET | Total number of "buffer gets" | ORABUFFERG | DEC | 31 | 0 | |||
| ROWS_PROCE | Number of processed rows | ORAROWPROC | DEC | 31 | 0 | |||
| COMMAND_TY | Oracle command type definition | ORACOMTYPE | INT4 | 10 | 0 | |||
| OPTIM_MODE | Optimizer mode | ORAOPTMODE | CHAR | 10 | 0 | |||
| PARSING_US | ID of the user who built this child cursor | ORAPARSUSR | INT4 | 10 | 0 | |||
| PARSING_SC | Schema ID | ORAPARSSCH | INT4 | 10 | 0 | |||
| KEPT_VERSI | Indicator for using DBMS_SHARED_POOL | ORAKEPTVER | INT4 | 10 | 0 | |||
| ADDRESS | Address of statement in the cache | ORAADDRESS | CHAR | 16 | 0 | |||
| HASH_VALUE | Hash value of statement | ORAHASHVAL | FLTP | 16 | 16 | |||
| MODULE | Program Name | ORAMODULE | CHAR | 64 | 0 | |||
| DB_USER | Column USERNAME in V$SESSION | ORAUSER | CHAR | 10 | 0 | |||
| MODULE_HAS | Hash value of module | ORAMODULEH | FLTP | 16 | 16 | |||
| ACTION | Action name | ORAACTION | CHAR | 64 | 0 | |||
| ACTION_HAS | Hash value of action | ORAACTIONH | FLTP | 16 | 16 | |||
| SERIALIZAB | Number of producing ORA-8177 | ORASERIAL | INT4 | 10 | 0 | |||
| CHILD_LATC | Child Latch Number | ORACHILDLA | INT4 | 10 | 0 | |||
| CPU_TIME | CPU Time in Miroseconds | ORACPUTIME | DEC | 31 | 0 | |||
| ELAPSED_TI | Elapsed Time in Microseconds | ORAELAPSED | DEC | 31 | 0 | |||
| DISKRPER_E | Number of 'disk reads' for each execution | ORADRPERE | DEC | 31 | 1 | |||
| BUFFGPER_E | Number of 'buffer gets' for each execution | ORABGPERE | DEC | 31 | 1 | |||
| PARSCPER_E | Parse calls per execution | ORAPCPERE | DEC | 31 | 1 | |||
| ROWSPPER_E | Number of rows processed for each execution | ORARPPERE | DEC | 31 | 1 | |||
| BUFFGPER_R | Number of 'buffer gets' for each row | ORABGPERR | DEC | 31 | 1 | |||
| COLFIELD | Field for controlling colors in ABAP List Viewer | ORACOLFIEL | CHAR | 3 | 0 | |||
| WAIT_TIME | Wait time | ORAWAITTIM | DEC | 31 | 0 | |||
| CPU_TIME_E | CPU Time per Execution | ORACTPERE | DEC | 31 | 1 | |||
| ELAPSEDTIE | Elapsed Time per Execution | ORAELAPERE | DEC | 31 | 1 | |||
| WAITTIME_E | Wait Time per Execution | ORAWTPERE | DEC | 31 | 1 | |||
