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