Table/Structure Field list used by SAP ABAP Program LSTUN_ORAF02 (Include LSTUN_ORAF02)
SAP ABAP Program
LSTUN_ORAF02 (Include LSTUN_ORAF02) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ALVDYNP - SORTPOS | Sort sequence | ||
| 2 | ALVDYNP - SORTDOWN | Sort order: Descending | ||
| 3 | ALVDYNP - SORTUP | Sort order: Ascending | ||
| 4 | DBRELEASE - DBRELEASE | Database release | ||
| 5 | DD02L - TABNAME | Table Name | ||
| 6 | DD03L - FIELDNAME | Field Name | ||
| 7 | DISVARIANT - HANDLE | Mgt. ID for repeated calls from the same program | ||
| 8 | DISVARIANT - REPORT | ABAP Program Name | ||
| 9 | DISVARIANT - TEXT | Description for layout | ||
| 10 | DISVARIANT - USERNAME | User name for user-specific storage | ||
| 11 | DISVARIANT - VARIANT | Layout | ||
| 12 | ORAALLUSR - USERNAME | Database user | ||
| 13 | ORAALLUSR - USER_ID | ID of the user who built this child cursor | ||
| 14 | ORACCACHST - CCRESETDAY | Day cursor cache reset | ||
| 15 | ORACCACHST - TABNAME | Name of internal table for output | ||
| 16 | ORACCACHST - SNAPSHOTT | Time cursor cache analyzed | ||
| 17 | ORACCACHST - SNAPSHOTD | Day cursor cache analyzed | ||
| 18 | ORACCACHST - SHOW_MODE | Single-Character Flag | ||
| 19 | ORACCACHST - EX_RESET | Single-Character Flag | ||
| 20 | ORACCACHST - DBSTARTTIM | Time database started | ||
| 21 | ORACCACHST - DBSTARTDAY | Day of database start | ||
| 22 | ORACCACHST - CCRESETTIM | Time cursor cache reset | ||
| 23 | ORACLE_RELEASE - R1 | Oracle release number | ||
| 24 | ORASESSION - USERNAME | Column USERNAME in V$SESSION | ||
| 25 | ORASESSION - SID | Session ID | ||
| 26 | ORASQLADER - BUFFGPER_E | Number of 'buffer gets' for each execution | ||
| 27 | ORASQLADER - WAIT_TIME | Wait time | ||
| 28 | ORASQLADER - WAITTIME_E | Wait Time per Execution | ||
| 29 | ORASQLADER - ROWSPPER_E | Number of rows processed for each execution | ||
| 30 | ORASQLADER - PARSCPER_E | Parse calls per execution | ||
| 31 | ORASQLADER - ELAPSEDTIE | Elapsed Time per Execution | ||
| 32 | ORASQLADER - DISKRPER_E | Number of 'disk reads' for each execution | ||
| 33 | ORASQLADER - CPU_TIME_E | CPU Time per Execution | ||
| 34 | ORASQLADER - BUFFGPER_R | Number of 'buffer gets' for each row | ||
| 35 | ORASQLAREA - ELAPSEDTIE | Elapsed Time per Execution | ||
| 36 | ORASQLAREA - PARSE_CALL | Sum of all 'parse calls' | ||
| 37 | ORASQLAREA - PARSING_US | ID of the user who built this child cursor | ||
| 38 | ORASQLAREA - PERSISTENT | Total 'persistent memory' | ||
| 39 | ORASQLAREA - PARSCPER_E | Parse calls per execution | ||
| 40 | ORASQLAREA - ROWSPPER_E | Number of rows processed for each execution | ||
| 41 | ORASQLAREA - ROWS_PROCE | Number of processed rows | ||
| 42 | ORASQLAREA - RUNTIME_ME | Total "runtime memory" | ||
| 43 | ORASQLAREA - SHARABLE_M | Total shareable memory | ||
| 44 | ORASQLAREA - SORTS | Sum of the number of sorts | ||
| 45 | ORASQLAREA - SQL_TEXT | Start of SQL statement | ||
| 46 | ORASQLAREA - USERS_EXEC | Number of users executing | ||
| 47 | ORASQLAREA - USERS_OPEN | Number of users who have opened cursor version | ||
| 48 | ORASQLAREA - WAITTIME_E | Wait Time per Execution | ||
| 49 | ORASQLAREA - WAIT_TIME | Wait time | ||
| 50 | ORASQLAREA - LOADS | Number of loads or reloads | ||
| 51 | ORASQLAREA - MODULE | Program Name | ||
| 52 | ORASQLAREA - ACTION | Action name | ||
| 53 | ORASQLAREA - ADDRESS | Address of statement in the cache | ||
| 54 | ORASQLAREA - BUFFER_GET | Total number of "buffer gets" | ||
| 55 | ORASQLAREA - BUFFGPER_E | Number of 'buffer gets' for each execution | ||
| 56 | ORASQLAREA - BUFFGPER_R | Number of 'buffer gets' for each row | ||
| 57 | ORASQLAREA - CPU_TIME | CPU Time in Miroseconds | ||
| 58 | ORASQLAREA - CPU_TIME_E | CPU Time per Execution | ||
| 59 | ORASQLAREA - DB_USER | Column USERNAME in V$SESSION | ||
| 60 | ORASQLAREA - DISKRPER_E | Number of 'disk reads' for each execution | ||
| 61 | ORASQLAREA - DISK_READS | Sum of all 'disk reads' | ||
| 62 | ORASQLAREA - ELAPSED_TI | Elapsed Time in Microseconds | ||
| 63 | ORASQLAREA - EXECUTIONS | Total number of executions | ||
| 64 | ORASQLAREA - LOADED_VER | Loaded cursor versions | ||
| 65 | ORAV_SQL - USERS_OPEN | Number of users executing the statement | ||
| 66 | ORAV_SQL - USERS_EXEC | Number of users executing | ||
| 67 | ORAV_SQL - SORTS | Number of sorts | ||
| 68 | ORAV_SQL - SHARABLE_M | Shareable memory | ||
| 69 | ORAV_SQL - RUNTIME_ME | Ephemeral frame used | ||
| 70 | ORAV_SQL - EXECUTIONS | Number of executions | ||
| 71 | ORAV_SQL - ROWS_PROCE | Number of rows parsed | ||
| 72 | ORAV_SQL - PERSISTENT | Persistent memory | ||
| 73 | ORAV_SQL - LOADS | Number of loads or reloads | ||
| 74 | ORAV_SQL - LOADED_VER | Context heap load flag | ||
| 75 | ORAV_SQL - ELAPSED_TI | Elapsed Time in Microseconds | ||
| 76 | ORAV_SQL - DISK_READS | Disk reads for this child cursor | ||
| 77 | ORAV_SQL - CPU_TIME | CPU Time in Miroseconds | ||
| 78 | ORAV_SQL - BUFFER_GET | Buffer gets for this child cursor | ||
| 79 | ORAV_SQL - ADDRESS | Address of statement in the cache | ||
| 80 | ORAV_SQL - PARSE_CALL | Parse calls for this child cursor | ||
| 81 | ORAV_SQLTX - ADDRESS | Address of statement in the cache | ||
| 82 | ORAV_SQLTX - SQL_TEXT | Piece of SQL text | ||
| 83 | ORAV_SQLTX - PIECE | Number of piece of SQL text | ||
| 84 | PROG_REF_T - CONT_OFFS | Offset of a Processing Control Block | ||
| 85 | PROG_REF_T - PROG_NAME | ABAP Program: Current Main Program | ||
| 86 | SYST - FDPOS | ABAP System Field: Occurrence in Byte or Character String | ||
| 87 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 88 | SYST - UCOMM | ABAP System Field: PAI-Triggering Function Code | ||
| 89 | SYST - UNAME | ABAP System Field: Name of Current User |