ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
6090.38 |
3830 |
1096268 |
2017-11-16 03:46 |
2017-11-16 06:46 |
customer order: creation |
475.43 |
524 |
85578 |
2017-11-16 03:46 |
2017-11-16 06:46 |
customer order: refuse |
37.80 |
266 |
6804 |
2017-11-16 03:46 |
2017-11-16 06:46 |
order to supplier: creation |
122.26 |
2304 |
22006 |
2017-11-16 03:46 |
2017-11-16 06:46 |
order to supplier: removal |
3.11 |
22993 |
560 |
2017-11-16 03:46 |
2017-11-16 06:46 |
invoice (draft): creation |
121.83 |
3495 |
21929 |
2017-11-16 03:46 |
2017-11-16 06:46 |
invoice (draft): removal |
44.26 |
536 |
7966 |
2017-11-16 03:46 |
2017-11-16 06:46 |
invoice accept: apply |
66.29 |
13104 |
11932 |
2017-11-16 03:46 |
2017-11-16 06:46 |
invoice accept: cancel |
18.49 |
2990 |
3309 |
2017-11-16 03:46 |
2017-11-16 06:46 |
customer reserve: creation |
3492.16 |
206 |
628588 |
2017-11-16 03:46 |
2017-11-16 06:46 |
customer reserve: removal |
1054.58 |
75 |
189824 |
2017-11-16 03:46 |
2017-11-16 06:46 |
realization accept: apply |
218.08 |
592 |
39254 |
2017-11-16 03:46 |
2017-11-16 06:46 |
realization accept: cancel |
92.48 |
171 |
16647 |
2017-11-16 03:46 |
2017-11-16 06:46 |
payment from customer: creation |
159.33 |
918 |
28679 |
2017-11-16 03:46 |
2017-11-16 06:46 |
payment from customer: removal |
15.19 |
153 |
2735 |
2017-11-16 03:46 |
2017-11-16 06:46 |
payment to supplier: creation |
131.12 |
727 |
23601 |
2017-11-16 03:46 |
2017-11-16 06:46 |
payment to supplier: removal |
8.99 |
154 |
1618 |
2017-11-16 03:46 |
2017-11-16 06:46 |
service: total inventory turnovers |
9.04 |
3490 |
1628 |
2017-11-16 03:46 |
2017-11-16 06:46 |
service: total monetary turnovers |
19.99 |
67 |
3599 |
2017-11-16 03:46 |
2017-11-16 06:46 |
service: refresh index statistics |
0.07 |
20014 |
11 |
2017-11-16 03:46 |
2017-11-16 06:46 |
Done for 65460 ms, from 6:49:06.04 to 6:50:11.50.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
4994 |
103857 |
89886 |
13971 |
13.45 |
03:46:43 |
04:04:43 |
interval # 2, overall |
2 |
5888 |
118379 |
105975 |
12404 |
10.48 |
04:04:44 |
04:22:44 |
interval # 3, overall |
3 |
5996 |
121095 |
107923 |
13172 |
10.88 |
04:22:45 |
04:40:45 |
interval # 4, overall |
4 |
6363 |
128365 |
114534 |
13831 |
10.77 |
04:40:46 |
04:58:46 |
interval # 5, overall |
5 |
6174 |
124055 |
111127 |
12928 |
10.42 |
04:58:47 |
05:16:47 |
interval # 6, overall |
6 |
6663 |
135526 |
119930 |
15596 |
11.51 |
05:16:48 |
05:34:48 |
interval # 7, overall |
7 |
6114 |
121145 |
110058 |
11087 |
9.15 |
05:34:49 |
05:52:49 |
interval # 8, overall |
8 |
6306 |
128556 |
113507 |
15049 |
11.71 |
05:52:50 |
06:10:50 |
interval # 9, overall |
9 |
6253 |
131140 |
112547 |
18593 |
14.18 |
06:10:51 |
06:28:51 |
interval # 10, overall |
10 |
6155 |
118431 |
110781 |
7650 |
6.46 |
06:28:52 |
06:46:52 |
Done for 188730 ms, from 6:53:19.68 to 6:56:28.41.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
3243.34 |
0.1245 |
1.6335 |
2883 |
19 |
TEST_TIME |
2 |
3520.70 |
0.7525 |
1.1977 |
1626 |
22 |
TEST_TIME |
3 |
3178.26 |
0.8846 |
1.1324 |
1258 |
21 |
TEST_TIME |
4 |
3152.24 |
0.8564 |
1.1437 |
1280 |
21 |
TEST_TIME |
5 |
3229.38 |
0.8931 |
1.1240 |
1645 |
28 |
TEST_TIME |
6 |
3291.30 |
0.9192 |
1.1002 |
1508 |
27 |
TEST_TIME |
7 |
3409.59 |
0.9104 |
1.1001 |
1757 |
41 |
TEST_TIME |
8 |
3555.56 |
0.9231 |
1.0762 |
1717 |
100 |
TEST_TIME |
9 |
3710.88 |
0.9181 |
1.0843 |
1780 |
100 |
TEST_TIME |
10 |
3897.31 |
0.9292 |
1.0644 |
2115 |
100 |
TEST_TIME |
11 |
4028.57 |
0.9369 |
1.0603 |
2139 |
100 |
TEST_TIME |
12 |
4136.16 |
0.9467 |
1.0403 |
1563 |
100 |
TEST_TIME |
13 |
4163.85 |
0.9539 |
1.0417 |
1684 |
100 |
TEST_TIME |
14 |
4267.24 |
0.9439 |
1.0518 |
1563 |
100 |
TEST_TIME |
15 |
4415.18 |
0.9488 |
1.0533 |
1963 |
100 |
TEST_TIME |
16 |
4605.60 |
0.9466 |
1.0630 |
2361 |
100 |
TEST_TIME |
17 |
4780.23 |
0.9639 |
1.0508 |
2024 |
100 |
TEST_TIME |
18 |
4899.91 |
0.9682 |
1.0410 |
1978 |
100 |
TEST_TIME |
19 |
5011.10 |
0.9644 |
1.0367 |
1759 |
100 |
TEST_TIME |
20 |
5129.34 |
0.9623 |
1.0367 |
1624 |
100 |
TEST_TIME |
21 |
5227.20 |
0.9689 |
1.0337 |
1884 |
100 |
TEST_TIME |
22 |
5297.99 |
0.9738 |
1.0179 |
1695 |
100 |
TEST_TIME |
23 |
5237.97 |
0.9848 |
1.0199 |
1580 |
97 |
TEST_TIME |
24 |
5272.73 |
0.9710 |
1.0093 |
1273 |
99 |
TEST_TIME |
25 |
5212.20 |
0.9816 |
1.0074 |
1218 |
96 |
TEST_TIME |
26 |
5206.94 |
0.9696 |
1.0208 |
1273 |
100 |
TEST_TIME |
27 |
5219.38 |
0.9806 |
1.0203 |
1291 |
100 |
TEST_TIME |
28 |
5172.74 |
0.9928 |
1.0143 |
1419 |
98 |
TEST_TIME |
29 |
5191.35 |
0.9759 |
1.0172 |
1266 |
100 |
TEST_TIME |
30 |
5205.36 |
0.9806 |
1.0142 |
2268 |
100 |
TEST_TIME |
31 |
5222.44 |
0.9783 |
1.0213 |
1737 |
98 |
TEST_TIME |
32 |
5320.91 |
0.9711 |
1.0156 |
2178 |
100 |
TEST_TIME |
33 |
5332.26 |
0.9827 |
1.0214 |
2261 |
97 |
TEST_TIME |
34 |
5362.76 |
0.9857 |
1.0156 |
2006 |
96 |
TEST_TIME |
35 |
5386.21 |
0.9823 |
1.0191 |
1565 |
97 |
TEST_TIME |
36 |
5407.99 |
0.9868 |
1.0059 |
1564 |
100 |
TEST_TIME |
37 |
5403.95 |
0.9871 |
1.0088 |
1408 |
99 |
TEST_TIME |
38 |
5382.17 |
0.9862 |
1.0090 |
1550 |
100 |
TEST_TIME |
39 |
5376.08 |
0.9842 |
1.0155 |
1551 |
100 |
TEST_TIME |
40 |
5388.85 |
0.9878 |
1.0177 |
1470 |
100 |
TEST_TIME |
41 |
5423.18 |
0.9870 |
1.0082 |
1395 |
100 |
TEST_TIME |
42 |
5409.88 |
0.9866 |
1.0186 |
1322 |
100 |
TEST_TIME |
43 |
5439.50 |
0.9895 |
1.0123 |
1311 |
100 |
TEST_TIME |
44 |
5420.89 |
0.9927 |
1.0097 |
1218 |
99 |
TEST_TIME |
45 |
5417.07 |
0.9880 |
1.0108 |
2194 |
100 |
TEST_TIME |
46 |
5442.06 |
0.9842 |
1.0095 |
2033 |
99 |
TEST_TIME |
47 |
5440.51 |
0.9883 |
1.0187 |
1864 |
98 |
TEST_TIME |
48 |
5489.59 |
0.9886 |
1.0132 |
1805 |
100 |
TEST_TIME |
49 |
5512.27 |
0.9885 |
1.0106 |
1853 |
100 |
TEST_TIME |
50 |
5524.45 |
0.9885 |
1.0129 |
1850 |
100 |
TEST_TIME |
51 |
5559.54 |
0.9867 |
1.0083 |
1857 |
99 |
TEST_TIME |
52 |
5563.95 |
0.9881 |
1.0103 |
1758 |
100 |
TEST_TIME |
53 |
5570.97 |
0.9900 |
1.0094 |
1639 |
100 |
TEST_TIME |
54 |
5583.78 |
0.9884 |
1.0149 |
1576 |
100 |
TEST_TIME |
55 |
5624.47 |
0.9892 |
1.0095 |
1514 |
100 |
TEST_TIME |
56 |
5615.01 |
0.9932 |
1.0096 |
1429 |
100 |
TEST_TIME |
57 |
5627.67 |
0.9897 |
1.0076 |
1488 |
100 |
TEST_TIME |
58 |
5624.36 |
0.9908 |
1.0106 |
1279 |
100 |
TEST_TIME |
59 |
5633.18 |
0.9919 |
1.0074 |
1275 |
100 |
TEST_TIME |
60 |
5607.71 |
0.9954 |
1.0053 |
1603 |
100 |
TEST_TIME |
61 |
5613.80 |
0.9878 |
1.0100 |
1957 |
100 |
TEST_TIME |
62 |
5638.81 |
0.9893 |
1.0082 |
2121 |
98 |
TEST_TIME |
63 |
5638.34 |
0.9923 |
1.0085 |
2062 |
99 |
TEST_TIME |
64 |
5672.38 |
0.9868 |
1.0095 |
1832 |
100 |
TEST_TIME |
65 |
5688.02 |
0.9913 |
1.0071 |
2057 |
100 |
TEST_TIME |
66 |
5692.03 |
0.9911 |
1.0075 |
1821 |
99 |
TEST_TIME |
67 |
5702.93 |
0.9906 |
1.0097 |
1608 |
100 |
TEST_TIME |
68 |
5715.88 |
0.9926 |
1.0064 |
1673 |
100 |
TEST_TIME |
69 |
5740.01 |
0.9876 |
1.0107 |
1431 |
100 |
TEST_TIME |
70 |
5763.54 |
0.9922 |
1.0080 |
1442 |
100 |
TEST_TIME |
71 |
5783.54 |
0.9904 |
1.0083 |
1396 |
100 |
TEST_TIME |
72 |
5785.32 |
0.9940 |
1.0068 |
1447 |
100 |
TEST_TIME |
73 |
5781.00 |
0.9937 |
1.0075 |
1446 |
100 |
TEST_TIME |
74 |
5779.65 |
0.9941 |
1.0036 |
1415 |
100 |
TEST_TIME |
75 |
5772.21 |
0.9915 |
1.0060 |
1850 |
99 |
TEST_TIME |
76 |
5795.23 |
0.9888 |
1.0058 |
1746 |
100 |
TEST_TIME |
77 |
5787.63 |
0.9940 |
1.0089 |
1265 |
100 |
TEST_TIME |
78 |
5786.23 |
0.9962 |
1.0085 |
1948 |
97 |
TEST_TIME |
79 |
5800.90 |
0.9932 |
1.0059 |
1803 |
97 |
TEST_TIME |
80 |
5811.64 |
0.9915 |
1.0055 |
1733 |
99 |
TEST_TIME |
81 |
5810.71 |
0.9932 |
1.0080 |
1452 |
100 |
TEST_TIME |
82 |
5828.68 |
0.9926 |
1.0035 |
1474 |
100 |
TEST_TIME |
83 |
5825.56 |
0.9919 |
1.0094 |
1370 |
100 |
TEST_TIME |
84 |
5849.12 |
0.9934 |
1.0038 |
1589 |
100 |
TEST_TIME |
85 |
5828.58 |
0.9955 |
1.0047 |
1550 |
96 |
TEST_TIME |
86 |
5822.21 |
0.9941 |
1.0058 |
1509 |
94 |
TEST_TIME |
87 |
5818.53 |
0.9948 |
1.0048 |
1467 |
94 |
TEST_TIME |
88 |
5821.94 |
0.9928 |
1.0051 |
1247 |
100 |
TEST_TIME |
89 |
5828.15 |
0.9928 |
1.0051 |
1382 |
100 |
TEST_TIME |
90 |
5845.20 |
0.9911 |
1.0069 |
2458 |
100 |
TEST_TIME |
91 |
5864.31 |
0.9926 |
1.0088 |
2114 |
98 |
TEST_TIME |
92 |
5895.71 |
0.9926 |
1.0085 |
1756 |
99 |
TEST_TIME |
93 |
5919.15 |
0.9937 |
1.0063 |
1655 |
100 |
TEST_TIME |
94 |
5930.56 |
0.9937 |
1.0038 |
1660 |
100 |
TEST_TIME |
95 |
5928.87 |
0.9935 |
1.0033 |
1734 |
100 |
TEST_TIME |
96 |
5921.40 |
0.9941 |
1.0043 |
1422 |
99 |
TEST_TIME |
97 |
5909.11 |
0.9960 |
1.0039 |
1569 |
88 |
TEST_TIME |
98 |
5920.06 |
0.9918 |
1.0052 |
1362 |
100 |
TEST_TIME |
99 |
5916.80 |
0.9956 |
1.0047 |
1458 |
99 |
TEST_TIME |
100 |
5935.87 |
0.9915 |
1.0032 |
1377 |
100 |
TEST_TIME |
101 |
5916.80 |
0.9964 |
1.0080 |
1329 |
99 |
TEST_TIME |
102 |
5941.64 |
0.9940 |
1.0057 |
1301 |
100 |
TEST_TIME |
103 |
5953.68 |
0.9939 |
1.0068 |
1286 |
100 |
TEST_TIME |
104 |
5965.93 |
0.9952 |
1.0023 |
1296 |
100 |
TEST_TIME |
105 |
5961.29 |
0.9936 |
1.0046 |
1907 |
100 |
TEST_TIME |
106 |
5976.19 |
0.9927 |
1.0036 |
1852 |
97 |
TEST_TIME |
107 |
5965.36 |
0.9960 |
1.0050 |
1640 |
88 |
TEST_TIME |
108 |
5984.53 |
0.9925 |
1.0051 |
1704 |
99 |
TEST_TIME |
109 |
5990.52 |
0.9949 |
1.0055 |
1708 |
98 |
TEST_TIME |
110 |
5990.76 |
0.9964 |
1.0044 |
1653 |
93 |
TEST_TIME |
111 |
5997.10 |
0.9943 |
1.0071 |
1523 |
96 |
TEST_TIME |
112 |
6026.33 |
0.9932 |
1.0040 |
1223 |
100 |
TEST_TIME |
113 |
6028.67 |
0.9947 |
1.0045 |
1431 |
100 |
TEST_TIME |
114 |
6013.86 |
0.9981 |
1.0022 |
1570 |
98 |
TEST_TIME |
115 |
6011.36 |
0.9940 |
1.0040 |
1307 |
99 |
TEST_TIME |
116 |
6020.16 |
0.9939 |
1.0040 |
1359 |
100 |
TEST_TIME |
117 |
6020.66 |
0.9954 |
1.0024 |
1296 |
98 |
TEST_TIME |
118 |
6014.74 |
0.9949 |
1.0038 |
1269 |
99 |
TEST_TIME |
119 |
5997.38 |
0.9983 |
1.0019 |
1355 |
98 |
TEST_TIME |
120 |
5976.65 |
0.9970 |
1.0028 |
1355 |
95 |
TEST_TIME |
121 |
5989.21 |
0.9924 |
1.0062 |
1773 |
97 |
TEST_TIME |
122 |
5991.20 |
0.9976 |
1.0027 |
1774 |
93 |
TEST_TIME |
123 |
6003.50 |
0.9927 |
1.0054 |
1675 |
98 |
TEST_TIME |
124 |
6000.80 |
0.9978 |
1.0027 |
1872 |
95 |
TEST_TIME |
125 |
6008.15 |
0.9934 |
1.0046 |
1460 |
98 |
TEST_TIME |
126 |
6003.24 |
0.9975 |
1.0027 |
1691 |
99 |
TEST_TIME |
127 |
6006.25 |
0.9943 |
1.0056 |
1510 |
100 |
TEST_TIME |
128 |
6018.42 |
0.9958 |
1.0043 |
1348 |
100 |
TEST_TIME |
129 |
6016.36 |
0.9968 |
1.0024 |
1660 |
100 |
TEST_TIME |
130 |
6012.83 |
0.9953 |
1.0049 |
1376 |
98 |
TEST_TIME |
131 |
6022.79 |
0.9956 |
1.0073 |
1275 |
100 |
TEST_TIME |
132 |
6039.62 |
0.9969 |
1.0021 |
1344 |
100 |
TEST_TIME |
133 |
6025.25 |
0.9969 |
1.0033 |
1275 |
100 |
TEST_TIME |
134 |
6008.53 |
0.9986 |
1.0041 |
1110 |
96 |
TEST_TIME |
135 |
6025.94 |
0.9937 |
1.0049 |
1401 |
100 |
TEST_TIME |
136 |
6036.81 |
0.9958 |
1.0046 |
2031 |
98 |
TEST_TIME |
137 |
6038.50 |
0.9970 |
1.0035 |
1849 |
97 |
TEST_TIME |
138 |
6047.30 |
0.9947 |
1.0031 |
1773 |
92 |
TEST_TIME |
139 |
6044.29 |
0.9964 |
1.0048 |
1584 |
92 |
TEST_TIME |
140 |
6049.76 |
0.9967 |
1.0028 |
1601 |
96 |
TEST_TIME |
141 |
6047.25 |
0.9961 |
1.0027 |
1517 |
99 |
TEST_TIME |
142 |
6040.38 |
0.9968 |
1.0054 |
1267 |
100 |
TEST_TIME |
143 |
6053.27 |
0.9969 |
1.0023 |
1458 |
100 |
TEST_TIME |
144 |
6039.68 |
0.9976 |
1.0028 |
1546 |
98 |
TEST_TIME |
145 |
6048.39 |
0.9945 |
1.0036 |
1416 |
100 |
TEST_TIME |
146 |
6055.27 |
0.9956 |
1.0035 |
1283 |
100 |
TEST_TIME |
147 |
6050.85 |
0.9974 |
1.0023 |
1551 |
99 |
TEST_TIME |
148 |
6041.32 |
0.9971 |
1.0049 |
1407 |
99 |
TEST_TIME |
149 |
6050.27 |
0.9967 |
1.0020 |
1151 |
100 |
TEST_TIME |
150 |
6051.07 |
0.9952 |
1.0031 |
1768 |
99 |
TEST_TIME |
151 |
6062.22 |
0.9946 |
1.0056 |
1531 |
99 |
TEST_TIME |
152 |
6068.72 |
0.9980 |
1.0029 |
1916 |
94 |
TEST_TIME |
153 |
6064.54 |
0.9970 |
1.0030 |
1659 |
92 |
TEST_TIME |
154 |
6074.74 |
0.9948 |
1.0025 |
1640 |
96 |
TEST_TIME |
155 |
6068.16 |
0.9971 |
1.0048 |
1544 |
94 |
TEST_TIME |
156 |
6073.94 |
0.9974 |
1.0024 |
1557 |
97 |
TEST_TIME |
157 |
6073.44 |
0.9960 |
1.0026 |
1476 |
93 |
TEST_TIME |
158 |
6079.49 |
0.9971 |
1.0029 |
1353 |
98 |
TEST_TIME |
159 |
6075.40 |
0.9973 |
1.0025 |
1419 |
91 |
TEST_TIME |
160 |
6067.38 |
0.9975 |
1.0024 |
1328 |
93 |
TEST_TIME |
161 |
6060.72 |
0.9973 |
1.0024 |
1178 |
88 |
TEST_TIME |
162 |
6053.19 |
0.9975 |
1.0027 |
1247 |
87 |
TEST_TIME |
163 |
6050.65 |
0.9969 |
1.0026 |
1268 |
92 |
TEST_TIME |
164 |
6045.32 |
0.9974 |
1.0025 |
1328 |
92 |
TEST_TIME |
165 |
6035.83 |
0.9980 |
1.0025 |
1214 |
95 |
TEST_TIME |
166 |
6038.35 |
0.9960 |
1.0057 |
1640 |
95 |
TEST_TIME |
167 |
6061.10 |
0.9959 |
1.0024 |
1638 |
100 |
TEST_TIME |
168 |
6060.70 |
0.9965 |
1.0023 |
1729 |
95 |
TEST_TIME |
169 |
6057.91 |
0.9968 |
1.0032 |
1698 |
95 |
TEST_TIME |
170 |
6065.64 |
0.9974 |
1.0020 |
1646 |
94 |
TEST_TIME |
171 |
6062.88 |
0.9966 |
1.0028 |
1494 |
91 |
TEST_TIME |
172 |
6063.42 |
0.9969 |
1.0039 |
1447 |
94 |
TEST_TIME |
173 |
6066.24 |
0.9976 |
1.0055 |
1250 |
98 |
TEST_TIME |
174 |
6077.15 |
0.9981 |
1.0025 |
1636 |
99 |
TEST_TIME |
175 |
6075.17 |
0.9971 |
1.0020 |
1355 |
100 |
TEST_TIME |
176 |
6069.62 |
0.9972 |
1.0022 |
1259 |
97 |
TEST_TIME |
177 |
6071.42 |
0.9963 |
1.0036 |
1323 |
97 |
TEST_TIME |
178 |
6070.96 |
0.9981 |
1.0025 |
1244 |
94 |
TEST_TIME |
179 |
6087.95 |
0.9941 |
1.0036 |
984 |
99 |
TEST_TIME |
180 |
6080.88 |
0.9992 |
1.0015 |
1037 |
98 |
Done for 9810 ms, from 6:56:29.94 to 6:56:39.75.
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 |
38304 |
49364 |
34442 |
<null> |
37671 |
8413 |
44217 |
<null> |
46675 |
14870 |
37584 |
50006 |
70891 |
68147 |
98590 |
25753 |
213278 |
223636 |
<null> |
03:46:43 |
04:04:43 |
fetches per second |
2 |
22038 |
52085 |
30595 |
<null> |
32064 |
4749 |
54480 |
4856 |
73230 |
60934 |
30562 |
18144 |
25127 |
61017 |
33908 |
5335 |
357926 |
160923 |
<null> |
04:04:44 |
04:22:44 |
fetches per second |
3 |
13579 |
10377 |
11367 |
4879 |
13039 |
46561 |
28515 |
<null> |
22689 |
54470 |
25451 |
4962 |
27106 |
3043 |
72761 |
13028 |
<null> |
<null> |
<null> |
04:22:45 |
04:40:45 |
fetches per second |
4 |
22029 |
46091 |
24203 |
<null> |
17963 |
25890 |
39990 |
7871 |
27971 |
89461 |
28493 |
27342 |
57415 |
974 |
33244 |
<null> |
15740 |
229475 |
<null> |
04:40:46 |
04:58:46 |
fetches per second |
5 |
12814 |
67298 |
10017 |
<null> |
17897 |
127613 |
30097 |
45838 |
46058 |
5954 |
15134 |
4423 |
29797 |
46426 |
64362 |
36467 |
50375 |
40673 |
<null> |
04:58:47 |
05:16:47 |
fetches per second |
6 |
11077 |
25933 |
17025 |
38818 |
21374 |
43071 |
28576 |
174504 |
44972 |
7876 |
26432 |
11237 |
45606 |
4305 |
43395 |
3907 |
25827 |
22445 |
<null> |
05:16:48 |
05:34:48 |
fetches per second |
7 |
11674 |
5747 |
7424 |
49519 |
16949 |
<null> |
25755 |
3942 |
5894 |
3011 |
17089 |
6585 |
33677 |
9774 |
21380 |
5294 |
16276 |
66540 |
<null> |
05:34:49 |
05:52:49 |
fetches per second |
8 |
7539 |
5311 |
5438 |
8737 |
11764 |
<null> |
29733 |
6280 |
108237 |
3991 |
7581 |
2344 |
10350 |
4245 |
19435 |
8194 |
139974 |
133748 |
<null> |
05:52:50 |
06:10:50 |
fetches per second |
9 |
5703 |
3521 |
27681 |
5304 |
5242 |
7515 |
32398 |
<null> |
9132 |
75432 |
9027 |
18571 |
14310 |
<null> |
39882 |
12032 |
<null> |
291662 |
<null> |
06:10:51 |
06:28:51 |
fetches per second |
10 |
8370 |
4160 |
3617 |
<null> |
5717 |
5297 |
19636 |
5017 |
7450 |
15344 |
6981 |
1846 |
30803 |
4902 |
22138 |
175250 |
39869 |
18016 |
<null> |
06:28:52 |
06:46:52 |
marks per second |
1 |
8390 |
6593 |
7224 |
<null> |
7998 |
2239 |
6338 |
<null> |
6189 |
3096 |
5987 |
8750 |
5646 |
10913 |
4403 |
3707 |
12490 |
4999 |
<null> |
03:46:43 |
04:04:43 |
marks per second |
2 |
4560 |
6416 |
6503 |
<null> |
7370 |
969 |
9269 |
748 |
15280 |
10220 |
4010 |
3105 |
1938 |
10335 |
3170 |
1000 |
44442 |
12082 |
<null> |
04:04:44 |
04:22:44 |
marks per second |
3 |
2810 |
1267 |
2203 |
858 |
2346 |
10193 |
3449 |
<null> |
2721 |
8453 |
3536 |
813 |
1645 |
466 |
4398 |
2126 |
<null> |
<null> |
<null> |
04:22:45 |
04:40:45 |
marks per second |
4 |
4331 |
5578 |
4975 |
<null> |
3750 |
6177 |
5073 |
1067 |
1239 |
15076 |
3210 |
2919 |
2694 |
146 |
2404 |
<null> |
1537 |
11636 |
<null> |
04:40:46 |
04:58:46 |
marks per second |
5 |
2632 |
9210 |
1815 |
<null> |
3875 |
27260 |
2880 |
6373 |
3512 |
892 |
2968 |
653 |
1200 |
7114 |
3693 |
7851 |
1371 |
1429 |
<null> |
04:58:47 |
05:16:47 |
marks per second |
6 |
2333 |
3674 |
3222 |
5564 |
3847 |
10380 |
3795 |
24083 |
7073 |
1355 |
2922 |
1315 |
1586 |
706 |
2098 |
538 |
1714 |
732 |
<null> |
05:16:48 |
05:34:48 |
marks per second |
7 |
2457 |
740 |
1027 |
6971 |
3410 |
<null> |
2679 |
547 |
728 |
615 |
1391 |
1099 |
1378 |
1464 |
1560 |
895 |
267 |
1462 |
<null> |
05:34:49 |
05:52:49 |
marks per second |
8 |
1463 |
696 |
849 |
1192 |
1838 |
<null> |
3113 |
872 |
2536 |
646 |
691 |
341 |
340 |
644 |
990 |
1651 |
3222 |
887 |
<null> |
05:52:50 |
06:10:50 |
marks per second |
9 |
1193 |
461 |
5478 |
810 |
755 |
1656 |
3610 |
<null> |
563 |
12492 |
1703 |
2492 |
704 |
<null> |
5022 |
1664 |
<null> |
8573 |
<null> |
06:10:51 |
06:28:51 |
marks per second |
10 |
1494 |
513 |
521 |
<null> |
788 |
1244 |
1398 |
697 |
480 |
2857 |
721 |
276 |
717 |
751 |
973 |
22250 |
13055 |
518 |
<null> |
06:28:52 |
06:46:52 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:46:43 |
04:04:43 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:04:44 |
04:22:44 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
<null> |
04:22:45 |
04:40:45 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
04:40:46 |
04:58:46 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:58:47 |
05:16:47 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:16:48 |
05:34:48 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:34:49 |
05:52:49 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:52:50 |
06:10:50 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
0 |
<null> |
06:10:51 |
06:28:51 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:28:52 |
06:46:52 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
1 |
0 |
1 |
0 |
1 |
3 |
0 |
<null> |
03:46:43 |
04:04:43 |
writes/marks*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
04:04:44 |
04:22:44 |
writes/marks*100 |
3 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
<null> |
04:22:45 |
04:40:45 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
0 |
0 |
<null> |
04:40:46 |
04:58:46 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
<null> |
04:58:47 |
05:16:47 |
writes/marks*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:16:48 |
05:34:48 |
writes/marks*100 |
7 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
5 |
0 |
<null> |
05:34:49 |
05:52:49 |
writes/marks*100 |
8 |
1 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
05:52:50 |
06:10:50 |
writes/marks*100 |
9 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
2 |
1 |
0 |
1 |
0 |
<null> |
0 |
0 |
<null> |
0 |
<null> |
06:10:51 |
06:28:51 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:28:52 |
06:46:52 |
Done for 8370 ms, from 6:56:40.72 to 6:56:49.09.
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 |
1899146 |
1777621 |
121525 |
6.39 |
0 |
12855 |
55 |
121525 |
2017-11-16 03:46 |
2017-11-16 06:46 |
doc_list_biud |
1899580 |
1777621 |
121959 |
6.42 |
0 |
8705 |
19 |
121959 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_add_invoice_to_stock |
20584 |
11932 |
8652 |
42.03 |
15 |
289084 |
13104 |
8652 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_cancel_adding_invoice |
4247 |
3309 |
938 |
22.08 |
0 |
64085 |
2990 |
938 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_cancel_client_order |
6960 |
6804 |
156 |
2.24 |
0 |
2293 |
266 |
156 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_cancel_customer_reserve |
302490 |
189824 |
112666 |
37.24 |
0 |
4680 |
75 |
112666 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_cancel_pay_from_customer |
2748 |
2735 |
13 |
0.47 |
0 |
2870 |
153 |
13 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_cancel_pay_to_supplier |
1622 |
1618 |
4 |
0.24 |
0 |
2917 |
154 |
4 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_cancel_supplier_invoice |
10200 |
7966 |
2234 |
21.90 |
0 |
12183 |
536 |
2234 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_cancel_supplier_order |
1656 |
560 |
1096 |
66.18 |
31 |
205624 |
22993 |
1096 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_cancel_write_off |
23608 |
16647 |
6961 |
29.48 |
0 |
6256 |
171 |
6961 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_client_order |
85578 |
85578 |
0 |
0.00 |
0 |
4743 |
524 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_customer_reserve |
628588 |
628588 |
0 |
0.00 |
0 |
7285 |
206 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_fill_shopping_cart |
129773 |
129513 |
260 |
0.20 |
0 |
4898 |
104 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_fill_shopping_cart_clo_res |
628588 |
628588 |
0 |
0.00 |
0 |
4680 |
15 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_get_clo_for_invoice |
11932 |
11932 |
0 |
0.00 |
0 |
6754 |
364 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_kill_cost_storno |
31825 |
24309 |
7516 |
23.61 |
0 |
2605 |
24 |
7516 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_kill_qstorno_ret_qs2qd |
638325 |
404821 |
233504 |
36.58 |
0 |
8175 |
29 |
233504 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_kill_qty_storno |
398172 |
276296 |
121876 |
30.60 |
0 |
8674 |
86 |
121876 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_lock_selected_doc |
84219 |
71864 |
12355 |
14.67 |
0 |
2153 |
8 |
12355 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_make_cost_storno |
103466 |
103466 |
0 |
0.00 |
0 |
12698 |
453 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_multiply_rows_for_pdistr |
103466 |
103466 |
0 |
0.00 |
0 |
3963 |
61 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_multiply_rows_for_qdistr |
85578 |
85578 |
0 |
0.00 |
0 |
3151 |
175 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_pay_from_customer |
28679 |
28679 |
0 |
0.00 |
0 |
13463 |
918 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_pay_to_supplier |
23601 |
23601 |
0 |
0.00 |
0 |
11169 |
727 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_payment_common |
52280 |
52280 |
0 |
0.00 |
0 |
3385 |
64 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_qd_handle_on_cancel_clo |
6957 |
6804 |
153 |
2.19 |
0 |
2262 |
116 |
153 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_qd_handle_on_invoice_upd_sts |
15990 |
15241 |
749 |
4.68 |
0 |
8642 |
394 |
749 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_qd_handle_on_reserve_upd_sts |
39254 |
39254 |
0 |
0.00 |
0 |
2933 |
55 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_reserve_write_off |
40555 |
39254 |
1301 |
3.20 |
0 |
12027 |
592 |
1301 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_supplier_invoice |
22031 |
21929 |
102 |
0.46 |
0 |
30685 |
3495 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
sp_supplier_order |
22164 |
22006 |
158 |
0.71 |
0 |
14539 |
2304 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
srv_find_qd_qs_mism |
1120150 |
998642 |
121508 |
10.84 |
0 |
10203 |
31 |
121508 |
2017-11-16 03:46 |
2017-11-16 06:46 |
srv_make_invnt_saldo |
1628 |
1628 |
0 |
0.00 |
46 |
28626 |
3490 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
srv_make_money_saldo |
3599 |
3599 |
0 |
0.00 |
0 |
2340 |
67 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
1856 |
54522 |
20014 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_add_invoice_to_stock |
8652 |
8652 |
0 |
0.00 |
0 |
1684 |
103 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_cancel_adding_invoice |
763 |
763 |
0 |
0.00 |
0 |
2059 |
225 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_cancel_client_order |
156 |
156 |
0 |
0.00 |
0 |
1716 |
108 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_cancel_customer_reserve |
93 |
93 |
0 |
0.00 |
0 |
873 |
86 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_cancel_pay_from_customer |
13 |
13 |
0 |
0.00 |
0 |
889 |
152 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_cancel_pay_to_supplier |
4 |
4 |
0 |
0.00 |
0 |
140 |
58 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_cancel_supplier_invoice |
740 |
740 |
0 |
0.00 |
0 |
982 |
98 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_cancel_supplier_order |
14024 |
14024 |
0 |
0.00 |
0 |
2839 |
143 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_cancel_write_off |
35 |
35 |
0 |
0.00 |
0 |
811 |
53 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_reserve_write_off |
1301 |
1301 |
0 |
0.00 |
0 |
1233 |
81 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_supplier_invoice |
102 |
102 |
0 |
0.00 |
0 |
1607 |
117 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-abend:sp_supplier_order |
158 |
158 |
0 |
0.00 |
0 |
1404 |
107 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_add_invoice_to_stock |
11932 |
11932 |
0 |
0.00 |
0 |
22137 |
706 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_cancel_adding_invoice |
1337 |
1337 |
0 |
0.00 |
0 |
9735 |
821 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_cancel_client_order |
6804 |
6804 |
0 |
0.00 |
0 |
1810 |
74 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_cancel_customer_reserve |
2667 |
2667 |
0 |
0.00 |
0 |
1872 |
73 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_cancel_pay_from_customer |
2735 |
2735 |
0 |
0.00 |
0 |
1482 |
62 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_cancel_pay_to_supplier |
1618 |
1618 |
0 |
0.00 |
0 |
1497 |
50 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_cancel_supplier_invoice |
1000 |
1000 |
0 |
0.00 |
0 |
1701 |
86 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_cancel_supplier_order |
560 |
560 |
0 |
0.00 |
0 |
43649 |
2230 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_cancel_write_off |
3957 |
3957 |
0 |
0.00 |
0 |
2636 |
76 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_client_order |
85578 |
85578 |
0 |
0.00 |
0 |
3058 |
89 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_customer_reserve |
4174 |
4174 |
0 |
0.00 |
0 |
1779 |
65 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_pay_from_customer |
28679 |
28679 |
0 |
0.00 |
0 |
2636 |
77 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_pay_to_supplier |
23601 |
23601 |
0 |
0.00 |
0 |
1653 |
69 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_reserve_write_off |
39254 |
39254 |
0 |
0.00 |
0 |
2433 |
82 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_supplier_invoice |
21929 |
21929 |
0 |
0.00 |
0 |
2138 |
77 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:sp_supplier_order |
22006 |
22006 |
0 |
0.00 |
0 |
2620 |
83 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:srv_make_invnt_saldo |
1628 |
1628 |
0 |
0.00 |
0 |
1388 |
34 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:srv_make_money_saldo |
3599 |
3599 |
0 |
0.00 |
0 |
1139 |
28 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
t$perf-norm:srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
0 |
1716 |
327 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_add_invoice_to_stock |
41168 |
23864 |
17304 |
42.03 |
0 |
1716 |
19 |
17304 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_all_customers |
128504 |
128504 |
0 |
0.00 |
0 |
592 |
6 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_all_suppliers |
88414 |
87894 |
520 |
0.58 |
0 |
795 |
6 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_all_wares |
171156 |
171156 |
0 |
0.00 |
0 |
1170 |
5 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_cancel_adding_invoice |
3204 |
2674 |
530 |
16.54 |
0 |
3136 |
172 |
530 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_cancel_client_order |
13920 |
13608 |
312 |
2.24 |
0 |
952 |
7 |
312 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_cancel_customer_prepayment |
5496 |
5470 |
26 |
0.47 |
0 |
952 |
9 |
26 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_cancel_customer_reserve |
5520 |
5334 |
186 |
3.36 |
0 |
1217 |
10 |
186 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_cancel_payment_to_supplier |
3244 |
3236 |
8 |
0.24 |
0 |
1388 |
10 |
8 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_cancel_supplier_invoice |
3480 |
2000 |
1480 |
42.52 |
0 |
951 |
22 |
1480 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_cancel_supplier_order |
3312 |
1120 |
2192 |
66.18 |
0 |
515 |
10 |
2192 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_cancel_write_off |
7984 |
7914 |
70 |
0.87 |
0 |
3712 |
107 |
70 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_max_id_clo_ord |
22164 |
22006 |
158 |
0.71 |
0 |
842 |
6 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_max_id_clo_res |
4174 |
4174 |
0 |
0.00 |
0 |
1077 |
19 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_max_id_ord_sup |
22031 |
21929 |
102 |
0.46 |
0 |
671 |
6 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_max_non_paid_invoice |
23589 |
23589 |
0 |
0.00 |
0 |
780 |
6 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_max_non_paid_realizn |
28679 |
28679 |
0 |
0.00 |
0 |
874 |
6 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_min_id_clo_ord |
22164 |
22006 |
158 |
0.71 |
0 |
1295 |
8 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_min_id_clo_res |
4174 |
4174 |
0 |
0.00 |
0 |
764 |
10 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_min_id_ord_sup |
22031 |
21929 |
102 |
0.46 |
0 |
1342 |
8 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_min_non_paid_invoice |
23601 |
23601 |
0 |
0.00 |
0 |
2574 |
11 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_min_non_paid_realizn |
28679 |
28679 |
0 |
0.00 |
0 |
1435 |
9 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_our_firm |
42652 |
42652 |
0 |
0.00 |
0 |
1170 |
6 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
v_reserve_write_off |
81110 |
78508 |
2602 |
3.20 |
0 |
2059 |
9 |
2602 |
2017-11-16 03:46 |
2017-11-16 06:46 |
x_lock_depdocs_on_canc_invoice |
18940 |
10275 |
8665 |
45.74 |
0 |
1700 |
35 |
8665 |
2017-11-16 03:46 |
2017-11-16 06:46 |
x_lock_depdocs_on_canc_sup_ord |
1650 |
560 |
1090 |
66.06 |
0 |
1061 |
63 |
1090 |
2017-11-16 03:46 |
2017-11-16 06:46 |
x_make_qstorno_1000_1200 |
22164 |
22006 |
158 |
0.71 |
0 |
13963 |
2073 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
x_make_qstorno_1200_2000 |
22031 |
21929 |
102 |
0.46 |
0 |
29905 |
3261 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
x_make_qstorno_2100_3300 |
628588 |
628588 |
0 |
0.00 |
0 |
7004 |
174 |
0 |
2017-11-16 03:46 |
2017-11-16 06:46 |
Done for 291300 ms, from 7:01:31.86 to 7:06:23.16.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
99 |
sp_kill_cost_storno |
335544336 |
2017-11-16 03:47 |
2017-11-16 06:42 |
deadlock |
75 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-11-16 03:47 |
2017-11-16 06:44 |
deadlock |
10847 |
sp_lock_selected_doc |
335544336 |
2017-11-16 03:46 |
2017-11-16 06:46 |
deadlock |
153 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-11-16 03:47 |
2017-11-16 06:45 |
deadlock |
167 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-11-16 03:47 |
2017-11-16 06:45 |
deadlock |
696 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-11-16 03:47 |
2017-11-16 06:46 |
deadlock |
309 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-11-16 03:56 |
2017-11-16 06:46 |
user_exc |
158 |
x_make_qstorno_1000_1200 |
335544517 |
2017-11-16 03:48 |
2017-11-16 06:43 |
user_exc |
102 |
x_make_qstorno_1200_2000 |
335544517 |
2017-11-16 03:48 |
2017-11-16 06:40 |
Done for 8580 ms, from 7:06:29.43 to 7:06:38.01.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 448837
MON$OLDEST_ACTIVE 448838
MON$OLDEST_SNAPSHOT 448838
MON$NEXT_TRANSACTION 448838
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:12:20.4040
MON$PAGES 836288
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.3.32837 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32837 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32837 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32837 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Gstat execution time Thu Nov 16 07:06:38 2017
Database header page information:
Flags 0
Generation 449044
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 448839
Oldest active 448840
Oldest snapshot 448840
Next transaction 448841
Sequence number 0
Next attachment ID 9572
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:12:20
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 33.58, 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.24
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: 322, 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: 324, 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: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, 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: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
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: 320, 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: 332, Index root page: 333
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: 336, 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: 337, 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: 335, 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: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.13, total records: 2212272
Average version length: 47.86, total versions: 4100, 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: 15, data page slots: 24048
Data pages: 24048, average fill: 72%
Primary pages: 24048, secondary pages: 0, swept pages: 14246
Empty pages: 6, full pages: 20128
Fill distribution:
0 - 19% = 7
20 - 39% = 8
40 - 59% = 113
60 - 79% = 23918
80 - 99% = 2
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 10785, nodes: 2212272
Average node length: 19.34, total dup: 0, max dup: 0
Average key length: 16.38, compression ratio: 1.65
Average prefix length: 13.62, average data length: 13.38
Clustering factor: 506581, ratio: 0.23
Fill distribution:
0 - 19% = 642
20 - 39% = 2432
40 - 59% = 5199
60 - 79% = 1124
80 - 99% = 1388
Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7966, nodes: 2212272
Average node length: 11.63, total dup: 0, max dup: 0
Average key length: 8.68, compression ratio: 1.04
Average prefix length: 3.32, average data length: 5.68
Clustering factor: 475654, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 3863
40 - 59% = 4033
60 - 79% = 63
80 - 99% = 6
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 176368, depth: 3, leaf buckets: 4003, nodes: 2212272
Average node length: 6.83, total dup: 1606890, max dup: 49
Average key length: 3.88, compression ratio: 2.32
Average prefix length: 7.39, average data length: 1.61
Clustering factor: 465873, ratio: 0.21
Fill distribution:
0 - 19% = 158
20 - 39% = 1382
40 - 59% = 1783
60 - 79% = 165
80 - 99% = 515
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.33, total records: 672941
Average version length: 36.25, total versions: 2030, max versions: 4
Average fragment length: 4.17, total fragments: 6, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8552
Data pages: 8552, average fill: 75%
Primary pages: 8550, secondary pages: 2, swept pages: 7730
Empty pages: 2, full pages: 7587
Fill distribution:
0 - 19% = 7
20 - 39% = 11
40 - 59% = 35
60 - 79% = 8468
80 - 99% = 31
Index DOC_LIST_ID_DESC (1)
Root page: 249265, depth: 3, leaf buckets: 2490, nodes: 672941
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 169231, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 1417
40 - 59% = 1033
60 - 79% = 35
80 - 99% = 4
Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 707, nodes: 672941
Average node length: 4.88, total dup: 672891, max dup: 46364
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 308808, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 603
60 - 79% = 79
80 - 99% = 25
Index PK_DOC_LIST (0)
Root page: 317935, depth: 3, leaf buckets: 2083, nodes: 672941
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 169231, ratio: 0.25
Fill distribution:
0 - 19% = 149
20 - 39% = 687
40 - 59% = 776
60 - 79% = 217
80 - 99% = 254
DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
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: 318, 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: 319, 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: 317, 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: 338, Index root page: 339
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: 340, 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: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 65.65, total records: 400
Average version length: 20.85, total versions: 91836, max versions: 1442
Average fragment length: 18.72, total fragments: 377, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.58
Pointer pages: 1, data page slots: 1632
Data pages: 1632, average fill: 34%
Primary pages: 7, secondary pages: 1625, swept pages: 2
Empty pages: 3, full pages: 4
Fill distribution:
0 - 19% = 3
20 - 39% = 1586
40 - 59% = 38
60 - 79% = 1
80 - 99% = 4
Index PK_INVNT_SALDO (0)
Root page: 282, 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: 292, ratio: 0.73
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 12.23, total records: 19567
Average version length: 71.14, total versions: 16209, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 7.85
Pointer pages: 2, data page slots: 1416
Data pages: 688, average fill: 38%
Primary pages: 685, secondary pages: 3, swept pages: 53
Empty pages: 157, full pages: 120
Fill distribution:
0 - 19% = 244
20 - 39% = 117
40 - 59% = 153
60 - 79% = 87
80 - 99% = 87
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 71, nodes: 19567
Average node length: 13.76, total dup: 909, max dup: 1
Average key length: 11.73, compression ratio: 2.30
Average prefix length: 18.22, average data length: 8.78
Clustering factor: 15102, ratio: 0.77
Fill distribution:
0 - 19% = 0
20 - 39% = 24
40 - 59% = 35
60 - 79% = 11
80 - 99% = 1
MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 14.98, 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.14
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% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 273, 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: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 42.90, total records: 63
Average version length: 45.17, total versions: 6, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.49
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 7%
Primary pages: 16, secondary pages: 0, swept pages: 13
Empty pages: 5, 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: 266924, depth: 2, leaf buckets: 1, nodes: 63
Average node length: 12.52, total dup: 30, max dup: 5
Average key length: 10.89, compression ratio: 1.74
Average prefix length: 10.62, average data length: 8.38
Clustering factor: 44, ratio: 0.70
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
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 MON_LOG_DTS (4)
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_GDSCODE (2)
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
Index MON_LOG_ROWSET_DESC (1)
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
Index MON_LOG_UNIT (3)
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 PK_MON_LOG (0)
Root page: 361, 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: 366, Index root page: 367
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: 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_GDSCODE (2)
Root page: 371, 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: 370, 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: 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
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 369, 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: 239, Index root page: 240
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: 242, 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: 241, 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: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 41.31, total records: 222008
Average version length: 32.94, total versions: 10194, max versions: 7
Average fragment length: 33.00, total fragments: 3, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.55
Pointer pages: 2, data page slots: 2536
Data pages: 2536, average fill: 66%
Primary pages: 2530, secondary pages: 6, swept pages: 880
Empty pages: 10, full pages: 1016
Fill distribution:
0 - 19% = 30
20 - 39% = 105
40 - 59% = 347
60 - 79% = 2030
80 - 99% = 24
Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 208, nodes: 222008
Average node length: 4.53, total dup: 221959, max dup: 11920
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 36617, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 20
40 - 59% = 89
60 - 79% = 77
80 - 99% = 22
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 244, nodes: 222008
Average node length: 5.48, total dup: 200022, max dup: 45
Average key length: 2.96, compression ratio: 7.43
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 47680, ratio: 0.21
Fill distribution:
0 - 19% = 2
20 - 39% = 10
40 - 59% = 108
60 - 79% = 81
80 - 99% = 43
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 246, nodes: 222008
Average node length: 5.48, total dup: 200022, max dup: 45
Average key length: 2.96, compression ratio: 7.43
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 47778, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 14
40 - 59% = 104
60 - 79% = 95
80 - 99% = 32
Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 232, nodes: 222008
Average node length: 5.27, total dup: 200022, max dup: 45
Average key length: 2.75, compression ratio: 3.28
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 47762, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 16
40 - 59% = 99
60 - 79% = 79
80 - 99% = 38
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.97, total records: 285102
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.14
Pointer pages: 2, data page slots: 2440
Data pages: 2440, average fill: 64%
Primary pages: 2440, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 2435
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2435
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 350620, depth: 2, leaf buckets: 228, nodes: 285102
Average node length: 4.55, total dup: 284921, max dup: 2882
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 61883, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 92
60 - 79% = 62
80 - 99% = 73
PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
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: 346, 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: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.57, total records: 11662296
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.19
Pointer pages: 170, data page slots: 276424
Data pages: 276424, average fill: 87%
Primary pages: 276424, secondary pages: 0, swept pages: 3
Empty pages: 2, full pages: 276421
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 276421
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 12898, nodes: 11662296
Average node length: 5.66, total dup: 10808656, max dup: 152
Average key length: 2.18, compression ratio: 3.67
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 4711057, ratio: 0.40
Fill distribution:
0 - 19% = 11
20 - 39% = 0
40 - 59% = 6652
60 - 79% = 4180
80 - 99% = 2055
Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 11538, nodes: 11662296
Average node length: 4.56, total dup: 11662292, max dup: 10750792
Average key length: 1.08, compression ratio: 0.36
Average prefix length: 0.39, average data length: 0.00
Clustering factor: 347904, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 11534
60 - 79% = 0
80 - 99% = 3
Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 14005, nodes: 11662296
Average node length: 5.73, total dup: 11281616, max dup: 26498
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 1064908, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 10022
60 - 79% = 2162
80 - 99% = 1818
Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 14197, nodes: 11662296
Average node length: 5.56, total dup: 11633200, max dup: 1492711
Average key length: 2.07, compression ratio: 18.23
Average prefix length: 37.70, average data length: 0.07
Clustering factor: 6840949, ratio: 0.59
Fill distribution:
0 - 19% = 21
20 - 39% = 2
40 - 59% = 12193
60 - 79% = 681
80 - 99% = 1300
PHRASES (145)
Primary pointer page: 266, Index root page: 267
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: 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
Index PHRASES_NAME (2)
Root page: 279, 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: 278, 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: 277, 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: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.86, total records: 471591
Average version length: 56.12, total versions: 2315, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 4, data page slots: 5584
Data pages: 5584, average fill: 75%
Primary pages: 5584, secondary pages: 0, swept pages: 3331
Empty pages: 2, full pages: 5410
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 8
60 - 79% = 5564
80 - 99% = 7
Index PSTORNED_RCV_ID (2)
Root page: 616239, depth: 3, leaf buckets: 629, nodes: 471591
Average node length: 5.95, total dup: 396957, max dup: 953
Average key length: 3.15, compression ratio: 2.86
Average prefix length: 8.01, average data length: 0.99
Clustering factor: 62841, ratio: 0.13
Fill distribution:
0 - 19% = 16
20 - 39% = 32
40 - 59% = 374
60 - 79% = 163
80 - 99% = 44
Index PSTORNED_SND_ID (1)
Root page: 799842, depth: 3, leaf buckets: 504, nodes: 471591
Average node length: 5.60, total dup: 420918, max dup: 106
Average key length: 2.80, compression ratio: 3.21
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 117043, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 205
60 - 79% = 190
80 - 99% = 95
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
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: 308, 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: 243, Index root page: 244
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: 246, 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: 245, 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: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 2295, max versions: 1627
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: 16
Data pages: 16, average fill: 46%
Primary pages: 7, secondary pages: 9, swept pages: 0
Empty pages: 7, full pages: 8
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 7
Index PK_SEMAPHORES (0)
Root page: 327, 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: 328, 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: 236, Index root page: 237
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: 238, 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: 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$AUTOGEN$SOURCE (135)
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$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
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: 200, 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: 207, Index root page: 224
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: 226, 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: 227, Index root page: 228
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: 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$PERF_LOG (164)
Primary pointer page: 352, Index root page: 353
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: 360, 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: 205, Index root page: 206
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: 201, Index root page: 202
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: 204, 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: 203, 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: 193, Index root page: 194
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: 197, 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: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 57.86, total records: 2696
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.50
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 62%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 32
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 1
60 - 79% = 32
80 - 99% = 0
WARES (144)
Primary pointer page: 264, Index root page: 265
Total formats: 1, used formats: 1
Average record length: 78.23, 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.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 78%
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: 377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 67
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, 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: 274, 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: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 276, 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: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.86, total dup: 0, max dup: 0
Average key length: 51.84, compression ratio: 1.00
Average prefix length: 2.73, average data length: 48.86
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
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: 325, 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: 326, 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: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 12.91, total records: 27347
Average version length: 72.18, total versions: 22453, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 10.53
Pointer pages: 2, data page slots: 1632
Data pages: 552, average fill: 63%
Primary pages: 551, secondary pages: 1, swept pages: 51
Empty pages: 84, full pages: 328
Fill distribution:
0 - 19% = 107
20 - 39% = 34
40 - 59% = 51
60 - 79% = 90
80 - 99% = 270
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 41, nodes: 27347
Average node length: 6.19, total dup: 23917, max dup: 14
Average key length: 3.62, compression ratio: 10.23
Average prefix length: 35.51, average data length: 1.49
Clustering factor: 4256, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 20
60 - 79% = 10
80 - 99% = 3
XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.05, total records: 1272881
Average version length: 71.79, total versions: 19691, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.91
Pointer pages: 12, data page slots: 18632
Data pages: 18632, average fill: 75%
Primary pages: 18632, secondary pages: 0, swept pages: 7801
Empty pages: 41, full pages: 16729
Fill distribution:
0 - 19% = 117
20 - 39% = 152
40 - 59% = 426
60 - 79% = 17591
80 - 99% = 346
Index XQD_1000_3300_DOC (1)
Root page: 373062, depth: 3, leaf buckets: 1506, nodes: 1272881
Average node length: 5.14, total dup: 1239237, max dup: 131
Average key length: 2.20, compression ratio: 4.10
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 146542, ratio: 0.12
Fill distribution:
0 - 19% = 22
20 - 39% = 108
40 - 59% = 1138
60 - 79% = 72
80 - 99% = 166
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 236266, depth: 3, leaf buckets: 1805, nodes: 1272881
Average node length: 6.26, total dup: 1111658, max dup: 22
Average key length: 3.32, compression ratio: 11.16
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 246293, ratio: 0.19
Fill distribution:
0 - 19% = 32
20 - 39% = 155
40 - 59% = 1313
60 - 79% = 131
80 - 99% = 174
XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 26.80, total records: 75579
Average version length: 71.91, total versions: 47513, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 5.07
Pointer pages: 4, data page slots: 4144
Data pages: 2096, average fill: 45%
Primary pages: 2096, secondary pages: 0, swept pages: 183
Empty pages: 423, full pages: 636
Fill distribution:
0 - 19% = 636
20 - 39% = 300
40 - 59% = 333
60 - 79% = 327
80 - 99% = 500
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 747796, depth: 3, leaf buckets: 130, nodes: 75579
Average node length: 5.80, total dup: 66558, max dup: 48
Average key length: 3.40, compression ratio: 10.88
Average prefix length: 35.72, average data length: 1.28
Clustering factor: 9953, ratio: 0.13
Fill distribution:
0 - 19% = 3
20 - 39% = 68
40 - 59% = 42
60 - 79% = 13
80 - 99% = 4
XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 68.21, total records: 1793917
Average version length: 71.91, total versions: 98875, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.99
Pointer pages: 18, data page slots: 27784
Data pages: 27768, average fill: 72%
Primary pages: 27767, secondary pages: 1, swept pages: 11777
Empty pages: 202, full pages: 20581
Fill distribution:
0 - 19% = 477
20 - 39% = 867
40 - 59% = 2399
60 - 79% = 21882
80 - 99% = 2143
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 198687, depth: 3, leaf buckets: 2780, nodes: 1793917
Average node length: 5.61, total dup: 1686938, max dup: 70
Average key length: 2.65, compression ratio: 13.95
Average prefix length: 36.41, average data length: 0.59
Clustering factor: 244816, ratio: 0.14
Fill distribution:
0 - 19% = 11
20 - 39% = 1223
40 - 59% = 1139
60 - 79% = 226
80 - 99% = 181
XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 5.88, total records: 32545
Average version length: 71.73, total versions: 29832, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 23.11
Pointer pages: 4, data page slots: 2824
Data pages: 1086, average fill: 40%
Primary pages: 1085, secondary pages: 1, swept pages: 106
Empty pages: 271, full pages: 263
Fill distribution:
0 - 19% = 410
20 - 39% = 158
40 - 59% = 178
60 - 79% = 133
80 - 99% = 207
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 57, nodes: 32545
Average node length: 5.42, total dup: 29353, max dup: 73
Average key length: 3.39, compression ratio: 10.92
Average prefix length: 35.71, average data length: 1.29
Clustering factor: 3994, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 38
40 - 59% = 13
60 - 79% = 6
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 70.53, total records: 2826059
Average version length: 71.71, total versions: 42320, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.93
Pointer pages: 25, data page slots: 40352
Data pages: 40352, average fill: 76%
Primary pages: 40352, secondary pages: 0, swept pages: 24392
Empty pages: 13, full pages: 37110
Fill distribution:
0 - 19% = 29
20 - 39% = 56
40 - 59% = 456
60 - 79% = 38735
80 - 99% = 1076
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5760, nodes: 2826059
Average node length: 6.87, total dup: 2289570, max dup: 15
Average key length: 3.90, compression ratio: 9.50
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 560221, ratio: 0.20
Fill distribution:
0 - 19% = 8
20 - 39% = 2960
40 - 59% = 2330
60 - 79% = 278
80 - 99% = 184
XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.84, total records: 4888796
Average version length: 84.86, total versions: 4459, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 47, data page slots: 75112
Data pages: 75112, average fill: 80%
Primary pages: 75112, secondary pages: 0, swept pages: 27755
Empty pages: 0, full pages: 75061
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 5
60 - 79% = 21014
80 - 99% = 54091
Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4981, nodes: 4888796
Average node length: 5.16, total dup: 4777343, max dup: 131
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 794103, ratio: 0.16
Fill distribution:
0 - 19% = 21
20 - 39% = 89
40 - 59% = 2177
60 - 79% = 2083
80 - 99% = 611
Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 5622, nodes: 4888796
Average node length: 5.69, total dup: 4378658, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 284577, ratio: 0.06
Fill distribution:
0 - 19% = 62
20 - 39% = 208
40 - 59% = 3541
60 - 79% = 258
80 - 99% = 1553
Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5555, nodes: 4888796
Average node length: 5.81, total dup: 4277784, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 851482, ratio: 0.17
Fill distribution:
0 - 19% = 24
20 - 39% = 90
40 - 59% = 2479
60 - 79% = 2100
80 - 99% = 862
XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 82.50, total records: 2454485
Average version length: 84.39, total versions: 27787, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 24, data page slots: 38344
Data pages: 38344, average fill: 79%
Primary pages: 38344, secondary pages: 0, swept pages: 24982
Empty pages: 11, full pages: 36937
Fill distribution:
0 - 19% = 24
20 - 39% = 55
40 - 59% = 284
60 - 79% = 15999
80 - 99% = 21982
Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2639, nodes: 2454485
Average node length: 5.15, total dup: 2397208, max dup: 161
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 387516, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 54
40 - 59% = 1572
60 - 79% = 754
80 - 99% = 257
Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 4302, nodes: 2454485
Average node length: 6.22, total dup: 2013865, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 260708, ratio: 0.11
Fill distribution:
0 - 19% = 110
20 - 39% = 1809
40 - 59% = 1736
60 - 79% = 445
80 - 99% = 202
Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2996, nodes: 2454485
Average node length: 5.81, total dup: 2148069, max dup: 41
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 463654, ratio: 0.19
Fill distribution:
0 - 19% = 32
20 - 39% = 45
40 - 59% = 1830
60 - 79% = 779
80 - 99% = 310
XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.35, total records: 5188403
Average version length: 85.30, total versions: 41520, 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: 50, data page slots: 80832
Data pages: 80824, average fill: 80%
Primary pages: 80824, secondary pages: 0, swept pages: 23819
Empty pages: 119, full pages: 77033
Fill distribution:
0 - 19% = 203
20 - 39% = 279
40 - 59% = 1039
60 - 79% = 18573
80 - 99% = 60730
Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5570, nodes: 5188403
Average node length: 5.04, total dup: 5157983, max dup: 664
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 802723, ratio: 0.15
Fill distribution:
0 - 19% = 8
20 - 39% = 309
40 - 59% = 3242
60 - 79% = 1493
80 - 99% = 518
Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6460, nodes: 5188403
Average node length: 5.53, total dup: 4781495, max dup: 49
Average key length: 2.54, compression ratio: 3.55
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 325127, ratio: 0.06
Fill distribution:
0 - 19% = 73
20 - 39% = 1789
40 - 59% = 2701
60 - 79% = 624
80 - 99% = 1273
Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 6256, nodes: 5188403
Average node length: 5.68, total dup: 4658269, max dup: 86
Average key length: 2.69, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 884033, ratio: 0.17
Fill distribution:
0 - 19% = 6
20 - 39% = 266
40 - 59% = 3714
60 - 79% = 1673
80 - 99% = 597
XQS_2000_3300 (269)
Primary pointer page: 761, Index root page: 762
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: 763, 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: 765, 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: 764, 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: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 82.90, total records: 3484363
Average version length: 84.81, total versions: 35235, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 34, data page slots: 54544
Data pages: 54544, average fill: 79%
Primary pages: 54544, secondary pages: 0, swept pages: 35340
Empty pages: 14, full pages: 52281
Fill distribution:
0 - 19% = 34
20 - 39% = 62
40 - 59% = 342
60 - 79% = 22238
80 - 99% = 31868
Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3821, nodes: 3484363
Average node length: 5.03, total dup: 3467033, max dup: 1621
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 750327, ratio: 0.22
Fill distribution:
0 - 19% = 22
20 - 39% = 400
40 - 59% = 2110
60 - 79% = 869
80 - 99% = 420
Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 6250, nodes: 3484363
Average node length: 6.24, total dup: 2852646, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 422399, ratio: 0.12
Fill distribution:
0 - 19% = 231
20 - 39% = 2715
40 - 59% = 2416
60 - 79% = 570
80 - 99% = 318
Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 4120, nodes: 3484363
Average node length: 5.59, total dup: 3177992, max dup: 99
Average key length: 2.61, compression ratio: 3.45
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 792896, ratio: 0.23
Fill distribution:
0 - 19% = 11
20 - 39% = 332
40 - 59% = 2125
60 - 79% = 1178
80 - 99% = 474
XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.19, total records: 668852
Average version length: 70.32, total versions: 3463, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 9160
Data pages: 9160, average fill: 78%
Primary pages: 9160, secondary pages: 0, swept pages: 6339
Empty pages: 6, full pages: 9153
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 9061
80 - 99% = 93
Index XQS_3300_3400_DOC_ID (0)
Root page: 176651, depth: 3, leaf buckets: 822, nodes: 668852
Average node length: 5.32, total dup: 630226, max dup: 118
Average key length: 2.44, compression ratio: 3.69
Average prefix length: 8.62, average data length: 0.38
Clustering factor: 57458, ratio: 0.09
Fill distribution:
0 - 19% = 4
20 - 39% = 195
40 - 59% = 353
60 - 79% = 194
80 - 99% = 76
Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 898, nodes: 668852
Average node length: 5.93, total dup: 571416, max dup: 25
Average key length: 3.05, compression ratio: 2.95
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 63218, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 206
40 - 59% = 368
60 - 79% = 221
80 - 99% = 101
ZDOC_DATA (230)
Primary pointer page: 644, Index root page: 645
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: 642, Index root page: 643
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: 646, Index root page: 647
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: 652, Index root page: 653
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: 662, 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: 654, Index root page: 655
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: 663, 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: 648, Index root page: 649
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: 656, 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: 657, 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: 650, Index root page: 651
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: 659, 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: 658, 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: 661, 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: 660, 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: 640, Index root page: 641
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: 614, Index root page: 615
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: 268, Index root page: 269
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: 281, 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 Thu Nov 16 07:07:28 2017
Done for 50190 ms, from 7:06:38.40 to 7:07:28.59.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2212272 |
4100 |
0.1853 |
DOC_LIST |
672941 |
2030 |
0.3016 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
91836 |
22959.0000 |
INVNT_TURNOVER_LOG |
19567 |
16209 |
82.8384 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
63 |
6 |
9.5238 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
222008 |
10194 |
4.5917 |
PERF_ESTIMATED |
285102 |
0 |
0.0000 |
PERF_LOG |
11662296 |
0 |
0.0000 |
PSTORNED |
471591 |
2315 |
0.4908 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
2295 |
57375.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2696 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
27347 |
22453 |
82.1040 |
XQD_1000_3300 |
1272881 |
19691 |
1.5469 |
XQD_1200_2000 |
75579 |
47513 |
62.8653 |
XQD_2000_3300 |
1793917 |
98875 |
5.5116 |
XQD_2100_3300 |
32545 |
29832 |
91.6638 |
XQD_3300_3400 |
2826059 |
42320 |
1.4974 |
XQS_1000_1200 |
4888796 |
4459 |
0.0912 |
XQS_1000_3300 |
2454485 |
27787 |
1.1320 |
XQS_1200_2000 |
5188403 |
41520 |
0.8002 |
XQS_2100_3300 |
3484363 |
35235 |
1.0112 |
XQS_3300_3400 |
668852 |
3463 |
0.5177 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2070 ms, from 7:07:39.32 to 7:07:41.39.
07:07:41.49 Validation started
07:07:41.50 Relation 140 (DOC_LIST)
07:07:41.50 process pointer page 0 of 6
07:07:41.63 process pointer page 1 of 6
07:07:41.75 process pointer page 2 of 6
07:07:41.80 process pointer page 3 of 6
07:07:41.85 process pointer page 4 of 6
07:07:41.89 process pointer page 5 of 6
07:07:41.89 Index 1 (PK_DOC_LIST)
07:07:42.00 Index 2 (DOC_LIST_ID_DESC)
07:07:42.17 Index 3 (FK_DOC_LIST_AGENTS)
07:07:42.39 Relation 140 (DOC_LIST) is ok
07:07:42.39 Relation 141 (DOC_DATA)
07:07:42.39 process pointer page 0 of 15
07:07:42.49 process pointer page 1 of 15
07:07:42.59 process pointer page 2 of 15
07:07:42.70 process pointer page 3 of 15
07:07:42.80 process pointer page 4 of 15
07:07:42.84 process pointer page 5 of 15
07:07:42.92 process pointer page 6 of 15
07:07:43.03 process pointer page 7 of 15
07:07:43.13 process pointer page 8 of 15
07:07:43.22 process pointer page 9 of 15
07:07:43.31 process pointer page 10 of 15
07:07:43.37 process pointer page 11 of 15
07:07:43.42 process pointer page 12 of 15
07:07:43.45 process pointer page 13 of 15
07:07:43.50 process pointer page 14 of 15
07:07:43.52 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:07:44.01 Index 3 (DOC_DATA_ID_DESC)
07:07:44.78 Index 4 (FK_DOC_DATA_DOC_LIST)
07:07:45.25 Relation 141 (DOC_DATA) is ok
07:07:45.25 Relation 147 (INVNT_SALDO)
07:07:45.25 process pointer page 0 of 1
07:07:45.51 Index 1 (PK_INVNT_SALDO)
07:07:45.51 Relation 147 (INVNT_SALDO) is ok
07:07:45.51 Relation 150 (PDISTR)
07:07:45.51 process pointer page 0 of 2
07:07:45.64 process pointer page 1 of 2
07:07:45.68 Index 2 (PDISTR_SND_ID)
07:07:45.76 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:07:45.84 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:07:45.89 Index 5 (PDISTR_AGENT_ID)
07:07:45.90 Relation 150 (PDISTR) is ok
07:07:45.90 Relation 151 (PSTORNED)
07:07:45.90 process pointer page 0 of 4
07:07:45.95 process pointer page 1 of 4
07:07:46.04 process pointer page 2 of 4
07:07:46.15 process pointer page 3 of 4
07:07:46.20 Index 2 (PSTORNED_SND_ID)
07:07:46.32 Index 3 (PSTORNED_RCV_ID)
07:07:46.39 Relation 151 (PSTORNED) is ok
07:07:46.39 Relation 156 (SEMAPHORES)
07:07:46.39 process pointer page 0 of 1
07:07:46.39 Index 1 (PK_SEMAPHORES)
07:07:46.39 Index 2 (SEMAPHORES_TASK_UNQ)
07:07:46.39 Relation 156 (SEMAPHORES) is ok
07:07:46.39 Relation 157 (INVNT_TURNOVER_LOG)
07:07:46.39 process pointer page 0 of 2
07:07:46.42 process pointer page 1 of 2
07:07:46.42 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:07:46.42 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:07:46.42 Relation 160 (PERF_ESTIMATED)
07:07:46.42 process pointer page 0 of 2
07:07:46.46 process pointer page 1 of 2
07:07:46.48 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:07:46.49 Relation 160 (PERF_ESTIMATED) is ok
07:07:46.49 Relation 161 (PERF_ISQL_STAT)
07:07:46.49 process pointer page 0 of 1
07:07:46.49 Index 1 (PERF_ISQL_STAT_TRN)
07:07:46.49 Relation 161 (PERF_ISQL_STAT) is ok
07:07:46.49 Relation 162 (TRACE_STAT)
07:07:46.49 process pointer page 0 of 1
07:07:46.51 Relation 162 (TRACE_STAT) is ok
07:07:46.51 Relation 163 (PERF_LOG)
07:07:46.51 process pointer page 0 of 170
07:07:46.54 process pointer page 1 of 170
07:07:46.57 process pointer page 2 of 170
07:07:46.60 process pointer page 3 of 170
07:07:46.64 process pointer page 4 of 170
07:07:46.67 process pointer page 5 of 170
07:07:46.70 process pointer page 6 of 170
07:07:46.71 process pointer page 7 of 170
07:07:46.74 process pointer page 8 of 170
07:07:46.78 process pointer page 9 of 170
07:07:46.81 process pointer page 10 of 170
07:07:46.84 process pointer page 11 of 170
07:07:46.85 process pointer page 12 of 170
07:07:46.88 process pointer page 13 of 170
07:07:46.92 process pointer page 14 of 170
07:07:46.95 process pointer page 15 of 170
07:07:46.96 process pointer page 16 of 170
07:07:46.99 process pointer page 17 of 170
07:07:47.03 process pointer page 18 of 170
07:07:47.04 process pointer page 19 of 170
07:07:47.07 process pointer page 20 of 170
07:07:47.10 process pointer page 21 of 170
07:07:47.12 process pointer page 22 of 170
07:07:47.15 process pointer page 23 of 170
07:07:47.18 process pointer page 24 of 170
07:07:47.20 process pointer page 25 of 170
07:07:47.23 process pointer page 26 of 170
07:07:47.26 process pointer page 27 of 170
07:07:47.27 process pointer page 28 of 170
07:07:47.31 process pointer page 29 of 170
07:07:47.32 process pointer page 30 of 170
07:07:47.35 process pointer page 31 of 170
07:07:47.38 process pointer page 32 of 170
07:07:47.40 process pointer page 33 of 170
07:07:47.43 process pointer page 34 of 170
07:07:47.45 process pointer page 35 of 170
07:07:47.48 process pointer page 36 of 170
07:07:47.51 process pointer page 37 of 170
07:07:47.54 process pointer page 38 of 170
07:07:47.57 process pointer page 39 of 170
07:07:47.62 process pointer page 40 of 170
07:07:47.65 process pointer page 41 of 170
07:07:47.68 process pointer page 42 of 170
07:07:47.71 process pointer page 43 of 170
07:07:47.74 process pointer page 44 of 170
07:07:47.77 process pointer page 45 of 170
07:07:47.81 process pointer page 46 of 170
07:07:47.82 process pointer page 47 of 170
07:07:47.85 process pointer page 48 of 170
07:07:47.91 process pointer page 49 of 170
07:07:47.98 process pointer page 50 of 170
07:07:48.01 process pointer page 51 of 170
07:07:48.04 process pointer page 52 of 170
07:07:48.09 process pointer page 53 of 170
07:07:48.12 process pointer page 54 of 170
07:07:48.21 process pointer page 55 of 170
07:07:48.24 process pointer page 56 of 170
07:07:48.27 process pointer page 57 of 170
07:07:48.32 process pointer page 58 of 170
07:07:48.35 process pointer page 59 of 170
07:07:48.43 process pointer page 60 of 170
07:07:48.48 process pointer page 61 of 170
07:07:48.51 process pointer page 62 of 170
07:07:48.60 process pointer page 63 of 170
07:07:48.66 process pointer page 64 of 170
07:07:48.71 process pointer page 65 of 170
07:07:48.74 process pointer page 66 of 170
07:07:48.77 process pointer page 67 of 170
07:07:48.80 process pointer page 68 of 170
07:07:48.83 process pointer page 69 of 170
07:07:48.87 process pointer page 70 of 170
07:07:48.90 process pointer page 71 of 170
07:07:48.93 process pointer page 72 of 170
07:07:48.96 process pointer page 73 of 170
07:07:48.99 process pointer page 74 of 170
07:07:49.01 process pointer page 75 of 170
07:07:49.04 process pointer page 76 of 170
07:07:49.07 process pointer page 77 of 170
07:07:49.08 process pointer page 78 of 170
07:07:49.12 process pointer page 79 of 170
07:07:49.15 process pointer page 80 of 170
07:07:49.18 process pointer page 81 of 170
07:07:49.21 process pointer page 82 of 170
07:07:49.24 process pointer page 83 of 170
07:07:49.27 process pointer page 84 of 170
07:07:49.30 process pointer page 85 of 170
07:07:49.33 process pointer page 86 of 170
07:07:49.37 process pointer page 87 of 170
07:07:49.40 process pointer page 88 of 170
07:07:49.43 process pointer page 89 of 170
07:07:49.44 process pointer page 90 of 170
07:07:49.47 process pointer page 91 of 170
07:07:49.51 process pointer page 92 of 170
07:07:49.52 process pointer page 93 of 170
07:07:49.55 process pointer page 94 of 170
07:07:49.58 process pointer page 95 of 170
07:07:49.60 process pointer page 96 of 170
07:07:49.63 process pointer page 97 of 170
07:07:49.65 process pointer page 98 of 170
07:07:49.68 process pointer page 99 of 170
07:07:49.72 process pointer page 100 of 170
07:07:49.76 process pointer page 101 of 170
07:07:49.82 process pointer page 102 of 170
07:07:49.91 process pointer page 103 of 170
07:07:50.00 process pointer page 104 of 170
07:07:50.04 process pointer page 105 of 170
07:07:50.08 process pointer page 106 of 170
07:07:50.11 process pointer page 107 of 170
07:07:50.15 process pointer page 108 of 170
07:07:50.24 process pointer page 109 of 170
07:07:50.32 process pointer page 110 of 170
07:07:50.41 process pointer page 111 of 170
07:07:50.50 process pointer page 112 of 170
07:07:50.57 process pointer page 113 of 170
07:07:50.61 process pointer page 114 of 170
07:07:50.69 process pointer page 115 of 170
07:07:50.78 process pointer page 116 of 170
07:07:50.88 process pointer page 117 of 170
07:07:50.96 process pointer page 118 of 170
07:07:51.05 process pointer page 119 of 170
07:07:51.13 process pointer page 120 of 170
07:07:51.16 process pointer page 121 of 170
07:07:51.19 process pointer page 122 of 170
07:07:51.25 process pointer page 123 of 170
07:07:51.33 process pointer page 124 of 170
07:07:51.42 process pointer page 125 of 170
07:07:51.52 process pointer page 126 of 170
07:07:51.61 process pointer page 127 of 170
07:07:51.69 process pointer page 128 of 170
07:07:51.77 process pointer page 129 of 170
07:07:51.80 process pointer page 130 of 170
07:07:51.85 process pointer page 131 of 170
07:07:51.91 process pointer page 132 of 170
07:07:52.00 process pointer page 133 of 170
07:07:52.10 process pointer page 134 of 170
07:07:52.19 process pointer page 135 of 170
07:07:52.24 process pointer page 136 of 170
07:07:52.30 process pointer page 137 of 170
07:07:52.38 process pointer page 138 of 170
07:07:52.44 process pointer page 139 of 170
07:07:52.47 process pointer page 140 of 170
07:07:52.50 process pointer page 141 of 170
07:07:52.55 process pointer page 142 of 170
07:07:52.58 process pointer page 143 of 170
07:07:52.61 process pointer page 144 of 170
07:07:52.69 process pointer page 145 of 170
07:07:52.73 process pointer page 146 of 170
07:07:52.80 process pointer page 147 of 170
07:07:52.84 process pointer page 148 of 170
07:07:52.88 process pointer page 149 of 170
07:07:52.91 process pointer page 150 of 170
07:07:52.95 process pointer page 151 of 170
07:07:53.02 process pointer page 152 of 170
07:07:53.11 process pointer page 153 of 170
07:07:53.19 process pointer page 154 of 170
07:07:53.28 process pointer page 155 of 170
07:07:53.37 process pointer page 156 of 170
07:07:53.47 process pointer page 157 of 170
07:07:53.53 process pointer page 158 of 170
07:07:53.56 process pointer page 159 of 170
07:07:53.59 process pointer page 160 of 170
07:07:53.69 process pointer page 161 of 170
07:07:53.76 process pointer page 162 of 170
07:07:53.86 process pointer page 163 of 170
07:07:53.95 process pointer page 164 of 170
07:07:54.05 process pointer page 165 of 170
07:07:54.08 process pointer page 166 of 170
07:07:54.12 process pointer page 167 of 170
07:07:54.22 process pointer page 168 of 170
07:07:54.29 process pointer page 169 of 170
07:07:54.31 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:07:57.09 Index 2 (PERF_LOG_UNIT)
07:07:59.71 Index 3 (PERF_LOG_TRN_DESC)
07:08:01.92 Index 4 (PERF_LOG_GDSCODE)
07:08:03.09 Relation 163 (PERF_LOG) is ok
07:08:03.09 Relation 167 (V_STOPTEST)
07:08:03.09 Relation 167 (V_STOPTEST) is ok
07:08:03.09 Relation 184 (V_QDISTR_SOURCE)
07:08:03.09 Relation 184 (V_QDISTR_SOURCE) is ok
07:08:03.09 Relation 185 (V_QSTORNED_SOURCE)
07:08:03.09 Relation 185 (V_QSTORNED_SOURCE) is ok
07:08:03.09 Relation 260 (XQD_1000_1200)
07:08:03.09 process pointer page 0 of 2
07:08:03.09 process pointer page 1 of 2
07:08:03.14 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:08:03.16 Relation 260 (XQD_1000_1200) is ok
07:08:03.16 Relation 261 (XQD_1200_2000)
07:08:03.16 process pointer page 0 of 4
07:08:03.26 process pointer page 1 of 4
07:08:03.31 process pointer page 2 of 4
07:08:03.33 process pointer page 3 of 4
07:08:03.33 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:08:03.34 Relation 261 (XQD_1200_2000) is ok
07:08:03.34 Relation 262 (XQD_1000_3300)
07:08:03.34 process pointer page 0 of 12
07:08:03.45 process pointer page 1 of 12
07:08:03.53 process pointer page 2 of 12
07:08:03.59 process pointer page 3 of 12
07:08:03.64 process pointer page 4 of 12
07:08:03.69 process pointer page 5 of 12
07:08:03.75 process pointer page 6 of 12
07:08:03.84 process pointer page 7 of 12
07:08:03.95 process pointer page 8 of 12
07:08:04.00 process pointer page 9 of 12
07:08:04.06 process pointer page 10 of 12
07:08:04.11 process pointer page 11 of 12
07:08:04.12 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:08:04.37 Index 2 (XQD_1000_3300_DOC)
07:08:04.70 Relation 262 (XQD_1000_3300) is ok
07:08:04.70 Relation 263 (XQD_2000_3300)
07:08:04.70 process pointer page 0 of 18
07:08:04.76 process pointer page 1 of 18
07:08:04.81 process pointer page 2 of 18
07:08:04.86 process pointer page 3 of 18
07:08:04.90 process pointer page 4 of 18
07:08:04.93 process pointer page 5 of 18
07:08:05.00 process pointer page 6 of 18
07:08:05.11 process pointer page 7 of 18
07:08:05.21 process pointer page 8 of 18
07:08:05.32 process pointer page 9 of 18
07:08:05.42 process pointer page 10 of 18
07:08:05.53 process pointer page 11 of 18
07:08:05.62 process pointer page 12 of 18
07:08:05.68 process pointer page 13 of 18
07:08:05.73 process pointer page 14 of 18
07:08:05.79 process pointer page 15 of 18
07:08:05.89 process pointer page 16 of 18
07:08:05.99 process pointer page 17 of 18
07:08:05.99 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:08:06.62 Relation 263 (XQD_2000_3300) is ok
07:08:06.62 Relation 264 (XQD_2100_3300)
07:08:06.62 process pointer page 0 of 4
07:08:06.65 process pointer page 1 of 4
07:08:06.65 process pointer page 2 of 4
07:08:06.65 process pointer page 3 of 4
07:08:06.65 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:08:06.67 Relation 264 (XQD_2100_3300) is ok
07:08:06.67 Relation 265 (XQD_3300_3400)
07:08:06.67 process pointer page 0 of 25
07:08:06.70 process pointer page 1 of 25
07:08:06.81 process pointer page 2 of 25
07:08:06.90 process pointer page 3 of 25
07:08:07.01 process pointer page 4 of 25
07:08:07.04 process pointer page 5 of 25
07:08:07.10 process pointer page 6 of 25
07:08:07.15 process pointer page 7 of 25
07:08:07.21 process pointer page 8 of 25
07:08:07.26 process pointer page 9 of 25
07:08:07.29 process pointer page 10 of 25
07:08:07.34 process pointer page 11 of 25
07:08:07.37 process pointer page 12 of 25
07:08:07.40 process pointer page 13 of 25
07:08:07.45 process pointer page 14 of 25
07:08:07.48 process pointer page 15 of 25
07:08:07.52 process pointer page 16 of 25
07:08:07.62 process pointer page 17 of 25
07:08:07.73 process pointer page 18 of 25
07:08:07.82 process pointer page 19 of 25
07:08:07.85 process pointer page 20 of 25
07:08:07.90 process pointer page 21 of 25
07:08:07.94 process pointer page 22 of 25
07:08:07.98 process pointer page 23 of 25
07:08:08.01 process pointer page 24 of 25
07:08:08.04 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:08:08.41 Relation 265 (XQD_3300_3400) is ok
07:08:08.41 Relation 266 (XQS_1000_1200)
07:08:08.41 process pointer page 0 of 47
07:08:08.44 process pointer page 1 of 47
07:08:08.48 process pointer page 2 of 47
07:08:08.51 process pointer page 3 of 47
07:08:08.54 process pointer page 4 of 47
07:08:08.57 process pointer page 5 of 47
07:08:08.60 process pointer page 6 of 47
07:08:08.63 process pointer page 7 of 47
07:08:08.66 process pointer page 8 of 47
07:08:08.69 process pointer page 9 of 47
07:08:08.71 process pointer page 10 of 47
07:08:08.74 process pointer page 11 of 47
07:08:08.77 process pointer page 12 of 47
07:08:08.80 process pointer page 13 of 47
07:08:08.83 process pointer page 14 of 47
07:08:08.87 process pointer page 15 of 47
07:08:08.91 process pointer page 16 of 47
07:08:08.94 process pointer page 17 of 47
07:08:09.02 process pointer page 18 of 47
07:08:09.07 process pointer page 19 of 47
07:08:09.18 process pointer page 20 of 47
07:08:09.27 process pointer page 21 of 47
07:08:09.38 process pointer page 22 of 47
07:08:09.46 process pointer page 23 of 47
07:08:09.50 process pointer page 24 of 47
07:08:09.54 process pointer page 25 of 47
07:08:09.61 process pointer page 26 of 47
07:08:09.71 process pointer page 27 of 47
07:08:09.82 process pointer page 28 of 47
07:08:09.91 process pointer page 29 of 47
07:08:09.99 process pointer page 30 of 47
07:08:10.02 process pointer page 31 of 47
07:08:10.07 process pointer page 32 of 47
07:08:10.10 process pointer page 33 of 47
07:08:10.14 process pointer page 34 of 47
07:08:10.18 process pointer page 35 of 47
07:08:10.22 process pointer page 36 of 47
07:08:10.25 process pointer page 37 of 47
07:08:10.28 process pointer page 38 of 47
07:08:10.32 process pointer page 39 of 47
07:08:10.35 process pointer page 40 of 47
07:08:10.38 process pointer page 41 of 47
07:08:10.41 process pointer page 42 of 47
07:08:10.44 process pointer page 43 of 47
07:08:10.46 process pointer page 44 of 47
07:08:10.49 process pointer page 45 of 47
07:08:10.52 process pointer page 46 of 47
07:08:10.52 Index 1 (XQS_1000_1200_DOC_ID)
07:08:11.06 Index 2 (XQS_1000_1200_SND_ID)
07:08:11.47 Index 3 (XQS_1000_1200_RCV_ID)
07:08:11.83 Relation 266 (XQS_1000_1200) is ok
07:08:11.83 Relation 267 (XQS_1200_2000)
07:08:11.83 process pointer page 0 of 50
07:08:11.86 process pointer page 1 of 50
07:08:11.89 process pointer page 2 of 50
07:08:11.92 process pointer page 3 of 50
07:08:11.95 process pointer page 4 of 50
07:08:11.99 process pointer page 5 of 50
07:08:12.02 process pointer page 6 of 50
07:08:12.03 process pointer page 7 of 50
07:08:12.06 process pointer page 8 of 50
07:08:12.09 process pointer page 9 of 50
07:08:12.20 process pointer page 10 of 50
07:08:12.31 process pointer page 11 of 50
07:08:12.34 process pointer page 12 of 50
07:08:12.39 process pointer page 13 of 50
07:08:12.42 process pointer page 14 of 50
07:08:12.47 process pointer page 15 of 50
07:08:12.50 process pointer page 16 of 50
07:08:12.58 process pointer page 17 of 50
07:08:12.63 process pointer page 18 of 50
07:08:12.67 process pointer page 19 of 50
07:08:12.72 process pointer page 20 of 50
07:08:12.81 process pointer page 21 of 50
07:08:12.84 process pointer page 22 of 50
07:08:12.89 process pointer page 23 of 50
07:08:12.94 process pointer page 24 of 50
07:08:12.97 process pointer page 25 of 50
07:08:13.00 process pointer page 26 of 50
07:08:13.03 process pointer page 27 of 50
07:08:13.06 process pointer page 28 of 50
07:08:13.11 process pointer page 29 of 50
07:08:13.14 process pointer page 30 of 50
07:08:13.17 process pointer page 31 of 50
07:08:13.20 process pointer page 32 of 50
07:08:13.23 process pointer page 33 of 50
07:08:13.26 process pointer page 34 of 50
07:08:13.30 process pointer page 35 of 50
07:08:13.33 process pointer page 36 of 50
07:08:13.36 process pointer page 37 of 50
07:08:13.37 process pointer page 38 of 50
07:08:13.41 process pointer page 39 of 50
07:08:13.44 process pointer page 40 of 50
07:08:13.47 process pointer page 41 of 50
07:08:13.48 process pointer page 42 of 50
07:08:13.51 process pointer page 43 of 50
07:08:13.55 process pointer page 44 of 50
07:08:13.58 process pointer page 45 of 50
07:08:13.61 process pointer page 46 of 50
07:08:13.64 process pointer page 47 of 50
07:08:13.67 process pointer page 48 of 50
07:08:13.70 process pointer page 49 of 50
07:08:13.73 Index 1 (XQS_1200_2000_DOC_ID)
07:08:14.53 Index 2 (XQS_1200_2000_SND_ID)
07:08:15.56 Index 3 (XQS_1200_2000_RCV_ID)
07:08:16.53 Relation 267 (XQS_1200_2000) is ok
07:08:16.53 Relation 268 (XQS_1000_3300)
07:08:16.53 process pointer page 0 of 24
07:08:16.57 process pointer page 1 of 24
07:08:16.60 process pointer page 2 of 24
07:08:16.71 process pointer page 3 of 24
07:08:16.77 process pointer page 4 of 24
07:08:16.82 process pointer page 5 of 24
07:08:16.92 process pointer page 6 of 24
07:08:17.01 process pointer page 7 of 24
07:08:17.04 process pointer page 8 of 24
07:08:17.09 process pointer page 9 of 24
07:08:17.12 process pointer page 10 of 24
07:08:17.16 process pointer page 11 of 24
07:08:17.20 process pointer page 12 of 24
07:08:17.31 process pointer page 13 of 24
07:08:17.35 process pointer page 14 of 24
07:08:17.38 process pointer page 15 of 24
07:08:17.43 process pointer page 16 of 24
07:08:17.49 process pointer page 17 of 24
07:08:17.59 process pointer page 18 of 24
07:08:17.70 process pointer page 19 of 24
07:08:17.79 process pointer page 20 of 24
07:08:17.90 process pointer page 21 of 24
07:08:17.94 process pointer page 22 of 24
07:08:17.98 process pointer page 23 of 24
07:08:17.99 Index 1 (XQS_1000_3300_DOC_ID)
07:08:18.48 Index 2 (XQS_1000_3300_SND_ID)
07:08:19.18 Index 3 (XQS_1000_3300_RCV_ID)
07:08:19.63 Relation 268 (XQS_1000_3300) is ok
07:08:19.63 Relation 269 (XQS_2000_3300)
07:08:19.63 process pointer page 0 of 1
07:08:19.63 Index 1 (XQS_2000_3300_DOC_ID)
07:08:19.63 Index 2 (XQS_2000_3300_SND_ID)
07:08:19.63 Index 3 (XQS_2000_3300_RCV_ID)
07:08:19.63 Relation 269 (XQS_2000_3300) is ok
07:08:19.63 Relation 270 (XQS_2100_3300)
07:08:19.63 process pointer page 0 of 34
07:08:19.72 process pointer page 1 of 34
07:08:19.77 process pointer page 2 of 34
07:08:19.82 process pointer page 3 of 34
07:08:19.85 process pointer page 4 of 34
07:08:19.89 process pointer page 5 of 34
07:08:19.93 process pointer page 6 of 34
07:08:19.96 process pointer page 7 of 34
07:08:20.05 process pointer page 8 of 34
07:08:20.10 process pointer page 9 of 34
07:08:20.14 process pointer page 10 of 34
07:08:20.22 process pointer page 11 of 34
07:08:20.32 process pointer page 12 of 34
07:08:20.43 process pointer page 13 of 34
07:08:20.52 process pointer page 14 of 34
07:08:20.55 process pointer page 15 of 34
07:08:20.61 process pointer page 16 of 34
07:08:20.64 process pointer page 17 of 34
07:08:20.69 process pointer page 18 of 34
07:08:20.72 process pointer page 19 of 34
07:08:20.75 process pointer page 20 of 34
07:08:20.78 process pointer page 21 of 34
07:08:20.82 process pointer page 22 of 34
07:08:20.85 process pointer page 23 of 34
07:08:20.94 process pointer page 24 of 34
07:08:21.02 process pointer page 25 of 34
07:08:21.11 process pointer page 26 of 34
07:08:21.21 process pointer page 27 of 34
07:08:21.24 process pointer page 28 of 34
07:08:21.30 process pointer page 29 of 34
07:08:21.39 process pointer page 30 of 34
07:08:21.44 process pointer page 31 of 34
07:08:21.47 process pointer page 32 of 34
07:08:21.50 process pointer page 33 of 34
07:08:21.52 Index 1 (XQS_2100_3300_DOC_ID)
07:08:22.53 Index 2 (XQS_2100_3300_SND_ID)
07:08:23.58 Index 3 (XQS_2100_3300_RCV_ID)
07:08:24.08 Relation 270 (XQS_2100_3300) is ok
07:08:24.08 Relation 271 (XQS_3300_3400)
07:08:24.08 process pointer page 0 of 6
07:08:24.11 process pointer page 1 of 6
07:08:24.12 process pointer page 2 of 6
07:08:24.15 process pointer page 3 of 6
07:08:24.18 process pointer page 4 of 6
07:08:24.20 process pointer page 5 of 6
07:08:24.22 Index 1 (XQS_3300_3400_DOC_ID)
07:08:24.36 Index 2 (XQS_3300_3400_SND_ID)
07:08:24.53 Relation 271 (XQS_3300_3400) is ok
07:08:24.53 Validation finished
Done for 43120 ms, from 7:07:41.42 to 7:08:24.54.
Differences between old and current firebird.log
7:08:25.74. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_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:
2017-11-16 07:08 471 oltp30_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Thu Nov 16 07:07:41 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Thu Nov 16 07:08:24 2017
12: Database: D:\OLTP-EMUL\OLTP30-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.oltp30\oltp30_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-11-16 7:08:31.61 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html