SAP ABAP Table GORASQLAREA (Structure Similar to Oracle Table GV$SQLAREA)

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	GORASQLAREA	Table Relationship Diagram
Short Description	Structure Similar to Oracle Table GV$SQLAREA

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	☐	ORASHARMEM	ORAPNUMBER	DEC	31	0	Total shareable memory
4	PERSISTENT_MEM	☐	ORAPERSMEM	ORAMEMORY	INT4	10	0	Total 'persistent memory'
5	RUNTIME_MEM	☐	ORARUNTMEM	ORAMEMORY	INT4	10	0	Total "runtime memory"
6	SORTS	☐	ORASORTS	ORANUMB8	INT4	10	0	Sum of the number of sorts
7	VERSION_COUNT	☐	ORAVERSCOU	ORANUMBER	INT4	10	0	Number of children
8	LOADED_VERSIONS	☐	ORALOADVER	ORANUMB8	INT4	10	0	Loaded cursor versions
9	OPEN_VERSIONS	☐	ORAOPENVER	ORANUMB8	INT4	10	0	Number of opened cursor versions
10	USERS_OPENING	☐	ORAUSROPEN	ORANUMB8	INT4	10	0	Number of users who have opened cursor version
11	EXECUTIONS	☐	ORAEXECNUM	ORAPNUMBER	DEC	31	0	Total number of executions
12	FETCHES	☐	ORAFETCHES	ORAPNUMBER	DEC	31	0	Total Number of Fetches
13	USERS_EXECUTING	☐	ORAUSREXEC	ORANUMB7	INT4	10	0	Number of users executing
14	LOADS	☐	ORALOADS	ORANUMB5	INT4	10	0	Number of loads or reloads
15	FIRST_LOAD_TIME	☐	ORALOAD_T	ORATIMESTA	CHAR	19	0	Time SQL statement loaded
16	INVALIDATIONS	☐	ORAINVALID	ORANUMB8	INT4	10	0	Number of 'invalidations' for all versions
17	PARSE_CALLS	☐	ORAPARSEC	ORANUMB8	INT4	10	0	Sum of all 'parse calls'
18	DISK_READS	☐	ORADISKR	ORAPNUMBER	DEC	31	0	Sum of all 'disk reads'
19	BUFFER_GETS	☐	ORABUFFERG	ORAPNUMBER	DEC	31	0	Total number of "buffer gets"
20	ROWS_PROCESSED	☐	ORAROWPROC	ORAPNUMBER	DEC	31	0	Number of processed rows
21	COMMAND_TYPE	☐	ORACOMTYPE	ORANUMBER	INT4	10	0	Oracle command type definition
22	OPTIMIZER_MODE	☐	ORAOPTMODE	ORAOPTMODE	CHAR	10	0	Optimizer mode
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	HASH_VALUE	☐	ORAHASHVALN	ORANUMD22	DEC	22	0	Hash Value of Statement (DEC22)
28	DB_USER	☐	ORAUSER	CHAR10	CHAR	10	0	Column USERNAME in V$SESSION
29	MODULE	☐	ORAMODULE	ORACHAR64	CHAR	64	0	Program Name
30	MODULE_HASH	☐	ORAMODULEHN	ORANUMD22	DEC	22	0	Hash Value of Module (DEC22)
31	ACTION	☐	ORAACTION	CHAR64	CHAR	64	0	Action name
32	ACTION_HASH	☐	ORAACTIONHN	ORANUMD22	DEC	22	0	Hash Value of Action (DEC22)
33	CHILD_LATCH	☐	ORACHILDLA	ORANUMBER	INT4	10	0	Child Latch Number
34	SERIALIZABLE_ABORTS	☐	ORASERIAL	ORANUMBER	INT4	10	0	Number of producing ORA-8177
35	CPU_TIME	☐	ORACPUTIME	ORAPNUMBER	DEC	31	0	CPU Time in Miroseconds
36	ELAPSED_TIME	☐	ORAELAPSED	ORAPNUMBER	DEC	31	0	Elapsed Time in Microseconds
37	OUTLINE_CATEGORY	☐			CHAR	64	0
38	OUTLINE_SID	☐			FLTP	16	16
39	LAST_LOAD_TIME	☐	ORALASTLOA	CHAR19	CHAR	19	0	Last Load Time
40	END_FETCH_CNT	☐			DEC	31	0
41	PLSQL_EXEC_TIME	☐			DEC	31	0
42	DIRECT_WRITES	☐			DEC	31	0
43	SQL_ID	☐			CHAR	13	0
44	LAST_ACTIVE_TIME	☐			CHAR	19	0
45	APPLICATION_WAIT_TIME	☐			DEC	31	0
46	CONCURRENCY_WAIT_TIME	☐			DEC	31	0
47	CLUSTER_WAIT_TIME	☐			DEC	31	0
48	USER_IO_WAIT_TIME	☐			DEC	31	0
49	PLAN_HASH_VALUE	☐			DEC	22	0
50	SQL_FULLTEXT	☐			STRG	0	0
51	.INCLUDE	☐				0	0	Derived Values from GV$SQL
52	DISK_READS_PER_EXEC	☐	ORADRPERE	ORADEC16	DEC	31	1	Number of 'disk reads' for each execution
53	BUFFER_GETS_PER_EXEC	☐	ORABGPERE	ORADEC16	DEC	31	1	Number of 'buffer gets' for each execution
54	PARSE_CALLS_PER_EXEC	☐	ORAPCPERE	ORADEC16	DEC	31	1	Parse calls per execution
55	ROWS_PROCESSED_PER_EXEC	☐	ORARPPERE	ORADEC16	DEC	31	1	Number of rows processed for each execution
56	BUFFER_GETS_PER_ROW	☐	ORABGPERR	ORADEC16	DEC	31	1	Number of 'buffer gets' for each row
57	WAIT_TIME	☐	ORAWAITTIM	ORAPNUMBER	DEC	31	0	Wait time
58	CPU_TIME_PER_EXEC	☐	ORACTPERE	ORADEC16	DEC	31	1	CPU Time per Execution
59	ELAPSED_TIME_PER_EXEC	☐	ORAELAPERE	ORADEC16	DEC	31	1	Elapsed Time per Execution
60	WAIT_TIME_PER_EXEC	☐	ORAWTPERE	ORADEC16	DEC	31	1	Wait Time per Execution
61	APPL_WAIT_TIME_PER_EXEC	☐			DEC	31	0
62	CONC_WAIT_TIME_PER_EXEC	☐			DEC	31	0
63	CLUST_WAIT_TIME_PER_EXEC	☐			DEC	31	0
64	USER_IO_WAIT_TIME_PER_EXEC	☐			DEC	31	0
65	PLSQL_TIME_PER_EXEC	☐			DEC	31	0
66	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