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