SAP ABAP Table DB6_VIEW_SQLCACHE_DETAIL (DB6: View Data of SQL Cache Entry)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Basic Data

Table Category	INTTAB	Structure
Structure	DB6_VIEW_SQLCACHE_DETAIL	Table Relationship Diagram
Short Description	DB6: View Data of SQL Cache Entry

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	WA	☐	DB6PMSQC		STRU	0	0
2	COMPTIME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
3	PARTITN	☐			INT4	10	0
4	ARTIF_KEY	☐			INT4	10	0
5	CALLERFLAG	☐			CHAR	1	0
6	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
7	PRGVERS	☐			CHAR	20	0
8	NUM_EXECUT	☐			DEC	22	0
9	NUM_COMPIL	☐			DEC	22	0
10	PREPTWORST	☐			DEC	22	0
11	PREPTBEST	☐			DEC	22	0
12	INT_RW_DEL	☐			DEC	22	0
13	INT_RW_INS	☐			DEC	22	0
14	RW_READ	☐			DEC	22	0
15	INT_RW_UPD	☐			DEC	22	0
16	RW_WRITTEN	☐			DEC	22	0
17	STMT_SORTS	☐			DEC	22	0
18	TOTEXETS	☐			DEC	22	0
19	TOTEXETMS	☐			DEC	22	0
20	TOTUSRCTS	☐			DEC	22	0
21	TOTUSRCTMS	☐			DEC	22	0
22	TOTSYSCTS	☐			DEC	22	0
23	TOTSYSCTMS	☐			DEC	22	0
24	EXETMSPCT	☐			DEC	22	2
25	READPCT	☐			DEC	22	2
26	WRITTENPCT	☐			DEC	22	2
27	AVGEXECTMS	☐			DEC	22	2
28	AVGRRTMS	☐			DEC	22	2
29	AVGRWTMS	☐			DEC	22	2
30	DB_NAME	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
31	STMT_LEN	☐			INT4	10	0
32	STMT_TEXT	☐			STRG	0	0
33	AUTH_ID	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
34	PL_D_LRS	☐			DEC	22	0
35	PL_D_PRS	☐			DEC	22	0
36	PL_I_LRS	☐			DEC	22	0
37	PL_I_PRS	☐			DEC	22	0
38	PL_TD_LRS	☐			DEC	22	0
39	PL_TD_PRS	☐			DEC	22	0
40	PL_TI_LRS	☐			DEC	22	0
41	PL_TI_PRS	☐			DEC	22	0
42	SORT_OVERFLOWS	☐			DEC	22	0
43	TOTAL_SORT_TIME	☐			DEC	22	0
44	PL_XDA_LRS	☐			DEC	22	0
45	PL_XDA_PRS	☐			DEC	22	0
46	PL_TEMP_XDA_LRS	☐			DEC	22	0
47	PL_TEMP_XDA_PRS	☐			DEC	22	0
48	COLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
49	BP_QAL	☐			DEC	8	2
50	STATS_FABRICATE_TIME	☐			DEC	22	0
51	SYNC_RUNSTATS_TIME	☐			DEC	22	0
52	ROWS_RETURNED	☐			DEC	22	0
53	STMT_PKGCACHE_ID	☐			DEC	22	0
54	INSERT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
55	ACC_EFFICIENCY	☐			DEC	22	1
56	BPGETS_ROWRET	☐			DEC	22	1
57	BPGETS_EXEC	☐			DEC	22	1
58	SHORT_STMT_TEXT	☐			STRG	0	0
59	PL_COL_LRS	☐			DEC	22	0
60	PL_COL_PRS	☐			DEC	22	0
61	PL_TEMP_COL_LRS	☐			DEC	22	0
62	PL_TEMP_COL_PRS	☐			DEC	22	0

History

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