Data Element list used by SAP ABAP Table ORA_S_SQL_INFO (Oracle Monitoring: SQL Information)
SAP ABAP Table
ORA_S_SQL_INFO (Oracle Monitoring: SQL Information) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ORA_ACTION_HASH | Oracle monitoring: ACTION: Currently executing action hash | ||
| 2 | ORA_ACTION_V10 | Oracle Monitoring: Action version 10 | ||
| 3 | ORA_ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ||
| 4 | ORA_APPLICATION_WAIT_TIME | Oracle Monitoring: Application Wait Time | ||
| 5 | ORA_BUFFER_GETS | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | ||
| 6 | ORA_CHILD_ADDRESS | Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor | ||
| 7 | ORA_CHILD_LATCH | Oracle Monitoring: CHILD_LATCH: Child Latch Number | ||
| 8 | ORA_CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ||
| 9 | ORA_CLUSTER_WAIT_TIME | Oracle Monitoring: Cluster Wait Time | ||
| 10 | ORA_COMMAND_TYPE | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | ||
| 11 | ORA_CONCURRENCY_WAIT_TIME | Oracle Monitoring: Concurrency Wait TIme | ||
| 12 | ORA_CPU_TIME | Oracle Monitoring: CPU_TIME | ||
| 13 | ORA_DIRECT_WRITES | Oracle Monitoring: Oracle Direct Writes | ||
| 14 | ORA_DISK_READS | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | ||
| 15 | ORA_ELAPSED_TIME | Oracle Monitoring: ELAPSED_TIME: in microseconds | ||
| 16 | ORA_END_OF_FETCH_COUT | Oracle montoring: End of Fetch Count | ||
| 17 | ORA_EXECUTIONS | Oracle Monitoring: EXECUTIONS: # Executions | ||
| 18 | ORA_FETCHES | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | ||
| 19 | ORA_FIRST_LOAD_TIME | Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation | ||
| 20 | ORA_HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ||
| 21 | ORA_INST_ID | Oracle monitor: Instance ID | ||
| 22 | ORA_INVALIDATIONS | Oracle monitoring: # of times objects were marked invalid | ||
| 23 | ORA_IS_OBSOLETE | Oracle Monitoring: IS_OBSOLETE | ||
| 24 | ORA_JAVA_EXEC_TIME | Oracle Monitoring: Java Exec Time | ||
| 25 | ORA_KEPT_VERSIONS | Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept | ||
| 26 | ORA_LAST_LOAD_TIME | Oracle Monitoring: LAST_LOAD_TIME | ||
| 27 | ORA_LITERAL_HASH_VALUE | Oracle Monitoring: LITERAL_HASH_VALUE: H val of replaced lit | ||
| 28 | ORA_LOADED_VERSIONS | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | ||
| 29 | ORA_LOADS | Oracle Monitoring: # Times Object was Loaded or Reloaded | ||
| 30 | ORA_MODULE_HASH | Oracle monitoring: MODULE_HASH: curr. executing module hash | ||
| 31 | ORA_MODULE_V10 | Oracle Monitoring: Module for Version 10 | ||
| 32 | ORA_OBJECT_STATUS | Oracle Monitoring: OBJECT_STATUS | ||
| 33 | ORA_OLD_HASH_VALUE | Oracle Monitoring: Old Hash Value | ||
| 34 | ORA_OPEN_VERSIONS | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | ||
| 35 | ORA_OPTIMIZER_COST | Oracle Monitoring: OPTIMIZER_COST: Cost of Execution | ||
| 36 | ORA_OPTIMIZER_ENV_HASH_VALUE | Oracle Monitoring: Optimizer Env Hash Value | ||
| 37 | ORA_OPTIMIZER_MODE | Oracle Monitoring: OPTIMIZER_MODE: Mode of SQL Execution | ||
| 38 | ORA_OUTLINE_CATEGORY | Oracle Monitoring: OUTLINE_CATEGORY: If outline, its catgory | ||
| 39 | ORA_OUTLINE_SID | Oracle Monitoring: OUTLINE_SID: Outline Session ID | ||
| 40 | ORA_PARSE_CALLS | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | ||
| 41 | ORA_PARSING_SCHEMA_ID | Oracle Monitoring: PARSING_SCHEMA_ID | ||
| 42 | ORA_PARSING_USER_ID | Oracle Monitoring: PARSING_USER_ID: 1st User having parsed | ||
| 43 | ORA_PERSISTENT_MEM | Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim | ||
| 44 | ORA_PLAN_HASH_VALUE | Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan | ||
| 45 | ORA_PLSQL_EXEC_TIME | Oracle Monitoring: PLSQL Exec Time | ||
| 46 | ORA_PROGRAM_ID | Oracle Monitoring: Program ID | ||
| 47 | ORA_PROGRAM_LINE_HASH | Oracle Monitoring: Program Line# | ||
| 48 | ORA_REMOTE | Oracle Monitoring: REMOTE: Is Remote Mapped? | ||
| 49 | ORA_ROWS_PROCESSED | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | ||
| 50 | ORA_RUNTIME_MEM | Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. | ||
| 51 | ORA_SERIALIZABLE_ABORTS | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | ||
| 52 | ORA_SESSION_CNT | Oracle Monitoring: Oracle Session Count | ||
| 53 | ORA_SHARABLE_MEM | Oracle Monitoring: SHARABLE_MEM: Shared Memory Used | ||
| 54 | ORA_SORTS | Oracle Monitoring: SORTS: Number of Sorts Done for cursor | ||
| 55 | ORA_SQLTYPE | Oracle Monitoring: SQLTYPE: SQL Version used | ||
| 56 | ORA_SQL_ID | Oracle monitoring: SQL_ID | ||
| 57 | ORA_SQL_PROFILE | Oracle Monitoring: SQL Profile | ||
| 58 | ORA_SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ||
| 59 | ORA_TYPE_CHK_HEAP | Oracle Monitoring: TYPE_CHK_HEAP: Type Check Heap Descriptor | ||
| 60 | ORA_USERS_EXECUTING | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | ||
| 61 | ORA_USERS_OPENING | Oracle Monitoring: USERS_OPENING: # of users executing SQL | ||
| 62 | ORA_USER_IO_WAIT_TIME | Oracle Monitoring: User I/O Wait Time |