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

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	Table Relationship Diagram
Short Description	DB6: View Data of SQL Cache

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	SUM_RW_READ	☐			DEC	22	0
2	SUM_RW_WRITTEN	☐			DEC	22	0
3	SUM_TOTEXETMS	☐			DEC	22	0
4	IT_DB6PMSQC	☐	DB6PMSQC_TAB		TTYP	0	0
5	FILTER	☐	DB6_VIEW_SQLCACHE_FILTER		STRU	0	0
6	NUM_EXECUT	☐			DEC	22	0
7	TOTEXETMS	☐			DEC	22	0
8	AVGEXETMS	☐			DEC	22	0
9	PREPTWORST	☐			DEC	22	0
10	PREPTBEST	☐			DEC	22	0
11	RW_READ	☐			DEC	22	0
12	RW_WRITTEN	☐			DEC	22	0
13	STMT_TEXT	☐			STRG	0	0
14	ACC_EFFICIENCY	☐			INT4	10	0
15	ROW_COUNT	☐			DEC	22	0

History

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