SAP ABAP Table GORAV_SQL_SELECT (Structure Corresponding to Oracle Table GV$SQL)

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_SELECT	Table Relationship Diagram
Short Description	Structure Corresponding to Oracle Table 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	☐	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	PARSING_USER_ID	☐	ORAPARSUSR	ORANUMBER	INT4	10	0	ID of the user who built this child cursor
21	ADDRESS	☐	ORAADDRESS	CHAR16	CHAR	16	0	Address of statement in the cache
22	HASH_VALUE	☐	ORAHASHVAL	ORAP16	FLTP	16	16	Hash value of statement
23	MODULE	☐	ORAMODULE	ORACHAR64	CHAR	64	0	Program Name
24	ACTION	☐	ORAACTION	CHAR64	CHAR	64	0	Action name
25	CPU_TIME	☐	ORACPUTIME	ORAPNUMBER	DEC	31	0	CPU Time in Miroseconds
26	ELAPSED_TIME	☐	ORAELAPSED	ORAPNUMBER	DEC	31	0	Elapsed Time in Microseconds
27	OUTLINE_CATEGORY	☐			CHAR	64	0
28	OUTLINE_SID	☐			FLTP	16	16
29	LAST_LOAD_TIME	☐	ORALASTLOA	CHAR19	CHAR	19	0	Last Load Time
30	END_FETCH_CNT	☐			DEC	31	0
31	PLSQL_EXEC_TIME	☐			DEC	31	0
32	DIRECT_WRITES	☐			DEC	31	0
33	SQL_ID	☐			CHAR	13	0
34	LAST_ACTIVE_TIME	☐			CHAR	19	0
35	APPLICATION_WAIT_TIME	☐			DEC	31	0
36	CONCURRENCY_WAIT_TIME	☐			DEC	31	0
37	CLUSTER_WAIT_TIME	☐			DEC	31	0
38	USER_IO_WAIT_TIME	☐			DEC	31	0
39	PLAN_HASH_VALUE	☐	ORAHASHVALN	ORANUMD22	DEC	22	0	Hash Value of Statement (DEC22)
40	SQL_FULLTEXT	☐			STRG	0	0

History

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