SAP ABAP Table DB6_VIEW_PACKAGE_CACHE (DB6: View Package 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_PACKAGE_CACHE	Table Relationship Diagram
Short Description	DB6: View Package 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	RB_SELECTION	☐			STRG	0	0
2	STATEMENT_BY	☐			STRG	0	0
3	STATEMENT_BY_LIST	☐	DBAKEYVAL_TAB		TTYP	0	0
4	RB_STATEMENT_BY_C	☐			CHAR	1	0
5	RB_STATEMENT_BY	☐			CHAR	1	0
6	RB_CUSTOM	☐			CHAR	1	0
7	CURR_TOPN_VALUE	☐			INT4	10	0
8	DISPLAY_STATIC_PACKAGES	☐			CHAR	1	0
9	IT_DB6MON_PKGC_STMT_TAB	☐	DB6MON_PKGC_STMT_TAB		TTYP	0	0
10	COORD_STMT_EXEC_TIME	☐			INT4	10	0
11	NUM_COORD_EXECUTIONS	☐			INT4	10	0
12	AVG_COORD_STMT_EXEC_TIME	☐			DEC	8	2
13	ROWS_READ_PER_ROWS_PROCESSED	☐			INT4	10	0
14	BP_GETS_PER_ROWS_PROCESSED	☐			INT4	10	0
15	ROWS_READ	☐			INT4	10	0
16	ROWS_MODIFIED	☐			INT4	10	0
17	INVALID_ONLY	☐			CHAR	1	0
18	STMT_TEXT	☐			STRG	0	0
19	WA_DB6MON_PKGC_STMT	☐	DB6MON_PKGC_STMT		STRU	0	0
20	.INCLUDE	☐				0	0	DB6: Package Cache Statement DB structure
21	MEMBER	☐			INT4	10	0
22	SECTION_TYPE	☐			CHAR	1	0
23	INSERT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
24	EXECUTABLE_ID	☐			RSTR	0	0
25	PACKAGE_SCHEMA	☐			SSTR	128	0
26	PACKAGE_NAME	☐			SSTR	128	0
27	PACKAGE_VERSION_ID	☐			SSTR	64	0
28	SECTION_NUMBER	☐			DEC	22	0
29	EFFECTIVE_ISOLATION	☐			CHAR	2	0
30	NUM_EXECUTIONS	☐			DEC	22	0
31	NUM_EXEC_WITH_METRICS	☐			DEC	22	0
32	PREP_TIME	☐			DEC	22	0
33	TOTAL_ACT_TIME	☐			DEC	22	0
34	TOTAL_ACT_WAIT_TIME	☐			DEC	22	0
35	TOTAL_CPU_TIME	☐			DEC	22	0
36	POOL_READ_TIME	☐			DEC	22	0
37	POOL_WRITE_TIME	☐			DEC	22	0
38	DIRECT_READ_TIME	☐			DEC	22	0
39	DIRECT_WRITE_TIME	☐			DEC	22	0
40	LOCK_WAIT_TIME	☐			DEC	22	0
41	TOTAL_SECTION_SORT_TIME	☐			DEC	22	0
42	TOTAL_SECTION_SORT_PROC_TIME	☐			DEC	22	0
43	TOTAL_SECTION_SORTS	☐			DEC	22	0
44	LOCK_ESCALS	☐			DEC	22	0
45	LOCK_WAITS	☐			DEC	22	0
46	ROWS_MODIFIED	☐			DEC	22	0
47	ROWS_READ	☐			DEC	22	0
48	ROWS_RETURNED	☐			DEC	22	0
49	DIRECT_READS	☐			DEC	22	0
50	DIRECT_READ_REQS	☐			DEC	22	0
51	DIRECT_WRITES	☐			DEC	22	0
52	DIRECT_WRITE_REQS	☐			DEC	22	0
53	POOL_DATA_L_READS	☐			DEC	22	0
54	POOL_TEMP_DATA_L_READS	☐			DEC	22	0
55	POOL_XDA_L_READS	☐			DEC	22	0
56	POOL_TEMP_XDA_L_READS	☐			DEC	22	0
57	POOL_INDEX_L_READS	☐			DEC	22	0
58	POOL_TEMP_INDEX_L_READS	☐			DEC	22	0
59	POOL_DATA_P_READS	☐			DEC	22	0
60	POOL_TEMP_DATA_P_READS	☐			DEC	22	0
61	POOL_XDA_P_READS	☐			DEC	22	0
62	POOL_TEMP_XDA_P_READS	☐			DEC	22	0
63	POOL_INDEX_P_READS	☐			DEC	22	0
64	POOL_TEMP_INDEX_P_READS	☐			DEC	22	0
65	POOL_DATA_WRITES	☐			DEC	22	0
66	POOL_XDA_WRITES	☐			DEC	22	0
67	POOL_INDEX_WRITES	☐			DEC	22	0
68	TOTAL_SORTS	☐			DEC	22	0
69	POST_THRESHOLD_SORTS	☐			DEC	22	0
70	POST_SHRTHRESHOLD_SORTS	☐			DEC	22	0
71	SORT_OVERFLOWS	☐			DEC	22	0
72	WLM_QUEUE_TIME_TOTAL	☐			DEC	22	0
73	WLM_QUEUE_ASSIGNMENTS_TOTAL	☐			DEC	22	0
74	DEADLOCKS	☐			DEC	22	0
75	FCM_RECV_VOLUME	☐			DEC	22	0
76	FCM_RECVS_TOTAL	☐			DEC	22	0
77	FCM_SEND_VOLUME	☐			DEC	22	0
78	FCM_SENDS_TOTAL	☐			DEC	22	0
79	FCM_RECV_WAIT_TIME	☐			DEC	22	0
80	FCM_SEND_WAIT_TIME	☐			DEC	22	0
81	LOCK_TIMEOUTS	☐			DEC	22	0
82	LOG_BUFFER_WAIT_TIME	☐			DEC	22	0
83	NUM_LOG_BUFFER_FULL	☐			DEC	22	0
84	LOG_DISK_WAIT_TIME	☐			DEC	22	0
85	LOG_DISK_WAITS_TOTAL	☐			DEC	22	0
86	LAST_METRICS_UPDATE	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
87	NUM_COORD_EXEC	☐			DEC	22	0
88	NUM_COORD_EXEC_WITH_METRICS	☐			DEC	22	0
89	VALID	☐			CHAR	1	0
90	TOTAL_ROUTINE_TIME	☐			DEC	22	0
91	TOTAL_ROUTINE_INVOCATIONS	☐			DEC	22	0
92	ROUTINE_ID	☐			DEC	22	0
93	STMT_TYPE_ID	☐			CHAR	32	0
94	QUERY_COST_ESTIMATE	☐			DEC	22	0
95	STMT_PKG_CACHE_ID	☐			DEC	22	0
96	COORD_STMT_EXEC_TIME	☐			DEC	22	0
97	STMT_EXEC_TIME	☐			DEC	22	0
98	TOTAL_SECTION_TIME	☐			DEC	22	0
99	TOTAL_SECTION_PROC_TIME	☐			DEC	22	0
100	TOTAL_ROUTINE_NON_SECT_TIME	☐			DEC	22	0
101	TOTAL_ROUTINE_NON_SECT_PROC_TI	☐			DEC	22	0
102	AVG_COORD_STMT_EXEC_TIME	☐			DEC	22	2
103	ROWS_READ_PER_ROWS_PROCESSED	☐			DEC	22	0
104	BP_GETS_PER_ROWS_PROCESSED	☐			DEC	22	0
105	POOL_QUALITY	☐			DEC	6	2
106	COORD_MEMBER	☐			INT4	10	0
107	MEMBER_COUNT	☐			INT2	5	0
108	PREFETCH_WAITS	☐			DEC	22	0
109	PREFETCH_WAIT_TIME	☐			DEC	22	0
110	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
111	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
112	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
113	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
114	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
115	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
116	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
117	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
118	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
119	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
120	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
121	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
122	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
123	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
124	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
125	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
126	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
127	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
128	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
129	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
130	POOL_COL_L_READS	☐			DEC	22	0
131	POOL_COL_P_READS	☐			DEC	22	0
132	POOL_TEMP_COL_L_READS	☐			DEC	22	0
133	POOL_TEMP_COL_P_READS	☐			DEC	22	0
134	POOL_COL_WRITES	☐			DEC	22	0
135	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
136	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
137	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
138	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
139	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
140	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
141	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
142	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
143	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
144	PL_D_GBP_L_READS	☐			DEC	22	0
145	PL_D_GBP_P_READS	☐			DEC	22	0
146	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
147	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
148	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
149	PL_I_GBP_L_READS	☐			DEC	22	0
150	PL_I_GBP_P_READS	☐			DEC	22	0
151	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
152	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
153	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
154	PL_X_GBP_L_READS	☐			DEC	22	0
155	PL_X_GBP_P_READS	☐			DEC	22	0
156	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
157	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
158	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
159	PL_C_GBP_L_READS	☐			DEC	22	0
160	PL_C_GBP_P_READS	☐			DEC	22	0
161	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
162	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
163	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
164	GBP_HIT_RATIO	☐			DEC	22	2
165	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
166	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
167	D_GBP_HIT_RATIO	☐			DEC	22	2
168	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
169	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
170	I_GBP_HIT_RATIO	☐			DEC	22	2
171	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
172	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
173	X_GBP_HIT_RATIO	☐			DEC	22	2
174	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
175	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
176	C_GBP_HIT_RATIO	☐			DEC	22	2
177	LOCK_WAITS_GLOBAL	☐			DEC	22	0
178	LOCK_WAIT_TIME_GLOBAL	☐			DEC	22	0
179	LOCK_TIMEOUTS_GLOBAL	☐			DEC	22	0
180	LOCK_ESCALS_MAXLOCKS	☐			DEC	22	0
181	LOCK_ESCALS_LOCKLIST	☐			DEC	22	0
182	LOCK_ESCALS_GLOBAL	☐			DEC	22	0
183	RECLAIM_WAIT_TIME	☐			DEC	22	0
184	SPACEMAPPAGE_RECLAIM_WAIT_TIME	☐			DEC	22	0
185	TOTAL_RECLAIM_WAIT_TIME	☐			DEC	22	0
186	CF_WAITS	☐			DEC	22	0
187	CF_WAIT_TIME	☐			DEC	22	0
188	STMT_TEXT	☐			STRG	0	0
189	COLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
190	MEMBER_IMAGE	☐	DB6PARTNAM		CHAR	4	0	DB6: Partition Name for Listbox Element
191	SHORT_STMT_TEXT	☐			STRG	0	0
192	STMT_HASH_VALUE	☐			INT4	10	0
193	COMP_ENV_DESC	☐			RSTR	0	0
194	COORD_MEMBER_IMAGE	☐			CHAR	10	0
195	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
196	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
197	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
198	TIME_PERIOD	☐			INT4	10	0
199	EXPLAIN_VERSION	☐			INT4	10	0
200	EXPLAIN_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
201	REMOVED_DETECTION_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission

History

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