SAP ABAP Table GORAV_SQL (Fields of GV$SQL + Derived Values)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-SYS (Application Component) Database Interface/DBMS for Oracle
     ⤷ STUN_ORA (Package) Objects for Performance Analysis (ST04): Oracle DB

Basic Data

Table Category	INTTAB	Structure
Structure	GORAV_SQL	Table Relationship Diagram
Short Description	Fields of GV$SQL + Derived Values

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	☐	ORAINST_ID	ORANUMBER	INT4	10	0	Oracle Instance ID
2	SQL_TEXT	☐	ORASQLTEXT	CHAR60	CHAR	60	0	Start of SQL statement
3	SHARABLE_MEM	☐	ORSHARMEM	ORAMEMORY	INT4	10	0	Shareable memory
4	PERSISTENT_MEM	☐	ORPERSMEM	ORAMEMORY	INT4	10	0	Persistent memory
5	RUNTIME_MEM	☐	ORRUNTMEM	ORAMEMORY	INT4	10	0	Ephemeral frame used
6	SORTS	☐	ORSORTS	ORANUMBER	INT4	10	0	Number of sorts
7	LOADED_VERSIONS	☐	ORLOADVER	ORANUMBER	INT4	10	0	Context heap load flag
8	OPEN_VERSIONS	☐	OROPENVER	ORANUMBER	INT4	10	0	Flag for child cursors is locked
9	USERS_OPENING	☐	ORUSROPEN	ORANUMBER	INT4	10	0	Number of users executing the statement
10	EXECUTIONS	☐	OREXECNUM	ORAPNUMBER	DEC	31	0	Number of executions
11	FETCHES	☐	ORAFETCHES	ORAPNUMBER	DEC	31	0	Total Number of Fetches
12	USERS_EXECUTING	☐	ORUSREXEC	ORANUMBER	INT4	10	0	Number of users executing
13	LOADS	☐	ORALOADS	ORANUMB5	INT4	10	0	Number of loads or reloads
14	FIRST_LOAD_TIME	☐	ORALOAD_T	ORATIMESTA	CHAR	19	0	Time SQL statement loaded
15	INVALIDATIONS	☐	ORINVALID	ORANUMBER	INT4	10	0	Invalidations for this child cursor
16	PARSE_CALLS	☐	ORPARSEC	ORANUMBER	INT4	10	0	Parse calls for this child cursor
17	DISK_READS	☐	ORDISKR	ORAPNUMBER	DEC	31	0	Disk reads for this child cursor
18	BUFFER_GETS	☐	ORBUFFERG	ORAPNUMBER	DEC	31	0	Buffer gets for this child cursor
19	ROWS_PROCESSED	☐	ORROWPROC	ORAPNUMBER	DEC	31	0	Number of rows parsed
20	COMMAND_TYPE	☐	ORACOMTYPE	ORANUMBER	INT4	10	0	Oracle command type definition
21	OPTIMIZER_MODE	☐	ORAOPTMODE	ORAOPTMODE	CHAR	10	0	Optimizer mode
22	OPTIMIZER_COST	☐	ORAOPTCOST	ORANUMBER	INT4	10	0	Cost of this query
23	PARSING_USER_ID	☐	ORAPARSUSR	ORANUMBER	INT4	10	0	ID of the user who built this child cursor
24	PARSING_SCHEMA_ID	☐	ORAPARSSCH	ORANUMBER	INT4	10	0	Schema ID
25	KEPT_VERSIONS	☐	ORAKEPTVER	ORANUMBER	INT4	10	0	Indicator for using DBMS_SHARED_POOL
26	ADDRESS	☐	ORAADDRESS	CHAR16	CHAR	16	0	Address of statement in the cache
27	TYPE_CHK_HEAP	☐	ORATYPECHK	ORARAW4	RAW	4	0	Descriptor of type
28	HASH_VALUE	☐	ORAHASHVALN	ORANUMD22	DEC	22	0	Hash Value of Statement (DEC22)
29	PLAN_HASH_VALUE	☐	ORAHASHVALN	ORANUMD22	DEC	22	0	Hash Value of Statement (DEC22)
30	CHILD_NUMBER	☐	ORACHILDNU	ORANUMBER	INT4	10	0	Number of child cursor
31	MODULE	☐	ORAMODULE	ORACHAR64	CHAR	64	0	Program Name
32	MODULE_HASH	☐	ORAMODULEHN	ORANUMD22	DEC	22	0	Hash Value of Module (DEC22)
33	ACTION	☐	ORAACTION	CHAR64	CHAR	64	0	Action name
34	ACTION_HASH	☐	ORAACTIONHN	ORANUMD22	DEC	22	0	Hash Value of Action (DEC22)
35	SERIALIZABLE_ABORTS	☐	ORASERIAL	ORANUMBER	INT4	10	0	Number of producing ORA-8177
36	CPU_TIME	☐	ORACPUTIME	ORAPNUMBER	DEC	31	0	CPU Time in Miroseconds
37	ELAPSED_TIME	☐	ORAELAPSED	ORAPNUMBER	DEC	31	0	Elapsed Time in Microseconds
38	DB_USER	☐	ORAUSER	CHAR10	CHAR	10	0	Column USERNAME in V$SESSION
39	OUTLINE_CATEGORY	☐			CHAR	64	0
40	OUTLINE_SID	☐			FLTP	16	16
41	LAST_LOAD_TIME	☐	ORALASTLOA	CHAR19	CHAR	19	0	Last Load Time
42	END_FETCH_CNT	☐			DEC	31	0
43	PLSQL_EXEC_TIME	☐			DEC	31	0
44	DIRECT_WRITES	☐			DEC	31	0
45	SQL_ID	☐			CHAR	13	0
46	LAST_ACTIVE_TIME	☐			CHAR	19	0
47	APPLICATION_WAIT_TIME	☐			DEC	31	0
48	CONCURRENCY_WAIT_TIME	☐			DEC	31	0
49	CLUSTER_WAIT_TIME	☐			DEC	31	0
50	USER_IO_WAIT_TIME	☐			DEC	31	0
51	SQL_FULLTEXT	☐			STRG	0	0
52	.INCLUDE	☐				0	0	Derived Values from GV$SQL
53	DISK_READS_PER_EXEC	☐	ORADRPERE	ORADEC16	DEC	31	1	Number of 'disk reads' for each execution
54	BUFFER_GETS_PER_EXEC	☐	ORABGPERE	ORADEC16	DEC	31	1	Number of 'buffer gets' for each execution
55	PARSE_CALLS_PER_EXEC	☐	ORAPCPERE	ORADEC16	DEC	31	1	Parse calls per execution
56	ROWS_PROCESSED_PER_EXEC	☐	ORARPPERE	ORADEC16	DEC	31	1	Number of rows processed for each execution
57	BUFFER_GETS_PER_ROW	☐	ORABGPERR	ORADEC16	DEC	31	1	Number of 'buffer gets' for each row
58	WAIT_TIME	☐	ORAWAITTIM	ORAPNUMBER	DEC	31	0	Wait time
59	CPU_TIME_PER_EXEC	☐	ORACTPERE	ORADEC16	DEC	31	1	CPU Time per Execution
60	ELAPSED_TIME_PER_EXEC	☐	ORAELAPERE	ORADEC16	DEC	31	1	Elapsed Time per Execution
61	WAIT_TIME_PER_EXEC	☐	ORAWTPERE	ORADEC16	DEC	31	1	Wait Time per Execution
62	APPL_WAIT_TIME_PER_EXEC	☐			DEC	31	0
63	CONC_WAIT_TIME_PER_EXEC	☐			DEC	31	0
64	CLUST_WAIT_TIME_PER_EXEC	☐			DEC	31	0
65	USER_IO_WAIT_TIME_PER_EXEC	☐			DEC	31	0
66	PLSQL_TIME_PER_EXEC	☐			DEC	31	0
67	COLFIELD	☐	ORACOLFIEL	CHAR3	CHAR	3	0	Field for controlling colors in ABAP List Viewer

History

Last changed by/on	SAP	20141013
SAP Release Created in	710