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