SAP ABAP Table DB6MON_PKGC_METRIC (DB6: Package Cache Statement DB structure)
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 DB6MON_PKGC_METRIC   Table Relationship Diagram
Short Description DB6: Package Cache Statement DB structure    
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 MEMBER     INT4 10   0    
2 SECTION_TYPE     CHAR 1   0    
3 INSERT_TIMESTAMP DB6DATETIM   CHAR 26   0   DBA: ISO conform timestamp with ms precission  
4 EXECUTABLE_ID     RSTR 0   0    
5 PACKAGE_SCHEMA     SSTR 128   0    
6 PACKAGE_NAME     SSTR 128   0    
7 PACKAGE_VERSION_ID     SSTR 64   0    
8 SECTION_NUMBER     DEC 22   0    
9 EFFECTIVE_ISOLATION     CHAR 2   0    
10 NUM_EXECUTIONS     DEC 22   0    
11 NUM_EXEC_WITH_METRICS     DEC 22   0    
12 PREP_TIME     DEC 22   0    
13 TOTAL_ACT_TIME     DEC 22   0    
14 TOTAL_ACT_WAIT_TIME     DEC 22   0    
15 TOTAL_CPU_TIME     DEC 22   0    
16 POOL_READ_TIME     DEC 22   0    
17 POOL_WRITE_TIME     DEC 22   0    
18 DIRECT_READ_TIME     DEC 22   0    
19 DIRECT_WRITE_TIME     DEC 22   0    
20 LOCK_WAIT_TIME     DEC 22   0    
21 TOTAL_SECTION_SORT_TIME     DEC 22   0    
22 TOTAL_SECTION_SORT_PROC_TIME     DEC 22   0    
23 TOTAL_SECTION_SORTS     DEC 22   0    
24 LOCK_ESCALS     DEC 22   0    
25 LOCK_WAITS     DEC 22   0    
26 ROWS_MODIFIED     DEC 22   0    
27 ROWS_READ     DEC 22   0    
28 ROWS_RETURNED     DEC 22   0    
29 DIRECT_READS     DEC 22   0    
30 DIRECT_READ_REQS     DEC 22   0    
31 DIRECT_WRITES     DEC 22   0    
32 DIRECT_WRITE_REQS     DEC 22   0    
33 POOL_DATA_L_READS     DEC 22   0    
34 POOL_TEMP_DATA_L_READS     DEC 22   0    
35 POOL_XDA_L_READS     DEC 22   0    
36 POOL_TEMP_XDA_L_READS     DEC 22   0    
37 POOL_INDEX_L_READS     DEC 22   0    
38 POOL_TEMP_INDEX_L_READS     DEC 22   0    
39 POOL_DATA_P_READS     DEC 22   0    
40 POOL_TEMP_DATA_P_READS     DEC 22   0    
41 POOL_XDA_P_READS     DEC 22   0    
42 POOL_TEMP_XDA_P_READS     DEC 22   0    
43 POOL_INDEX_P_READS     DEC 22   0    
44 POOL_TEMP_INDEX_P_READS     DEC 22   0    
45 POOL_DATA_WRITES     DEC 22   0    
46 POOL_XDA_WRITES     DEC 22   0    
47 POOL_INDEX_WRITES     DEC 22   0    
48 TOTAL_SORTS     DEC 22   0    
49 POST_THRESHOLD_SORTS     DEC 22   0    
50 POST_SHRTHRESHOLD_SORTS     DEC 22   0    
51 SORT_OVERFLOWS     DEC 22   0    
52 WLM_QUEUE_TIME_TOTAL     DEC 22   0    
53 WLM_QUEUE_ASSIGNMENTS_TOTAL     DEC 22   0    
54 DEADLOCKS     DEC 22   0    
55 FCM_RECV_VOLUME     DEC 22   0    
56 FCM_RECVS_TOTAL     DEC 22   0    
57 FCM_SEND_VOLUME     DEC 22   0    
58 FCM_SENDS_TOTAL     DEC 22   0    
59 FCM_RECV_WAIT_TIME     DEC 22   0    
60 FCM_SEND_WAIT_TIME     DEC 22   0    
61 LOCK_TIMEOUTS     DEC 22   0    
62 LOG_BUFFER_WAIT_TIME     DEC 22   0    
63 NUM_LOG_BUFFER_FULL     DEC 22   0    
64 LOG_DISK_WAIT_TIME     DEC 22   0    
65 LOG_DISK_WAITS_TOTAL     DEC 22   0    
66 LAST_METRICS_UPDATE DB6DATETIM   CHAR 26   0   DBA: ISO conform timestamp with ms precission  
67 NUM_COORD_EXEC     DEC 22   0    
68 NUM_COORD_EXEC_WITH_METRICS     DEC 22   0    
69 VALID     CHAR 1   0    
70 TOTAL_ROUTINE_TIME     DEC 22   0    
71 TOTAL_ROUTINE_INVOCATIONS     DEC 22   0    
72 ROUTINE_ID     DEC 22   0    
73 STMT_TYPE_ID     CHAR 32   0    
74 QUERY_COST_ESTIMATE     DEC 22   0    
75 STMT_PKG_CACHE_ID     DEC 22   0    
76 COORD_STMT_EXEC_TIME     DEC 22   0    
77 STMT_EXEC_TIME     DEC 22   0    
78 TOTAL_SECTION_TIME     DEC 22   0    
79 TOTAL_SECTION_PROC_TIME     DEC 22   0    
80 TOTAL_ROUTINE_NON_SECT_TIME     DEC 22   0    
81 TOTAL_ROUTINE_NON_SECT_PROC_TI     DEC 22   0    
82 AVG_COORD_STMT_EXEC_TIME     DEC 22   2    
83 ROWS_READ_PER_ROWS_PROCESSED     DEC 22   0    
84 BP_GETS_PER_ROWS_PROCESSED     DEC 22   0    
85 POOL_QUALITY     DEC 6   2    
86 COORD_MEMBER     INT4 10   0    
87 MEMBER_COUNT     INT2 5   0    
88 PREFETCH_WAITS     DEC 22   0    
89 PREFETCH_WAIT_TIME     DEC 22   0    
90 PL_QUED_ASYNC_DATA_PAGES     DEC 22   0    
91 PL_QUED_ASYNC_DATA_REQS     DEC 22   0    
92 PL_QUED_ASYNC_INDEX_PAGES     DEC 22   0    
93 PL_QUED_ASYNC_INDEX_REQS     DEC 22   0    
94 PL_QUED_ASYNC_OTHER_REQS     DEC 22   0    
95 PL_QUED_ASYNC_TEMP_DATA_PAGES     DEC 22   0    
96 PL_QUED_ASYNC_TEMP_DATA_REQS     DEC 22   0    
97 PL_QUED_ASYNC_TEMP_INDEX_PAGES     DEC 22   0    
98 PL_QUED_ASYNC_TEMP_INDEX_REQS     DEC 22   0    
99 PL_QUED_ASYNC_TEMP_XDA_PAGES     DEC 22   0    
100 PL_QUED_ASYNC_TEMP_XDA_REQS     DEC 22   0    
101 PL_QUED_ASYNC_XDA_PAGES     DEC 22   0    
102 PL_QUED_ASYNC_XDA_REQS     DEC 22   0    
103 PL_FAILED_ASYNC_DATA_REQS     DEC 22   0    
104 PL_FAILED_ASYNC_INDEX_REQS     DEC 22   0    
105 PL_FAILED_ASYNC_OTHER_REQS     DEC 22   0    
106 PL_FAILED_ASYNC_TEMP_DATA_REQS     DEC 22   0    
107 PL_FAILED_ASYNC_TEMP_INDEX_REQ     DEC 22   0    
108 PL_FAILED_ASYNC_TEMP_XDA_REQS     DEC 22   0    
109 PL_FAILED_ASYNC_XDA_REQS     DEC 22   0    
110 POOL_COL_L_READS     DEC 22   0    
111 POOL_COL_P_READS     DEC 22   0    
112 POOL_TEMP_COL_L_READS     DEC 22   0    
113 POOL_TEMP_COL_P_READS     DEC 22   0    
114 POOL_COL_WRITES     DEC 22   0    
115 PL_QUED_ASYNC_COL_PAGES     DEC 22   0    
116 PL_QUED_ASYNC_COL_REQS     DEC 22   0    
117 PL_QUED_ASYNC_TEMP_COL_PAGES     DEC 22   0    
118 PL_QUED_ASYNC_TEMP_COL_REQS     DEC 22   0    
119 PL_FAILED_ASYNC_COL_REQS     DEC 22   0    
120 PL_FAILED_ASYNC_TEMP_COL_REQS     DEC 22   0    
121 .INCLUDE       0   0   DB6: Global Buffer Pool Metrics - Direct Reads  
122 PL_D_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
123 PL_D_GBP_INVALID_PAGES     DEC 22   0    
124 PL_D_GBP_L_READS     DEC 22   0    
125 PL_D_GBP_P_READS     DEC 22   0    
126 PL_D_LBP_PAGES_FOUND     DEC 22   0    
127 PL_I_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
128 PL_I_GBP_INVALID_PAGES     DEC 22   0    
129 PL_I_GBP_L_READS     DEC 22   0    
130 PL_I_GBP_P_READS     DEC 22   0    
131 PL_I_LBP_PAGES_FOUND     DEC 22   0    
132 PL_X_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
133 PL_X_GBP_INVALID_PAGES     DEC 22   0    
134 PL_X_GBP_L_READS     DEC 22   0    
135 PL_X_GBP_P_READS     DEC 22   0    
136 PL_X_LBP_PAGES_FOUND     DEC 22   0    
137 PL_C_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
138 PL_C_GBP_INVALID_PAGES     DEC 22   0    
139 PL_C_GBP_L_READS     DEC 22   0    
140 PL_C_GBP_P_READS     DEC 22   0    
141 PL_C_LBP_PAGES_FOUND     DEC 22   0    
142 LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
143 LBP_GBP_IND_HIT_RATIO     DEC 22   2    
144 GBP_HIT_RATIO     DEC 22   2    
145 D_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
146 D_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
147 D_GBP_HIT_RATIO     DEC 22   2    
148 I_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
149 I_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
150 I_GBP_HIT_RATIO     DEC 22   2    
151 X_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
152 X_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
153 X_GBP_HIT_RATIO     DEC 22   2    
154 C_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
155 C_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
156 C_GBP_HIT_RATIO     DEC 22   2    
157 LOCK_WAITS_GLOBAL     DEC 22   0    
158 LOCK_WAIT_TIME_GLOBAL     DEC 22   0    
159 LOCK_TIMEOUTS_GLOBAL     DEC 22   0    
160 LOCK_ESCALS_MAXLOCKS     DEC 22   0    
161 LOCK_ESCALS_LOCKLIST     DEC 22   0    
162 LOCK_ESCALS_GLOBAL     DEC 22   0    
163 RECLAIM_WAIT_TIME     DEC 22   0    
164 SPACEMAPPAGE_RECLAIM_WAIT_TIME     DEC 22   0    
165 TOTAL_RECLAIM_WAIT_TIME     DEC 22   0    
166 CF_WAITS     DEC 22   0    
167 CF_WAIT_TIME     DEC 22   0    
History
Last changed by/on SAP  20141013 
SAP Release Created in 703