Table/Structure Field list used by SAP ABAP Class CL_ORA_DBC_SQL_REQUEST_10 (Data Collector for SQL Request)
SAP ABAP Class
CL_ORA_DBC_SQL_REQUEST_10 (Data Collector for SQL Request) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | GORASQLADER - BUFFER_GETS_PER_ROW | Number of 'buffer gets' for each row | ||
| 2 | GORASQLADER - CPU_TIME_PER_EXEC | CPU Time per Execution | ||
| 3 | GORASQLADER - DISK_READS_PER_EXEC | Number of 'disk reads' for each execution | ||
| 4 | GORASQLADER - ELAPSED_TIME_PER_EXEC | Elapsed Time per Execution | ||
| 5 | GORASQLADER - PARSE_CALLS_PER_EXEC | Parse calls per execution | ||
| 6 | GORASQLADER - ROWS_PROCESSED_PER_EXEC | Number of rows processed for each execution | ||
| 7 | GORASQLADER - WAIT_TIME | Wait time | ||
| 8 | GORASQLADER - WAIT_TIME_PER_EXEC | Wait Time per Execution | ||
| 9 | GORASQLADER - BUFFER_GETS_PER_EXEC | Number of 'buffer gets' for each execution | ||
| 10 | GORASQLAREA - PERSISTENT_MEM | Total 'persistent memory' | ||
| 11 | GORASQLAREA - INST_ID | Oracle Instance ID | ||
| 12 | GORASQLAREA - PARSING_USER_ID | ID of the user who built this child cursor | ||
| 13 | GORASQLAREA - PARSE_CALLS_PER_EXEC | Parse calls per execution | ||
| 14 | GORASQLAREA - PARSE_CALLS | Sum of all 'parse calls' | ||
| 15 | GORASQLAREA - PARSE_CALLS | Sum of all 'parse calls' | ||
| 16 | GORASQLAREA - LOADS | Number of loads or reloads | ||
| 17 | GORASQLAREA - LOADED_VERSIONS | Loaded cursor versions | ||
| 18 | GORASQLAREA - LAST_ACTIVE_TIME | GORASQLAREA-LAST_ACTIVE_TIME | ||
| 19 | GORASQLAREA - WAIT_TIME | Wait time | ||
| 20 | GORASQLAREA - ROWS_PROCESSED | Number of processed rows | ||
| 21 | GORASQLAREA - ROWS_PROCESSED | Number of processed rows | ||
| 22 | GORASQLAREA - ROWS_PROCESSED_PER_EXEC | Number of rows processed for each execution | ||
| 23 | GORASQLAREA - RUNTIME_MEM | Total "runtime memory" | ||
| 24 | GORASQLAREA - SHARABLE_MEM | Total shareable memory | ||
| 25 | GORASQLAREA - SORTS | Sum of the number of sorts | ||
| 26 | GORASQLAREA - SQL_TEXT | Start of SQL statement | ||
| 27 | GORASQLAREA - USERS_EXECUTING | Number of users executing | ||
| 28 | GORASQLAREA - USERS_OPENING | Number of users who have opened cursor version | ||
| 29 | GORASQLAREA - WAIT_TIME_PER_EXEC | Wait Time per Execution | ||
| 30 | GORASQLAREA - EXECUTIONS | Total number of executions | ||
| 31 | GORASQLAREA - INST_ID | Oracle Instance ID | ||
| 32 | GORASQLAREA - ADDRESS | Address of statement in the cache | ||
| 33 | GORASQLAREA - ADDRESS | Address of statement in the cache | ||
| 34 | GORASQLAREA - BUFFER_GETS | Total number of "buffer gets" | ||
| 35 | GORASQLAREA - BUFFER_GETS | Total number of "buffer gets" | ||
| 36 | GORASQLAREA - BUFFER_GETS_PER_EXEC | Number of 'buffer gets' for each execution | ||
| 37 | GORASQLAREA - BUFFER_GETS_PER_ROW | Number of 'buffer gets' for each row | ||
| 38 | GORASQLAREA - CPU_TIME | CPU Time in Miroseconds | ||
| 39 | GORASQLAREA - CPU_TIME | CPU Time in Miroseconds | ||
| 40 | GORASQLAREA - CPU_TIME_PER_EXEC | CPU Time per Execution | ||
| 41 | GORASQLAREA - DIRECT_WRITES | GORASQLAREA-DIRECT_WRITES | ||
| 42 | GORASQLAREA - EXECUTIONS | Total number of executions | ||
| 43 | GORASQLAREA - ELAPSED_TIME_PER_EXEC | Elapsed Time per Execution | ||
| 44 | GORASQLAREA - ELAPSED_TIME | Elapsed Time in Microseconds | ||
| 45 | GORASQLAREA - ELAPSED_TIME | Elapsed Time in Microseconds | ||
| 46 | GORASQLAREA - DISK_READS_PER_EXEC | Number of 'disk reads' for each execution | ||
| 47 | GORASQLAREA - DISK_READS | Sum of all 'disk reads' | ||
| 48 | GORASQLAREA - DISK_READS | Sum of all 'disk reads' | ||
| 49 | GORASQLAREA - DB_USER | Column USERNAME in V$SESSION | ||
| 50 | GORAVSQLAR_DBC - USERNAME | Database user | ||
| 51 | GORAVSQLAR_DBC - USERNAME | Database user | ||
| 52 | GORAVSQLAR_DBC - SQLTEXT | Restriction on SQL statements to be analyzed | ||
| 53 | GORAVSQLAR_DBC - SQLTEXT | Restriction on SQL statements to be analyzed | ||
| 54 | GORAVSQLAR_DBC - SKIP_SELC | Field list display for select statements | ||
| 55 | GORAVSQLAR_DBC - SHAREDMEM | Restriction on shared memory | ||
| 56 | GORAVSQLAR_DBC - SHAREDMEM | Restriction on shared memory | ||
| 57 | GORAVSQLAR_DBC - ORAINST_LIST_T | GORAVSQLAR_DBC-ORAINST_LIST_T | ||
| 58 | GORAVSQLAR_DBC - EXECUTIONS | Restriction on the number of total executions | ||
| 59 | GORAVSQLAR_DBC - ORAINST_LIST_T | GORAVSQLAR_DBC-ORAINST_LIST_T | ||
| 60 | GORAVSQLAR_DBC - BUFFERGETS | Restriction on number of 'buffer gets' | ||
| 61 | GORAVSQLAR_DBC - BUFFERGETS | Restriction on number of 'buffer gets' | ||
| 62 | GORAVSQLAR_DBC - CURRENTEXE | Restriction on number of 'current executions' | ||
| 63 | GORAVSQLAR_DBC - CURRENTEXE | Restriction on number of 'current executions' | ||
| 64 | GORAVSQLAR_DBC - DISKREADS | Restriction on number of 'disk reads' | ||
| 65 | GORAVSQLAR_DBC - DISKREADS | Restriction on number of 'disk reads' | ||
| 66 | GORAVSQLAR_DBC - EXECUTIONS | Restriction on the number of total executions | ||
| 67 | GORAV_SQL - USERS_OPENING | Number of users executing the statement | ||
| 68 | GORAV_SQL - USERS_EXECUTING | Number of users executing | ||
| 69 | GORAV_SQL - SORTS | Number of sorts | ||
| 70 | GORAV_SQL - SHARABLE_MEM | Shareable memory | ||
| 71 | GORAV_SQL - RUNTIME_MEM | Ephemeral frame used | ||
| 72 | GORAV_SQL - ROWS_PROCESSED | Number of rows parsed | ||
| 73 | GORAV_SQL - PERSISTENT_MEM | Persistent memory | ||
| 74 | GORAV_SQL - PARSE_CALLS | Parse calls for this child cursor | ||
| 75 | GORAV_SQL - LOADS | Number of loads or reloads | ||
| 76 | GORAV_SQL - LAST_ACTIVE_TIME | GORAV_SQL-LAST_ACTIVE_TIME | ||
| 77 | GORAV_SQL - INST_ID | Oracle Instance ID | ||
| 78 | GORAV_SQL - EXECUTIONS | Number of executions | ||
| 79 | GORAV_SQL - ELAPSED_TIME | Elapsed Time in Microseconds | ||
| 80 | GORAV_SQL - DISK_READS | Disk reads for this child cursor | ||
| 81 | GORAV_SQL - DIRECT_WRITES | GORAV_SQL-DIRECT_WRITES | ||
| 82 | GORAV_SQL - CPU_TIME | CPU Time in Miroseconds | ||
| 83 | GORAV_SQL - BUFFER_GETS | Buffer gets for this child cursor | ||
| 84 | GORAV_SQL - ADDRESS | Address of statement in the cache | ||
| 85 | GORAV_SQL - LOADED_VERSIONS | Context heap load flag | ||
| 86 | GORAV_SQLTX - ADDRESS | Address of statement in the cache | ||
| 87 | GORAV_SQLTX - SQL_TEXT | Piece of SQL text | ||
| 88 | GORAV_SQLTX - PIECE | Number of piece of SQL text | ||
| 89 | GORAV_SQLTX - INST_ID | Oracle Instance ID | ||
| 90 | GORAV_SQLTX - INST_ID | Oracle Instance ID | ||
| 91 | GORAV_SQLTX - HASH_VALUE | Hash value of statement | ||
| 92 | GORAV_SQLTX - ADDRESS | Address of statement in the cache | ||
| 93 | ORAALLUSR - USERNAME | Database user | ||
| 94 | ORAALLUSR - USER_ID | ID of the user who built this child cursor | ||
| 95 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables |