SAP ABAP Table ORA_S_SQL_INFO (Oracle Monitoring: SQL Information)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
Basic Data
Table Category INTTAB    Structure 
Structure ORA_S_SQL_INFO   Table Relationship Diagram
Short Description Oracle Monitoring: SQL Information    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 SESSION_CNT ORA_SESSION_CNT ORA_DEC_10 DEC 10   0   Oracle Monitoring: Oracle Session Count  
2 .INCLUDE       0   0   Oracle Monitoring: GV$SQL  
3 INST_ID ORA_INST_ID ORA_INST_ID DEC 22   0   Oracle monitor: Instance ID  
4 SQL_TEXT ORA_SQL_TEXT ORA_CHAR_1000 LCHR 1000   0   Oracle Monitoring: SQL_TEXT: SQL Text of current cursor  
5 SQL_ID ORA_SQL_ID ORA_SQLID CHAR 13   0   Oracle monitoring: SQL_ID  
6 SHARABLE_MEM ORA_SHARABLE_MEM ORA_NUMBER DEC 22   0   Oracle Monitoring: SHARABLE_MEM: Shared Memory Used  
7 PERSISTENT_MEM ORA_PERSISTENT_MEM ORA_NUMBER DEC 22   0   Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim  
8 RUNTIME_MEM ORA_RUNTIME_MEM ORA_NUMBER DEC 22   0   Oracle Monitoring: RUNTIME_MEM: Mem required during Execut.  
9 SORTS ORA_SORTS ORA_NUMBER DEC 22   0   Oracle Monitoring: SORTS: Number of Sorts Done for cursor  
10 LOADED_VERSIONS ORA_LOADED_VERSIONS ORA_NUMBER DEC 22   0   Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded  
11 OPEN_VERSIONS ORA_OPEN_VERSIONS ORA_NUMBER DEC 22   0   Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked?  
12 USERS_OPENING ORA_USERS_OPENING ORA_NUMBER DEC 22   0   Oracle Monitoring: USERS_OPENING: # of users executing SQL  
13 FETCHES ORA_FETCHES ORA_NUMBER DEC 22   0   Oracle Monitoring: FETCHES: # Fetches assoc. with statement  
14 EXECUTIONS ORA_EXECUTIONS ORA_NUMBER DEC 22   0   Oracle Monitoring: EXECUTIONS: # Executions  
15 END_OF_FETCH_COUNT ORA_END_OF_FETCH_COUT ORA_DEC_22 DEC 22   0   Oracle montoring: End of Fetch Count  
16 USERS_EXECUTING ORA_USERS_EXECUTING ORA_NUMBER DEC 22   0   Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL  
17 LOADS ORA_LOADS ORA_NUMBER DEC 22   0   Oracle Monitoring: # Times Object was Loaded or Reloaded  
18 FIRST_LOAD_TIME ORA_FIRST_LOAD_TIME ORA_CHAR_19 CHAR 19   0   Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation  
19 INVALIDATIONS ORA_INVALIDATIONS ORA_NUM_22 DEC 22   0   Oracle monitoring: # of times objects were marked invalid  
20 PARSE_CALLS ORA_PARSE_CALLS ORA_NUMBER DEC 22   0   Oracle Monitoring: PARSE_CALLS: Number of Parse Calls  
21 DISK_READS ORA_DISK_READS ORA_NUMBER DEC 22   0   Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor  
22 DIRECT_WRITES ORA_DIRECT_WRITES ORA_DEC_22 DEC 22   0   Oracle Monitoring: Oracle Direct Writes  
23 BUFFER_GETS ORA_BUFFER_GETS ORA_NUMBER DEC 22   0   Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor  
24 APPLICATION_WAIT_TIME ORA_APPLICATION_WAIT_TIME ORA_DEC_22 DEC 22   0   Oracle Monitoring: Application Wait Time  
25 CONCURRENCY_WAIT_TIME ORA_CONCURRENCY_WAIT_TIME ORA_DEC_22 DEC 22   0   Oracle Monitoring: Concurrency Wait TIme  
26 CLUSTER_WAIT_TIME ORA_CLUSTER_WAIT_TIME ORA_DEC_22 DEC 22   0   Oracle Monitoring: Cluster Wait Time  
27 USER_IO_WAIT_TIME ORA_USER_IO_WAIT_TIME ORA_DEC_22 DEC 22   0   Oracle Monitoring: User I/O Wait Time  
28 PLSQL_EXEC_TIME ORA_PLSQL_EXEC_TIME ORA_DEC_22 DEC 22   0   Oracle Monitoring: PLSQL Exec Time  
29 JAVA_EXEC_TIME ORA_JAVA_EXEC_TIME ORA_DEC_22 DEC 22   0   Oracle Monitoring: Java Exec Time  
30 ROWS_PROCESSED ORA_ROWS_PROCESSED ORA_NUMBER DEC 22   0   Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned  
31 COMMAND_TYPE ORA_COMMAND_TYPE ORA_NUMBER DEC 22   0   Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def.  
32 OPTIMIZER_MODE ORA_OPTIMIZER_MODE ORA_CHAR_10 CHAR 10   0   Oracle Monitoring: OPTIMIZER_MODE: Mode of SQL Execution  
33 OPTIMIZER_COST ORA_OPTIMIZER_COST ORA_NUMBER DEC 22   0   Oracle Monitoring: OPTIMIZER_COST: Cost of Execution  
34 OPTIMIZER_ENV_HASH_VALUE ORA_OPTIMIZER_ENV_HASH_VALUE ORA_DEC_22 DEC 22   0   Oracle Monitoring: Optimizer Env Hash Value  
35 PARSING_USER_ID ORA_PARSING_USER_ID ORA_NUMBER DEC 22   0   Oracle Monitoring: PARSING_USER_ID: 1st User having parsed  
36 PARSING_SCHEMA_ID ORA_PARSING_SCHEMA_ID ORA_NUMBER DEC 22   0   Oracle Monitoring: PARSING_SCHEMA_ID  
37 KEPT_VERSIONS ORA_KEPT_VERSIONS ORA_NUMBER DEC 22   0   Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept  
38 ADDRESS ORA_ADDRESS ORA_RAW_8 RAW 8   0   Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor  
39 TYPE_CHK_HEAP ORA_TYPE_CHK_HEAP ORA_RAW_8 RAW 8   0   Oracle Monitoring: TYPE_CHK_HEAP: Type Check Heap Descriptor  
40 HASH_VALUE ORA_HASH_VALUE ORA_NUMBER DEC 22   0   Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment  
41 OLD_HASH_VALUE ORA_OLD_HASH_VALUE ORA_DEC_22 DEC 22   0   Oracle Monitoring: Old Hash Value  
42 PLAN_HASH_VALUE ORA_PLAN_HASH_VALUE ORA_NUMBER DEC 22   0   Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan  
43 CHILD_NUMBER ORA_CHILD_NUMBER ORA_NUMBER DEC 22   0   Oracle Monitoring: CHILD_NUMBER  
44 MODULE_NAME ORA_MODULE_V10 ORA_CHAR_64 CHAR 64   0   Oracle Monitoring: Module for Version 10  
45 MODULE_HASH ORA_MODULE_HASH ORA_MODULE_HASH DEC 22   0   Oracle monitoring: MODULE_HASH: curr. executing module hash  
46 ACTION ORA_ACTION_V10 ORA_CHAR_64 CHAR 64   0   Oracle Monitoring: Action version 10  
47 ACTION_HASH ORA_ACTION_HASH ORA_ACTION_HASH DEC 22   0   Oracle monitoring: ACTION: Currently executing action hash  
48 SERIALIZABLE_ABORTS ORA_SERIALIZABLE_ABORTS ORA_NUMBER DEC 22   0   Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial  
49 OUTLINE_CATEGORY ORA_OUTLINE_CATEGORY ORA_CHAR_64 CHAR 64   0   Oracle Monitoring: OUTLINE_CATEGORY: If outline, its catgory  
50 CPU_TIME ORA_CPU_TIME ORA_NUMBER DEC 22   0   Oracle Monitoring: CPU_TIME  
51 ELAPSED_TIME ORA_ELAPSED_TIME ORA_NUMBER DEC 22   0   Oracle Monitoring: ELAPSED_TIME: in microseconds  
52 OUTLINE_SID ORA_OUTLINE_SID ORA_NUMBER DEC 22   0   Oracle Monitoring: OUTLINE_SID: Outline Session ID  
53 CHILD_ADDRESS ORA_CHILD_ADDRESS ORA_RAW_8 RAW 8   0   Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor  
54 SQLTYPE ORA_SQLTYPE ORA_NUMBER DEC 22   0   Oracle Monitoring: SQLTYPE: SQL Version used  
55 REMOTE ORA_REMOTE ORA_CHAR_1 CHAR 1   0   Oracle Monitoring: REMOTE: Is Remote Mapped?  
56 OBJECT_STATUS ORA_OBJECT_STATUS ORA_CHAR_19 CHAR 19   0   Oracle Monitoring: OBJECT_STATUS  
57 LITERAL_HASH_VALUE ORA_LITERAL_HASH_VALUE ORA_NUMBER DEC 22   0   Oracle Monitoring: LITERAL_HASH_VALUE: H val of replaced lit  
58 LAST_LOAD_TIME ORA_LAST_LOAD_TIME ORA_CHAR_19 CHAR 19   0   Oracle Monitoring: LAST_LOAD_TIME  
59 IS_OBSOLETE ORA_IS_OBSOLETE ORA_CHAR_1 CHAR 1   0   Oracle Monitoring: IS_OBSOLETE  
60 CHILD_LATCH ORA_CHILD_LATCH ORA_NUMBER DEC 22   0   Oracle Monitoring: CHILD_LATCH: Child Latch Number  
61 SQL_PROFILE ORA_SQL_PROFILE ORA_CHAR_64 CHAR 64   0   Oracle Monitoring: SQL Profile  
62 PROGRAM_ID ORA_PROGRAM_ID ORA_DEC_22 DEC 22   0   Oracle Monitoring: Program ID  
63 PROGRAM_LINE_HASH ORA_PROGRAM_LINE_HASH ORA_DEC_22 DEC 22   0   Oracle Monitoring: Program Line#  
History
Last changed by/on SAP  20110908 
SAP Release Created in 710