ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
6606.02 |
1703 |
1189084 |
2018-06-17 08:17 |
2018-06-17 11:17 |
customer order: creation |
417.78 |
97 |
75201 |
2018-06-17 08:17 |
2018-06-17 11:17 |
customer order: refuse |
34.11 |
55 |
6139 |
2018-06-17 08:17 |
2018-06-17 11:17 |
order to supplier: creation |
106.59 |
356 |
19186 |
2018-06-17 08:17 |
2018-06-17 11:17 |
order to supplier: removal |
3.10 |
5262 |
555 |
2018-06-17 08:17 |
2018-06-17 11:17 |
invoice (draft): creation |
106.06 |
502 |
19090 |
2018-06-17 08:17 |
2018-06-17 11:17 |
invoice (draft): removal |
48.41 |
96 |
8666 |
2018-06-17 08:17 |
2018-06-17 11:17 |
invoice accept: apply |
61.83 |
3043 |
11130 |
2018-06-17 08:17 |
2018-06-17 11:17 |
invoice accept: cancel |
21.40 |
459 |
3830 |
2018-06-17 08:17 |
2018-06-17 11:17 |
customer reserve: creation |
3759.35 |
43 |
676683 |
2018-06-17 08:17 |
2018-06-17 11:17 |
customer reserve: removal |
1464.99 |
10 |
263699 |
2018-06-17 08:17 |
2018-06-17 11:17 |
realization accept: apply |
193.82 |
84 |
34888 |
2018-06-17 08:17 |
2018-06-17 11:17 |
realization accept: cancel |
91.41 |
27 |
16454 |
2018-06-17 08:17 |
2018-06-17 11:17 |
payment from customer: creation |
139.57 |
114 |
25122 |
2018-06-17 08:17 |
2018-06-17 11:17 |
payment from customer: removal |
13.16 |
30 |
2368 |
2018-06-17 08:17 |
2018-06-17 11:17 |
payment to supplier: creation |
115.08 |
74 |
20715 |
2018-06-17 08:17 |
2018-06-17 11:17 |
payment to supplier: removal |
8.15 |
45 |
1458 |
2018-06-17 08:17 |
2018-06-17 11:17 |
service: total inventory turnovers |
10.97 |
750 |
1964 |
2018-06-17 08:17 |
2018-06-17 11:17 |
service: total monetary turnovers |
10.69 |
13 |
1924 |
2018-06-17 08:17 |
2018-06-17 11:17 |
service: refresh index statistics |
0.07 |
21290 |
12 |
2018-06-17 08:17 |
2018-06-17 11:17 |
Done for 84350 ms, from 11:18:57.54 to 11:20:21.89.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
5057 |
104210 |
91025 |
13185 |
12.65 |
08:17:03 |
08:35:03 |
interval # 2, overall |
2 |
6722 |
139953 |
120987 |
18966 |
13.55 |
08:35:04 |
08:53:04 |
interval # 3, overall |
3 |
7353 |
158205 |
132350 |
25855 |
16.34 |
08:53:05 |
09:11:05 |
interval # 4, overall |
4 |
5676 |
123702 |
102169 |
21533 |
17.41 |
09:11:06 |
09:29:06 |
interval # 5, overall |
5 |
7257 |
159867 |
130617 |
29250 |
18.30 |
09:29:07 |
09:47:07 |
interval # 6, overall |
6 |
6590 |
141702 |
118619 |
23083 |
16.29 |
09:47:08 |
10:05:08 |
interval # 7, overall |
7 |
6872 |
149883 |
123697 |
26186 |
17.47 |
10:05:09 |
10:23:09 |
interval # 8, overall |
8 |
7522 |
162097 |
135399 |
26698 |
16.47 |
10:23:10 |
10:41:10 |
interval # 9, overall |
9 |
7262 |
159015 |
130713 |
28302 |
17.80 |
10:41:11 |
10:59:11 |
interval # 10, overall |
10 |
5750 |
128595 |
103508 |
25087 |
19.51 |
10:59:12 |
11:17:12 |
Done for 252700 ms, from 11:24:30.29 to 11:28:42.99.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
6093.76 |
0.6870 |
1.2990 |
2316 |
100 |
TEST_TIME |
2 |
5034.06 |
0.7985 |
1.1862 |
2163 |
100 |
TEST_TIME |
3 |
4773.36 |
0.8343 |
1.1502 |
1682 |
100 |
TEST_TIME |
4 |
4483.34 |
0.9185 |
1.0978 |
1645 |
100 |
TEST_TIME |
5 |
4348.10 |
0.9057 |
1.0899 |
1743 |
100 |
TEST_TIME |
6 |
4369.59 |
0.9062 |
1.0820 |
1746 |
100 |
TEST_TIME |
7 |
4415.84 |
0.9181 |
1.0652 |
1609 |
100 |
TEST_TIME |
8 |
4430.68 |
0.9291 |
1.0696 |
1539 |
100 |
TEST_TIME |
9 |
4535.64 |
0.9288 |
1.0635 |
1797 |
100 |
TEST_TIME |
10 |
4627.46 |
0.9382 |
1.0594 |
1852 |
100 |
TEST_TIME |
11 |
4735.17 |
0.9411 |
1.0495 |
1546 |
100 |
TEST_TIME |
12 |
4765.65 |
0.9560 |
1.0500 |
1336 |
100 |
TEST_TIME |
13 |
4822.77 |
0.9578 |
1.0429 |
1457 |
100 |
TEST_TIME |
14 |
4845.77 |
0.9639 |
1.0396 |
1404 |
100 |
TEST_TIME |
15 |
4970.93 |
0.9458 |
1.0452 |
2194 |
100 |
TEST_TIME |
16 |
5074.46 |
0.9599 |
1.0465 |
2108 |
100 |
TEST_TIME |
17 |
5141.02 |
0.9722 |
1.0301 |
2072 |
100 |
TEST_TIME |
18 |
5089.90 |
0.9827 |
1.0197 |
973 |
93 |
TEST_TIME |
19 |
5121.18 |
0.9601 |
1.0385 |
1955 |
100 |
TEST_TIME |
20 |
5240.91 |
0.9641 |
1.0350 |
1838 |
100 |
TEST_TIME |
21 |
5330.50 |
0.9695 |
1.0264 |
1695 |
100 |
TEST_TIME |
22 |
5371.61 |
0.9726 |
1.0275 |
1802 |
100 |
TEST_TIME |
23 |
5392.93 |
0.9791 |
1.0242 |
1594 |
100 |
TEST_TIME |
24 |
5420.78 |
0.9765 |
1.0213 |
1607 |
100 |
TEST_TIME |
25 |
5445.66 |
0.9760 |
1.0189 |
1478 |
100 |
TEST_TIME |
26 |
5445.04 |
0.9802 |
1.0196 |
1600 |
100 |
TEST_TIME |
27 |
5460.43 |
0.9791 |
1.0252 |
1407 |
100 |
TEST_TIME |
28 |
5464.04 |
0.9879 |
1.0161 |
1185 |
100 |
TEST_TIME |
29 |
5452.77 |
0.9831 |
1.0232 |
1215 |
100 |
TEST_TIME |
30 |
5513.41 |
0.9782 |
1.0242 |
1926 |
100 |
TEST_TIME |
31 |
5612.75 |
0.9741 |
1.0297 |
1922 |
100 |
TEST_TIME |
32 |
5715.18 |
0.9796 |
1.0176 |
1377 |
100 |
TEST_TIME |
33 |
5766.48 |
0.9780 |
1.0237 |
1669 |
100 |
TEST_TIME |
34 |
5849.57 |
0.9794 |
1.0193 |
1412 |
100 |
TEST_TIME |
35 |
5916.67 |
0.9789 |
1.0184 |
1528 |
100 |
TEST_TIME |
36 |
5963.29 |
0.9825 |
1.0162 |
1258 |
100 |
TEST_TIME |
37 |
5987.04 |
0.9849 |
1.0162 |
1392 |
100 |
TEST_TIME |
38 |
6012.91 |
0.9852 |
1.0118 |
1420 |
100 |
TEST_TIME |
39 |
6020.26 |
0.9847 |
1.0135 |
1373 |
100 |
TEST_TIME |
40 |
6059.04 |
0.9818 |
1.0129 |
1311 |
100 |
TEST_TIME |
41 |
6066.39 |
0.9870 |
1.0122 |
1289 |
100 |
TEST_TIME |
42 |
6061.86 |
0.9889 |
1.0125 |
1196 |
100 |
TEST_TIME |
43 |
6064.72 |
0.9885 |
1.0120 |
1306 |
100 |
TEST_TIME |
44 |
6084.27 |
0.9858 |
1.0101 |
1192 |
100 |
TEST_TIME |
45 |
6103.72 |
0.9845 |
1.0149 |
2170 |
100 |
TEST_TIME |
46 |
6180.26 |
0.9806 |
1.0176 |
2038 |
100 |
TEST_TIME |
47 |
6238.87 |
0.9871 |
1.0144 |
1956 |
100 |
TEST_TIME |
48 |
6283.62 |
0.9862 |
1.0149 |
1889 |
100 |
TEST_TIME |
49 |
6334.70 |
0.9864 |
1.0140 |
1673 |
100 |
TEST_TIME |
50 |
6383.18 |
0.9862 |
1.0145 |
1715 |
100 |
TEST_TIME |
51 |
6421.17 |
0.9887 |
1.0104 |
1698 |
100 |
TEST_TIME |
52 |
6431.26 |
0.9896 |
1.0098 |
1487 |
100 |
TEST_TIME |
53 |
6437.75 |
0.9897 |
1.0080 |
1388 |
100 |
TEST_TIME |
54 |
6383.40 |
0.9979 |
1.0027 |
1229 |
93 |
TEST_TIME |
55 |
6287.68 |
0.9995 |
1.0004 |
140 |
57 |
TEST_TIME |
56 |
6180.58 |
0.9996 |
1.0004 |
92 |
57 |
TEST_TIME |
57 |
6079.63 |
0.9992 |
1.0006 |
65 |
54 |
TEST_TIME |
58 |
5980.55 |
0.9997 |
1.0002 |
66 |
52 |
TEST_TIME |
59 |
5919.38 |
0.9934 |
1.0068 |
481 |
100 |
TEST_TIME |
60 |
5947.36 |
0.9853 |
1.0152 |
2158 |
100 |
TEST_TIME |
61 |
6018.06 |
0.9868 |
1.0108 |
1980 |
100 |
TEST_TIME |
62 |
6063.52 |
0.9870 |
1.0114 |
1838 |
100 |
TEST_TIME |
63 |
6096.34 |
0.9900 |
1.0126 |
2010 |
100 |
TEST_TIME |
64 |
6146.35 |
0.9886 |
1.0098 |
1866 |
100 |
TEST_TIME |
65 |
6164.85 |
0.9913 |
1.0075 |
1662 |
100 |
TEST_TIME |
66 |
6181.20 |
0.9896 |
1.0107 |
1595 |
100 |
TEST_TIME |
67 |
6217.32 |
0.9899 |
1.0084 |
1549 |
100 |
TEST_TIME |
68 |
6239.44 |
0.9901 |
1.0076 |
1451 |
100 |
TEST_TIME |
69 |
6246.54 |
0.9919 |
1.0082 |
1448 |
100 |
TEST_TIME |
70 |
6256.05 |
0.9923 |
1.0077 |
1346 |
100 |
TEST_TIME |
71 |
6248.20 |
0.9950 |
1.0059 |
1383 |
100 |
TEST_TIME |
72 |
6230.20 |
0.9948 |
1.0115 |
1378 |
100 |
TEST_TIME |
73 |
6245.21 |
0.9953 |
1.0066 |
1269 |
100 |
TEST_TIME |
74 |
6244.48 |
0.9932 |
1.0045 |
1166 |
100 |
TEST_TIME |
75 |
6237.73 |
0.9922 |
1.0064 |
1782 |
100 |
TEST_TIME |
76 |
6265.92 |
0.9887 |
1.0089 |
1734 |
100 |
TEST_TIME |
77 |
6297.07 |
0.9909 |
1.0093 |
1752 |
100 |
TEST_TIME |
78 |
6319.57 |
0.9935 |
1.0062 |
1903 |
100 |
TEST_TIME |
79 |
6325.83 |
0.9925 |
1.0085 |
1433 |
100 |
TEST_TIME |
80 |
6342.18 |
0.9933 |
1.0065 |
1558 |
100 |
TEST_TIME |
81 |
6356.77 |
0.9918 |
1.0078 |
1556 |
100 |
TEST_TIME |
82 |
6364.63 |
0.9943 |
1.0062 |
1444 |
100 |
TEST_TIME |
83 |
6374.59 |
0.9925 |
1.0074 |
1434 |
100 |
TEST_TIME |
84 |
6387.69 |
0.9933 |
1.0099 |
1424 |
100 |
TEST_TIME |
85 |
6411.07 |
0.9943 |
1.0052 |
1307 |
100 |
TEST_TIME |
86 |
6420.13 |
0.9921 |
1.0059 |
1217 |
100 |
TEST_TIME |
87 |
6425.58 |
0.9937 |
1.0052 |
1354 |
100 |
TEST_TIME |
88 |
6424.29 |
0.9940 |
1.0061 |
1331 |
100 |
TEST_TIME |
89 |
6423.22 |
0.9950 |
1.0052 |
1273 |
100 |
TEST_TIME |
90 |
6454.93 |
0.9891 |
1.0084 |
1776 |
100 |
TEST_TIME |
91 |
6505.56 |
0.9896 |
1.0095 |
1793 |
100 |
TEST_TIME |
92 |
6552.40 |
0.9914 |
1.0063 |
1677 |
100 |
TEST_TIME |
93 |
6557.47 |
0.9947 |
1.0056 |
1530 |
100 |
TEST_TIME |
94 |
6562.16 |
0.9942 |
1.0054 |
1533 |
100 |
TEST_TIME |
95 |
6549.23 |
0.9968 |
1.0027 |
697 |
100 |
TEST_TIME |
96 |
6499.90 |
0.9998 |
1.0003 |
179 |
91 |
TEST_TIME |
97 |
6436.81 |
0.9997 |
1.0003 |
109 |
83 |
TEST_TIME |
98 |
6375.16 |
0.9997 |
1.0004 |
128 |
89 |
TEST_TIME |
99 |
6365.73 |
0.9918 |
1.0066 |
1913 |
100 |
TEST_TIME |
100 |
6384.67 |
0.9938 |
1.0053 |
1544 |
100 |
TEST_TIME |
101 |
6388.31 |
0.9947 |
1.0042 |
1446 |
100 |
TEST_TIME |
102 |
6377.88 |
0.9960 |
1.0042 |
1272 |
100 |
TEST_TIME |
103 |
6368.37 |
0.9959 |
1.0031 |
1445 |
100 |
TEST_TIME |
104 |
6350.46 |
0.9962 |
1.0046 |
1395 |
100 |
TEST_TIME |
105 |
6362.17 |
0.9932 |
1.0073 |
1750 |
100 |
TEST_TIME |
106 |
6404.65 |
0.9912 |
1.0088 |
1700 |
100 |
TEST_TIME |
107 |
6446.05 |
0.9929 |
1.0067 |
1742 |
100 |
TEST_TIME |
108 |
6467.19 |
0.9942 |
1.0058 |
1646 |
100 |
TEST_TIME |
109 |
6475.11 |
0.9954 |
1.0054 |
1543 |
100 |
TEST_TIME |
110 |
6490.79 |
0.9945 |
1.0051 |
1562 |
100 |
TEST_TIME |
111 |
6501.01 |
0.9945 |
1.0065 |
1492 |
100 |
TEST_TIME |
112 |
6518.89 |
0.9948 |
1.0051 |
1441 |
100 |
TEST_TIME |
113 |
6530.31 |
0.9945 |
1.0060 |
1403 |
100 |
TEST_TIME |
114 |
6545.35 |
0.9950 |
1.0032 |
1253 |
100 |
TEST_TIME |
115 |
6540.34 |
0.9953 |
1.0049 |
1373 |
100 |
TEST_TIME |
116 |
6544.56 |
0.9956 |
1.0048 |
1217 |
100 |
TEST_TIME |
117 |
6540.69 |
0.9968 |
1.0034 |
1057 |
100 |
TEST_TIME |
118 |
6529.67 |
0.9965 |
1.0041 |
1122 |
100 |
TEST_TIME |
119 |
6530.07 |
0.9956 |
1.0030 |
1010 |
100 |
TEST_TIME |
120 |
6533.74 |
0.9940 |
1.0087 |
1579 |
100 |
TEST_TIME |
121 |
6569.36 |
0.9949 |
1.0060 |
1463 |
100 |
TEST_TIME |
122 |
6587.57 |
0.9950 |
1.0049 |
1699 |
100 |
TEST_TIME |
123 |
6600.97 |
0.9949 |
1.0069 |
1416 |
100 |
TEST_TIME |
124 |
6595.21 |
0.9997 |
1.0002 |
194 |
88 |
TEST_TIME |
125 |
6546.69 |
0.9996 |
1.0003 |
96 |
77 |
TEST_TIME |
126 |
6498.79 |
0.9997 |
1.0002 |
63 |
58 |
TEST_TIME |
127 |
6450.77 |
0.9997 |
1.0002 |
64 |
61 |
TEST_TIME |
128 |
6436.94 |
0.9945 |
1.0061 |
1652 |
100 |
TEST_TIME |
129 |
6465.86 |
0.9939 |
1.0058 |
1612 |
100 |
TEST_TIME |
130 |
6476.95 |
0.9963 |
1.0037 |
1537 |
100 |
TEST_TIME |
131 |
6479.78 |
0.9957 |
1.0040 |
1377 |
100 |
TEST_TIME |
132 |
6488.69 |
0.9950 |
1.0051 |
1236 |
100 |
TEST_TIME |
133 |
6501.02 |
0.9956 |
1.0043 |
1235 |
100 |
TEST_TIME |
134 |
6506.99 |
0.9959 |
1.0033 |
1223 |
100 |
TEST_TIME |
135 |
6512.47 |
0.9951 |
1.0052 |
2161 |
100 |
TEST_TIME |
136 |
6531.43 |
0.9949 |
1.0066 |
1987 |
100 |
TEST_TIME |
137 |
6560.48 |
0.9949 |
1.0045 |
1713 |
100 |
TEST_TIME |
138 |
6581.33 |
0.9943 |
1.0061 |
1562 |
100 |
TEST_TIME |
139 |
6600.75 |
0.9959 |
1.0042 |
1595 |
100 |
TEST_TIME |
140 |
6612.83 |
0.9952 |
1.0064 |
1531 |
100 |
TEST_TIME |
141 |
6628.94 |
0.9968 |
1.0029 |
1411 |
99 |
TEST_TIME |
142 |
6624.49 |
0.9965 |
1.0050 |
1386 |
100 |
TEST_TIME |
143 |
6635.30 |
0.9964 |
1.0039 |
1253 |
100 |
TEST_TIME |
144 |
6646.25 |
0.9953 |
1.0036 |
1269 |
100 |
TEST_TIME |
145 |
6647.21 |
0.9966 |
1.0026 |
1272 |
100 |
TEST_TIME |
146 |
6649.10 |
0.9955 |
1.0042 |
1102 |
100 |
TEST_TIME |
147 |
6652.71 |
0.9969 |
1.0054 |
1089 |
100 |
TEST_TIME |
148 |
6664.63 |
0.9971 |
1.0032 |
1096 |
100 |
TEST_TIME |
149 |
6655.64 |
0.9980 |
1.0019 |
1167 |
100 |
TEST_TIME |
150 |
6656.06 |
0.9952 |
1.0041 |
1614 |
100 |
TEST_TIME |
151 |
6669.44 |
0.9955 |
1.0042 |
1651 |
100 |
TEST_TIME |
152 |
6682.97 |
0.9956 |
1.0038 |
1771 |
100 |
TEST_TIME |
153 |
6689.90 |
0.9963 |
1.0031 |
1712 |
100 |
TEST_TIME |
154 |
6695.71 |
0.9958 |
1.0034 |
1508 |
100 |
TEST_TIME |
155 |
6709.03 |
0.9950 |
1.0035 |
1460 |
100 |
TEST_TIME |
156 |
6710.05 |
0.9969 |
1.0030 |
1387 |
100 |
TEST_TIME |
157 |
6717.51 |
0.9955 |
1.0040 |
1200 |
100 |
TEST_TIME |
158 |
6720.07 |
0.9973 |
1.0028 |
1381 |
100 |
TEST_TIME |
159 |
6716.44 |
0.9970 |
1.0039 |
1235 |
100 |
TEST_TIME |
160 |
6727.33 |
0.9960 |
1.0027 |
1165 |
100 |
TEST_TIME |
161 |
6719.09 |
0.9977 |
1.0020 |
1173 |
99 |
TEST_TIME |
162 |
6715.24 |
0.9964 |
1.0035 |
1068 |
100 |
TEST_TIME |
163 |
6713.83 |
0.9976 |
1.0021 |
1105 |
100 |
TEST_TIME |
164 |
6688.80 |
0.9997 |
1.0001 |
336 |
99 |
TEST_TIME |
165 |
6649.81 |
0.9999 |
1.0000 |
123 |
83 |
TEST_TIME |
166 |
6611.82 |
0.9997 |
1.0001 |
116 |
80 |
TEST_TIME |
167 |
6573.97 |
0.9999 |
1.0000 |
104 |
77 |
TEST_TIME |
168 |
6537.46 |
0.9996 |
1.0002 |
161 |
89 |
TEST_TIME |
169 |
6540.78 |
0.9938 |
1.0049 |
2063 |
100 |
TEST_TIME |
170 |
6561.60 |
0.9958 |
1.0065 |
1437 |
100 |
TEST_TIME |
171 |
6586.88 |
0.9967 |
1.0026 |
1514 |
100 |
TEST_TIME |
172 |
6590.66 |
0.9962 |
1.0030 |
1344 |
100 |
TEST_TIME |
173 |
6598.85 |
0.9961 |
1.0043 |
1300 |
100 |
TEST_TIME |
174 |
6614.69 |
0.9962 |
1.0027 |
1143 |
100 |
TEST_TIME |
175 |
6611.66 |
0.9975 |
1.0023 |
1240 |
100 |
TEST_TIME |
176 |
6606.77 |
0.9974 |
1.0028 |
1308 |
100 |
TEST_TIME |
177 |
6611.32 |
0.9965 |
1.0034 |
1250 |
100 |
TEST_TIME |
178 |
6617.09 |
0.9969 |
1.0023 |
1195 |
100 |
TEST_TIME |
179 |
6620.10 |
0.9963 |
1.0031 |
1129 |
100 |
TEST_TIME |
180 |
6605.56 |
0.9998 |
1.0000 |
111 |
100 |
Done for 10590 ms, from 11:28:44.86 to 11:28:55.45.
TRACED_DATA |
ITRV_NO |
SP_CLIENT_ORDER |
SP_CANCEL_CLIENT_ORDER |
SP_SUPPLIER_ORDER |
SP_CANCEL_SUPPLIER_ORDER |
SP_SUPPLIER_INVOICE |
SP_CANCEL_SUPPLIER_INVOICE |
SP_ADD_INVOICE_TO_STOCK |
SP_CANCEL_ADDING_INVOICE |
SP_CUSTOMER_RESERVE |
SP_CANCEL_CUSTOMER_RESERVE |
SP_RESERVE_WRITE_OFF |
SP_CANCEL_WRITE_OFF |
SP_PAY_FROM_CUSTOMER |
SP_CANCEL_PAY_FROM_CUSTOMER |
SP_PAY_TO_SUPPLIER |
SP_CANCEL_PAY_TO_SUPPLIER |
SRV_MAKE_INVNT_SALDO |
SRV_MAKE_MONEY_SALDO |
SRV_RECALC_IDX_STAT |
ITRV_BEG |
ITRV_END |
fetches per second |
1 |
82161 |
60034 |
75385 |
108453 |
70026 |
21166 |
100776 |
71551 |
97246 |
98369 |
78469 |
83827 |
87144 |
117833 |
166627 |
125999 |
149256 |
<null> |
<null> |
08:17:03 |
08:35:03 |
fetches per second |
2 |
76412 |
195969 |
65110 |
<null> |
68457 |
105506 |
104051 |
80238 |
84640 |
170714 |
98622 |
54631 |
102704 |
132041 |
128222 |
121035 |
189421 |
541833 |
<null> |
08:35:04 |
08:53:04 |
fetches per second |
3 |
67318 |
107523 |
90348 |
<null> |
75942 |
<null> |
98347 |
95745 |
112223 |
87335 |
108524 |
67376 |
114045 |
144800 |
121272 |
59406 |
67656 |
155857 |
<null> |
08:53:05 |
09:11:05 |
fetches per second |
4 |
80975 |
95333 |
58613 |
41129 |
73638 |
<null> |
114505 |
55585 |
121168 |
55871 |
104768 |
61322 |
91941 |
175250 |
185199 |
205250 |
161271 |
303625 |
<null> |
09:11:06 |
09:29:06 |
fetches per second |
5 |
69840 |
77716 |
49821 |
<null> |
67436 |
119576 |
90812 |
<null> |
101019 |
74145 |
105705 |
101149 |
92001 |
51105 |
123363 |
92677 |
199995 |
157444 |
<null> |
09:29:07 |
09:47:07 |
fetches per second |
6 |
72045 |
116246 |
90385 |
188510 |
80651 |
<null> |
111964 |
<null> |
46313 |
63499 |
99460 |
46440 |
73209 |
<null> |
131330 |
73684 |
128362 |
198273 |
<null> |
09:47:08 |
10:05:08 |
fetches per second |
7 |
71420 |
195555 |
63673 |
<null> |
64042 |
45687 |
95316 |
37020 |
<null> |
141806 |
75675 |
39673 |
93037 |
107076 |
108290 |
94702 |
177968 |
23930 |
<null> |
10:05:09 |
10:23:09 |
fetches per second |
8 |
85738 |
165124 |
76871 |
104201 |
66494 |
99057 |
116750 |
116195 |
95714 |
72812 |
100891 |
60388 |
126789 |
97968 |
83148 |
126270 |
<null> |
459000 |
<null> |
10:23:10 |
10:41:10 |
fetches per second |
9 |
56123 |
190767 |
77687 |
42629 |
73865 |
<null> |
87117 |
<null> |
123475 |
<null> |
91300 |
44553 |
120581 |
109312 |
108991 |
113750 |
269472 |
928000 |
<null> |
10:41:11 |
10:59:11 |
fetches per second |
10 |
61914 |
67313 |
66137 |
125196 |
72046 |
120637 |
97063 |
<null> |
76416 |
99322 |
52244 |
30828 |
87074 |
125937 |
103574 |
116923 |
157078 |
<null> |
<null> |
10:59:12 |
11:17:12 |
marks per second |
1 |
18060 |
7912 |
17018 |
23313 |
15086 |
3921 |
12469 |
15267 |
13718 |
20255 |
15543 |
14006 |
9516 |
18666 |
12497 |
20166 |
16070 |
<null> |
<null> |
08:17:03 |
08:35:03 |
marks per second |
2 |
16841 |
25974 |
14339 |
<null> |
15572 |
25485 |
14314 |
15850 |
9999 |
26314 |
15608 |
9319 |
11046 |
25541 |
15266 |
22125 |
16131 |
39833 |
<null> |
08:35:04 |
08:53:04 |
marks per second |
3 |
14403 |
14717 |
20356 |
<null> |
17349 |
<null> |
14139 |
17261 |
13937 |
18139 |
17627 |
11123 |
10449 |
21400 |
11685 |
10096 |
11342 |
16714 |
<null> |
08:53:05 |
09:11:05 |
marks per second |
4 |
18129 |
14207 |
13239 |
9768 |
16733 |
<null> |
15623 |
9265 |
12198 |
10114 |
12195 |
10638 |
8589 |
28650 |
14894 |
35750 |
12414 |
19781 |
<null> |
09:11:06 |
09:29:06 |
marks per second |
5 |
15103 |
10326 |
10582 |
<null> |
14707 |
27361 |
11819 |
<null> |
13528 |
11666 |
13665 |
18070 |
8221 |
8466 |
13686 |
13913 |
31757 |
17000 |
<null> |
09:29:07 |
09:47:07 |
marks per second |
6 |
15628 |
15607 |
20270 |
37322 |
17328 |
<null> |
15585 |
<null> |
7078 |
11606 |
13910 |
7200 |
4847 |
<null> |
19324 |
11823 |
19837 |
13953 |
<null> |
09:47:08 |
10:05:08 |
marks per second |
7 |
15557 |
26220 |
13659 |
<null> |
14541 |
11133 |
14120 |
5962 |
<null> |
23165 |
9882 |
5264 |
7234 |
29846 |
19154 |
15952 |
16966 |
1000 |
<null> |
10:05:09 |
10:23:09 |
marks per second |
8 |
18701 |
20018 |
17244 |
27485 |
14412 |
24886 |
16384 |
21231 |
10226 |
13072 |
12881 |
10439 |
7608 |
16696 |
16187 |
23416 |
<null> |
23200 |
<null> |
10:23:10 |
10:41:10 |
marks per second |
9 |
11613 |
25594 |
17221 |
7382 |
16052 |
<null> |
12935 |
<null> |
22468 |
<null> |
12651 |
7396 |
5689 |
18068 |
18878 |
22250 |
21347 |
101000 |
<null> |
10:41:11 |
10:59:11 |
marks per second |
10 |
13263 |
9259 |
13774 |
29743 |
14483 |
30193 |
12668 |
<null> |
11527 |
16233 |
5528 |
4457 |
4260 |
28312 |
19785 |
22558 |
12093 |
<null> |
<null> |
10:59:12 |
11:17:12 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
08:17:03 |
08:35:03 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:35:04 |
08:53:04 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:53:05 |
09:11:05 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
09:11:06 |
09:29:06 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
09:29:07 |
09:47:07 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
09:47:08 |
10:05:08 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:05:09 |
10:23:09 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
10:23:10 |
10:41:10 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:41:11 |
10:59:11 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
10:59:12 |
11:17:12 |
writes/marks*100 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
3 |
<null> |
<null> |
08:17:03 |
08:35:03 |
writes/marks*100 |
2 |
1 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
08:35:04 |
08:53:04 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
08:53:05 |
09:11:05 |
writes/marks*100 |
4 |
0 |
0 |
1 |
0 |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
09:11:06 |
09:29:06 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
09:29:07 |
09:47:07 |
writes/marks*100 |
6 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
4 |
0 |
<null> |
09:47:08 |
10:05:08 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:05:09 |
10:23:09 |
writes/marks*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
<null> |
0 |
<null> |
10:23:10 |
10:41:10 |
writes/marks*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
10:41:11 |
10:59:11 |
writes/marks*100 |
10 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
<null> |
<null> |
10:59:12 |
11:17:12 |
Done for 9820 ms, from 11:28:57.12 to 11:29:06.94.
UNIT |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
OK_MIN_MS |
OK_MAX_MS |
OK_AVG_MS |
CNT_LK_CONFL |
JOB_BEG |
JOB_END |
doc_list_aiud |
2128899 |
1900436 |
228463 |
10.73 |
0 |
12901 |
5 |
228463 |
2018-06-17 08:17 |
2018-06-17 11:17 |
doc_list_biud |
2129391 |
1900436 |
228955 |
10.75 |
0 |
91166 |
3 |
228955 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_add_invoice_to_stock |
17942 |
11130 |
6812 |
37.96 |
0 |
357163 |
3043 |
6812 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_cancel_adding_invoice |
5249 |
3830 |
1419 |
27.03 |
0 |
177731 |
459 |
1419 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_cancel_client_order |
6285 |
6139 |
146 |
2.32 |
0 |
22355 |
55 |
146 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_cancel_customer_reserve |
479222 |
263699 |
215523 |
44.97 |
0 |
30467 |
10 |
215523 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_cancel_pay_from_customer |
2382 |
2368 |
14 |
0.58 |
0 |
13806 |
30 |
14 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_cancel_pay_to_supplier |
1460 |
1458 |
2 |
0.13 |
0 |
19703 |
45 |
2 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_cancel_supplier_invoice |
11517 |
8666 |
2851 |
24.75 |
0 |
10358 |
96 |
2851 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_cancel_supplier_order |
1492 |
555 |
937 |
62.80 |
0 |
145299 |
5262 |
937 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_cancel_write_off |
26128 |
16454 |
9674 |
37.02 |
0 |
9453 |
27 |
9674 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_client_order |
75201 |
75201 |
0 |
0.00 |
0 |
44975 |
97 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_customer_reserve |
676683 |
676683 |
0 |
0.00 |
0 |
85754 |
43 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_fill_shopping_cart |
113778 |
113477 |
301 |
0.26 |
0 |
9282 |
16 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_fill_shopping_cart_clo_res |
676683 |
676683 |
0 |
0.00 |
0 |
23385 |
3 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_get_clo_for_invoice |
11130 |
11130 |
0 |
0.00 |
0 |
41980 |
79 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_kill_cost_storno |
34837 |
24110 |
10727 |
30.79 |
0 |
6318 |
3 |
10727 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_kill_qstorno_ret_qs2qd |
996047 |
553073 |
442974 |
44.47 |
0 |
12574 |
4 |
442974 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_kill_qty_storno |
574250 |
345361 |
228889 |
39.85 |
0 |
91166 |
13 |
228889 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_lock_selected_doc |
73790 |
64634 |
9156 |
12.40 |
0 |
26223 |
3 |
9156 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_make_cost_storno |
91855 |
91855 |
0 |
0.00 |
0 |
12527 |
43 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_multiply_rows_for_pdistr |
91855 |
91855 |
0 |
0.00 |
0 |
9953 |
7 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_multiply_rows_for_qdistr |
75201 |
75201 |
0 |
0.00 |
0 |
31481 |
38 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_pay_from_customer |
25122 |
25122 |
0 |
0.00 |
0 |
19843 |
114 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_pay_to_supplier |
20715 |
20715 |
0 |
0.00 |
0 |
19765 |
74 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_payment_common |
45837 |
45837 |
0 |
0.00 |
0 |
7176 |
15 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_qd_handle_on_cancel_clo |
6279 |
6139 |
140 |
2.22 |
0 |
5913 |
23 |
140 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_qd_handle_on_invoice_upd_sts |
16222 |
14960 |
1262 |
7.77 |
0 |
91166 |
80 |
1262 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_qd_handle_on_reserve_upd_sts |
34888 |
34888 |
0 |
0.00 |
0 |
14961 |
10 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_reserve_write_off |
35354 |
34888 |
466 |
1.31 |
0 |
28236 |
84 |
466 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_supplier_invoice |
19195 |
19090 |
105 |
0.54 |
0 |
62712 |
502 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
sp_supplier_order |
19382 |
19186 |
196 |
1.01 |
0 |
71636 |
356 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
srv_find_qd_qs_mism |
1326574 |
1098067 |
228507 |
17.22 |
0 |
12854 |
3 |
228507 |
2018-06-17 08:17 |
2018-06-17 11:17 |
srv_make_invnt_saldo |
1964 |
1964 |
0 |
0.00 |
16 |
155688 |
750 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
srv_make_money_saldo |
1924 |
1924 |
0 |
0.00 |
0 |
967 |
13 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
1918 |
222098 |
21290 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_add_invoice_to_stock |
6812 |
6812 |
0 |
0.00 |
0 |
18221 |
26 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_cancel_adding_invoice |
623 |
623 |
0 |
0.00 |
0 |
19750 |
149 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_cancel_client_order |
146 |
146 |
0 |
0.00 |
0 |
1466 |
14 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_cancel_customer_reserve |
26 |
26 |
0 |
0.00 |
0 |
16 |
3 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_cancel_pay_from_customer |
14 |
14 |
0 |
0.00 |
0 |
62 |
7 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_cancel_pay_to_supplier |
2 |
2 |
0 |
0.00 |
0 |
16 |
8 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_cancel_supplier_invoice |
538 |
538 |
0 |
0.00 |
0 |
18221 |
74 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_cancel_supplier_order |
25836 |
25836 |
0 |
0.00 |
0 |
17769 |
28 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_cancel_write_off |
14 |
14 |
0 |
0.00 |
0 |
16 |
3 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_reserve_write_off |
466 |
466 |
0 |
0.00 |
0 |
2262 |
15 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_supplier_invoice |
105 |
105 |
0 |
0.00 |
0 |
63 |
4 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-abend:sp_supplier_order |
196 |
196 |
0 |
0.00 |
0 |
297 |
6 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_add_invoice_to_stock |
11130 |
11130 |
0 |
0.00 |
0 |
127562 |
273 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_cancel_adding_invoice |
1237 |
1237 |
0 |
0.00 |
0 |
86611 |
303 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_cancel_client_order |
6139 |
6139 |
0 |
0.00 |
0 |
18626 |
48 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_cancel_customer_reserve |
2407 |
2407 |
0 |
0.00 |
0 |
17987 |
61 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_cancel_pay_from_customer |
2368 |
2368 |
0 |
0.00 |
0 |
9048 |
26 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_cancel_pay_to_supplier |
1458 |
1458 |
0 |
0.00 |
0 |
7504 |
35 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_cancel_supplier_invoice |
954 |
954 |
0 |
0.00 |
0 |
12121 |
38 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_cancel_supplier_order |
555 |
555 |
0 |
0.00 |
0 |
160649 |
983 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_cancel_write_off |
3498 |
3498 |
0 |
0.00 |
0 |
17613 |
55 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_client_order |
75201 |
75201 |
0 |
0.00 |
0 |
24866 |
46 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_customer_reserve |
3521 |
3521 |
0 |
0.00 |
0 |
9033 |
18 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_pay_from_customer |
25122 |
25122 |
0 |
0.00 |
0 |
16863 |
33 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_pay_to_supplier |
20715 |
20715 |
0 |
0.00 |
0 |
18829 |
36 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_reserve_write_off |
34888 |
34888 |
0 |
0.00 |
0 |
22121 |
45 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_supplier_invoice |
19090 |
19090 |
0 |
0.00 |
0 |
18860 |
29 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:sp_supplier_order |
19186 |
19186 |
0 |
0.00 |
0 |
20764 |
40 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:srv_make_invnt_saldo |
1964 |
1964 |
0 |
0.00 |
0 |
9219 |
10 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:srv_make_money_saldo |
1924 |
1924 |
0 |
0.00 |
0 |
17300 |
35 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
47 |
11 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_add_invoice_to_stock |
35884 |
22260 |
13624 |
37.96 |
0 |
12933 |
7 |
13624 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_all_customers |
113092 |
113092 |
0 |
0.00 |
0 |
546 |
1 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_all_suppliers |
78552 |
77950 |
602 |
0.76 |
0 |
250 |
1 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_all_wares |
150402 |
150402 |
0 |
0.00 |
0 |
608 |
1 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_cancel_adding_invoice |
2876 |
2474 |
402 |
13.97 |
0 |
8751 |
24 |
402 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_cancel_client_order |
12570 |
12278 |
292 |
2.32 |
0 |
17176 |
4 |
292 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_cancel_customer_prepayment |
4764 |
4736 |
28 |
0.58 |
0 |
13666 |
5 |
28 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_cancel_customer_reserve |
4866 |
4814 |
52 |
1.06 |
0 |
4571 |
3 |
52 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_cancel_payment_to_supplier |
2920 |
2916 |
4 |
0.13 |
0 |
19625 |
11 |
4 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_cancel_supplier_invoice |
2984 |
1908 |
1076 |
36.05 |
0 |
2574 |
7 |
1076 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_cancel_supplier_order |
2984 |
1110 |
1874 |
62.80 |
0 |
390 |
2 |
1874 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_cancel_write_off |
7024 |
6996 |
28 |
0.39 |
0 |
8970 |
19 |
28 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_max_id_clo_ord |
19382 |
19186 |
196 |
1.01 |
0 |
670 |
1 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_max_id_clo_res |
3521 |
3521 |
0 |
0.00 |
0 |
5896 |
8 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_max_id_ord_sup |
19195 |
19090 |
105 |
0.54 |
0 |
436 |
1 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_max_non_paid_invoice |
20016 |
20016 |
0 |
0.00 |
0 |
1623 |
1 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_max_non_paid_realizn |
25122 |
25122 |
0 |
0.00 |
0 |
344 |
1 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_min_id_clo_ord |
19382 |
19186 |
196 |
1.01 |
0 |
9266 |
3 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_min_id_clo_res |
3521 |
3521 |
0 |
0.00 |
0 |
7238 |
12 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_min_id_ord_sup |
19195 |
19090 |
105 |
0.54 |
0 |
3432 |
3 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_min_non_paid_invoice |
20715 |
20715 |
0 |
0.00 |
0 |
6739 |
2 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_min_non_paid_realizn |
25122 |
25122 |
0 |
0.00 |
0 |
5570 |
2 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_our_firm |
37310 |
37310 |
0 |
0.00 |
0 |
328 |
1 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
v_reserve_write_off |
70708 |
69776 |
932 |
1.31 |
0 |
26208 |
5 |
932 |
2018-06-17 08:17 |
2018-06-17 11:17 |
x_lock_depdocs_on_canc_invoice |
22507 |
11542 |
10965 |
48.71 |
0 |
951 |
5 |
10965 |
2018-06-17 08:17 |
2018-06-17 11:17 |
x_lock_depdocs_on_canc_sup_ord |
1491 |
555 |
936 |
62.77 |
0 |
265 |
8 |
936 |
2018-06-17 08:17 |
2018-06-17 11:17 |
x_make_qstorno_1000_1200 |
19382 |
19186 |
196 |
1.01 |
0 |
71620 |
317 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
x_make_qstorno_1200_2000 |
19195 |
19090 |
105 |
0.54 |
0 |
62681 |
463 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
x_make_qstorno_2100_3300 |
676683 |
676683 |
0 |
0.00 |
0 |
85754 |
39 |
0 |
2018-06-17 08:17 |
2018-06-17 11:17 |
Done for 484110 ms, from 11:37:03.21 to 11:45:07.32.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
80 |
sp_kill_cost_storno |
335544336 |
2018-06-17 08:18 |
2018-06-17 11:11 |
deadlock |
87 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2018-06-17 08:18 |
2018-06-17 11:13 |
deadlock |
7868 |
sp_lock_selected_doc |
335544336 |
2018-06-17 08:17 |
2018-06-17 11:17 |
deadlock |
140 |
sp_qd_handle_on_cancel_clo |
335544336 |
2018-06-17 08:17 |
2018-06-17 11:15 |
deadlock |
210 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2018-06-17 08:18 |
2018-06-17 11:16 |
deadlock |
590 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2018-06-17 08:17 |
2018-06-17 11:16 |
deadlock |
173 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2018-06-17 08:17 |
2018-06-17 11:16 |
user_exc |
196 |
x_make_qstorno_1000_1200 |
335544517 |
2018-06-17 08:17 |
2018-06-17 11:16 |
user_exc |
105 |
x_make_qstorno_1200_2000 |
335544517 |
2018-06-17 08:17 |
2018-06-17 11:15 |
Done for 16080 ms, from 11:45:22.44 to 11:45:38.52.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 420739
MON$OLDEST_ACTIVE 420740
MON$OLDEST_SNAPSHOT 420740
MON$NEXT_TRANSACTION 420740
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 852672
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.1008 Firebird 4.0 Alpha 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.1008 Firebird 4.0 Alpha 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.1008 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.1008 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Gstat execution time Sun Jun 17 11:45:39 2018
Database header page information:
Flags 0
Generation 420780
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 420741
Oldest active 420742
Oldest snapshot 420742
Next transaction 420743
Sequence number 0
Next attachment ID 9289
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.27
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 339, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 338, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.06, total records: 2022830
Average version length: 47.69, total versions: 1133, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 14, data page slots: 21856
Data pages: 21856, average fill: 73%
Primary pages: 21856, secondary pages: 0, swept pages: 14067
Empty pages: 4, full pages: 20571
Fill distribution:
0 - 19% = 7
20 - 39% = 11
40 - 59% = 170
60 - 79% = 21666
80 - 99% = 2
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 9792, nodes: 2022830
Average node length: 19.37, total dup: 0, max dup: 0
Average key length: 16.41, compression ratio: 1.64
Average prefix length: 13.58, average data length: 13.42
Clustering factor: 262140, ratio: 0.13
Fill distribution:
0 - 19% = 857
20 - 39% = 2697
40 - 59% = 3209
60 - 79% = 1155
80 - 99% = 1874
Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7296, nodes: 2022830
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.69, compression ratio: 1.04
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 265176, ratio: 0.13
Fill distribution:
0 - 19% = 4
20 - 39% = 3576
40 - 59% = 3560
60 - 79% = 145
80 - 99% = 11
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 173747, depth: 3, leaf buckets: 3273, nodes: 2022830
Average node length: 6.85, total dup: 1463087, max dup: 49
Average key length: 3.90, compression ratio: 2.31
Average prefix length: 7.38, average data length: 1.62
Clustering factor: 230827, ratio: 0.11
Fill distribution:
0 - 19% = 123
20 - 39% = 1096
40 - 59% = 912
60 - 79% = 442
80 - 99% = 700
DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.47, total records: 622145
Average version length: 61.61, total versions: 341, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7856
Data pages: 7856, average fill: 75%
Primary pages: 7855, secondary pages: 1, swept pages: 7291
Empty pages: 2, full pages: 7643
Fill distribution:
0 - 19% = 10
20 - 39% = 9
40 - 59% = 33
60 - 79% = 7792
80 - 99% = 12
Index DOC_LIST_ID_DESC (1)
Root page: 251229, depth: 3, leaf buckets: 2235, nodes: 622145
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 121453, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 1122
40 - 59% = 1021
60 - 79% = 83
80 - 99% = 8
Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 651, nodes: 622145
Average node length: 4.87, total dup: 622095, max dup: 32249
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 281950, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 555
60 - 79% = 77
80 - 99% = 19
Index PK_DOC_LIST (0)
Root page: 353004, depth: 3, leaf buckets: 1462, nodes: 622145
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 121453, ratio: 0.20
Fill distribution:
0 - 19% = 72
20 - 39% = 210
40 - 59% = 374
60 - 79% = 404
80 - 99% = 402
DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 343, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 67.13, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 19.54, total fragments: 369, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.55
Pointer pages: 1, data page slots: 40
Data pages: 37, average fill: 21%
Primary pages: 4, secondary pages: 33, swept pages: 4
Empty pages: 7, full pages: 3
Fill distribution:
0 - 19% = 24
20 - 39% = 9
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 285, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 42.71, total records: 4562
Average version length: 71.11, total versions: 1827, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 2.25
Pointer pages: 1, data page slots: 408
Data pages: 144, average fill: 39%
Primary pages: 144, secondary pages: 0, swept pages: 62
Empty pages: 42, full pages: 37
Fill distribution:
0 - 19% = 55
20 - 39% = 15
40 - 59% = 27
60 - 79% = 29
80 - 99% = 18
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 23, nodes: 4562
Average node length: 14.70, total dup: 175, max dup: 1
Average key length: 12.81, compression ratio: 2.11
Average prefix length: 17.15, average data length: 9.85
Clustering factor: 3179, ratio: 0.70
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 7
60 - 79% = 1
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 15.10, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.12
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 45.87, total records: 38
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.40
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 3%
Primary pages: 15, secondary pages: 1, swept pages: 11
Empty pages: 7, full pages: 0
Fill distribution:
0 - 19% = 16
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 275, depth: 1, leaf buckets: 1, nodes: 38
Average node length: 13.79, total dup: 11, max dup: 4
Average key length: 12.39, compression ratio: 1.53
Average prefix length: 9.29, average data length: 9.71
Clustering factor: 33, ratio: 0.87
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 356, Index root page: 357
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 241, Index root page: 242
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 244, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 243, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 17.58, total records: 688197
Average version length: 42.42, total versions: 221, max versions: 5
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.64
Pointer pages: 3, data page slots: 3912
Data pages: 3912, average fill: 75%
Primary pages: 3912, secondary pages: 0, swept pages: 3385
Empty pages: 8, full pages: 3735
Fill distribution:
0 - 19% = 11
20 - 39% = 7
40 - 59% = 21
60 - 79% = 3508
80 - 99% = 365
Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 191, nodes: 175652
Average node length: 4.88, total dup: 175603, max dup: 8597
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 24196, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 119
60 - 79% = 38
80 - 99% = 13
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 206, nodes: 175652
Average node length: 5.81, total dup: 158425, max dup: 39
Average key length: 2.95, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 27303, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 17
40 - 59% = 89
60 - 79% = 66
80 - 99% = 33
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 202, nodes: 175652
Average node length: 5.81, total dup: 158425, max dup: 39
Average key length: 2.94, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 27344, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 94
60 - 79% = 70
80 - 99% = 31
Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 205, nodes: 175652
Average node length: 5.60, total dup: 158425, max dup: 39
Average key length: 2.73, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 27351, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 20
40 - 59% = 87
60 - 79% = 69
80 - 99% = 27
PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.91, total records: 249754
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 2, data page slots: 2136
Data pages: 2136, average fill: 64%
Primary pages: 2136, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 2132
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2132
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 578122, depth: 2, leaf buckets: 193, nodes: 249754
Average node length: 4.49, total dup: 249573, max dup: 2315
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.55, average data length: 0.00
Clustering factor: 42150, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 63
60 - 79% = 67
80 - 99% = 63
PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 349, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.84, total records: 12951330
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.17
Pointer pages: 189, data page slots: 307840
Data pages: 307840, average fill: 87%
Primary pages: 307840, secondary pages: 0, swept pages: 3
Empty pages: 6, full pages: 307833
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 307833
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 15663, nodes: 12951330
Average node length: 5.70, total dup: 12136844, max dup: 184
Average key length: 2.16, compression ratio: 3.70
Average prefix length: 7.88, average data length: 0.12
Clustering factor: 1794241, ratio: 0.14
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 11061
60 - 79% = 2892
80 - 99% = 1704
Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 13094, nodes: 12951330
Average node length: 4.67, total dup: 12951326, max dup: 11302046
Average key length: 1.13, compression ratio: 0.56
Average prefix length: 0.64, average data length: 0.00
Clustering factor: 368370, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 13090
60 - 79% = 1
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 16386, nodes: 12951330
Average node length: 5.74, total dup: 12607661, max dup: 29547
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 651243, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 13341
60 - 79% = 1739
80 - 99% = 1304
Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 15813, nodes: 12951330
Average node length: 5.60, total dup: 12934178, max dup: 2091268
Average key length: 2.06, compression ratio: 18.43
Average prefix length: 37.93, average data length: 0.06
Clustering factor: 5347755, ratio: 0.41
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 13885
60 - 79% = 251
80 - 99% = 1669
PHRASES (145)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 283, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.10, total records: 443210
Average version length: 55.89, total versions: 298, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5256
Data pages: 5256, average fill: 75%
Primary pages: 5256, secondary pages: 0, swept pages: 3684
Empty pages: 5, full pages: 4996
Fill distribution:
0 - 19% = 7
20 - 39% = 4
40 - 59% = 8
60 - 79% = 5235
80 - 99% = 2
Index PSTORNED_RCV_ID (2)
Root page: 698694, depth: 3, leaf buckets: 565, nodes: 443210
Average node length: 5.86, total dup: 378468, max dup: 719
Average key length: 3.07, compression ratio: 2.93
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 52994, ratio: 0.12
Fill distribution:
0 - 19% = 3
20 - 39% = 37
40 - 59% = 321
60 - 79% = 146
80 - 99% = 58
Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 475, nodes: 443210
Average node length: 5.62, total dup: 393870, max dup: 99
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 110055, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 195
60 - 79% = 188
80 - 99% = 85
RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 310, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 245, Index root page: 246
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 248, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 247, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 330, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 331, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 218, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 226, Index root page: 227
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 219, Index root page: 220
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 222, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 221, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 211, Index root page: 212
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 215, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.31, total records: 2430
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.56
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 69%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 29
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 29
80 - 99% = 0
WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 61.46, total records: 5681
Average version length: 72.13, total versions: 848, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.21
Pointer pages: 1, data page slots: 376
Data pages: 168, average fill: 40%
Primary pages: 168, secondary pages: 0, swept pages: 81
Empty pages: 8, full pages: 15
Fill distribution:
0 - 19% = 38
20 - 39% = 46
40 - 59% = 45
60 - 79% = 35
80 - 99% = 4
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 13, nodes: 5681
Average node length: 6.68, total dup: 4925, max dup: 14
Average key length: 4.77, compression ratio: 7.75
Average prefix length: 34.36, average data length: 2.64
Clustering factor: 913, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 6
60 - 79% = 0
80 - 99% = 0
XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.95, total records: 632816
Average version length: 71.63, total versions: 2058, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 6, data page slots: 9472
Data pages: 9472, average fill: 73%
Primary pages: 9472, secondary pages: 0, swept pages: 6478
Empty pages: 4, full pages: 6968
Fill distribution:
0 - 19% = 7
20 - 39% = 47
40 - 59% = 565
60 - 79% = 8828
80 - 99% = 25
Index XQD_1000_3300_DOC (1)
Root page: 776457, depth: 3, leaf buckets: 572, nodes: 632816
Average node length: 5.10, total dup: 613859, max dup: 116
Average key length: 2.22, compression ratio: 4.06
Average prefix length: 8.81, average data length: 0.19
Clustering factor: 71010, ratio: 0.11
Fill distribution:
0 - 19% = 2
20 - 39% = 61
40 - 59% = 215
60 - 79% = 39
80 - 99% = 255
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 258150, depth: 3, leaf buckets: 871, nodes: 632816
Average node length: 6.21, total dup: 551889, max dup: 18
Average key length: 3.33, compression ratio: 11.11
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 125362, ratio: 0.20
Fill distribution:
0 - 19% = 21
20 - 39% = 142
40 - 59% = 420
60 - 79% = 143
80 - 99% = 145
XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 27.32, total records: 118313
Average version length: 71.73, total versions: 4836, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.98
Pointer pages: 2, data page slots: 2032
Data pages: 1984, average fill: 37%
Primary pages: 1983, secondary pages: 1, swept pages: 1262
Empty pages: 165, full pages: 318
Fill distribution:
0 - 19% = 707
20 - 39% = 422
40 - 59% = 359
60 - 79% = 357
80 - 99% = 139
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 71, nodes: 39852
Average node length: 5.84, total dup: 35122, max dup: 49
Average key length: 3.47, compression ratio: 10.65
Average prefix length: 35.64, average data length: 1.36
Clustering factor: 4808, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 38
40 - 59% = 24
60 - 79% = 9
80 - 99% = 0
XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 45.30, total records: 2437277
Average version length: 71.13, total versions: 14658, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.00
Pointer pages: 19, data page slots: 30128
Data pages: 30088, average fill: 62%
Primary pages: 30088, secondary pages: 0, swept pages: 8123
Empty pages: 350, full pages: 28841
Fill distribution:
0 - 19% = 540
20 - 39% = 7535
40 - 59% = 1524
60 - 79% = 17044
80 - 99% = 3445
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 188815, depth: 3, leaf buckets: 2115, nodes: 1416586
Average node length: 5.53, total dup: 1344407, max dup: 49
Average key length: 2.56, compression ratio: 14.43
Average prefix length: 36.49, average data length: 0.51
Clustering factor: 106251, ratio: 0.08
Fill distribution:
0 - 19% = 19
20 - 39% = 877
40 - 59% = 860
60 - 79% = 208
80 - 99% = 151
XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.02, total records: 4444758
Average version length: 70.66, total versions: 746, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.08
Pointer pages: 18, data page slots: 28808
Data pages: 28776, average fill: 49%
Primary pages: 28776, secondary pages: 0, swept pages: 9897
Empty pages: 9, full pages: 28617
Fill distribution:
0 - 19% = 13
20 - 39% = 10970
40 - 59% = 6184
60 - 79% = 11460
80 - 99% = 149
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 7, nodes: 2084
Average node length: 10.50, total dup: 1515, max dup: 33
Average key length: 7.50, compression ratio: 4.93
Average prefix length: 31.77, average data length: 5.23
Clustering factor: 449, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 2
60 - 79% = 1
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 62.52, total records: 3172581
Average version length: 71.32, total versions: 5715, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.18
Pointer pages: 25, data page slots: 40536
Data pages: 40528, average fill: 76%
Primary pages: 40528, secondary pages: 0, swept pages: 28471
Empty pages: 17, full pages: 39123
Fill distribution:
0 - 19% = 42
20 - 39% = 335
40 - 59% = 961
60 - 79% = 36691
80 - 99% = 2499
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5753, nodes: 2727198
Average node length: 6.84, total dup: 2214193, max dup: 14
Average key length: 3.87, compression ratio: 9.57
Average prefix length: 35.32, average data length: 1.68
Clustering factor: 384211, ratio: 0.14
Fill distribution:
0 - 19% = 4
20 - 39% = 3403
40 - 59% = 1870
60 - 79% = 301
80 - 99% = 175
XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.52, total records: 4439538
Average version length: 83.73, total versions: 334, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 42, data page slots: 68104
Data pages: 68104, average fill: 80%
Primary pages: 68104, secondary pages: 0, swept pages: 24818
Empty pages: 12, full pages: 67915
Fill distribution:
0 - 19% = 15
20 - 39% = 3
40 - 59% = 11
60 - 79% = 19477
80 - 99% = 48598
Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4617, nodes: 4439538
Average node length: 5.15, total dup: 4338768, max dup: 128
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 655924, ratio: 0.15
Fill distribution:
0 - 19% = 16
20 - 39% = 62
40 - 59% = 2162
60 - 79% = 1991
80 - 99% = 386
Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 3865, nodes: 4439538
Average node length: 5.70, total dup: 3968198, max dup: 49
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 117086, ratio: 0.03
Fill distribution:
0 - 19% = 16
20 - 39% = 91
40 - 59% = 845
60 - 79% = 231
80 - 99% = 2682
Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5122, nodes: 4439538
Average node length: 5.81, total dup: 3884817, max dup: 27
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 708119, ratio: 0.16
Fill distribution:
0 - 19% = 29
20 - 39% = 73
40 - 59% = 2278
60 - 79% = 2150
80 - 99% = 592
XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 83.36, total records: 2704308
Average version length: 83.69, total versions: 4858, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 26, data page slots: 41992
Data pages: 41992, average fill: 79%
Primary pages: 41992, secondary pages: 0, swept pages: 30409
Empty pages: 32, full pages: 41053
Fill distribution:
0 - 19% = 65
20 - 39% = 92
40 - 59% = 217
60 - 79% = 13509
80 - 99% = 28109
Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2851, nodes: 2704308
Average node length: 5.15, total dup: 2640926, max dup: 165
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 417635, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 38
40 - 59% = 1619
60 - 79% = 852
80 - 99% = 337
Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4019, nodes: 2704308
Average node length: 6.24, total dup: 2212831, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 180861, ratio: 0.07
Fill distribution:
0 - 19% = 85
20 - 39% = 1174
40 - 59% = 1524
60 - 79% = 684
80 - 99% = 552
Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 3224, nodes: 2704308
Average node length: 5.81, total dup: 2364850, max dup: 38
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 505334, ratio: 0.19
Fill distribution:
0 - 19% = 19
20 - 39% = 41
40 - 59% = 1820
60 - 79% = 989
80 - 99% = 355
XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.62, total records: 4673381
Average version length: 84.61, total versions: 5379, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 45, data page slots: 71888
Data pages: 71824, average fill: 80%
Primary pages: 71824, secondary pages: 0, swept pages: 16337
Empty pages: 335, full pages: 70946
Fill distribution:
0 - 19% = 398
20 - 39% = 150
40 - 59% = 204
60 - 79% = 9733
80 - 99% = 61339
Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 4747, nodes: 4673381
Average node length: 5.04, total dup: 4645991, max dup: 728
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 664433, ratio: 0.14
Fill distribution:
0 - 19% = 6
20 - 39% = 109
40 - 59% = 2468
60 - 79% = 1571
80 - 99% = 593
Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5053, nodes: 4673381
Average node length: 5.50, total dup: 4322819, max dup: 49
Average key length: 2.51, compression ratio: 3.58
Average prefix length: 8.56, average data length: 0.44
Clustering factor: 116158, ratio: 0.02
Fill distribution:
0 - 19% = 142
20 - 39% = 1001
40 - 59% = 1549
60 - 79% = 698
80 - 99% = 1663
Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5345, nodes: 4673381
Average node length: 5.69, total dup: 4185493, max dup: 81
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 734960, ratio: 0.16
Fill distribution:
0 - 19% = 6
20 - 39% = 94
40 - 59% = 2815
60 - 79% = 1709
80 - 99% = 721
XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 823, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 825, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 824, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.43, total records: 3268538
Average version length: 83.58, total versions: 3802, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 31, data page slots: 50536
Data pages: 50528, average fill: 80%
Primary pages: 50528, secondary pages: 0, swept pages: 35018
Empty pages: 56, full pages: 49692
Fill distribution:
0 - 19% = 91
20 - 39% = 90
40 - 59% = 233
60 - 79% = 12941
80 - 99% = 37173
Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3602, nodes: 3268538
Average node length: 5.02, total dup: 3252975, max dup: 1345
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 560185, ratio: 0.17
Fill distribution:
0 - 19% = 25
20 - 39% = 408
40 - 59% = 1968
60 - 79% = 818
80 - 99% = 383
Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 4784, nodes: 3268538
Average node length: 6.24, total dup: 2675560, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 228815, ratio: 0.07
Fill distribution:
0 - 19% = 136
20 - 39% = 1396
40 - 59% = 1640
60 - 79% = 837
80 - 99% = 775
Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 3967, nodes: 3268538
Average node length: 5.57, total dup: 2989157, max dup: 84
Average key length: 2.59, compression ratio: 3.47
Average prefix length: 8.49, average data length: 0.51
Clustering factor: 607361, ratio: 0.19
Fill distribution:
0 - 19% = 15
20 - 39% = 443
40 - 59% = 2136
60 - 79% = 933
80 - 99% = 440
XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.40, total records: 543857
Average version length: 69.37, total versions: 604, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 5, data page slots: 7464
Data pages: 7464, average fill: 77%
Primary pages: 7464, secondary pages: 0, swept pages: 5818
Empty pages: 3, full pages: 7305
Fill distribution:
0 - 19% = 5
20 - 39% = 6
40 - 59% = 22
60 - 79% = 7413
80 - 99% = 18
Index XQS_3300_3400_DOC_ID (0)
Root page: 219058, depth: 3, leaf buckets: 650, nodes: 543857
Average node length: 5.33, total dup: 509980, max dup: 117
Average key length: 2.47, compression ratio: 3.64
Average prefix length: 8.59, average data length: 0.41
Clustering factor: 48825, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 147
40 - 59% = 244
60 - 79% = 189
80 - 99% = 68
Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 711, nodes: 543857
Average node length: 5.92, total dup: 463429, max dup: 14
Average key length: 3.06, compression ratio: 2.94
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 50249, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 129
40 - 59% = 305
60 - 79% = 200
80 - 99% = 74
ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 672, Index root page: 673
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 676, Index root page: 677
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 682, Index root page: 683
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 692, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 684, Index root page: 685
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 693, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 678, Index root page: 679
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 686, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 687, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 680, Index root page: 681
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 689, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 688, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 691, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 690, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 622, Index root page: 623
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 620, Index root page: 621
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 271, Index root page: 272
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 284, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Gstat completion time Sun Jun 17 11:48:57 2018
Done for 198200 ms, from 11:45:38.97 to 11:48:57.17.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2022830 |
1133 |
0.0560 |
DOC_LIST |
622145 |
341 |
0.0548 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
4562 |
1827 |
40.0482 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
38 |
0 |
0.0000 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
688197 |
221 |
0.0321 |
PERF_ESTIMATED |
249754 |
0 |
0.0000 |
PERF_LOG |
12951330 |
0 |
0.0000 |
PSTORNED |
443210 |
298 |
0.0672 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
0 |
0.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2430 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
5681 |
848 |
14.9269 |
XQD_1000_3300 |
632816 |
2058 |
0.3252 |
XQD_1200_2000 |
118313 |
4836 |
4.0874 |
XQD_2000_3300 |
2437277 |
14658 |
0.6014 |
XQD_2100_3300 |
4444758 |
746 |
0.0167 |
XQD_3300_3400 |
3172581 |
5715 |
0.1801 |
XQS_1000_1200 |
4439538 |
334 |
0.0075 |
XQS_1000_3300 |
2704308 |
4858 |
0.1796 |
XQS_1200_2000 |
4673381 |
5379 |
0.1150 |
XQS_2100_3300 |
3268538 |
3802 |
0.1163 |
XQS_3300_3400 |
543857 |
604 |
0.1110 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2220 ms, from 11:49:08.98 to 11:49:11.20.
11:49:11.29 Validation started
11:49:11.31 Relation 140 (DOC_LIST)
11:49:11.31 process pointer page 0 of 5
11:49:11.40 process pointer page 1 of 5
11:49:11.49 process pointer page 2 of 5
11:49:11.60 process pointer page 3 of 5
11:49:11.70 process pointer page 4 of 5
11:49:11.79 Index 1 (PK_DOC_LIST)
11:49:12.02 Index 2 (DOC_LIST_ID_DESC)
11:49:12.29 Index 3 (FK_DOC_LIST_AGENTS)
11:49:12.51 Relation 140 (DOC_LIST) is ok
11:49:12.51 Relation 141 (DOC_DATA)
11:49:12.51 process pointer page 0 of 14
11:49:12.54 process pointer page 1 of 14
11:49:12.58 process pointer page 2 of 14
11:49:12.62 process pointer page 3 of 14
11:49:12.68 process pointer page 4 of 14
11:49:12.72 process pointer page 5 of 14
11:49:12.76 process pointer page 6 of 14
11:49:12.79 process pointer page 7 of 14
11:49:12.83 process pointer page 8 of 14
11:49:12.87 process pointer page 9 of 14
11:49:12.91 process pointer page 10 of 14
11:49:12.99 process pointer page 11 of 14
11:49:13.04 process pointer page 12 of 14
11:49:13.11 process pointer page 13 of 14
11:49:13.16 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:49:14.16 Index 3 (DOC_DATA_ID_DESC)
11:49:14.77 Index 4 (FK_DOC_DATA_DOC_LIST)
11:49:15.39 Relation 141 (DOC_DATA) is ok
11:49:15.39 Relation 147 (INVNT_SALDO)
11:49:15.39 process pointer page 0 of 1
11:49:15.39 Index 1 (PK_INVNT_SALDO)
11:49:15.39 Relation 147 (INVNT_SALDO) is ok
11:49:15.39 Relation 150 (PDISTR)
11:49:15.39 process pointer page 0 of 3
11:49:15.49 process pointer page 1 of 3
11:49:15.56 process pointer page 2 of 3
11:49:15.61 Index 2 (PDISTR_SND_ID)
11:49:15.67 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:49:15.75 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:49:15.81 Index 5 (PDISTR_AGENT_ID)
11:49:15.89 Relation 150 (PDISTR) is ok
11:49:15.89 Relation 151 (PSTORNED)
11:49:15.89 process pointer page 0 of 4
11:49:15.97 process pointer page 1 of 4
11:49:16.06 process pointer page 2 of 4
11:49:16.16 process pointer page 3 of 4
11:49:16.17 Index 2 (PSTORNED_SND_ID)
11:49:16.33 Index 3 (PSTORNED_RCV_ID)
11:49:16.45 Relation 151 (PSTORNED) is ok
11:49:16.47 Relation 156 (SEMAPHORES)
11:49:16.47 process pointer page 0 of 1
11:49:16.47 Index 1 (PK_SEMAPHORES)
11:49:16.47 Index 2 (SEMAPHORES_TASK_UNQ)
11:49:16.47 Relation 156 (SEMAPHORES) is ok
11:49:16.47 Relation 157 (INVNT_TURNOVER_LOG)
11:49:16.47 process pointer page 0 of 1
11:49:16.47 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:49:16.47 Relation 157 (INVNT_TURNOVER_LOG) is ok
11:49:16.47 Relation 160 (PERF_ESTIMATED)
11:49:16.47 process pointer page 0 of 2
11:49:16.56 process pointer page 1 of 2
11:49:16.59 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:49:16.67 Relation 160 (PERF_ESTIMATED) is ok
11:49:16.67 Relation 161 (PERF_ISQL_STAT)
11:49:16.67 process pointer page 0 of 1
11:49:16.67 Index 1 (PERF_ISQL_STAT_TRN)
11:49:16.67 Relation 161 (PERF_ISQL_STAT) is ok
11:49:16.67 Relation 162 (TRACE_STAT)
11:49:16.67 process pointer page 0 of 1
11:49:16.67 Relation 162 (TRACE_STAT) is ok
11:49:16.67 Relation 163 (PERF_LOG)
11:49:16.67 process pointer page 0 of 189
11:49:16.77 process pointer page 1 of 189
11:49:16.84 process pointer page 2 of 189
11:49:16.92 process pointer page 3 of 189
11:49:17.01 process pointer page 4 of 189
11:49:17.09 process pointer page 5 of 189
11:49:17.17 process pointer page 6 of 189
11:49:17.26 process pointer page 7 of 189
11:49:17.34 process pointer page 8 of 189
11:49:17.42 process pointer page 9 of 189
11:49:17.51 process pointer page 10 of 189
11:49:17.59 process pointer page 11 of 189
11:49:17.69 process pointer page 12 of 189
11:49:17.76 process pointer page 13 of 189
11:49:17.84 process pointer page 14 of 189
11:49:17.94 process pointer page 15 of 189
11:49:18.01 process pointer page 16 of 189
11:49:18.09 process pointer page 17 of 189
11:49:18.18 process pointer page 18 of 189
11:49:18.26 process pointer page 19 of 189
11:49:18.36 process pointer page 20 of 189
11:49:18.43 process pointer page 21 of 189
11:49:18.51 process pointer page 22 of 189
11:49:18.61 process pointer page 23 of 189
11:49:18.68 process pointer page 24 of 189
11:49:18.76 process pointer page 25 of 189
11:49:18.84 process pointer page 26 of 189
11:49:18.93 process pointer page 27 of 189
11:49:19.01 process pointer page 28 of 189
11:49:19.09 process pointer page 29 of 189
11:49:19.17 process pointer page 30 of 189
11:49:19.26 process pointer page 31 of 189
11:49:19.34 process pointer page 32 of 189
11:49:19.42 process pointer page 33 of 189
11:49:19.51 process pointer page 34 of 189
11:49:19.59 process pointer page 35 of 189
11:49:19.67 process pointer page 36 of 189
11:49:19.71 process pointer page 37 of 189
11:49:19.74 process pointer page 38 of 189
11:49:19.78 process pointer page 39 of 189
11:49:19.84 process pointer page 40 of 189
11:49:19.87 process pointer page 41 of 189
11:49:19.96 process pointer page 42 of 189
11:49:20.04 process pointer page 43 of 189
11:49:20.12 process pointer page 44 of 189
11:49:20.20 process pointer page 45 of 189
11:49:20.29 process pointer page 46 of 189
11:49:20.37 process pointer page 47 of 189
11:49:20.45 process pointer page 48 of 189
11:49:20.52 process pointer page 49 of 189
11:49:20.62 process pointer page 50 of 189
11:49:20.70 process pointer page 51 of 189
11:49:20.77 process pointer page 52 of 189
11:49:20.85 process pointer page 53 of 189
11:49:20.93 process pointer page 54 of 189
11:49:21.02 process pointer page 55 of 189
11:49:21.10 process pointer page 56 of 189
11:49:21.18 process pointer page 57 of 189
11:49:21.26 process pointer page 58 of 189
11:49:21.34 process pointer page 59 of 189
11:49:21.43 process pointer page 60 of 189
11:49:21.51 process pointer page 61 of 189
11:49:21.59 process pointer page 62 of 189
11:49:21.66 process pointer page 63 of 189
11:49:21.76 process pointer page 64 of 189
11:49:21.84 process pointer page 65 of 189
11:49:21.91 process pointer page 66 of 189
11:49:21.99 process pointer page 67 of 189
11:49:22.08 process pointer page 68 of 189
11:49:22.16 process pointer page 69 of 189
11:49:22.24 process pointer page 70 of 189
11:49:22.32 process pointer page 71 of 189
11:49:22.40 process pointer page 72 of 189
11:49:22.49 process pointer page 73 of 189
11:49:22.57 process pointer page 74 of 189
11:49:22.65 process pointer page 75 of 189
11:49:22.72 process pointer page 76 of 189
11:49:22.82 process pointer page 77 of 189
11:49:22.90 process pointer page 78 of 189
11:49:22.97 process pointer page 79 of 189
11:49:23.05 process pointer page 80 of 189
11:49:23.15 process pointer page 81 of 189
11:49:23.22 process pointer page 82 of 189
11:49:23.30 process pointer page 83 of 189
11:49:23.38 process pointer page 84 of 189
11:49:23.47 process pointer page 85 of 189
11:49:23.55 process pointer page 86 of 189
11:49:23.63 process pointer page 87 of 189
11:49:23.72 process pointer page 88 of 189
11:49:23.80 process pointer page 89 of 189
11:49:23.88 process pointer page 90 of 189
11:49:23.93 process pointer page 91 of 189
11:49:23.96 process pointer page 92 of 189
11:49:23.99 process pointer page 93 of 189
11:49:24.02 process pointer page 94 of 189
11:49:24.05 process pointer page 95 of 189
11:49:24.08 process pointer page 96 of 189
11:49:24.11 process pointer page 97 of 189
11:49:24.14 process pointer page 98 of 189
11:49:24.19 process pointer page 99 of 189
11:49:24.21 process pointer page 100 of 189
11:49:24.24 process pointer page 101 of 189
11:49:24.27 process pointer page 102 of 189
11:49:24.30 process pointer page 103 of 189
11:49:24.33 process pointer page 104 of 189
11:49:24.36 process pointer page 105 of 189
11:49:24.41 process pointer page 106 of 189
11:49:24.46 process pointer page 107 of 189
11:49:24.50 process pointer page 108 of 189
11:49:24.53 process pointer page 109 of 189
11:49:24.57 process pointer page 110 of 189
11:49:24.60 process pointer page 111 of 189
11:49:24.63 process pointer page 112 of 189
11:49:24.71 process pointer page 113 of 189
11:49:24.78 process pointer page 114 of 189
11:49:24.88 process pointer page 115 of 189
11:49:24.96 process pointer page 116 of 189
11:49:25.03 process pointer page 117 of 189
11:49:25.10 process pointer page 118 of 189
11:49:25.13 process pointer page 119 of 189
11:49:25.17 process pointer page 120 of 189
11:49:25.22 process pointer page 121 of 189
11:49:25.31 process pointer page 122 of 189
11:49:25.39 process pointer page 123 of 189
11:49:25.47 process pointer page 124 of 189
11:49:25.55 process pointer page 125 of 189
11:49:25.63 process pointer page 126 of 189
11:49:25.72 process pointer page 127 of 189
11:49:25.80 process pointer page 128 of 189
11:49:25.88 process pointer page 129 of 189
11:49:25.95 process pointer page 130 of 189
11:49:26.03 process pointer page 131 of 189
11:49:26.13 process pointer page 132 of 189
11:49:26.20 process pointer page 133 of 189
11:49:26.28 process pointer page 134 of 189
11:49:26.36 process pointer page 135 of 189
11:49:26.45 process pointer page 136 of 189
11:49:26.53 process pointer page 137 of 189
11:49:26.61 process pointer page 138 of 189
11:49:26.69 process pointer page 139 of 189
11:49:26.78 process pointer page 140 of 189
11:49:26.86 process pointer page 141 of 189
11:49:26.94 process pointer page 142 of 189
11:49:27.01 process pointer page 143 of 189
11:49:27.09 process pointer page 144 of 189
11:49:27.19 process pointer page 145 of 189
11:49:27.26 process pointer page 146 of 189
11:49:27.34 process pointer page 147 of 189
11:49:27.44 process pointer page 148 of 189
11:49:27.51 process pointer page 149 of 189
11:49:27.59 process pointer page 150 of 189
11:49:27.67 process pointer page 151 of 189
11:49:27.76 process pointer page 152 of 189
11:49:27.84 process pointer page 153 of 189
11:49:27.92 process pointer page 154 of 189
11:49:28.00 process pointer page 155 of 189
11:49:28.09 process pointer page 156 of 189
11:49:28.17 process pointer page 157 of 189
11:49:28.25 process pointer page 158 of 189
11:49:28.32 process pointer page 159 of 189
11:49:28.40 process pointer page 160 of 189
11:49:28.50 process pointer page 161 of 189
11:49:28.57 process pointer page 162 of 189
11:49:28.65 process pointer page 163 of 189
11:49:28.73 process pointer page 164 of 189
11:49:28.82 process pointer page 165 of 189
11:49:28.90 process pointer page 166 of 189
11:49:28.98 process pointer page 167 of 189
11:49:29.06 process pointer page 168 of 189
11:49:29.14 process pointer page 169 of 189
11:49:29.23 process pointer page 170 of 189
11:49:29.31 process pointer page 171 of 189
11:49:29.39 process pointer page 172 of 189
11:49:29.46 process pointer page 173 of 189
11:49:29.56 process pointer page 174 of 189
11:49:29.64 process pointer page 175 of 189
11:49:29.71 process pointer page 176 of 189
11:49:29.79 process pointer page 177 of 189
11:49:29.88 process pointer page 178 of 189
11:49:29.96 process pointer page 179 of 189
11:49:30.04 process pointer page 180 of 189
11:49:30.12 process pointer page 181 of 189
11:49:30.20 process pointer page 182 of 189
11:49:30.29 process pointer page 183 of 189
11:49:30.32 process pointer page 184 of 189
11:49:30.35 process pointer page 185 of 189
11:49:30.38 process pointer page 186 of 189
11:49:30.42 process pointer page 187 of 189
11:49:30.46 process pointer page 188 of 189
11:49:30.52 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:49:34.63 Index 2 (PERF_LOG_UNIT)
11:49:40.07 Index 3 (PERF_LOG_TRN_DESC)
11:49:43.32 Index 4 (PERF_LOG_GDSCODE)
11:49:46.26 Relation 163 (PERF_LOG) is ok
11:49:46.26 Relation 167 (V_STOPTEST)
11:49:46.26 Relation 167 (V_STOPTEST) is ok
11:49:46.26 Relation 184 (V_QDISTR_SOURCE)
11:49:46.26 Relation 184 (V_QDISTR_SOURCE) is ok
11:49:46.26 Relation 185 (V_QSTORNED_SOURCE)
11:49:46.26 Relation 185 (V_QSTORNED_SOURCE) is ok
11:49:46.26 Relation 260 (XQD_1000_1200)
11:49:46.26 process pointer page 0 of 1
11:49:46.28 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:49:46.28 Relation 260 (XQD_1000_1200) is ok
11:49:46.28 Relation 261 (XQD_1200_2000)
11:49:46.28 process pointer page 0 of 2
11:49:46.36 process pointer page 1 of 2
11:49:46.37 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:49:46.39 Relation 261 (XQD_1200_2000) is ok
11:49:46.39 Relation 262 (XQD_1000_3300)
11:49:46.39 process pointer page 0 of 6
11:49:46.48 process pointer page 1 of 6
11:49:46.58 process pointer page 2 of 6
11:49:46.67 process pointer page 3 of 6
11:49:46.75 process pointer page 4 of 6
11:49:46.84 process pointer page 5 of 6
11:49:46.92 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:49:47.15 Index 2 (XQD_1000_3300_DOC)
11:49:47.34 Relation 262 (XQD_1000_3300) is ok
11:49:47.34 Relation 263 (XQD_2000_3300)
11:49:47.34 process pointer page 0 of 19
11:49:47.43 process pointer page 1 of 19
11:49:47.51 process pointer page 2 of 19
11:49:47.61 process pointer page 3 of 19
11:49:47.68 process pointer page 4 of 19
11:49:47.76 process pointer page 5 of 19
11:49:47.86 process pointer page 6 of 19
11:49:47.93 process pointer page 7 of 19
11:49:48.01 process pointer page 8 of 19
11:49:48.11 process pointer page 9 of 19
11:49:48.17 process pointer page 10 of 19
11:49:48.26 process pointer page 11 of 19
11:49:48.36 process pointer page 12 of 19
11:49:48.45 process pointer page 13 of 19
11:49:48.54 process pointer page 14 of 19
11:49:48.62 process pointer page 15 of 19
11:49:48.71 process pointer page 16 of 19
11:49:48.79 process pointer page 17 of 19
11:49:48.87 process pointer page 18 of 19
11:49:48.92 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:49:49.37 Relation 263 (XQD_2000_3300) is ok
11:49:49.37 Relation 264 (XQD_2100_3300)
11:49:49.37 process pointer page 0 of 18
11:49:49.45 process pointer page 1 of 18
11:49:49.53 process pointer page 2 of 18
11:49:49.59 process pointer page 3 of 18
11:49:49.65 process pointer page 4 of 18
11:49:49.73 process pointer page 5 of 18
11:49:49.79 process pointer page 6 of 18
11:49:49.87 process pointer page 7 of 18
11:49:49.93 process pointer page 8 of 18
11:49:50.01 process pointer page 9 of 18
11:49:50.07 process pointer page 10 of 18
11:49:50.15 process pointer page 11 of 18
11:49:50.21 process pointer page 12 of 18
11:49:50.27 process pointer page 13 of 18
11:49:50.35 process pointer page 14 of 18
11:49:50.41 process pointer page 15 of 18
11:49:50.48 process pointer page 16 of 18
11:49:50.55 process pointer page 17 of 18
11:49:50.59 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:49:50.60 Relation 264 (XQD_2100_3300) is ok
11:49:50.60 Relation 265 (XQD_3300_3400)
11:49:50.60 process pointer page 0 of 25
11:49:50.68 process pointer page 1 of 25
11:49:50.77 process pointer page 2 of 25
11:49:50.87 process pointer page 3 of 25
11:49:50.96 process pointer page 4 of 25
11:49:51.05 process pointer page 5 of 25
11:49:51.13 process pointer page 6 of 25
11:49:51.23 process pointer page 7 of 25
11:49:51.32 process pointer page 8 of 25
11:49:51.40 process pointer page 9 of 25
11:49:51.43 process pointer page 10 of 25
11:49:51.48 process pointer page 11 of 25
11:49:51.51 process pointer page 12 of 25
11:49:51.55 process pointer page 13 of 25
11:49:51.65 process pointer page 14 of 25
11:49:51.74 process pointer page 15 of 25
11:49:51.82 process pointer page 16 of 25
11:49:51.91 process pointer page 17 of 25
11:49:52.01 process pointer page 18 of 25
11:49:52.10 process pointer page 19 of 25
11:49:52.18 process pointer page 20 of 25
11:49:52.27 process pointer page 21 of 25
11:49:52.36 process pointer page 22 of 25
11:49:52.46 process pointer page 23 of 25
11:49:52.55 process pointer page 24 of 25
11:49:52.63 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:49:53.75 Relation 265 (XQD_3300_3400) is ok
11:49:53.75 Relation 266 (XQS_1000_1200)
11:49:53.75 process pointer page 0 of 42
11:49:53.85 process pointer page 1 of 42
11:49:53.92 process pointer page 2 of 42
11:49:54.02 process pointer page 3 of 42
11:49:54.11 process pointer page 4 of 42
11:49:54.21 process pointer page 5 of 42
11:49:54.30 process pointer page 6 of 42
11:49:54.39 process pointer page 7 of 42
11:49:54.47 process pointer page 8 of 42
11:49:54.56 process pointer page 9 of 42
11:49:54.66 process pointer page 10 of 42
11:49:54.75 process pointer page 11 of 42
11:49:54.84 process pointer page 12 of 42
11:49:54.92 process pointer page 13 of 42
11:49:55.02 process pointer page 14 of 42
11:49:55.11 process pointer page 15 of 42
11:49:55.19 process pointer page 16 of 42
11:49:55.28 process pointer page 17 of 42
11:49:55.38 process pointer page 18 of 42
11:49:55.45 process pointer page 19 of 42
11:49:55.55 process pointer page 20 of 42
11:49:55.64 process pointer page 21 of 42
11:49:55.72 process pointer page 22 of 42
11:49:55.81 process pointer page 23 of 42
11:49:55.91 process pointer page 24 of 42
11:49:55.98 process pointer page 25 of 42
11:49:56.08 process pointer page 26 of 42
11:49:56.17 process pointer page 27 of 42
11:49:56.25 process pointer page 28 of 42
11:49:56.34 process pointer page 29 of 42
11:49:56.44 process pointer page 30 of 42
11:49:56.53 process pointer page 31 of 42
11:49:56.61 process pointer page 32 of 42
11:49:56.65 process pointer page 33 of 42
11:49:56.70 process pointer page 34 of 42
11:49:56.73 process pointer page 35 of 42
11:49:56.76 process pointer page 36 of 42
11:49:56.79 process pointer page 37 of 42
11:49:56.83 process pointer page 38 of 42
11:49:56.92 process pointer page 39 of 42
11:49:57.01 process pointer page 40 of 42
11:49:57.11 process pointer page 41 of 42
11:49:57.17 Index 1 (XQS_1000_1200_DOC_ID)
11:49:58.51 Index 2 (XQS_1000_1200_SND_ID)
11:49:59.67 Index 3 (XQS_1000_1200_RCV_ID)
11:50:00.68 Relation 266 (XQS_1000_1200) is ok
11:50:00.68 Relation 267 (XQS_1200_2000)
11:50:00.68 process pointer page 0 of 45
11:50:00.77 process pointer page 1 of 45
11:50:00.87 process pointer page 2 of 45
11:50:00.96 process pointer page 3 of 45
11:50:01.05 process pointer page 4 of 45
11:50:01.15 process pointer page 5 of 45
11:50:01.23 process pointer page 6 of 45
11:50:01.33 process pointer page 7 of 45
11:50:01.43 process pointer page 8 of 45
11:50:01.52 process pointer page 9 of 45
11:50:01.62 process pointer page 10 of 45
11:50:01.71 process pointer page 11 of 45
11:50:01.80 process pointer page 12 of 45
11:50:01.90 process pointer page 13 of 45
11:50:01.96 process pointer page 14 of 45
11:50:01.99 process pointer page 15 of 45
11:50:02.04 process pointer page 16 of 45
11:50:02.08 process pointer page 17 of 45
11:50:02.16 process pointer page 18 of 45
11:50:02.27 process pointer page 19 of 45
11:50:02.36 process pointer page 20 of 45
11:50:02.47 process pointer page 21 of 45
11:50:02.58 process pointer page 22 of 45
11:50:02.69 process pointer page 23 of 45
11:50:02.79 process pointer page 24 of 45
11:50:02.89 process pointer page 25 of 45
11:50:03.00 process pointer page 26 of 45
11:50:03.10 process pointer page 27 of 45
11:50:03.21 process pointer page 28 of 45
11:50:03.32 process pointer page 29 of 45
11:50:03.41 process pointer page 30 of 45
11:50:03.52 process pointer page 31 of 45
11:50:03.63 process pointer page 32 of 45
11:50:03.72 process pointer page 33 of 45
11:50:03.83 process pointer page 34 of 45
11:50:03.94 process pointer page 35 of 45
11:50:04.05 process pointer page 36 of 45
11:50:04.14 process pointer page 37 of 45
11:50:04.25 process pointer page 38 of 45
11:50:04.36 process pointer page 39 of 45
11:50:04.45 process pointer page 40 of 45
11:50:04.56 process pointer page 41 of 45
11:50:04.66 process pointer page 42 of 45
11:50:04.77 process pointer page 43 of 45
11:50:04.88 process pointer page 44 of 45
11:50:04.88 Index 1 (XQS_1200_2000_DOC_ID)
11:50:06.48 Index 2 (XQS_1200_2000_SND_ID)
11:50:07.92 Index 3 (XQS_1200_2000_RCV_ID)
11:50:09.13 Relation 267 (XQS_1200_2000) is ok
11:50:09.13 Relation 268 (XQS_1000_3300)
11:50:09.13 process pointer page 0 of 26
11:50:09.57 process pointer page 1 of 26
11:50:10.07 process pointer page 2 of 26
11:50:10.57 process pointer page 3 of 26
11:50:11.07 process pointer page 4 of 26
11:50:11.38 process pointer page 5 of 26
11:50:11.65 process pointer page 6 of 26
11:50:11.93 process pointer page 7 of 26
11:50:12.18 process pointer page 8 of 26
11:50:12.46 process pointer page 9 of 26
11:50:12.61 process pointer page 10 of 26
11:50:12.89 process pointer page 11 of 26
11:50:13.17 process pointer page 12 of 26
11:50:13.50 process pointer page 13 of 26
11:50:13.86 process pointer page 14 of 26
11:50:14.17 process pointer page 15 of 26
11:50:14.52 process pointer page 16 of 26
11:50:14.89 process pointer page 17 of 26
11:50:15.27 process pointer page 18 of 26
11:50:15.64 process pointer page 19 of 26
11:50:16.06 process pointer page 20 of 26
11:50:16.54 process pointer page 21 of 26
11:50:17.03 process pointer page 22 of 26
11:50:17.40 process pointer page 23 of 26
11:50:17.73 process pointer page 24 of 26
11:50:18.15 process pointer page 25 of 26
11:50:18.48 Index 1 (XQS_1000_3300_DOC_ID)
11:50:20.05 Index 2 (XQS_1000_3300_SND_ID)
11:50:21.86 Index 3 (XQS_1000_3300_RCV_ID)
11:50:23.30 Relation 268 (XQS_1000_3300) is ok
11:50:23.30 Relation 269 (XQS_2000_3300)
11:50:23.30 process pointer page 0 of 1
11:50:23.30 Index 1 (XQS_2000_3300_DOC_ID)
11:50:23.30 Index 2 (XQS_2000_3300_SND_ID)
11:50:23.30 Index 3 (XQS_2000_3300_RCV_ID)
11:50:23.30 Relation 269 (XQS_2000_3300) is ok
11:50:23.30 Relation 270 (XQS_2100_3300)
11:50:23.30 process pointer page 0 of 31
11:50:23.78 process pointer page 1 of 31
11:50:24.28 process pointer page 2 of 31
11:50:24.80 process pointer page 3 of 31
11:50:25.30 process pointer page 4 of 31
11:50:25.67 process pointer page 5 of 31
11:50:26.14 process pointer page 6 of 31
11:50:26.59 process pointer page 7 of 31
11:50:27.04 process pointer page 8 of 31
11:50:27.51 process pointer page 9 of 31
11:50:27.96 process pointer page 10 of 31
11:50:28.42 process pointer page 11 of 31
11:50:28.82 process pointer page 12 of 31
11:50:29.26 process pointer page 13 of 31
11:50:29.70 process pointer page 14 of 31
11:50:30.13 process pointer page 15 of 31
11:50:30.54 process pointer page 16 of 31
11:50:30.97 process pointer page 17 of 31
11:50:31.38 process pointer page 18 of 31
11:50:31.77 process pointer page 19 of 31
11:50:32.18 process pointer page 20 of 31
11:50:32.60 process pointer page 21 of 31
11:50:33.02 process pointer page 22 of 31
11:50:33.44 process pointer page 23 of 31
11:50:33.86 process pointer page 24 of 31
11:50:34.30 process pointer page 25 of 31
11:50:34.77 process pointer page 26 of 31
11:50:35.22 process pointer page 27 of 31
11:50:35.62 process pointer page 28 of 31
11:50:36.04 process pointer page 29 of 31
11:50:36.53 process pointer page 30 of 31
11:50:36.95 Index 1 (XQS_2100_3300_DOC_ID)
11:50:38.93 Index 2 (XQS_2100_3300_SND_ID)
11:50:41.05 Index 3 (XQS_2100_3300_RCV_ID)
11:50:43.10 Relation 270 (XQS_2100_3300) is ok
11:50:43.10 Relation 271 (XQS_3300_3400)
11:50:43.11 process pointer page 0 of 5
11:50:43.58 process pointer page 1 of 5
11:50:44.05 process pointer page 2 of 5
11:50:44.44 process pointer page 3 of 5
11:50:44.89 process pointer page 4 of 5
11:50:45.12 Index 1 (XQS_3300_3400_DOC_ID)
11:50:45.44 Index 2 (XQS_3300_3400_SND_ID)
11:50:45.76 Relation 271 (XQS_3300_3400) is ok
11:50:45.79 Validation finished
Done for 94670 ms, from 11:49:11.23 to 11:50:45.90.
Differences between old and current firebird.log
11:50:47.64. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2018-06-17 11:50 478 oltp40_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Sun Jun 17 11:49:11 2018
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sun Jun 17 11:50:45 2018
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2018-06-17 11:50:57.51 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html