SAP ABAP Table /SDF/NEWVSQLAREA (Fields of Shared Cursor Cache in ST04)

Hierarchy

☛ ST-PI (Software Component) SAP Solution Tools Plug-In
   ⤷ SV-SMG-SDD (Application Component) Service Data Download
     ⤷ /SDF/STPI_DDIC (Package) DDIC for /SDF/STPI Development

Basic Data

Table Category	INTTAB	Structure
Structure	/SDF/NEWVSQLAREA	Table Relationship Diagram
Short Description	Fields of Shared Cursor Cache in ST04

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	☐			INT4	10	0
2	INST_NAME	☐			CHAR	16	0
3	SQL_ID	☐			CHAR	13	0
4	SQL_TEXT	☐			CHAR	80	0
5	EXPL_SOURCE	☐			CHAR	30	0
6	SHAR_MEM	☐			DEC	30	0
7	PERS_MEM	☐			DEC	30	0
8	RUNTIM_MEM	☐			DEC	30	0
9	SQLSORTS	☐			DEC	30	0
10	LOAD_VERSN	☐			DEC	30	0
11	OPEN_VERSN	☐			DEC	30	0
12	USERS_OPEN	☐			DEC	30	0
13	FETCHES	☐			DEC	30	0
14	EXECUTIONS	☐			DEC	30	0
15	PX_SERV_EXECS	☐			DEC	30	0
16	END_OF_FETCHES	☐			DEC	30	0
17	USERS_EXEC	☐			DEC	30	0
18	LOADS	☐			DEC	30	0
19	FIRST_LOAD	☐			CHAR	19	0
20	INVALIDATN	☐			INT4	10	0
21	PARSE_CALL	☐			INT4	10	0
22	DISK_READS	☐			DEC	30	0
23	DR_PERCENT	☐	/SDF/DEC10_2	/SDF/DEC10_2	DEC	10	2	Datenelement Dec länge 10 decimalstellen 2
24	BUFFER_GET	☐			DEC	30	0
25	BG_PERCENT	☐	/SDF/DEC10_2	/SDF/DEC10_2	DEC	10	2	Datenelement Dec länge 10 decimalstellen 2
26	RECS_PROCE	☐			DEC	30	0
27	ADDRESS	☐			CHAR	16	0
28	HASH_VALUE	☐			DEC	30	0
29	CHILD_NUM	☐			INT4	10	0
30	MODULENAME	☐			CHAR	64	0
31	ACTION	☐			CHAR	64	0
32	SHOW	☐			CHAR	1	0
33	INVALID	☐			CHAR	1	0
34	DISKRD_EXC	☐			DEC	30	2
35	BUFGET_EXC	☐			DEC	30	2
36	PARCAL_EXC	☐			DEC	30	0
37	RECPRO_EXC	☐			DEC	30	2
38	BUFGET_ROW	☐			DEC	30	2
39	PARSUSERID	☐			INT4	10	0
40	USER_NAME	☐			CHAR	30	0
41	CPU_TIME	☐			DEC	30	0
42	CPU_TIME_PERC	☐			DEC	10	0
43	ELAP_TIME	☐			DEC	30	0
44	ELAP_TIME_PERC	☐			DEC	10	0
45	WAIT_TIME	☐			DEC	30	0
46	CPU_EXC	☐			DEC	30	0
47	ELAP_EXC	☐			DEC	30	0
48	WAIT_EXC	☐			DEC	30	0
49	APPLW_EXEC	☐			DEC	30	0
50	CONCW_EXEC	☐			DEC	30	0
51	CLUSTW_EXEC	☐			DEC	30	0
52	OUTL_CAT	☐			CHAR	110	0
53	OUTL_SID	☐			INT4	10	0
54	RP_PERCENT	☐	/SDF/DEC10_2	/SDF/DEC10_2	DEC	10	2	Datenelement Dec länge 10 decimalstellen 2
55	RE_PERCENT	☐	/SDF/DEC10_2	/SDF/DEC10_2	DEC	10	2	Datenelement Dec länge 10 decimalstellen 2
56	LAST_LOAD_TIME	☐			CHAR	19	0
57	LAST_ACTIVE_TIME	☐			CHAR	19	0
58	DIRECT_WRITES	☐			DEC	30	0
59	OBJECT_STATUS	☐			CHAR	19	0
60	OVERFLOW	☐			CHAR	1	0
61	APPL_WAIT_TIME	☐			DEC	30	0
62	APPLW_PERC	☐	/SDF/DEC10_2	/SDF/DEC10_2	DEC	10	2	Datenelement Dec länge 10 decimalstellen 2
63	CONC_WAIT_TIME	☐			DEC	30	0
64	CONCW_PERC	☐	/SDF/DEC10_2	/SDF/DEC10_2	DEC	10	2	Datenelement Dec länge 10 decimalstellen 2
65	CLUST_WAIT_TIME	☐			DEC	30	0
66	CLUSTW_PERC	☐	/SDF/DEC10_2	/SDF/DEC10_2	DEC	10	2	Datenelement Dec länge 10 decimalstellen 2
67	USR_IO_WAIT_TIME	☐			DEC	30	0
68	PLSQL_EXEC_TIME	☐			DEC	30	0
69	USR_IO_PER_EXEC	☐			DEC	30	0
70	PLSQL_PER_EXEC	☐			DEC	30	0
71	STMT_SOURCE	☐			CHAR	1	0
72	DBA_HIST_B_TS	☐			CHAR	19	0
73	DBA_HIST_E_TS	☐			CHAR	19	0
74	SQL_PROFILE	☐			CHAR	64	0
75	PLAN_HASH_VALUE	☐			DEC	30	0
76	OPTIMIZER_MODE	☐			CHAR	10	0
77	PARSING_SCHEMA_NAME	☐			CHAR	30	0
78	IS_OBSOLETE	☐			CHAR	1	0
79	IS_BIND_SENSITIVE	☐			CHAR	1	0
80	IS_BIND_AWARE	☐			CHAR	1	0
81	SQL_PATCH	☐			CHAR	30	0
82	SQL_PLAN_BASELINE	☐			CHAR	30	0
83	SERVICE	☐			CHAR	64	0
84	AVG_HARD_PARSE_TIME	☐			DEC	30	0
85	AVG_HARD_PARSE_TIME_EXC	☐			DEC	30	2
86	IO_CEL_OFL_ELIG_BYT	☐			DEC	30	0
87	IO_CEL_OFL_ELIG_BYT_EXC	☐			DEC	30	2
88	IO_INTCON_BYT	☐			DEC	30	0
89	IO_INTCON_BYT_EXC	☐			DEC	30	2
90	PHYS_READ_REQ	☐			DEC	30	0
91	PHYS_READ_REQ_EXC	☐			DEC	30	2
92	PHYS_READ_BYT	☐			DEC	30	0
93	PHYS_READ_BYT_EXC	☐			DEC	30	2
94	PHYS_WRITE_REQ	☐			DEC	30	0
95	PHYS_WRITE_REQ_EXC	☐			DEC	30	2
96	PHYS_WRITE_BYT	☐			DEC	30	0
97	PHYS_WRITE_BYT_EXC	☐			DEC	30	2
98	EXACT_MATCHING_SIG	☐			DEC	30	0
99	FORCE_MATCHING_SIG	☐			DEC	30	0
100	IO_CEL_UNCOMP_BYT	☐			DEC	30	0
101	IO_CEL_UNCOMP_BYT_EXC	☐			DEC	30	2
102	IO_CEL_OFL_RET_BYT	☐			DEC	30	0
103	IO_CEL_OFL_RB_EXC	☐			DEC	30	2
104	OPT_PHYS_READS	☐			DEC	30	0
105	OPT_PHYS_READS_EXC	☐			DEC	30	2

History

Last changed by/on	SAP	20140922
SAP Release Created in