ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
7249.97 |
2743 |
1304994 |
2017-02-10 03:46 |
2017-02-10 06:46 |
customer order: creation |
515.70 |
394 |
92826 |
2017-02-10 03:46 |
2017-02-10 06:46 |
customer order: refuse |
42.48 |
213 |
7647 |
2017-02-10 03:46 |
2017-02-10 06:46 |
order to supplier: creation |
131.11 |
1678 |
23600 |
2017-02-10 03:46 |
2017-02-10 06:46 |
order to supplier: removal |
3.24 |
18262 |
584 |
2017-02-10 03:46 |
2017-02-10 06:46 |
invoice (draft): creation |
132.39 |
2464 |
23831 |
2017-02-10 03:46 |
2017-02-10 06:46 |
invoice (draft): removal |
50.23 |
380 |
9041 |
2017-02-10 03:46 |
2017-02-10 06:46 |
invoice accept: apply |
74.15 |
9270 |
13347 |
2017-02-10 03:46 |
2017-02-10 06:46 |
invoice accept: cancel |
23.53 |
2062 |
4235 |
2017-02-10 03:46 |
2017-02-10 06:46 |
customer reserve: creation |
4119.68 |
136 |
741543 |
2017-02-10 03:46 |
2017-02-10 06:46 |
customer reserve: removal |
1445.28 |
47 |
260151 |
2017-02-10 03:46 |
2017-02-10 06:46 |
realization accept: apply |
236.63 |
489 |
42594 |
2017-02-10 03:46 |
2017-02-10 06:46 |
realization accept: cancel |
99.35 |
136 |
17883 |
2017-02-10 03:46 |
2017-02-10 06:46 |
payment from customer: creation |
173.79 |
892 |
31282 |
2017-02-10 03:46 |
2017-02-10 06:46 |
payment from customer: removal |
16.47 |
98 |
2964 |
2017-02-10 03:46 |
2017-02-10 06:46 |
payment to supplier: creation |
144.21 |
874 |
25958 |
2017-02-10 03:46 |
2017-02-10 06:46 |
payment to supplier: removal |
10.13 |
113 |
1823 |
2017-02-10 03:46 |
2017-02-10 06:46 |
service: total inventory turnovers |
10.36 |
2766 |
1864 |
2017-02-10 03:46 |
2017-02-10 06:46 |
service: total monetary turnovers |
21.16 |
50 |
3809 |
2017-02-10 03:46 |
2017-02-10 06:46 |
service: refresh index statistics |
0.07 |
11793 |
12 |
2017-02-10 03:46 |
2017-02-10 06:46 |
Done for 107920 ms, from 6:49:14.58 to 6:51:02.50.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
5126 |
106896 |
92272 |
14624 |
13.68 |
03:46:29 |
04:04:29 |
interval # 2, overall |
2 |
6967 |
140057 |
125414 |
14643 |
10.46 |
04:04:30 |
04:22:30 |
interval # 3, overall |
3 |
8092 |
158238 |
145648 |
12590 |
7.96 |
04:22:31 |
04:40:31 |
interval # 4, overall |
4 |
8257 |
171689 |
148630 |
23059 |
13.43 |
04:40:32 |
04:58:32 |
interval # 5, overall |
5 |
7565 |
150729 |
136173 |
14556 |
9.66 |
04:58:33 |
05:16:33 |
interval # 6, overall |
6 |
6900 |
141128 |
124204 |
16924 |
11.99 |
05:16:34 |
05:34:34 |
interval # 7, overall |
7 |
6722 |
133611 |
120988 |
12623 |
9.45 |
05:34:35 |
05:52:35 |
interval # 8, overall |
8 |
8054 |
160409 |
144974 |
15435 |
9.62 |
05:52:36 |
06:10:36 |
interval # 9, overall |
9 |
7355 |
148066 |
132387 |
15679 |
10.59 |
06:10:37 |
06:28:37 |
interval # 10, overall |
10 |
7461 |
154991 |
134304 |
20687 |
13.35 |
06:28:38 |
06:46:38 |
Done for 366430 ms, from 6:57:07.30 to 7:03:13.73.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
4755.32 |
0.4946 |
1.4972 |
2147 |
15 |
TEST_TIME |
2 |
4759.36 |
0.7481 |
1.2093 |
2029 |
14 |
TEST_TIME |
3 |
4539.92 |
0.8452 |
1.1606 |
2000 |
21 |
TEST_TIME |
4 |
4317.68 |
0.9153 |
1.1279 |
1640 |
24 |
TEST_TIME |
5 |
4250.67 |
0.9205 |
1.0938 |
1775 |
34 |
TEST_TIME |
6 |
4279.07 |
0.9055 |
1.0969 |
1619 |
60 |
TEST_TIME |
7 |
4430.07 |
0.9098 |
1.0621 |
2665 |
100 |
TEST_TIME |
8 |
4407.93 |
0.9341 |
1.0779 |
2471 |
93 |
TEST_TIME |
9 |
4492.70 |
0.9400 |
1.0601 |
2232 |
92 |
TEST_TIME |
10 |
4602.19 |
0.9315 |
1.0796 |
2126 |
100 |
TEST_TIME |
11 |
4749.90 |
0.9509 |
1.0578 |
2575 |
100 |
TEST_TIME |
12 |
4809.40 |
0.9577 |
1.0373 |
2270 |
96 |
TEST_TIME |
13 |
4869.52 |
0.9457 |
1.0299 |
1795 |
100 |
TEST_TIME |
14 |
4810.29 |
0.9681 |
1.0348 |
2248 |
100 |
TEST_TIME |
15 |
4886.64 |
0.9508 |
1.0482 |
1647 |
100 |
TEST_TIME |
16 |
5027.51 |
0.9552 |
1.0403 |
1973 |
100 |
TEST_TIME |
17 |
5105.93 |
0.9642 |
1.0306 |
1676 |
100 |
TEST_TIME |
18 |
5130.30 |
0.9688 |
1.0321 |
1756 |
100 |
TEST_TIME |
19 |
5178.77 |
0.9687 |
1.0292 |
1635 |
100 |
TEST_TIME |
20 |
5219.69 |
0.9701 |
1.0279 |
1694 |
100 |
TEST_TIME |
21 |
5301.39 |
0.9639 |
1.0345 |
2546 |
100 |
TEST_TIME |
22 |
5485.69 |
0.9544 |
1.0394 |
2508 |
100 |
TEST_TIME |
23 |
5635.26 |
0.9678 |
1.0309 |
2443 |
100 |
TEST_TIME |
24 |
5719.55 |
0.9734 |
1.0222 |
2296 |
100 |
TEST_TIME |
25 |
5817.15 |
0.9649 |
1.0269 |
1824 |
100 |
TEST_TIME |
26 |
5887.43 |
0.9759 |
1.0270 |
1977 |
100 |
TEST_TIME |
27 |
5969.37 |
0.9754 |
1.0220 |
1817 |
100 |
TEST_TIME |
28 |
6018.46 |
0.9774 |
1.0228 |
1889 |
100 |
TEST_TIME |
29 |
6033.34 |
0.9852 |
1.0206 |
1791 |
99 |
TEST_TIME |
30 |
6020.90 |
0.9886 |
1.0160 |
1595 |
100 |
TEST_TIME |
31 |
6054.07 |
0.9816 |
1.0163 |
1599 |
100 |
TEST_TIME |
32 |
6033.68 |
0.9879 |
1.0126 |
1688 |
100 |
TEST_TIME |
33 |
6011.01 |
0.9856 |
1.0189 |
1613 |
100 |
TEST_TIME |
34 |
6018.12 |
0.9887 |
1.0125 |
1489 |
100 |
TEST_TIME |
35 |
6030.40 |
0.9815 |
1.0124 |
1457 |
100 |
TEST_TIME |
36 |
6033.27 |
0.9838 |
1.0162 |
2621 |
100 |
TEST_TIME |
37 |
6037.02 |
0.9882 |
1.0165 |
1642 |
81 |
TEST_TIME |
38 |
6153.17 |
0.9787 |
1.0206 |
1590 |
100 |
TEST_TIME |
39 |
6223.81 |
0.9832 |
1.0174 |
2139 |
100 |
TEST_TIME |
40 |
6275.53 |
0.9838 |
1.0262 |
2004 |
100 |
TEST_TIME |
41 |
6365.53 |
0.9873 |
1.0167 |
1953 |
100 |
TEST_TIME |
42 |
6433.61 |
0.9820 |
1.0132 |
1719 |
100 |
TEST_TIME |
43 |
6448.30 |
0.9874 |
1.0149 |
1676 |
100 |
TEST_TIME |
44 |
6517.42 |
0.9813 |
1.0121 |
1652 |
100 |
TEST_TIME |
45 |
6550.04 |
0.9847 |
1.0131 |
1365 |
100 |
TEST_TIME |
46 |
6576.74 |
0.9871 |
1.0109 |
1123 |
100 |
TEST_TIME |
47 |
6590.77 |
0.9873 |
1.0107 |
1305 |
100 |
TEST_TIME |
48 |
6575.28 |
0.9920 |
1.0108 |
1171 |
100 |
TEST_TIME |
49 |
6567.88 |
0.9913 |
1.0085 |
1247 |
100 |
TEST_TIME |
50 |
6550.18 |
0.9910 |
1.0075 |
1168 |
100 |
TEST_TIME |
51 |
6570.59 |
0.9846 |
1.0138 |
2026 |
100 |
TEST_TIME |
52 |
6637.53 |
0.9851 |
1.0159 |
2308 |
100 |
TEST_TIME |
53 |
6692.11 |
0.9888 |
1.0092 |
2193 |
100 |
TEST_TIME |
54 |
6697.55 |
0.9897 |
1.0095 |
2242 |
95 |
TEST_TIME |
55 |
6715.44 |
0.9885 |
1.0156 |
1929 |
87 |
TEST_TIME |
56 |
6752.65 |
0.9920 |
1.0099 |
1613 |
96 |
TEST_TIME |
57 |
6766.87 |
0.9910 |
1.0072 |
1738 |
100 |
TEST_TIME |
58 |
6783.12 |
0.9875 |
1.0117 |
1474 |
100 |
TEST_TIME |
59 |
6833.42 |
0.9875 |
1.0115 |
1602 |
100 |
TEST_TIME |
60 |
6865.48 |
0.9900 |
1.0107 |
1445 |
100 |
TEST_TIME |
61 |
6908.38 |
0.9880 |
1.0121 |
1404 |
100 |
TEST_TIME |
62 |
6930.72 |
0.9926 |
1.0102 |
1560 |
100 |
TEST_TIME |
63 |
6972.67 |
0.9914 |
1.0078 |
1282 |
100 |
TEST_TIME |
64 |
6960.05 |
0.9939 |
1.0072 |
1400 |
99 |
TEST_TIME |
65 |
6954.46 |
0.9930 |
1.0075 |
1386 |
100 |
TEST_TIME |
66 |
6979.75 |
0.9887 |
1.0114 |
2184 |
100 |
TEST_TIME |
67 |
7039.11 |
0.9879 |
1.0092 |
2183 |
100 |
TEST_TIME |
68 |
7089.40 |
0.9873 |
1.0089 |
1976 |
100 |
TEST_TIME |
69 |
7107.71 |
0.9917 |
1.0094 |
1858 |
100 |
TEST_TIME |
70 |
7124.88 |
0.9926 |
1.0041 |
1636 |
100 |
TEST_TIME |
71 |
7078.91 |
0.9964 |
1.0054 |
1788 |
94 |
TEST_TIME |
72 |
7082.90 |
0.9909 |
1.0063 |
1769 |
100 |
TEST_TIME |
73 |
7066.31 |
0.9949 |
1.0063 |
1632 |
88 |
TEST_TIME |
74 |
7073.42 |
0.9947 |
1.0051 |
1640 |
78 |
TEST_TIME |
75 |
7065.94 |
0.9927 |
1.0063 |
1570 |
63 |
TEST_TIME |
76 |
7066.36 |
0.9930 |
1.0079 |
1346 |
79 |
TEST_TIME |
77 |
7080.44 |
0.9928 |
1.0049 |
1424 |
100 |
TEST_TIME |
78 |
7079.60 |
0.9921 |
1.0078 |
1378 |
100 |
TEST_TIME |
79 |
7103.66 |
0.9918 |
1.0073 |
1349 |
100 |
TEST_TIME |
80 |
7116.90 |
0.9928 |
1.0048 |
1367 |
100 |
TEST_TIME |
81 |
7108.70 |
0.9936 |
1.0041 |
2009 |
99 |
TEST_TIME |
82 |
7115.92 |
0.9908 |
1.0113 |
2082 |
100 |
TEST_TIME |
83 |
7148.80 |
0.9945 |
1.0045 |
2124 |
99 |
TEST_TIME |
84 |
7144.96 |
0.9931 |
1.0086 |
2078 |
94 |
TEST_TIME |
85 |
7158.83 |
0.9948 |
1.0047 |
1963 |
96 |
TEST_TIME |
86 |
7161.49 |
0.9926 |
1.0071 |
1656 |
95 |
TEST_TIME |
87 |
7161.95 |
0.9955 |
1.0039 |
1899 |
98 |
TEST_TIME |
88 |
7164.96 |
0.9953 |
1.0066 |
1728 |
99 |
TEST_TIME |
89 |
7179.01 |
0.9936 |
1.0033 |
1607 |
100 |
TEST_TIME |
90 |
7185.13 |
0.9913 |
1.0065 |
1512 |
100 |
TEST_TIME |
91 |
7211.48 |
0.9918 |
1.0057 |
1430 |
100 |
TEST_TIME |
92 |
7209.35 |
0.9952 |
1.0034 |
1471 |
100 |
TEST_TIME |
93 |
7189.52 |
0.9954 |
1.0055 |
1391 |
100 |
TEST_TIME |
94 |
7180.09 |
0.9961 |
1.0043 |
1386 |
100 |
TEST_TIME |
95 |
7175.42 |
0.9944 |
1.0042 |
1262 |
100 |
TEST_TIME |
96 |
7181.76 |
0.9929 |
1.0070 |
2005 |
100 |
TEST_TIME |
97 |
7224.88 |
0.9907 |
1.0067 |
2063 |
100 |
TEST_TIME |
98 |
7239.06 |
0.9945 |
1.0063 |
1964 |
100 |
TEST_TIME |
99 |
7244.42 |
0.9954 |
1.0033 |
2191 |
100 |
TEST_TIME |
100 |
7236.94 |
0.9943 |
1.0071 |
1830 |
97 |
TEST_TIME |
101 |
7241.67 |
0.9965 |
1.0053 |
1912 |
98 |
TEST_TIME |
102 |
7239.02 |
0.9958 |
1.0046 |
959 |
99 |
TEST_TIME |
103 |
7233.46 |
0.9958 |
1.0035 |
1489 |
100 |
TEST_TIME |
104 |
7221.90 |
0.9959 |
1.0029 |
1759 |
99 |
TEST_TIME |
105 |
7185.08 |
0.9984 |
1.0019 |
1442 |
80 |
TEST_TIME |
106 |
7164.75 |
0.9952 |
1.0026 |
1309 |
82 |
TEST_TIME |
107 |
7152.25 |
0.9950 |
1.0031 |
1457 |
98 |
TEST_TIME |
108 |
7147.56 |
0.9945 |
1.0050 |
1349 |
100 |
TEST_TIME |
109 |
7134.95 |
0.9976 |
1.0029 |
1514 |
100 |
TEST_TIME |
110 |
7109.85 |
0.9973 |
1.0015 |
1463 |
99 |
TEST_TIME |
111 |
7095.51 |
0.9945 |
1.0037 |
1876 |
95 |
TEST_TIME |
112 |
7095.93 |
0.9946 |
1.0056 |
2210 |
83 |
TEST_TIME |
113 |
7118.81 |
0.9952 |
1.0037 |
1723 |
85 |
TEST_TIME |
114 |
7118.49 |
0.9950 |
1.0044 |
1764 |
99 |
TEST_TIME |
115 |
7111.99 |
0.9966 |
1.0039 |
2153 |
97 |
TEST_TIME |
116 |
7104.68 |
0.9963 |
1.0058 |
2029 |
88 |
TEST_TIME |
117 |
7105.08 |
0.9972 |
1.0033 |
1910 |
90 |
TEST_TIME |
118 |
7099.86 |
0.9955 |
1.0027 |
1807 |
97 |
TEST_TIME |
119 |
7100.31 |
0.9942 |
1.0035 |
1612 |
99 |
TEST_TIME |
120 |
7098.49 |
0.9954 |
1.0038 |
1462 |
100 |
TEST_TIME |
121 |
7096.78 |
0.9958 |
1.0041 |
1640 |
100 |
TEST_TIME |
122 |
7097.42 |
0.9958 |
1.0054 |
1538 |
100 |
TEST_TIME |
123 |
7090.52 |
0.9982 |
1.0020 |
1664 |
97 |
TEST_TIME |
124 |
7070.90 |
0.9966 |
1.0029 |
1504 |
93 |
TEST_TIME |
125 |
7062.12 |
0.9961 |
1.0058 |
1395 |
98 |
TEST_TIME |
126 |
7081.39 |
0.9951 |
1.0060 |
1912 |
100 |
TEST_TIME |
127 |
7105.67 |
0.9947 |
1.0052 |
2221 |
100 |
TEST_TIME |
128 |
7127.55 |
0.9943 |
1.0055 |
1808 |
100 |
TEST_TIME |
129 |
7142.71 |
0.9956 |
1.0058 |
1822 |
100 |
TEST_TIME |
130 |
7167.14 |
0.9946 |
1.0049 |
1648 |
100 |
TEST_TIME |
131 |
7169.76 |
0.9969 |
1.0022 |
1808 |
100 |
TEST_TIME |
132 |
7157.48 |
0.9963 |
1.0034 |
1734 |
87 |
TEST_TIME |
133 |
7153.74 |
0.9964 |
1.0031 |
1672 |
86 |
TEST_TIME |
134 |
7148.01 |
0.9965 |
1.0042 |
1525 |
89 |
TEST_TIME |
135 |
7148.96 |
0.9966 |
1.0027 |
1177 |
100 |
TEST_TIME |
136 |
7148.26 |
0.9954 |
1.0033 |
1362 |
100 |
TEST_TIME |
137 |
7167.46 |
0.9933 |
1.0037 |
1271 |
100 |
TEST_TIME |
138 |
7168.29 |
0.9963 |
1.0040 |
1293 |
100 |
TEST_TIME |
139 |
7159.92 |
0.9979 |
1.0048 |
1344 |
98 |
TEST_TIME |
140 |
7171.97 |
0.9959 |
1.0038 |
1200 |
100 |
TEST_TIME |
141 |
7172.81 |
0.9966 |
1.0025 |
2092 |
99 |
TEST_TIME |
142 |
7165.45 |
0.9965 |
1.0040 |
2061 |
93 |
TEST_TIME |
143 |
7172.63 |
0.9960 |
1.0043 |
2032 |
92 |
TEST_TIME |
144 |
7194.62 |
0.9943 |
1.0039 |
1441 |
100 |
TEST_TIME |
145 |
7184.57 |
0.9984 |
1.0018 |
1833 |
95 |
TEST_TIME |
146 |
7172.44 |
0.9967 |
1.0032 |
1694 |
88 |
TEST_TIME |
147 |
7188.86 |
0.9942 |
1.0038 |
1661 |
92 |
TEST_TIME |
148 |
7189.16 |
0.9969 |
1.0022 |
1556 |
100 |
TEST_TIME |
149 |
7188.87 |
0.9955 |
1.0038 |
1418 |
99 |
TEST_TIME |
150 |
7187.45 |
0.9973 |
1.0021 |
1576 |
98 |
TEST_TIME |
151 |
7184.25 |
0.9959 |
1.0044 |
1356 |
98 |
TEST_TIME |
152 |
7188.27 |
0.9973 |
1.0036 |
1388 |
97 |
TEST_TIME |
153 |
7193.70 |
0.9963 |
1.0028 |
1391 |
99 |
TEST_TIME |
154 |
7182.93 |
0.9977 |
1.0029 |
1400 |
100 |
TEST_TIME |
155 |
7172.19 |
0.9979 |
1.0024 |
1239 |
99 |
TEST_TIME |
156 |
7172.40 |
0.9960 |
1.0062 |
1877 |
100 |
TEST_TIME |
157 |
7185.95 |
0.9979 |
1.0025 |
2025 |
97 |
TEST_TIME |
158 |
7182.31 |
0.9966 |
1.0031 |
1928 |
90 |
TEST_TIME |
159 |
7187.07 |
0.9961 |
1.0048 |
1593 |
97 |
TEST_TIME |
160 |
7205.06 |
0.9960 |
1.0048 |
1489 |
100 |
TEST_TIME |
161 |
7218.31 |
0.9969 |
1.0037 |
1798 |
99 |
TEST_TIME |
162 |
7212.24 |
0.9984 |
1.0025 |
1897 |
95 |
TEST_TIME |
163 |
7208.55 |
0.9970 |
1.0023 |
1704 |
89 |
TEST_TIME |
164 |
7207.43 |
0.9963 |
1.0039 |
1398 |
98 |
TEST_TIME |
165 |
7217.04 |
0.9965 |
1.0014 |
1496 |
100 |
TEST_TIME |
166 |
7196.67 |
0.9982 |
1.0022 |
1521 |
97 |
TEST_TIME |
167 |
7180.92 |
0.9984 |
1.0018 |
1575 |
93 |
TEST_TIME |
168 |
7173.80 |
0.9969 |
1.0029 |
1418 |
98 |
TEST_TIME |
169 |
7167.41 |
0.9979 |
1.0019 |
1359 |
100 |
TEST_TIME |
170 |
7155.40 |
0.9977 |
1.0038 |
1172 |
99 |
TEST_TIME |
171 |
7167.36 |
0.9963 |
1.0036 |
1469 |
100 |
TEST_TIME |
172 |
7173.94 |
0.9969 |
1.0031 |
1810 |
100 |
TEST_TIME |
173 |
7182.16 |
0.9961 |
1.0042 |
1781 |
100 |
TEST_TIME |
174 |
7195.63 |
0.9967 |
1.0039 |
1746 |
100 |
TEST_TIME |
175 |
7209.48 |
0.9963 |
1.0037 |
1621 |
100 |
TEST_TIME |
176 |
7228.84 |
0.9953 |
1.0031 |
1586 |
100 |
TEST_TIME |
177 |
7231.20 |
0.9971 |
1.0050 |
1629 |
100 |
TEST_TIME |
178 |
7245.18 |
0.9974 |
1.0020 |
1476 |
100 |
TEST_TIME |
179 |
7245.19 |
0.9964 |
1.0038 |
1438 |
100 |
TEST_TIME |
180 |
7241.78 |
0.9987 |
1.0011 |
722 |
100 |
Done for 11110 ms, from 7:03:16.04 to 7:03:27.15.
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 |
50771 |
53959 |
55188 |
<null> |
48262 |
4690 |
44142 |
73645 |
51299 |
54657 |
54483 |
47190 |
75608 |
63811 |
77863 |
63673 |
284327 |
510581 |
<null> |
03:46:29 |
04:04:29 |
fetches per second |
2 |
33182 |
21854 |
42077 |
<null> |
20316 |
85809 |
48071 |
22661 |
37280 |
101727 |
35332 |
44745 |
53797 |
62826 |
73688 |
<null> |
186674 |
347086 |
<null> |
04:04:30 |
04:22:30 |
fetches per second |
3 |
37013 |
68009 |
39013 |
<null> |
35707 |
45235 |
63997 |
9329 |
59174 |
<null> |
42666 |
64989 |
35724 |
46835 |
81986 |
52154 |
265058 |
50038 |
<null> |
04:22:31 |
04:40:31 |
fetches per second |
4 |
36587 |
65886 |
40947 |
<null> |
37598 |
32198 |
87056 |
<null> |
45623 |
5378 |
39432 |
2602 |
74140 |
126166 |
109082 |
<null> |
434037 |
70572 |
<null> |
04:40:32 |
04:58:32 |
fetches per second |
5 |
16132 |
6903 |
6833 |
<null> |
16691 |
5787 |
56226 |
<null> |
6103 |
21497 |
12724 |
5178 |
27039 |
8003 |
33918 |
125166 |
<null> |
127905 |
<null> |
04:58:33 |
05:16:33 |
fetches per second |
6 |
17175 |
5435 |
13827 |
18627 |
18385 |
17380 |
25799 |
7094 |
6212 |
8469 |
19835 |
2112 |
30027 |
7684 |
45236 |
3866 |
<null> |
90506 |
<null> |
05:16:34 |
05:34:34 |
fetches per second |
7 |
24598 |
6804 |
29442 |
<null> |
8270 |
3787 |
23915 |
5027 |
18915 |
4377 |
21398 |
1751 |
31246 |
68000 |
45367 |
8539 |
13144 |
328396 |
<null> |
05:34:35 |
05:52:35 |
fetches per second |
8 |
19182 |
74144 |
30158 |
46013 |
36439 |
10902 |
30863 |
6473 |
55979 |
43204 |
24187 |
20867 |
37524 |
29151 |
62379 |
33580 |
<null> |
244314 |
<null> |
05:52:36 |
06:10:36 |
fetches per second |
9 |
11372 |
3916 |
22788 |
<null> |
13371 |
5879 |
39533 |
<null> |
18837 |
8742 |
16668 |
2740 |
26577 |
70915 |
29964 |
6554 |
166750 |
136033 |
<null> |
06:10:37 |
06:28:37 |
fetches per second |
10 |
28972 |
25681 |
43653 |
61013 |
24114 |
80584 |
55563 |
116688 |
8084 |
93679 |
24192 |
8367 |
50995 |
39974 |
103199 |
10616 |
14577 |
923625 |
<null> |
06:28:38 |
06:46:38 |
marks per second |
1 |
11079 |
6757 |
11222 |
<null> |
9863 |
997 |
5147 |
12534 |
5353 |
10650 |
8824 |
7736 |
4975 |
10885 |
3826 |
10581 |
8372 |
15628 |
<null> |
03:46:29 |
04:04:29 |
marks per second |
2 |
6936 |
2421 |
8843 |
<null> |
4588 |
19058 |
6920 |
3627 |
3812 |
14909 |
5690 |
7049 |
2907 |
11163 |
2904 |
<null> |
18720 |
39381 |
<null> |
04:04:30 |
04:22:30 |
marks per second |
3 |
7941 |
7459 |
8754 |
<null> |
8108 |
9072 |
7941 |
1294 |
13240 |
<null> |
7938 |
11028 |
1772 |
6972 |
2379 |
8246 |
48805 |
2712 |
<null> |
04:22:31 |
04:40:31 |
marks per second |
4 |
7299 |
8734 |
8775 |
<null> |
8129 |
7959 |
10304 |
<null> |
4827 |
866 |
5789 |
370 |
3864 |
18666 |
3642 |
<null> |
19893 |
1750 |
<null> |
04:40:32 |
04:58:32 |
marks per second |
5 |
3160 |
949 |
1190 |
<null> |
3573 |
1506 |
6593 |
<null> |
737 |
3325 |
2576 |
737 |
1149 |
1289 |
1300 |
18500 |
<null> |
1423 |
<null> |
04:58:33 |
05:16:33 |
marks per second |
6 |
3559 |
716 |
2463 |
2553 |
3097 |
4473 |
2839 |
979 |
918 |
1300 |
2294 |
333 |
1189 |
720 |
2911 |
663 |
<null> |
3184 |
<null> |
05:16:34 |
05:34:34 |
marks per second |
7 |
4821 |
863 |
5696 |
<null> |
1700 |
938 |
2544 |
690 |
2255 |
627 |
1181 |
262 |
1503 |
10000 |
2921 |
1439 |
510 |
50177 |
<null> |
05:34:35 |
05:52:35 |
marks per second |
8 |
4022 |
9132 |
5865 |
6467 |
7733 |
2657 |
3500 |
872 |
11876 |
6920 |
2360 |
3109 |
1931 |
5943 |
6071 |
7225 |
<null> |
18546 |
<null> |
05:52:36 |
06:10:36 |
marks per second |
9 |
2418 |
504 |
3314 |
<null> |
2520 |
1151 |
4366 |
<null> |
2255 |
1406 |
2611 |
399 |
597 |
10613 |
4806 |
1025 |
4067 |
4333 |
<null> |
06:10:37 |
06:28:37 |
marks per second |
10 |
5891 |
2995 |
8143 |
9483 |
4858 |
16509 |
6940 |
16359 |
409 |
18148 |
3118 |
1295 |
1271 |
6067 |
8542 |
1870 |
316 |
46833 |
<null> |
06:28:38 |
06:46:38 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:46:29 |
04:04:29 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
04:04:30 |
04:22:30 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:22:31 |
04:40:31 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
04:40:32 |
04:58:32 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
04:58:33 |
05:16:33 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
05:16:34 |
05:34:34 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:34:35 |
05:52:35 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
05:52:36 |
06:10:36 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:10:37 |
06:28:37 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:28:38 |
06:46:38 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
03:46:29 |
04:04:29 |
writes/marks*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
2 |
0 |
<null> |
04:04:30 |
04:22:30 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
<null> |
04:22:31 |
04:40:31 |
writes/marks*100 |
4 |
1 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
0 |
<null> |
04:40:32 |
04:58:32 |
writes/marks*100 |
5 |
0 |
1 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
04:58:33 |
05:16:33 |
writes/marks*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
05:16:34 |
05:34:34 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
3 |
0 |
0 |
3 |
0 |
<null> |
05:34:35 |
05:52:35 |
writes/marks*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
05:52:36 |
06:10:36 |
writes/marks*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
2 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
0 |
<null> |
06:10:37 |
06:28:37 |
writes/marks*100 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
5 |
0 |
<null> |
06:28:38 |
06:46:38 |
Done for 10730 ms, from 7:03:28.87 to 7:03:39.60.
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 |
2243537 |
2095997 |
147540 |
6.57 |
0 |
9329 |
47 |
147540 |
2017-02-10 03:46 |
2017-02-10 06:46 |
doc_list_biud |
2244022 |
2095997 |
148025 |
6.59 |
0 |
6661 |
13 |
148025 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_add_invoice_to_stock |
22409 |
13347 |
9062 |
40.43 |
0 |
200866 |
9270 |
9062 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_cancel_adding_invoice |
5274 |
4235 |
1039 |
19.70 |
0 |
91183 |
2062 |
1039 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_cancel_client_order |
7790 |
7647 |
143 |
1.83 |
0 |
3931 |
213 |
143 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_cancel_customer_reserve |
397163 |
260151 |
137012 |
34.49 |
0 |
6427 |
47 |
137012 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_cancel_pay_from_customer |
2977 |
2964 |
13 |
0.43 |
0 |
1778 |
98 |
13 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_cancel_pay_to_supplier |
1825 |
1823 |
2 |
0.10 |
0 |
2247 |
113 |
2 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_cancel_supplier_invoice |
11354 |
9041 |
2313 |
20.37 |
0 |
7238 |
380 |
2313 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_cancel_supplier_order |
1781 |
584 |
1197 |
67.20 |
31 |
185984 |
18262 |
1197 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_cancel_write_off |
26336 |
17883 |
8453 |
32.09 |
0 |
3167 |
136 |
8453 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_client_order |
92826 |
92826 |
0 |
0.00 |
0 |
5694 |
394 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_customer_reserve |
741543 |
741543 |
0 |
0.00 |
0 |
5210 |
136 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_fill_shopping_cart |
140581 |
140257 |
324 |
0.23 |
0 |
6037 |
80 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_fill_shopping_cart_clo_res |
741543 |
741543 |
0 |
0.00 |
0 |
4056 |
10 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_get_clo_for_invoice |
13347 |
13347 |
0 |
0.00 |
0 |
5554 |
283 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_kill_cost_storno |
36041 |
26905 |
9136 |
25.34 |
0 |
2745 |
12 |
9136 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_kill_qstorno_ret_qs2qd |
831587 |
547810 |
283777 |
34.12 |
0 |
6615 |
17 |
283777 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_kill_qty_storno |
503408 |
355482 |
147926 |
29.38 |
0 |
6630 |
55 |
147926 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_lock_selected_doc |
91506 |
78757 |
12749 |
13.93 |
0 |
1311 |
6 |
12749 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_make_cost_storno |
113181 |
113181 |
0 |
0.00 |
0 |
9126 |
491 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_multiply_rows_for_pdistr |
113181 |
113181 |
0 |
0.00 |
0 |
3261 |
38 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_multiply_rows_for_qdistr |
92826 |
92826 |
0 |
0.00 |
0 |
5273 |
131 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_pay_from_customer |
31282 |
31282 |
0 |
0.00 |
15 |
9750 |
892 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_pay_to_supplier |
25958 |
25958 |
0 |
0.00 |
0 |
8159 |
874 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_payment_common |
57240 |
57240 |
0 |
0.00 |
0 |
2948 |
53 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_qd_handle_on_cancel_clo |
7783 |
7647 |
136 |
1.74 |
0 |
3244 |
93 |
136 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_qd_handle_on_invoice_upd_sts |
18435 |
17582 |
853 |
4.62 |
0 |
5008 |
292 |
853 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_qd_handle_on_reserve_upd_sts |
42594 |
42594 |
0 |
0.00 |
0 |
6567 |
41 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_reserve_write_off |
43856 |
42594 |
1262 |
2.87 |
0 |
9079 |
489 |
1262 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_supplier_invoice |
23948 |
23831 |
117 |
0.48 |
0 |
30685 |
2464 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
sp_supplier_order |
23807 |
23600 |
207 |
0.86 |
0 |
13338 |
1678 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
srv_find_qd_qs_mism |
1342319 |
1194726 |
147593 |
10.99 |
0 |
3136 |
22 |
147593 |
2017-02-10 03:46 |
2017-02-10 06:46 |
srv_make_invnt_saldo |
1864 |
1864 |
0 |
0.00 |
15 |
24851 |
2766 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
srv_make_money_saldo |
3809 |
3809 |
0 |
0.00 |
0 |
1794 |
50 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
1794 |
43306 |
11793 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_add_invoice_to_stock |
9062 |
9062 |
0 |
0.00 |
0 |
1700 |
67 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_cancel_adding_invoice |
834 |
834 |
0 |
0.00 |
0 |
1966 |
157 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_cancel_client_order |
143 |
143 |
0 |
0.00 |
0 |
375 |
50 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_cancel_customer_reserve |
76 |
76 |
0 |
0.00 |
0 |
483 |
44 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_cancel_pay_from_customer |
13 |
13 |
0 |
0.00 |
0 |
328 |
98 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_cancel_pay_to_supplier |
2 |
2 |
0 |
0.00 |
47 |
94 |
70 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_cancel_supplier_invoice |
711 |
711 |
0 |
0.00 |
0 |
2012 |
66 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_cancel_supplier_order |
16931 |
16931 |
0 |
0.00 |
0 |
2277 |
81 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_cancel_write_off |
24 |
24 |
0 |
0.00 |
0 |
609 |
104 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_reserve_write_off |
1262 |
1262 |
0 |
0.00 |
0 |
952 |
55 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_supplier_invoice |
117 |
117 |
0 |
0.00 |
0 |
702 |
70 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-abend:sp_supplier_order |
207 |
207 |
0 |
0.00 |
0 |
780 |
44 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_add_invoice_to_stock |
13347 |
13347 |
0 |
0.00 |
0 |
10858 |
451 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_cancel_adding_invoice |
1543 |
1543 |
0 |
0.00 |
0 |
8549 |
480 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_cancel_client_order |
7647 |
7647 |
0 |
0.00 |
0 |
1685 |
44 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_cancel_customer_reserve |
2859 |
2859 |
0 |
0.00 |
0 |
1326 |
51 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_cancel_pay_from_customer |
2964 |
2964 |
0 |
0.00 |
0 |
1358 |
36 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_cancel_pay_to_supplier |
1823 |
1823 |
0 |
0.00 |
0 |
951 |
36 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_cancel_supplier_invoice |
1059 |
1059 |
0 |
0.00 |
0 |
1529 |
50 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_cancel_supplier_order |
584 |
584 |
0 |
0.00 |
0 |
58438 |
1660 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_cancel_write_off |
4337 |
4337 |
0 |
0.00 |
0 |
2184 |
43 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_client_order |
92826 |
92826 |
0 |
0.00 |
0 |
2386 |
53 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_customer_reserve |
4262 |
4262 |
0 |
0.00 |
0 |
1498 |
37 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_pay_from_customer |
31282 |
31282 |
0 |
0.00 |
0 |
1607 |
44 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_pay_to_supplier |
25958 |
25958 |
0 |
0.00 |
0 |
1576 |
41 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_reserve_write_off |
42594 |
42594 |
0 |
0.00 |
0 |
2293 |
48 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_supplier_invoice |
23831 |
23831 |
0 |
0.00 |
0 |
1560 |
43 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:sp_supplier_order |
23600 |
23600 |
0 |
0.00 |
0 |
2418 |
47 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:srv_make_invnt_saldo |
1864 |
1864 |
0 |
0.00 |
0 |
1092 |
11 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:srv_make_money_saldo |
3809 |
3809 |
0 |
0.00 |
0 |
889 |
19 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
47 |
18 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_add_invoice_to_stock |
44818 |
26694 |
18124 |
40.43 |
0 |
1217 |
14 |
18124 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_all_customers |
139194 |
139194 |
0 |
0.00 |
0 |
578 |
5 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_all_suppliers |
96212 |
95564 |
648 |
0.67 |
0 |
827 |
5 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_all_wares |
185652 |
185652 |
0 |
0.00 |
0 |
858 |
4 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_cancel_adding_invoice |
3604 |
3086 |
518 |
14.37 |
0 |
3775 |
129 |
518 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_cancel_client_order |
15580 |
15294 |
286 |
1.83 |
0 |
1154 |
5 |
286 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_cancel_customer_prepayment |
5954 |
5928 |
26 |
0.43 |
0 |
795 |
6 |
26 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_cancel_customer_reserve |
5870 |
5718 |
152 |
2.58 |
0 |
843 |
7 |
152 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_cancel_payment_to_supplier |
3650 |
3646 |
4 |
0.10 |
0 |
1014 |
7 |
4 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_cancel_supplier_invoice |
3540 |
2118 |
1422 |
40.16 |
0 |
1014 |
15 |
1422 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_cancel_supplier_order |
3562 |
1168 |
2394 |
67.20 |
0 |
795 |
8 |
2394 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_cancel_write_off |
8722 |
8674 |
48 |
0.55 |
0 |
2247 |
93 |
48 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_max_id_clo_ord |
23807 |
23600 |
207 |
0.86 |
0 |
452 |
4 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_max_id_clo_res |
4262 |
4262 |
0 |
0.00 |
0 |
1123 |
16 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_max_id_ord_sup |
23948 |
23831 |
117 |
0.48 |
0 |
1201 |
5 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_max_non_paid_invoice |
25607 |
25607 |
0 |
0.00 |
0 |
640 |
4 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_max_non_paid_realizn |
31282 |
31282 |
0 |
0.00 |
0 |
624 |
5 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_min_id_clo_ord |
23807 |
23600 |
207 |
0.86 |
0 |
1435 |
6 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_min_id_clo_res |
4262 |
4262 |
0 |
0.00 |
0 |
2777 |
9 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_min_id_ord_sup |
23948 |
23831 |
117 |
0.48 |
0 |
1888 |
6 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_min_non_paid_invoice |
25958 |
25958 |
0 |
0.00 |
0 |
1872 |
7 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_min_non_paid_realizn |
31282 |
31282 |
0 |
0.00 |
0 |
1264 |
6 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_our_firm |
46458 |
46458 |
0 |
0.00 |
0 |
702 |
5 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
v_reserve_write_off |
87712 |
85188 |
2524 |
2.87 |
0 |
1092 |
6 |
2524 |
2017-02-10 03:46 |
2017-02-10 06:46 |
x_lock_depdocs_on_canc_invoice |
21984 |
12217 |
9767 |
44.42 |
0 |
1623 |
29 |
9767 |
2017-02-10 03:46 |
2017-02-10 06:46 |
x_lock_depdocs_on_canc_sup_ord |
1779 |
584 |
1195 |
67.17 |
0 |
1139 |
54 |
1195 |
2017-02-10 03:46 |
2017-02-10 06:46 |
x_make_qstorno_1000_1200 |
23807 |
23600 |
207 |
0.86 |
0 |
12356 |
1501 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
x_make_qstorno_1200_2000 |
23948 |
23831 |
117 |
0.48 |
0 |
29859 |
2283 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
x_make_qstorno_2100_3300 |
741543 |
741543 |
0 |
0.00 |
0 |
5179 |
114 |
0 |
2017-02-10 03:46 |
2017-02-10 06:46 |
Done for 545860 ms, from 7:12:33.65 to 7:21:39.51.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
84 |
sp_kill_cost_storno |
335544336 |
2017-02-10 03:46 |
2017-02-10 06:38 |
deadlock |
95 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-02-10 03:47 |
2017-02-10 06:44 |
deadlock |
2753 |
sp_lock_selected_doc |
335544336 |
2017-02-10 03:46 |
2017-02-10 06:46 |
deadlock |
136 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-02-10 03:54 |
2017-02-10 06:42 |
deadlock |
180 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-02-10 03:46 |
2017-02-10 06:46 |
deadlock |
55 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-02-10 03:53 |
2017-02-10 06:42 |
deadlock |
18 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-02-10 04:08 |
2017-02-10 06:40 |
user_exc |
207 |
x_make_qstorno_1000_1200 |
335544517 |
2017-02-10 03:48 |
2017-02-10 06:45 |
user_exc |
117 |
x_make_qstorno_1200_2000 |
335544517 |
2017-02-10 03:48 |
2017-02-10 06:45 |
concurrent_transaction |
8404 |
sp_lock_selected_doc |
335544878 |
2017-02-10 03:46 |
2017-02-10 06:46 |
concurrent_transaction |
710 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2017-02-10 03:46 |
2017-02-10 06:46 |
concurrent_transaction |
307 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2017-02-10 03:50 |
2017-02-10 06:44 |
Done for 15030 ms, from 7:21:52.58 to 7:22:07.61.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 476707
MON$OLDEST_ACTIVE 476708
MON$OLDEST_SNAPSHOT 476708
MON$NEXT_TRANSACTION 476708
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 918240
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.2.32685 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.2.32685 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.2.32685 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.2.32685 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 476883
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 476709
Oldest active 476710
Oldest snapshot 476710
Next transaction 476711
Sequence number 0
Next attachment ID 9640
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.17, total records: 2334577
Average version length: 47.67, total versions: 2065, 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: 16, data page slots: 25272
Data pages: 25272, average fill: 73%
Primary pages: 25272, secondary pages: 0, swept pages: 13807
Empty pages: 4, full pages: 23279
Fill distribution:
0 - 19% = 4
20 - 39% = 4
40 - 59% = 50
60 - 79% = 25210
80 - 99% = 4
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 11678, nodes: 2334577
Average node length: 19.40, total dup: 0, max dup: 0
Average key length: 16.44, compression ratio: 1.64
Average prefix length: 13.56, average data length: 13.44
Clustering factor: 510365, ratio: 0.22
Fill distribution:
0 - 19% = 738
20 - 39% = 3057
40 - 59% = 5371
60 - 79% = 1002
80 - 99% = 1510
Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 8439, nodes: 2334577
Average node length: 11.62, total dup: 0, max dup: 0
Average key length: 8.66, compression ratio: 1.04
Average prefix length: 3.33, average data length: 5.67
Clustering factor: 485426, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 4254
40 - 59% = 4090
60 - 79% = 88
80 - 99% = 7
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 168594, depth: 3, leaf buckets: 4255, nodes: 2334577
Average node length: 6.86, total dup: 1684901, max dup: 49
Average key length: 3.91, compression ratio: 2.30
Average prefix length: 7.37, average data length: 1.63
Clustering factor: 467047, ratio: 0.20
Fill distribution:
0 - 19% = 160
20 - 39% = 1667
40 - 59% = 1620
60 - 79% = 244
80 - 99% = 564
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.43, total records: 722195
Average version length: 35.91, total versions: 537, max versions: 3
Average fragment length: 42.90, total fragments: 10, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 9152
Data pages: 9144, average fill: 75%
Primary pages: 9139, secondary pages: 5, swept pages: 8325
Empty pages: 1, full pages: 8498
Fill distribution:
0 - 19% = 6
20 - 39% = 4
40 - 59% = 27
60 - 79% = 9093
80 - 99% = 14
Index DOC_LIST_ID_DESC (1)
Root page: 251190, depth: 3, leaf buckets: 2697, nodes: 722195
Average node length: 11.69, 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: 190087, ratio: 0.26
Fill distribution:
0 - 19% = 1
20 - 39% = 1599
40 - 59% = 1030
60 - 79% = 60
80 - 99% = 7
Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 764, nodes: 722195
Average node length: 4.89, total dup: 722145, max dup: 50716
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 330730, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 660
60 - 79% = 85
80 - 99% = 19
Index PK_DOC_LIST (0)
Root page: 311164, depth: 3, leaf buckets: 2214, nodes: 722195
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.80, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 190087, ratio: 0.26
Fill distribution:
0 - 19% = 170
20 - 39% = 822
40 - 59% = 636
60 - 79% = 274
80 - 99% = 312
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: 64.76, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 18.07, total fragments: 350, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.61
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 22%
Primary pages: 4, secondary pages: 28, swept pages: 4
Empty pages: 8, full pages: 3
Fill distribution:
0 - 19% = 21
20 - 39% = 7
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3
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: 55.28, total records: 4302
Average version length: 71.22, total versions: 966, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.74
Pointer pages: 2, data page slots: 248
Data pages: 144, average fill: 35%
Primary pages: 144, secondary pages: 0, swept pages: 57
Empty pages: 45, full pages: 29
Fill distribution:
0 - 19% = 69
20 - 39% = 6
40 - 59% = 22
60 - 79% = 37
80 - 99% = 10
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 23, nodes: 4302
Average node length: 15.51, total dup: 163, max dup: 1
Average key length: 12.87, compression ratio: 2.10
Average prefix length: 17.09, average data length: 9.91
Clustering factor: 3308, ratio: 0.77
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 8
60 - 79% = 0
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 14.96, 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.37, total records: 76
Average version length: 45.60, total versions: 5, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.51
Pointer pages: 1, data page slots: 56
Data pages: 16, average fill: 5%
Primary pages: 14, secondary pages: 2, swept pages: 12
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: 212010, depth: 2, leaf buckets: 1, nodes: 76
Average node length: 9.95, total dup: 45, max dup: 10
Average key length: 8.14, compression ratio: 2.33
Average prefix length: 13.25, average data length: 5.75
Clustering factor: 56, ratio: 0.74
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: 42.52, total records: 265321
Average version length: 32.35, total versions: 307, max versions: 5
Average fragment length: 33.86, total fragments: 7, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.51
Pointer pages: 2, data page slots: 3064
Data pages: 3064, average fill: 64%
Primary pages: 3036, secondary pages: 28, swept pages: 2000
Empty pages: 36, full pages: 1749
Fill distribution:
0 - 19% = 147
20 - 39% = 231
40 - 59% = 175
60 - 79% = 2511
80 - 99% = 0
Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 244, nodes: 265321
Average node length: 4.60, total dup: 265272, max dup: 11712
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 46483, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 101
60 - 79% = 97
80 - 99% = 32
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 298, nodes: 265321
Average node length: 5.53, total dup: 239591, max dup: 74
Average key length: 2.94, compression ratio: 7.49
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 61441, ratio: 0.23
Fill distribution:
0 - 19% = 1
20 - 39% = 28
40 - 59% = 125
60 - 79% = 103
80 - 99% = 41
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 295, nodes: 265321
Average node length: 5.53, total dup: 239591, max dup: 74
Average key length: 2.94, compression ratio: 7.49
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 61504, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 25
40 - 59% = 126
60 - 79% = 85
80 - 99% = 59
Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 304, nodes: 265321
Average node length: 5.32, total dup: 239591, max dup: 74
Average key length: 2.73, compression ratio: 3.30
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 61466, ratio: 0.23
Fill distribution:
0 - 19% = 1
20 - 39% = 52
40 - 59% = 116
60 - 79% = 103
80 - 99% = 32
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.94, total records: 309435
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 2, data page slots: 2648
Data pages: 2648, average fill: 64%
Primary pages: 2648, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 2643
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2643
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 870614, depth: 2, leaf buckets: 264, nodes: 309435
Average node length: 4.59, total dup: 309254, max dup: 2664
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 83254, ratio: 0.27
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 137
60 - 79% = 62
80 - 99% = 63
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.93, total records: 13496414
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.16
Pointer pages: 197, data page slots: 320608
Data pages: 320608, average fill: 87%
Primary pages: 320608, secondary pages: 0, swept pages: 3
Empty pages: 5, full pages: 320602
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 320602
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 15119, nodes: 13496414
Average node length: 5.71, total dup: 12637000, max dup: 141
Average key length: 2.15, compression ratio: 3.71
Average prefix length: 7.88, average data length: 0.11
Clustering factor: 4630419, ratio: 0.34
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 7974
60 - 79% = 4761
80 - 99% = 2375
Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 13546, nodes: 13496414
Average node length: 4.64, total dup: 13496409, max dup: 12399417
Average key length: 1.08, compression ratio: 0.38
Average prefix length: 0.41, average data length: 0.00
Clustering factor: 395810, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 13514
60 - 79% = 2
80 - 99% = 29
Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 16504, nodes: 13496414
Average node length: 5.78, total dup: 13092159, max dup: 23815
Average key length: 2.22, compression ratio: 4.05
Average prefix length: 8.81, average data length: 0.19
Clustering factor: 1038011, ratio: 0.08
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 12158
60 - 79% = 2430
80 - 99% = 1911
Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 16551, nodes: 13496414
Average node length: 5.62, total dup: 13470461, max dup: 1851346
Average key length: 2.07, compression ratio: 18.31
Average prefix length: 37.77, average data length: 0.06
Clustering factor: 7270628, ratio: 0.54
Fill distribution:
0 - 19% = 24
20 - 39% = 1
40 - 59% = 14251
60 - 79% = 599
80 - 99% = 1676
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: 55.08, total records: 456867
Average version length: 55.62, total versions: 924, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5424
Data pages: 5424, average fill: 75%
Primary pages: 5424, secondary pages: 0, swept pages: 3599
Empty pages: 1, full pages: 5152
Fill distribution:
0 - 19% = 4
20 - 39% = 2
40 - 59% = 12
60 - 79% = 5403
80 - 99% = 3
Index PSTORNED_RCV_ID (2)
Root page: 692290, depth: 3, leaf buckets: 613, nodes: 456867
Average node length: 6.02, total dup: 379455, max dup: 569
Average key length: 3.23, compression ratio: 2.79
Average prefix length: 7.94, average data length: 1.06
Clustering factor: 61688, ratio: 0.14
Fill distribution:
0 - 19% = 11
20 - 39% = 32
40 - 59% = 364
60 - 79% = 163
80 - 99% = 43
Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 495, nodes: 456867
Average node length: 5.60, total dup: 407530, max dup: 175
Average key length: 2.81, compression ratio: 3.21
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 112871, ratio: 0.25
Fill distribution:
0 - 19% = 6
20 - 39% = 5
40 - 59% = 211
60 - 79% = 191
80 - 99% = 82
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: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 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.89, total records: 3305
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: 76%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 39
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 40
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: 53.54, total records: 4899
Average version length: 72.26, total versions: 1267, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.54
Pointer pages: 2, data page slots: 304
Data pages: 200, average fill: 30%
Primary pages: 199, secondary pages: 1, swept pages: 117
Empty pages: 42, full pages: 25
Fill distribution:
0 - 19% = 86
20 - 39% = 52
40 - 59% = 24
60 - 79% = 31
80 - 99% = 7
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 12, nodes: 4899
Average node length: 7.02, total dup: 4242, max dup: 14
Average key length: 4.91, compression ratio: 7.54
Average prefix length: 34.23, average data length: 2.77
Clustering factor: 773, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 5
60 - 79% = 0
80 - 99% = 0
XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.99, total records: 1215287
Average version length: 71.74, total versions: 3172, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 12, data page slots: 18544
Data pages: 18464, average fill: 72%
Primary pages: 18464, secondary pages: 0, swept pages: 11498
Empty pages: 173, full pages: 14511
Fill distribution:
0 - 19% = 279
20 - 39% = 419
40 - 59% = 1039
60 - 79% = 16692
80 - 99% = 35
Index XQD_1000_3300_DOC (1)
Root page: 480218, depth: 3, leaf buckets: 1348, nodes: 1215287
Average node length: 5.13, total dup: 1183265, max dup: 121
Average key length: 2.19, compression ratio: 4.10
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 134957, ratio: 0.11
Fill distribution:
0 - 19% = 13
20 - 39% = 99
40 - 59% = 950
60 - 79% = 35
80 - 99% = 251
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 225198, depth: 3, leaf buckets: 1733, nodes: 1215287
Average node length: 6.25, total dup: 1061340, max dup: 28
Average key length: 3.32, compression ratio: 11.16
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 234221, ratio: 0.19
Fill distribution:
0 - 19% = 20
20 - 39% = 154
40 - 59% = 1275
60 - 79% = 152
80 - 99% = 132
XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 66.99, total records: 33765
Average version length: 72.02, total versions: 2392, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.03
Pointer pages: 3, data page slots: 2112
Data pages: 1248, average fill: 31%
Primary pages: 1248, secondary pages: 0, swept pages: 917
Empty pages: 245, full pages: 139
Fill distribution:
0 - 19% = 540
20 - 39% = 256
40 - 59% = 186
60 - 79% = 256
80 - 99% = 10
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 62, nodes: 33765
Average node length: 5.85, total dup: 29547, max dup: 49
Average key length: 3.61, compression ratio: 10.26
Average prefix length: 35.52, average data length: 1.48
Clustering factor: 3808, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 31
40 - 59% = 23
60 - 79% = 7
80 - 99% = 0
XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 71.03, total records: 1892134
Average version length: 71.58, total versions: 30315, 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: 19, data page slots: 30096
Data pages: 29768, average fill: 70%
Primary pages: 29768, secondary pages: 0, swept pages: 15730
Empty pages: 605, full pages: 22308
Fill distribution:
0 - 19% = 1104
20 - 39% = 1234
40 - 59% = 2387
60 - 79% = 24462
80 - 99% = 581
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 197657, depth: 3, leaf buckets: 2930, nodes: 1892134
Average node length: 5.60, total dup: 1782477, max dup: 49
Average key length: 2.63, compression ratio: 14.05
Average prefix length: 36.42, average data length: 0.58
Clustering factor: 231303, ratio: 0.12
Fill distribution:
0 - 19% = 16
20 - 39% = 1248
40 - 59% = 1254
60 - 79% = 203
80 - 99% = 209
XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 52.87, total records: 1986
Average version length: 71.86, total versions: 507, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.57
Pointer pages: 4, data page slots: 768
Data pages: 400, average fill: 6%
Primary pages: 399, secondary pages: 1, swept pages: 282
Empty pages: 255, full pages: 6
Fill distribution:
0 - 19% = 358
20 - 39% = 25
40 - 59% = 8
60 - 79% = 6
80 - 99% = 3
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 7, nodes: 1986
Average node length: 9.29, total dup: 1491, max dup: 46
Average key length: 7.21, compression ratio: 5.13
Average prefix length: 32.03, average data length: 4.97
Clustering factor: 362, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 71.40, total records: 2907070
Average version length: 71.22, total versions: 9114, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 26, data page slots: 41376
Data pages: 41376, average fill: 77%
Primary pages: 41376, secondary pages: 0, swept pages: 29876
Empty pages: 18, full pages: 38766
Fill distribution:
0 - 19% = 49
20 - 39% = 75
40 - 59% = 380
60 - 79% = 40659
80 - 99% = 213
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 6254, nodes: 2907070
Average node length: 6.91, total dup: 2341811, max dup: 25
Average key length: 3.93, compression ratio: 9.40
Average prefix length: 35.26, average data length: 1.74
Clustering factor: 547630, ratio: 0.19
Fill distribution:
0 - 19% = 6
20 - 39% = 3704
40 - 59% = 2087
60 - 79% = 303
80 - 99% = 154
XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.87, total records: 5157523
Average version length: 84.30, total versions: 1807, 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: 49, data page slots: 79320
Data pages: 79320, average fill: 80%
Primary pages: 79320, secondary pages: 0, swept pages: 30343
Empty pages: 9, full pages: 79015
Fill distribution:
0 - 19% = 11
20 - 39% = 5
40 - 59% = 27
60 - 79% = 22299
80 - 99% = 56978
Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 5284, nodes: 5157523
Average node length: 5.16, total dup: 5039782, max dup: 135
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 828113, ratio: 0.16
Fill distribution:
0 - 19% = 27
20 - 39% = 93
40 - 59% = 2342
60 - 79% = 2187
80 - 99% = 635
Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 5781, nodes: 5157523
Average node length: 5.69, total dup: 4619019, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 274722, ratio: 0.05
Fill distribution:
0 - 19% = 62
20 - 39% = 237
40 - 59% = 3394
60 - 79% = 281
80 - 99% = 1807
Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5874, nodes: 5157523
Average node length: 5.81, total dup: 4512434, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 887548, ratio: 0.17
Fill distribution:
0 - 19% = 26
20 - 39% = 123
40 - 59% = 2530
60 - 79% = 2331
80 - 99% = 864
XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 83.29, total records: 2666954
Average version length: 83.94, total versions: 7596, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 26, data page slots: 41592
Data pages: 41592, average fill: 79%
Primary pages: 41592, secondary pages: 0, swept pages: 29512
Empty pages: 10, full pages: 40341
Fill distribution:
0 - 19% = 22
20 - 39% = 66
40 - 59% = 248
60 - 79% = 16748
80 - 99% = 24508
Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2860, nodes: 2666954
Average node length: 5.15, total dup: 2604311, max dup: 157
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 436551, ratio: 0.16
Fill distribution:
0 - 19% = 4
20 - 39% = 70
40 - 59% = 1667
60 - 79% = 808
80 - 99% = 311
Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 4487, nodes: 2666954
Average node length: 6.26, total dup: 2175694, max dup: 14
Average key length: 3.28, compression ratio: 2.74
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 267029, ratio: 0.10
Fill distribution:
0 - 19% = 136
20 - 39% = 1857
40 - 59% = 1551
60 - 79% = 578
80 - 99% = 365
Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 3260, nodes: 2666954
Average node length: 5.81, total dup: 2331651, max dup: 37
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 518828, ratio: 0.19
Fill distribution:
0 - 19% = 13
20 - 39% = 81
40 - 59% = 1928
60 - 79% = 950
80 - 99% = 288
XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.82, total records: 5464475
Average version length: 85.37, total versions: 14107, 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: 53, data page slots: 85520
Data pages: 85376, average fill: 79%
Primary pages: 85376, secondary pages: 0, swept pages: 24721
Empty pages: 296, full pages: 81784
Fill distribution:
0 - 19% = 506
20 - 39% = 553
40 - 59% = 1088
60 - 79% = 17452
80 - 99% = 65777
Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5773, nodes: 5464475
Average node length: 5.04, total dup: 5432501, max dup: 674
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 837586, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 253
40 - 59% = 3260
60 - 79% = 1670
80 - 99% = 585
Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6730, nodes: 5464475
Average node length: 5.51, total dup: 5044273, max dup: 49
Average key length: 2.53, compression ratio: 3.56
Average prefix length: 8.55, average data length: 0.45
Clustering factor: 300611, ratio: 0.06
Fill distribution:
0 - 19% = 103
20 - 39% = 1818
40 - 59% = 2761
60 - 79% = 644
80 - 99% = 1404
Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 6474, nodes: 5464475
Average node length: 5.68, total dup: 4903952, max dup: 85
Average key length: 2.69, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 920405, ratio: 0.17
Fill distribution:
0 - 19% = 4
20 - 39% = 247
40 - 59% = 3628
60 - 79% = 1908
80 - 99% = 687
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: 83.60, total records: 3593960
Average version length: 83.96, total versions: 6890, 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: 35, data page slots: 56808
Data pages: 56808, average fill: 78%
Primary pages: 56808, secondary pages: 0, swept pages: 40885
Empty pages: 53, full pages: 52535
Fill distribution:
0 - 19% = 129
20 - 39% = 243
40 - 59% = 1081
60 - 79% = 22650
80 - 99% = 32705
Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3966, nodes: 3593960
Average node length: 5.03, total dup: 3576323, max dup: 1398
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 716276, ratio: 0.20
Fill distribution:
0 - 19% = 36
20 - 39% = 470
40 - 59% = 2116
60 - 79% = 896
80 - 99% = 448
Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 6104, nodes: 3593960
Average node length: 6.27, total dup: 2928304, max dup: 14
Average key length: 3.29, compression ratio: 2.74
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 407158, ratio: 0.11
Fill distribution:
0 - 19% = 207
20 - 39% = 2626
40 - 59% = 1964
60 - 79% = 804
80 - 99% = 503
Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 4339, nodes: 3593960
Average node length: 5.58, total dup: 3281539, max dup: 77
Average key length: 2.60, compression ratio: 3.46
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 765216, ratio: 0.21
Fill distribution:
0 - 19% = 22
20 - 39% = 476
40 - 59% = 2209
60 - 79% = 1179
80 - 99% = 453
XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.34, total records: 690890
Average version length: 69.29, total versions: 1776, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 6, data page slots: 9496
Data pages: 9496, average fill: 77%
Primary pages: 9496, secondary pages: 0, swept pages: 7034
Empty pages: 4, full pages: 9291
Fill distribution:
0 - 19% = 5
20 - 39% = 8
40 - 59% = 36
60 - 79% = 9402
80 - 99% = 45
Index XQS_3300_3400_DOC_ID (0)
Root page: 175287, depth: 3, leaf buckets: 830, nodes: 690890
Average node length: 5.33, total dup: 650370, max dup: 136
Average key length: 2.45, compression ratio: 3.68
Average prefix length: 8.61, average data length: 0.39
Clustering factor: 60141, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 191
40 - 59% = 327
60 - 79% = 214
80 - 99% = 98
Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 945, nodes: 690890
Average node length: 5.94, total dup: 589705, max dup: 27
Average key length: 3.06, compression ratio: 2.95
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 64607, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 228
40 - 59% = 400
60 - 79% = 212
80 - 99% = 103
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
Done for 191160 ms, from 7:22:08.09 to 7:25:19.25.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2334577 |
2065 |
0.0884 |
DOC_LIST |
722195 |
537 |
0.0743 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
4302 |
966 |
22.4546 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
76 |
5 |
6.5789 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
265321 |
307 |
0.1157 |
PERF_ESTIMATED |
309435 |
0 |
0.0000 |
PERF_LOG |
13496414 |
0 |
0.0000 |
PSTORNED |
456867 |
924 |
0.2022 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
0 |
0.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
3305 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
4899 |
1267 |
25.8624 |
XQD_1000_3300 |
1215287 |
3172 |
0.2610 |
XQD_1200_2000 |
33765 |
2392 |
7.0842 |
XQD_2000_3300 |
1892134 |
30315 |
1.6021 |
XQD_2100_3300 |
1986 |
507 |
25.5287 |
XQD_3300_3400 |
2907070 |
9114 |
0.3135 |
XQS_1000_1200 |
5157523 |
1807 |
0.0350 |
XQS_1000_3300 |
2666954 |
7596 |
0.2848 |
XQS_1200_2000 |
5464475 |
14107 |
0.2581 |
XQS_2100_3300 |
3593960 |
6890 |
0.1917 |
XQS_3300_3400 |
690890 |
1776 |
0.2570 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2390 ms, from 7:25:31.76 to 7:25:34.15.
07:25:34.32 Validation started
07:25:34.35 Relation 140 (DOC_LIST)
07:25:34.35 process pointer page 0 of 6
07:25:34.46 process pointer page 1 of 6
07:25:34.57 process pointer page 2 of 6
07:25:34.68 process pointer page 3 of 6
07:25:34.77 process pointer page 4 of 6
07:25:34.88 process pointer page 5 of 6
07:25:34.95 Index 1 (PK_DOC_LIST)
07:25:35.26 Index 2 (DOC_LIST_ID_DESC)
07:25:35.57 Index 3 (FK_DOC_LIST_AGENTS)
07:25:35.87 Relation 140 (DOC_LIST) is ok
07:25:35.87 Relation 141 (DOC_DATA)
07:25:35.87 process pointer page 0 of 16
07:25:35.96 process pointer page 1 of 16
07:25:36.05 process pointer page 2 of 16
07:25:36.15 process pointer page 3 of 16
07:25:36.24 process pointer page 4 of 16
07:25:36.33 process pointer page 5 of 16
07:25:36.43 process pointer page 6 of 16
07:25:36.52 process pointer page 7 of 16
07:25:36.61 process pointer page 8 of 16
07:25:36.71 process pointer page 9 of 16
07:25:36.80 process pointer page 10 of 16
07:25:36.90 process pointer page 11 of 16
07:25:36.97 process pointer page 12 of 16
07:25:37.07 process pointer page 13 of 16
07:25:37.16 process pointer page 14 of 16
07:25:37.25 process pointer page 15 of 16
07:25:37.30 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:25:38.53 Index 3 (DOC_DATA_ID_DESC)
07:25:39.55 Index 4 (FK_DOC_DATA_DOC_LIST)
07:25:40.34 Relation 141 (DOC_DATA) is ok
07:25:40.34 Relation 147 (INVNT_SALDO)
07:25:40.34 process pointer page 0 of 1
07:25:40.34 Index 1 (PK_INVNT_SALDO)
07:25:40.34 Relation 147 (INVNT_SALDO) is ok
07:25:40.34 Relation 150 (PDISTR)
07:25:40.34 process pointer page 0 of 2
07:25:40.44 process pointer page 1 of 2
07:25:40.51 Index 2 (PDISTR_SND_ID)
07:25:40.61 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:25:40.70 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:25:40.80 Index 5 (PDISTR_AGENT_ID)
07:25:40.87 Relation 150 (PDISTR) is ok
07:25:40.87 Relation 151 (PSTORNED)
07:25:40.87 process pointer page 0 of 4
07:25:40.97 process pointer page 1 of 4
07:25:41.06 process pointer page 2 of 4
07:25:41.14 process pointer page 3 of 4
07:25:41.17 Index 2 (PSTORNED_SND_ID)
07:25:41.33 Index 3 (PSTORNED_RCV_ID)
07:25:41.47 Relation 151 (PSTORNED) is ok
07:25:41.47 Relation 156 (SEMAPHORES)
07:25:41.47 process pointer page 0 of 1
07:25:41.47 Index 1 (PK_SEMAPHORES)
07:25:41.47 Index 2 (SEMAPHORES_TASK_UNQ)
07:25:41.47 Relation 156 (SEMAPHORES) is ok
07:25:41.47 Relation 157 (INVNT_TURNOVER_LOG)
07:25:41.47 process pointer page 0 of 2
07:25:41.47 process pointer page 1 of 2
07:25:41.48 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:25:41.48 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:25:41.48 Relation 160 (PERF_ESTIMATED)
07:25:41.48 process pointer page 0 of 2
07:25:41.58 process pointer page 1 of 2
07:25:41.64 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:25:41.73 Relation 160 (PERF_ESTIMATED) is ok
07:25:41.73 Relation 161 (PERF_ISQL_STAT)
07:25:41.73 process pointer page 0 of 1
07:25:41.73 Index 1 (PERF_ISQL_STAT_TRN)
07:25:41.73 Relation 161 (PERF_ISQL_STAT) is ok
07:25:41.73 Relation 162 (TRACE_STAT)
07:25:41.73 process pointer page 0 of 1
07:25:41.73 Relation 162 (TRACE_STAT) is ok
07:25:41.73 Relation 163 (PERF_LOG)
07:25:41.73 process pointer page 0 of 197
07:25:41.83 process pointer page 1 of 197
07:25:41.90 process pointer page 2 of 197
07:25:41.98 process pointer page 3 of 197
07:25:42.06 process pointer page 4 of 197
07:25:42.15 process pointer page 5 of 197
07:25:42.23 process pointer page 6 of 197
07:25:42.31 process pointer page 7 of 197
07:25:42.39 process pointer page 8 of 197
07:25:42.48 process pointer page 9 of 197
07:25:42.56 process pointer page 10 of 197
07:25:42.64 process pointer page 11 of 197
07:25:42.71 process pointer page 12 of 197
07:25:42.81 process pointer page 13 of 197
07:25:42.89 process pointer page 14 of 197
07:25:42.96 process pointer page 15 of 197
07:25:43.04 process pointer page 16 of 197
07:25:43.14 process pointer page 17 of 197
07:25:43.21 process pointer page 18 of 197
07:25:43.29 process pointer page 19 of 197
07:25:43.37 process pointer page 20 of 197
07:25:43.46 process pointer page 21 of 197
07:25:43.54 process pointer page 22 of 197
07:25:43.62 process pointer page 23 of 197
07:25:43.70 process pointer page 24 of 197
07:25:43.78 process pointer page 25 of 197
07:25:43.87 process pointer page 26 of 197
07:25:43.95 process pointer page 27 of 197
07:25:44.02 process pointer page 28 of 197
07:25:44.10 process pointer page 29 of 197
07:25:44.20 process pointer page 30 of 197
07:25:44.27 process pointer page 31 of 197
07:25:44.35 process pointer page 32 of 197
07:25:44.43 process pointer page 33 of 197
07:25:44.51 process pointer page 34 of 197
07:25:44.59 process pointer page 35 of 197
07:25:44.66 process pointer page 36 of 197
07:25:44.76 process pointer page 37 of 197
07:25:44.84 process pointer page 38 of 197
07:25:44.91 process pointer page 39 of 197
07:25:44.99 process pointer page 40 of 197
07:25:45.07 process pointer page 41 of 197
07:25:45.15 process pointer page 42 of 197
07:25:45.23 process pointer page 43 of 197
07:25:45.32 process pointer page 44 of 197
07:25:45.40 process pointer page 45 of 197
07:25:45.48 process pointer page 46 of 197
07:25:45.55 process pointer page 47 of 197
07:25:45.63 process pointer page 48 of 197
07:25:45.71 process pointer page 49 of 197
07:25:45.79 process pointer page 50 of 197
07:25:45.88 process pointer page 51 of 197
07:25:45.96 process pointer page 52 of 197
07:25:46.04 process pointer page 53 of 197
07:25:46.12 process pointer page 54 of 197
07:25:46.19 process pointer page 55 of 197
07:25:46.27 process pointer page 56 of 197
07:25:46.35 process pointer page 57 of 197
07:25:46.44 process pointer page 58 of 197
07:25:46.52 process pointer page 59 of 197
07:25:46.60 process pointer page 60 of 197
07:25:46.68 process pointer page 61 of 197
07:25:46.75 process pointer page 62 of 197
07:25:46.83 process pointer page 63 of 197
07:25:46.91 process pointer page 64 of 197
07:25:46.99 process pointer page 65 of 197
07:25:47.07 process pointer page 66 of 197
07:25:47.14 process pointer page 67 of 197
07:25:47.24 process pointer page 68 of 197
07:25:47.32 process pointer page 69 of 197
07:25:47.39 process pointer page 70 of 197
07:25:47.47 process pointer page 71 of 197
07:25:47.55 process pointer page 72 of 197
07:25:47.63 process pointer page 73 of 197
07:25:47.72 process pointer page 74 of 197
07:25:47.80 process pointer page 75 of 197
07:25:47.88 process pointer page 76 of 197
07:25:47.96 process pointer page 77 of 197
07:25:48.03 process pointer page 78 of 197
07:25:48.11 process pointer page 79 of 197
07:25:48.19 process pointer page 80 of 197
07:25:48.27 process pointer page 81 of 197
07:25:48.35 process pointer page 82 of 197
07:25:48.44 process pointer page 83 of 197
07:25:48.52 process pointer page 84 of 197
07:25:48.60 process pointer page 85 of 197
07:25:48.67 process pointer page 86 of 197
07:25:48.75 process pointer page 87 of 197
07:25:48.83 process pointer page 88 of 197
07:25:48.92 process pointer page 89 of 197
07:25:49.00 process pointer page 90 of 197
07:25:49.08 process pointer page 91 of 197
07:25:49.16 process pointer page 92 of 197
07:25:49.24 process pointer page 93 of 197
07:25:49.31 process pointer page 94 of 197
07:25:49.41 process pointer page 95 of 197
07:25:49.48 process pointer page 96 of 197
07:25:49.56 process pointer page 97 of 197
07:25:49.64 process pointer page 98 of 197
07:25:49.72 process pointer page 99 of 197
07:25:49.80 process pointer page 100 of 197
07:25:49.89 process pointer page 101 of 197
07:25:49.97 process pointer page 102 of 197
07:25:50.05 process pointer page 103 of 197
07:25:50.12 process pointer page 104 of 197
07:25:50.20 process pointer page 105 of 197
07:25:50.28 process pointer page 106 of 197
07:25:50.37 process pointer page 107 of 197
07:25:50.45 process pointer page 108 of 197
07:25:50.53 process pointer page 109 of 197
07:25:50.61 process pointer page 110 of 197
07:25:50.69 process pointer page 111 of 197
07:25:50.76 process pointer page 112 of 197
07:25:50.84 process pointer page 113 of 197
07:25:50.92 process pointer page 114 of 197
07:25:51.00 process pointer page 115 of 197
07:25:51.09 process pointer page 116 of 197
07:25:51.17 process pointer page 117 of 197
07:25:51.25 process pointer page 118 of 197
07:25:51.33 process pointer page 119 of 197
07:25:51.40 process pointer page 120 of 197
07:25:51.50 process pointer page 121 of 197
07:25:51.58 process pointer page 122 of 197
07:25:51.65 process pointer page 123 of 197
07:25:51.73 process pointer page 124 of 197
07:25:51.81 process pointer page 125 of 197
07:25:51.90 process pointer page 126 of 197
07:25:51.98 process pointer page 127 of 197
07:25:52.06 process pointer page 128 of 197
07:25:52.14 process pointer page 129 of 197
07:25:52.23 process pointer page 130 of 197
07:25:52.31 process pointer page 131 of 197
07:25:52.39 process pointer page 132 of 197
07:25:52.46 process pointer page 133 of 197
07:25:52.54 process pointer page 134 of 197
07:25:52.64 process pointer page 135 of 197
07:25:52.71 process pointer page 136 of 197
07:25:52.79 process pointer page 137 of 197
07:25:52.87 process pointer page 138 of 197
07:25:52.95 process pointer page 139 of 197
07:25:53.03 process pointer page 140 of 197
07:25:53.12 process pointer page 141 of 197
07:25:53.20 process pointer page 142 of 197
07:25:53.28 process pointer page 143 of 197
07:25:53.35 process pointer page 144 of 197
07:25:53.43 process pointer page 145 of 197
07:25:53.53 process pointer page 146 of 197
07:25:53.60 process pointer page 147 of 197
07:25:53.68 process pointer page 148 of 197
07:25:53.76 process pointer page 149 of 197
07:25:53.84 process pointer page 150 of 197
07:25:53.93 process pointer page 151 of 197
07:25:54.01 process pointer page 152 of 197
07:25:54.09 process pointer page 153 of 197
07:25:54.16 process pointer page 154 of 197
07:25:54.24 process pointer page 155 of 197
07:25:54.32 process pointer page 156 of 197
07:25:54.41 process pointer page 157 of 197
07:25:54.49 process pointer page 158 of 197
07:25:54.57 process pointer page 159 of 197
07:25:54.65 process pointer page 160 of 197
07:25:54.73 process pointer page 161 of 197
07:25:54.82 process pointer page 162 of 197
07:25:54.90 process pointer page 163 of 197
07:25:54.98 process pointer page 164 of 197
07:25:55.05 process pointer page 165 of 197
07:25:55.13 process pointer page 166 of 197
07:25:55.21 process pointer page 167 of 197
07:25:55.30 process pointer page 168 of 197
07:25:55.38 process pointer page 169 of 197
07:25:55.46 process pointer page 170 of 197
07:25:55.54 process pointer page 171 of 197
07:25:55.62 process pointer page 172 of 197
07:25:55.69 process pointer page 173 of 197
07:25:55.79 process pointer page 174 of 197
07:25:55.87 process pointer page 175 of 197
07:25:55.94 process pointer page 176 of 197
07:25:56.02 process pointer page 177 of 197
07:25:56.10 process pointer page 178 of 197
07:25:56.19 process pointer page 179 of 197
07:25:56.27 process pointer page 180 of 197
07:25:56.35 process pointer page 181 of 197
07:25:56.43 process pointer page 182 of 197
07:25:56.52 process pointer page 183 of 197
07:25:56.60 process pointer page 184 of 197
07:25:56.68 process pointer page 185 of 197
07:25:56.75 process pointer page 186 of 197
07:25:56.83 process pointer page 187 of 197
07:25:56.91 process pointer page 188 of 197
07:25:56.99 process pointer page 189 of 197
07:25:57.08 process pointer page 190 of 197
07:25:57.16 process pointer page 191 of 197
07:25:57.24 process pointer page 192 of 197
07:25:57.32 process pointer page 193 of 197
07:25:57.39 process pointer page 194 of 197
07:25:57.47 process pointer page 195 of 197
07:25:57.55 process pointer page 196 of 197
07:25:57.60 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:26:02.73 Index 2 (PERF_LOG_UNIT)
07:26:10.01 Index 3 (PERF_LOG_TRN_DESC)
07:26:13.82 Index 4 (PERF_LOG_GDSCODE)
07:26:16.94 Relation 163 (PERF_LOG) is ok
07:26:16.94 Relation 167 (V_STOPTEST)
07:26:16.94 Relation 167 (V_STOPTEST) is ok
07:26:16.94 Relation 184 (V_QDISTR_SOURCE)
07:26:16.94 Relation 184 (V_QDISTR_SOURCE) is ok
07:26:16.94 Relation 185 (V_QSTORNED_SOURCE)
07:26:16.94 Relation 185 (V_QSTORNED_SOURCE) is ok
07:26:16.94 Relation 260 (XQD_1000_1200)
07:26:16.96 process pointer page 0 of 2
07:26:16.96 process pointer page 1 of 2
07:26:16.96 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:26:16.97 Relation 260 (XQD_1000_1200) is ok
07:26:16.97 Relation 261 (XQD_1200_2000)
07:26:16.97 process pointer page 0 of 3
07:26:17.00 process pointer page 1 of 3
07:26:17.00 process pointer page 2 of 3
07:26:17.02 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:26:17.03 Relation 261 (XQD_1200_2000) is ok
07:26:17.03 Relation 262 (XQD_1000_3300)
07:26:17.03 process pointer page 0 of 12
07:26:17.13 process pointer page 1 of 12
07:26:17.22 process pointer page 2 of 12
07:26:17.32 process pointer page 3 of 12
07:26:17.39 process pointer page 4 of 12
07:26:17.49 process pointer page 5 of 12
07:26:17.56 process pointer page 6 of 12
07:26:17.66 process pointer page 7 of 12
07:26:17.75 process pointer page 8 of 12
07:26:17.85 process pointer page 9 of 12
07:26:17.92 process pointer page 10 of 12
07:26:18.00 process pointer page 11 of 12
07:26:18.03 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:26:18.50 Index 2 (XQD_1000_3300_DOC)
07:26:18.84 Relation 262 (XQD_1000_3300) is ok
07:26:18.84 Relation 263 (XQD_2000_3300)
07:26:18.84 process pointer page 0 of 19
07:26:18.95 process pointer page 1 of 19
07:26:19.05 process pointer page 2 of 19
07:26:19.14 process pointer page 3 of 19
07:26:19.23 process pointer page 4 of 19
07:26:19.33 process pointer page 5 of 19
07:26:19.42 process pointer page 6 of 19
07:26:19.51 process pointer page 7 of 19
07:26:19.61 process pointer page 8 of 19
07:26:19.70 process pointer page 9 of 19
07:26:19.80 process pointer page 10 of 19
07:26:19.87 process pointer page 11 of 19
07:26:19.97 process pointer page 12 of 19
07:26:20.05 process pointer page 13 of 19
07:26:20.14 process pointer page 14 of 19
07:26:20.22 process pointer page 15 of 19
07:26:20.29 process pointer page 16 of 19
07:26:20.37 process pointer page 17 of 19
07:26:20.45 process pointer page 18 of 19
07:26:20.48 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:26:21.14 Relation 263 (XQD_2000_3300) is ok
07:26:21.14 Relation 264 (XQD_2100_3300)
07:26:21.15 process pointer page 0 of 4
07:26:21.15 process pointer page 1 of 4
07:26:21.15 process pointer page 2 of 4
07:26:21.15 process pointer page 3 of 4
07:26:21.15 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:26:21.17 Relation 264 (XQD_2100_3300) is ok
07:26:21.17 Relation 265 (XQD_3300_3400)
07:26:21.17 process pointer page 0 of 26
07:26:21.25 process pointer page 1 of 26
07:26:21.34 process pointer page 2 of 26
07:26:21.43 process pointer page 3 of 26
07:26:21.53 process pointer page 4 of 26
07:26:21.61 process pointer page 5 of 26
07:26:21.70 process pointer page 6 of 26
07:26:21.79 process pointer page 7 of 26
07:26:21.87 process pointer page 8 of 26
07:26:21.96 process pointer page 9 of 26
07:26:22.06 process pointer page 10 of 26
07:26:22.15 process pointer page 11 of 26
07:26:22.24 process pointer page 12 of 26
07:26:22.32 process pointer page 13 of 26
07:26:22.42 process pointer page 14 of 26
07:26:22.51 process pointer page 15 of 26
07:26:22.59 process pointer page 16 of 26
07:26:22.68 process pointer page 17 of 26
07:26:22.78 process pointer page 18 of 26
07:26:22.87 process pointer page 19 of 26
07:26:22.95 process pointer page 20 of 26
07:26:23.04 process pointer page 21 of 26
07:26:23.13 process pointer page 22 of 26
07:26:23.23 process pointer page 23 of 26
07:26:23.31 process pointer page 24 of 26
07:26:23.40 process pointer page 25 of 26
07:26:23.43 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:26:24.69 Relation 265 (XQD_3300_3400) is ok
07:26:24.69 Relation 266 (XQS_1000_1200)
07:26:24.69 process pointer page 0 of 49
07:26:24.79 process pointer page 1 of 49
07:26:24.87 process pointer page 2 of 49
07:26:24.96 process pointer page 3 of 49
07:26:25.05 process pointer page 4 of 49
07:26:25.15 process pointer page 5 of 49
07:26:25.24 process pointer page 6 of 49
07:26:25.33 process pointer page 7 of 49
07:26:25.41 process pointer page 8 of 49
07:26:25.51 process pointer page 9 of 49
07:26:25.60 process pointer page 10 of 49
07:26:25.69 process pointer page 11 of 49
07:26:25.79 process pointer page 12 of 49
07:26:25.88 process pointer page 13 of 49
07:26:25.96 process pointer page 14 of 49
07:26:26.05 process pointer page 15 of 49
07:26:26.14 process pointer page 16 of 49
07:26:26.24 process pointer page 17 of 49
07:26:26.33 process pointer page 18 of 49
07:26:26.41 process pointer page 19 of 49
07:26:26.50 process pointer page 20 of 49
07:26:26.60 process pointer page 21 of 49
07:26:26.69 process pointer page 22 of 49
07:26:26.77 process pointer page 23 of 49
07:26:26.86 process pointer page 24 of 49
07:26:26.96 process pointer page 25 of 49
07:26:27.05 process pointer page 26 of 49
07:26:27.13 process pointer page 27 of 49
07:26:27.22 process pointer page 28 of 49
07:26:27.31 process pointer page 29 of 49
07:26:27.41 process pointer page 30 of 49
07:26:27.49 process pointer page 31 of 49
07:26:27.58 process pointer page 32 of 49
07:26:27.67 process pointer page 33 of 49
07:26:27.77 process pointer page 34 of 49
07:26:27.85 process pointer page 35 of 49
07:26:27.94 process pointer page 36 of 49
07:26:28.03 process pointer page 37 of 49
07:26:28.13 process pointer page 38 of 49
07:26:28.19 process pointer page 39 of 49
07:26:28.24 process pointer page 40 of 49
07:26:28.33 process pointer page 41 of 49
07:26:28.41 process pointer page 42 of 49
07:26:28.50 process pointer page 43 of 49
07:26:28.59 process pointer page 44 of 49
07:26:28.69 process pointer page 45 of 49
07:26:28.77 process pointer page 46 of 49
07:26:28.86 process pointer page 47 of 49
07:26:28.95 process pointer page 48 of 49
07:26:29.00 Index 1 (XQS_1000_1200_DOC_ID)
07:26:30.54 Index 2 (XQS_1000_1200_SND_ID)
07:26:32.12 Index 3 (XQS_1000_1200_RCV_ID)
07:26:33.43 Relation 266 (XQS_1000_1200) is ok
07:26:33.43 Relation 267 (XQS_1200_2000)
07:26:33.43 process pointer page 0 of 53
07:26:33.52 process pointer page 1 of 53
07:26:33.62 process pointer page 2 of 53
07:26:33.71 process pointer page 3 of 53
07:26:33.80 process pointer page 4 of 53
07:26:33.90 process pointer page 5 of 53
07:26:33.99 process pointer page 6 of 53
07:26:34.09 process pointer page 7 of 53
07:26:34.18 process pointer page 8 of 53
07:26:34.27 process pointer page 9 of 53
07:26:34.38 process pointer page 10 of 53
07:26:34.48 process pointer page 11 of 53
07:26:34.58 process pointer page 12 of 53
07:26:34.69 process pointer page 13 of 53
07:26:34.80 process pointer page 14 of 53
07:26:34.91 process pointer page 15 of 53
07:26:35.02 process pointer page 16 of 53
07:26:35.13 process pointer page 17 of 53
07:26:35.22 process pointer page 18 of 53
07:26:35.33 process pointer page 19 of 53
07:26:35.44 process pointer page 20 of 53
07:26:35.55 process pointer page 21 of 53
07:26:35.66 process pointer page 22 of 53
07:26:35.75 process pointer page 23 of 53
07:26:35.86 process pointer page 24 of 53
07:26:35.97 process pointer page 25 of 53
07:26:36.08 process pointer page 26 of 53
07:26:36.18 process pointer page 27 of 53
07:26:36.28 process pointer page 28 of 53
07:26:36.39 process pointer page 29 of 53
07:26:36.50 process pointer page 30 of 53
07:26:36.60 process pointer page 31 of 53
07:26:36.71 process pointer page 32 of 53
07:26:36.82 process pointer page 33 of 53
07:26:36.91 process pointer page 34 of 53
07:26:37.02 process pointer page 35 of 53
07:26:37.13 process pointer page 36 of 53
07:26:37.24 process pointer page 37 of 53
07:26:37.33 process pointer page 38 of 53
07:26:37.44 process pointer page 39 of 53
07:26:37.55 process pointer page 40 of 53
07:26:37.66 process pointer page 41 of 53
07:26:37.92 process pointer page 42 of 53
07:26:38.38 process pointer page 43 of 53
07:26:38.75 process pointer page 44 of 53
07:26:39.16 process pointer page 45 of 53
07:26:39.50 process pointer page 46 of 53
07:26:39.92 process pointer page 47 of 53
07:26:40.25 process pointer page 48 of 53
07:26:40.65 process pointer page 49 of 53
07:26:41.07 process pointer page 50 of 53
07:26:41.40 process pointer page 51 of 53
07:26:41.76 process pointer page 52 of 53
07:26:41.89 Index 1 (XQS_1200_2000_DOC_ID)
07:26:45.05 Index 2 (XQS_1200_2000_SND_ID)
07:26:48.00 Index 3 (XQS_1200_2000_RCV_ID)
07:26:50.96 Relation 267 (XQS_1200_2000) is ok
07:26:50.96 Relation 268 (XQS_1000_3300)
07:26:50.98 process pointer page 0 of 26
07:26:51.45 process pointer page 1 of 26
07:26:51.92 process pointer page 2 of 26
07:26:52.40 process pointer page 3 of 26
07:26:52.88 process pointer page 4 of 26
07:26:53.35 process pointer page 5 of 26
07:26:53.83 process pointer page 6 of 26
07:26:54.30 process pointer page 7 of 26
07:26:54.77 process pointer page 8 of 26
07:26:55.25 process pointer page 9 of 26
07:26:55.72 process pointer page 10 of 26
07:26:56.21 process pointer page 11 of 26
07:26:56.67 process pointer page 12 of 26
07:26:57.17 process pointer page 13 of 26
07:26:57.61 process pointer page 14 of 26
07:26:58.06 process pointer page 15 of 26
07:26:58.50 process pointer page 16 of 26
07:26:58.94 process pointer page 17 of 26
07:26:59.37 process pointer page 18 of 26
07:26:59.81 process pointer page 19 of 26
07:27:00.25 process pointer page 20 of 26
07:27:00.70 process pointer page 21 of 26
07:27:01.12 process pointer page 22 of 26
07:27:01.57 process pointer page 23 of 26
07:27:01.99 process pointer page 24 of 26
07:27:02.38 process pointer page 25 of 26
07:27:02.56 Index 1 (XQS_1000_3300_DOC_ID)
07:27:04.18 Index 2 (XQS_1000_3300_SND_ID)
07:27:05.94 Index 3 (XQS_1000_3300_RCV_ID)
07:27:07.77 Relation 268 (XQS_1000_3300) is ok
07:27:07.77 Relation 269 (XQS_2000_3300)
07:27:07.78 process pointer page 0 of 1
07:27:07.78 Index 1 (XQS_2000_3300_DOC_ID)
07:27:07.78 Index 2 (XQS_2000_3300_SND_ID)
07:27:07.78 Index 3 (XQS_2000_3300_RCV_ID)
07:27:07.78 Relation 269 (XQS_2000_3300) is ok
07:27:07.78 Relation 270 (XQS_2100_3300)
07:27:07.78 process pointer page 0 of 35
07:27:08.22 process pointer page 1 of 35
07:27:08.67 process pointer page 2 of 35
07:27:09.12 process pointer page 3 of 35
07:27:09.58 process pointer page 4 of 35
07:27:10.03 process pointer page 5 of 35
07:27:10.48 process pointer page 6 of 35
07:27:10.93 process pointer page 7 of 35
07:27:11.38 process pointer page 8 of 35
07:27:11.84 process pointer page 9 of 35
07:27:12.29 process pointer page 10 of 35
07:27:12.73 process pointer page 11 of 35
07:27:13.18 process pointer page 12 of 35
07:27:13.62 process pointer page 13 of 35
07:27:14.07 process pointer page 14 of 35
07:27:14.52 process pointer page 15 of 35
07:27:14.96 process pointer page 16 of 35
07:27:15.41 process pointer page 17 of 35
07:27:15.85 process pointer page 18 of 35
07:27:16.30 process pointer page 19 of 35
07:27:16.74 process pointer page 20 of 35
07:27:17.17 process pointer page 21 of 35
07:27:17.61 process pointer page 22 of 35
07:27:18.05 process pointer page 23 of 35
07:27:18.48 process pointer page 24 of 35
07:27:18.92 process pointer page 25 of 35
07:27:19.36 process pointer page 26 of 35
07:27:19.78 process pointer page 27 of 35
07:27:20.21 process pointer page 28 of 35
07:27:20.65 process pointer page 29 of 35
07:27:21.09 process pointer page 30 of 35
07:27:21.51 process pointer page 31 of 35
07:27:21.93 process pointer page 32 of 35
07:27:22.35 process pointer page 33 of 35
07:27:22.71 process pointer page 34 of 35
07:27:22.99 Index 1 (XQS_2100_3300_DOC_ID)
07:27:25.19 Index 2 (XQS_2100_3300_SND_ID)
07:27:27.55 Index 3 (XQS_2100_3300_RCV_ID)
07:27:30.06 Relation 270 (XQS_2100_3300) is ok
07:27:30.06 Relation 271 (XQS_3300_3400)
07:27:30.06 process pointer page 0 of 6
07:27:30.51 process pointer page 1 of 6
07:27:30.96 process pointer page 2 of 6
07:27:31.43 process pointer page 3 of 6
07:27:31.88 process pointer page 4 of 6
07:27:32.34 process pointer page 5 of 6
07:27:32.68 Index 1 (XQS_3300_3400_DOC_ID)
07:27:33.07 Index 2 (XQS_3300_3400_SND_ID)
07:27:33.51 Relation 271 (XQS_3300_3400) is ok
07:27:33.54 Validation finished
Done for 119470 ms, from 7:25:34.18 to 7:27:33.65.
Differences between old and current firebird.log
7:27:35.24. 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-02-10 07:27 504 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 Fri Feb 10 07:25:34 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Fri Feb 10 07:27:33 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-02-10 7:27:47.25 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html