SAP ABAP Table /SDF/NEWSTMTDATA (Statement Data of Shared Cursor Cache Download (Oracle))

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/NEWSTMTDATA	Table Relationship Diagram
Short Description	Statement Data of Shared Cursor Cache Download (Oracle)

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

History

Last changed by/on	SAP	20140922
SAP Release Created in