Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-08-22 6:50:36.74.
Server version: WI-V3.0.3.32798 Firebird 3.0
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperServer 3.0.3 |
D:\OLTP-EMUL\OLTP30-SMALL.FDB |
ON |
0 |
786432 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp30_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB30.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp30-small.fdb |
host |
localhost |
port |
3333 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp30 |
working_mode |
small_03 |
warm_time |
0 |
test_time |
180 |
idle_time |
0 |
use_mtee |
0 |
is_embed |
0 |
remove_isql_logs |
if_no_severe_errors |
no_auto_undo |
1 |
detailed_info |
0 |
mon_unit_perf |
0 |
trc_unit_perf |
1 |
init_buff |
32768 |
create_with_fw |
sync |
create_with_sweep |
0 |
wait_if_not_exists |
0 |
wait_after_create |
0 |
init_docs |
100000 |
wait_for_copy |
0 |
create_with_debug_objects |
1 |
create_with_split_heavy_tabs |
1 |
create_with_separate_qdistr_idx |
0 |
create_with_compound_columns_order |
most_selective_first |
make_html |
1 |
run_db_statistics |
1 |
run_db_validation |
1 |
file_name_with_test_params |
regular |
file_name_this_host_info |
cpu_8x3Ghz_ram_16gb |
upload_report |
1 |
max_snapshots_to_store |
720 |
replace_instance |
1 |
etalon_dbnm |
E:\OLTP-EMUL\oltp30-docs_100000-fw__ON.fdb |
used_in_replication |
0 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2017-08-22 06:47:05.8340 |
-1 |
<null> |
|
::1/51742 |
419021 |
9259 |
2 |
CATEGORY |
SETTING |
VAL |
COMMON |
TRACED_UNITS |
,, |
COMMON |
ENABLE_MON_QUERY |
0 |
COMMON |
HALT_TEST_ON_ERRORS |
,CK, |
COMMON |
QMISM_VERIFY_BITSET |
1 |
COMMON |
RECALC_IDX_MIN_INTERVAL |
15 |
COMMON |
ENABLE_RESERVES_WHEN_ADD_INVOICE |
1 |
COMMON |
ORDER_FOR_OUR_FIRM_PERCENT |
25 |
COMMON |
ENABLE_FILL_PHRASES |
0 |
COMMON |
RANDOM_SEEK_VIA_ROWS_LIMIT |
0 |
COMMON |
C_INVOICE_MIN_PURCHASE |
1000 |
COMMON |
C_INVOICE_MAX_PURCHASE |
2000 |
COMMON |
C_INVOICE_MIN_PROFIT_PRC |
35 |
COMMON |
C_INVOICE_MAX_PROFIT_PRC |
80 |
COMMON |
C_MIN_COST_TO_BE_SPLITTED |
1000 |
COMMON |
C_ROWS_TO_MULTIPLY |
10 |
COMMON |
C_PAYMENT_FROM_CLIENT_MIN_TOTAL |
1000 |
COMMON |
C_PAYMENT_FROM_CLIENT_MAX_TOTAL |
5000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MIN_TOTAL |
2000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MAX_TOTAL |
15000 |
COMMON |
BUILD_WITH_SPLIT_HEAVY_TABS |
1 |
COMMON |
BUILD_WITH_SEPAR_QDISTR_IDX |
0 |
COMMON |
BUILD_WITH_QD_COMPOUND_ORDR |
MOST_SELECTIVE_FIRST |
SMALL_03 |
C_WARES_MAX_ID |
400 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_ROWS |
10 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_ROWS |
50 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_QTY |
15 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_QTY |
50 |
SMALL_03 |
C_NUMBER_OF_AGENTS |
50 |
TAB_NAME |
IDX_NAME |
IDX_KEY |
XQD_1000_1200 |
XQD_1000_1200_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1000_3300 |
XQD_1000_3300_DOC |
DOC_ID |
XQD_1000_3300 |
XQD_1000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1200_2000 |
XQD_1200_2000_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2000_3300 |
XQD_2000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2100_3300 |
XQD_2100_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_3300_3400 |
XQD_3300_3400_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
Performance reports
ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
5917.97 |
2991 |
1065235 |
2017-08-22 03:47 |
2017-08-22 06:47 |
customer order: creation |
428.76 |
453 |
77177 |
2017-08-22 03:47 |
2017-08-22 06:47 |
customer order: refuse |
35.40 |
222 |
6372 |
2017-08-22 03:47 |
2017-08-22 06:47 |
order to supplier: creation |
109.26 |
1947 |
19667 |
2017-08-22 03:47 |
2017-08-22 06:47 |
order to supplier: removal |
2.97 |
17187 |
532 |
2017-08-22 03:47 |
2017-08-22 06:47 |
invoice (draft): creation |
110.13 |
2953 |
19824 |
2017-08-22 03:47 |
2017-08-22 06:47 |
invoice (draft): removal |
42.57 |
393 |
7662 |
2017-08-22 03:47 |
2017-08-22 06:47 |
invoice accept: apply |
60.75 |
10422 |
10875 |
2017-08-22 03:47 |
2017-08-22 06:47 |
invoice accept: cancel |
18.22 |
2556 |
3261 |
2017-08-22 03:47 |
2017-08-22 06:47 |
customer reserve: creation |
3381.66 |
151 |
608698 |
2017-08-22 03:47 |
2017-08-22 06:47 |
customer reserve: removal |
1140.25 |
55 |
204104 |
2017-08-22 03:47 |
2017-08-22 06:47 |
realization accept: apply |
197.48 |
506 |
35546 |
2017-08-22 03:47 |
2017-08-22 06:47 |
realization accept: cancel |
88.96 |
137 |
16012 |
2017-08-22 03:47 |
2017-08-22 06:47 |
payment from customer: creation |
143.71 |
823 |
25868 |
2017-08-22 03:47 |
2017-08-22 06:47 |
payment from customer: removal |
13.42 |
132 |
2415 |
2017-08-22 03:47 |
2017-08-22 06:47 |
payment to supplier: creation |
118.27 |
726 |
21288 |
2017-08-22 03:47 |
2017-08-22 06:47 |
payment to supplier: removal |
8.18 |
128 |
1465 |
2017-08-22 03:47 |
2017-08-22 06:47 |
service: total inventory turnovers |
9.19 |
2555 |
1654 |
2017-08-22 03:47 |
2017-08-22 06:47 |
service: total monetary turnovers |
15.57 |
66 |
2803 |
2017-08-22 03:47 |
2017-08-22 06:47 |
service: refresh index statistics |
0.07 |
15415 |
12 |
2017-08-22 03:47 |
2017-08-22 06:47 |
Done for 82270 ms, from 6:53:00.67 to 6:54:22.94.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
4267 |
90394 |
76809 |
13585 |
15.03 |
03:47:06 |
04:05:06 |
interval # 2, overall |
2 |
6224 |
125751 |
112039 |
13712 |
10.90 |
04:05:07 |
04:23:07 |
interval # 3, overall |
3 |
6249 |
127521 |
112484 |
15037 |
11.79 |
04:23:08 |
04:41:08 |
interval # 4, overall |
4 |
5698 |
114900 |
102566 |
12334 |
10.73 |
04:41:09 |
04:59:09 |
interval # 5, overall |
5 |
6099 |
123916 |
109780 |
14136 |
11.41 |
04:59:10 |
05:17:10 |
interval # 6, overall |
6 |
6017 |
120757 |
108303 |
12454 |
10.31 |
05:17:11 |
05:35:11 |
interval # 7, overall |
7 |
5948 |
123851 |
107064 |
16787 |
13.55 |
05:35:12 |
05:53:12 |
interval # 8, overall |
8 |
6128 |
121174 |
110303 |
10871 |
8.97 |
05:53:13 |
06:11:13 |
interval # 9, overall |
9 |
6673 |
133594 |
120106 |
13488 |
10.10 |
06:11:14 |
06:29:14 |
interval # 10, overall |
10 |
5877 |
116271 |
105781 |
10490 |
9.02 |
06:29:15 |
06:47:15 |
Done for 222310 ms, from 6:58:09.60 to 7:01:51.91.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
3943.90 |
0.5489 |
1.4440 |
1961 |
99 |
TEST_TIME |
2 |
3812.47 |
0.7472 |
1.2646 |
2039 |
99 |
TEST_TIME |
3 |
3869.28 |
0.8308 |
1.1352 |
2055 |
99 |
TEST_TIME |
4 |
3694.00 |
0.8919 |
1.1474 |
1626 |
99 |
TEST_TIME |
5 |
3739.44 |
0.9069 |
1.0961 |
1506 |
99 |
TEST_TIME |
6 |
3730.31 |
0.9156 |
1.1044 |
1156 |
99 |
TEST_TIME |
7 |
3819.33 |
0.9246 |
1.0786 |
1729 |
99 |
TEST_TIME |
8 |
3901.08 |
0.9242 |
1.0704 |
1628 |
99 |
TEST_TIME |
9 |
3984.02 |
0.9318 |
1.0622 |
1739 |
99 |
TEST_TIME |
10 |
4091.66 |
0.9316 |
1.0690 |
1535 |
99 |
TEST_TIME |
11 |
4172.43 |
0.9530 |
1.0558 |
1516 |
99 |
TEST_TIME |
12 |
4251.68 |
0.9498 |
1.0511 |
1553 |
99 |
TEST_TIME |
13 |
4275.37 |
0.9649 |
1.0355 |
1636 |
99 |
TEST_TIME |
14 |
4297.77 |
0.9577 |
1.0445 |
1477 |
99 |
TEST_TIME |
15 |
4270.40 |
0.9811 |
1.0161 |
1532 |
96 |
TEST_TIME |
16 |
4215.06 |
0.9652 |
1.0523 |
1699 |
97 |
TEST_TIME |
17 |
4359.89 |
0.9575 |
1.0232 |
1639 |
99 |
TEST_TIME |
18 |
4297.85 |
0.9804 |
1.0400 |
1246 |
96 |
TEST_TIME |
19 |
4348.53 |
0.9753 |
1.0318 |
1548 |
99 |
TEST_TIME |
20 |
4325.26 |
0.9855 |
1.0528 |
1490 |
98 |
TEST_TIME |
21 |
4447.62 |
0.9751 |
1.0335 |
1469 |
99 |
TEST_TIME |
22 |
4547.25 |
0.9649 |
1.0331 |
1674 |
99 |
TEST_TIME |
23 |
4602.92 |
0.9763 |
1.0263 |
1130 |
99 |
TEST_TIME |
24 |
4657.31 |
0.9720 |
1.0320 |
1643 |
99 |
TEST_TIME |
25 |
4723.65 |
0.9768 |
1.0274 |
1569 |
99 |
TEST_TIME |
26 |
4774.52 |
0.9774 |
1.0285 |
1399 |
99 |
TEST_TIME |
27 |
4823.50 |
0.9807 |
1.0199 |
1343 |
99 |
TEST_TIME |
28 |
4829.97 |
0.9822 |
1.0178 |
1416 |
99 |
TEST_TIME |
29 |
4831.39 |
0.9826 |
1.0194 |
1303 |
99 |
TEST_TIME |
30 |
4889.48 |
0.9737 |
1.0257 |
1891 |
99 |
TEST_TIME |
31 |
5005.60 |
0.9696 |
1.0267 |
1940 |
99 |
TEST_TIME |
32 |
5104.96 |
0.9759 |
1.0280 |
1884 |
99 |
TEST_TIME |
33 |
5194.17 |
0.9797 |
1.0213 |
1862 |
99 |
TEST_TIME |
34 |
5268.88 |
0.9772 |
1.0201 |
1759 |
99 |
TEST_TIME |
35 |
5273.69 |
0.9901 |
1.0104 |
1695 |
99 |
TEST_TIME |
36 |
5284.05 |
0.9804 |
1.0170 |
1172 |
99 |
TEST_TIME |
37 |
5274.78 |
0.9913 |
1.0067 |
1374 |
99 |
TEST_TIME |
38 |
5216.00 |
0.9913 |
1.0180 |
1103 |
99 |
TEST_TIME |
39 |
5221.44 |
0.9908 |
1.0139 |
1278 |
99 |
TEST_TIME |
40 |
5221.06 |
0.9886 |
1.0138 |
1286 |
99 |
TEST_TIME |
41 |
5215.47 |
0.9902 |
1.0070 |
1447 |
98 |
TEST_TIME |
42 |
5192.35 |
0.9874 |
1.0114 |
1374 |
99 |
TEST_TIME |
43 |
5200.22 |
0.9864 |
1.0135 |
1219 |
99 |
TEST_TIME |
44 |
5216.07 |
0.9875 |
1.0114 |
1236 |
99 |
TEST_TIME |
45 |
5246.24 |
0.9843 |
1.0147 |
2203 |
99 |
TEST_TIME |
46 |
5285.53 |
0.9852 |
1.0136 |
1729 |
99 |
TEST_TIME |
47 |
5322.52 |
0.9851 |
1.0175 |
1668 |
99 |
TEST_TIME |
48 |
5407.21 |
0.9813 |
1.0168 |
1793 |
99 |
TEST_TIME |
49 |
5448.17 |
0.9886 |
1.0132 |
1659 |
99 |
TEST_TIME |
50 |
5495.53 |
0.9849 |
1.0131 |
1596 |
99 |
TEST_TIME |
51 |
5532.58 |
0.9866 |
1.0216 |
1571 |
99 |
TEST_TIME |
52 |
5608.87 |
0.9884 |
1.0126 |
1264 |
99 |
TEST_TIME |
53 |
5622.20 |
0.9912 |
1.0072 |
1236 |
99 |
TEST_TIME |
54 |
5612.96 |
0.9902 |
1.0107 |
1131 |
99 |
TEST_TIME |
55 |
5611.58 |
0.9926 |
1.0055 |
1306 |
98 |
TEST_TIME |
56 |
5566.00 |
0.9956 |
1.0094 |
1237 |
97 |
TEST_TIME |
57 |
5547.90 |
0.9949 |
1.0083 |
1176 |
99 |
TEST_TIME |
58 |
5540.41 |
0.9928 |
1.0069 |
1008 |
99 |
TEST_TIME |
59 |
5532.06 |
0.9914 |
1.0071 |
1155 |
99 |
TEST_TIME |
60 |
5529.53 |
0.9908 |
1.0114 |
1567 |
99 |
TEST_TIME |
61 |
5532.07 |
0.9944 |
1.0150 |
1775 |
98 |
TEST_TIME |
62 |
5563.45 |
0.9930 |
1.0064 |
2078 |
98 |
TEST_TIME |
63 |
5561.36 |
0.9908 |
1.0044 |
1479 |
99 |
TEST_TIME |
64 |
5558.52 |
0.9893 |
1.0077 |
1511 |
98 |
TEST_TIME |
65 |
5548.50 |
0.9940 |
1.0071 |
1762 |
96 |
TEST_TIME |
66 |
5560.80 |
0.9896 |
1.0085 |
1440 |
98 |
TEST_TIME |
67 |
5574.08 |
0.9911 |
1.0064 |
1311 |
99 |
TEST_TIME |
68 |
5581.54 |
0.9903 |
1.0080 |
1373 |
99 |
TEST_TIME |
69 |
5590.93 |
0.9917 |
1.0121 |
1512 |
99 |
TEST_TIME |
70 |
5623.26 |
0.9919 |
1.0069 |
1541 |
99 |
TEST_TIME |
71 |
5619.30 |
0.9934 |
1.0051 |
1492 |
99 |
TEST_TIME |
72 |
5622.27 |
0.9906 |
1.0073 |
1234 |
99 |
TEST_TIME |
73 |
5628.41 |
0.9924 |
1.0050 |
1208 |
98 |
TEST_TIME |
74 |
5600.64 |
0.9964 |
1.0073 |
1138 |
99 |
TEST_TIME |
75 |
5599.79 |
0.9941 |
1.0055 |
1644 |
99 |
TEST_TIME |
76 |
5604.69 |
0.9914 |
1.0084 |
1470 |
99 |
TEST_TIME |
77 |
5640.47 |
0.9890 |
1.0054 |
1614 |
99 |
TEST_TIME |
78 |
5626.02 |
0.9950 |
1.0100 |
1546 |
97 |
TEST_TIME |
79 |
5642.87 |
0.9943 |
1.0039 |
1658 |
99 |
TEST_TIME |
80 |
5666.15 |
0.9909 |
1.0051 |
1378 |
99 |
TEST_TIME |
81 |
5666.72 |
0.9926 |
1.0086 |
1418 |
99 |
TEST_TIME |
82 |
5672.51 |
0.9953 |
1.0094 |
1470 |
99 |
TEST_TIME |
83 |
5681.50 |
0.9956 |
1.0037 |
1712 |
98 |
TEST_TIME |
84 |
5674.80 |
0.9929 |
1.0089 |
1386 |
99 |
TEST_TIME |
85 |
5707.50 |
0.9913 |
1.0080 |
1135 |
99 |
TEST_TIME |
86 |
5721.89 |
0.9938 |
1.0052 |
1083 |
99 |
TEST_TIME |
87 |
5720.89 |
0.9939 |
1.0064 |
1292 |
99 |
TEST_TIME |
88 |
5723.97 |
0.9945 |
1.0061 |
1131 |
99 |
TEST_TIME |
89 |
5733.15 |
0.9932 |
1.0049 |
931 |
99 |
TEST_TIME |
90 |
5735.17 |
0.9934 |
1.0041 |
1828 |
99 |
TEST_TIME |
91 |
5726.04 |
0.9947 |
1.0081 |
1735 |
95 |
TEST_TIME |
92 |
5743.00 |
0.9942 |
1.0104 |
1573 |
98 |
TEST_TIME |
93 |
5777.43 |
0.9936 |
1.0053 |
1650 |
99 |
TEST_TIME |
94 |
5783.17 |
0.9936 |
1.0073 |
1669 |
99 |
TEST_TIME |
95 |
5791.37 |
0.9953 |
1.0058 |
1434 |
99 |
TEST_TIME |
96 |
5784.32 |
0.9965 |
1.0046 |
1201 |
98 |
TEST_TIME |
97 |
5780.56 |
0.9949 |
1.0044 |
1389 |
99 |
TEST_TIME |
98 |
5778.93 |
0.9944 |
1.0054 |
1260 |
99 |
TEST_TIME |
99 |
5799.83 |
0.9920 |
1.0047 |
1186 |
99 |
TEST_TIME |
100 |
5806.11 |
0.9935 |
1.0063 |
1028 |
99 |
TEST_TIME |
101 |
5807.09 |
0.9962 |
1.0025 |
1309 |
99 |
TEST_TIME |
102 |
5776.38 |
0.9979 |
1.0022 |
1206 |
95 |
TEST_TIME |
103 |
5769.94 |
0.9935 |
1.0035 |
1121 |
99 |
TEST_TIME |
104 |
5749.00 |
0.9975 |
1.0038 |
1180 |
98 |
TEST_TIME |
105 |
5733.46 |
0.9969 |
1.0034 |
1305 |
97 |
TEST_TIME |
106 |
5750.69 |
0.9913 |
1.0040 |
1965 |
99 |
TEST_TIME |
107 |
5752.37 |
0.9943 |
1.0063 |
1793 |
98 |
TEST_TIME |
108 |
5775.54 |
0.9930 |
1.0066 |
1502 |
99 |
TEST_TIME |
109 |
5796.05 |
0.9940 |
1.0056 |
1892 |
99 |
TEST_TIME |
110 |
5808.46 |
0.9943 |
1.0052 |
1513 |
99 |
TEST_TIME |
111 |
5814.97 |
0.9950 |
1.0050 |
1466 |
99 |
TEST_TIME |
112 |
5827.98 |
0.9938 |
1.0040 |
1457 |
99 |
TEST_TIME |
113 |
5819.61 |
0.9966 |
1.0031 |
1443 |
98 |
TEST_TIME |
114 |
5806.13 |
0.9966 |
1.0036 |
1378 |
94 |
TEST_TIME |
115 |
5798.58 |
0.9961 |
1.0031 |
1060 |
90 |
TEST_TIME |
116 |
5806.16 |
0.9982 |
1.0029 |
1295 |
93 |
TEST_TIME |
117 |
5806.88 |
0.9942 |
1.0060 |
866 |
97 |
TEST_TIME |
118 |
5805.15 |
0.9978 |
1.0051 |
1008 |
99 |
TEST_TIME |
119 |
5799.98 |
0.9975 |
1.0030 |
1108 |
99 |
TEST_TIME |
120 |
5793.00 |
0.9958 |
1.0054 |
1625 |
99 |
TEST_TIME |
121 |
5794.72 |
0.9968 |
1.0031 |
1835 |
98 |
TEST_TIME |
122 |
5799.86 |
0.9940 |
1.0023 |
1616 |
98 |
TEST_TIME |
123 |
5795.76 |
0.9948 |
1.0029 |
1629 |
98 |
TEST_TIME |
124 |
5798.63 |
0.9944 |
1.0033 |
1532 |
93 |
TEST_TIME |
125 |
5798.93 |
0.9952 |
1.0024 |
1613 |
96 |
TEST_TIME |
126 |
5788.68 |
0.9962 |
1.0035 |
1476 |
94 |
TEST_TIME |
127 |
5783.21 |
0.9965 |
1.0034 |
1382 |
92 |
TEST_TIME |
128 |
5787.90 |
0.9947 |
1.0028 |
1201 |
96 |
TEST_TIME |
129 |
5769.83 |
0.9981 |
1.0026 |
1295 |
96 |
TEST_TIME |
130 |
5785.05 |
0.9951 |
1.0020 |
1394 |
98 |
TEST_TIME |
131 |
5771.02 |
0.9968 |
1.0054 |
1215 |
98 |
TEST_TIME |
132 |
5801.63 |
0.9925 |
1.0039 |
1144 |
99 |
TEST_TIME |
133 |
5804.31 |
0.9959 |
1.0038 |
1206 |
99 |
TEST_TIME |
134 |
5811.16 |
0.9952 |
1.0049 |
1112 |
99 |
TEST_TIME |
135 |
5821.66 |
0.9957 |
1.0028 |
1814 |
98 |
TEST_TIME |
136 |
5834.40 |
0.9933 |
1.0051 |
1533 |
99 |
TEST_TIME |
137 |
5850.38 |
0.9953 |
1.0042 |
1681 |
99 |
TEST_TIME |
138 |
5850.16 |
0.9971 |
1.0029 |
1459 |
97 |
TEST_TIME |
139 |
5858.83 |
0.9943 |
1.0028 |
1463 |
94 |
TEST_TIME |
140 |
5861.64 |
0.9953 |
1.0022 |
1273 |
97 |
TEST_TIME |
141 |
5855.14 |
0.9962 |
1.0031 |
1224 |
95 |
TEST_TIME |
142 |
5842.19 |
0.9983 |
1.0028 |
1242 |
96 |
TEST_TIME |
143 |
5831.44 |
0.9977 |
1.0025 |
1500 |
95 |
TEST_TIME |
144 |
5825.31 |
0.9966 |
1.0034 |
1372 |
95 |
TEST_TIME |
145 |
5819.40 |
0.9975 |
1.0026 |
1316 |
88 |
TEST_TIME |
146 |
5816.57 |
0.9962 |
1.0032 |
1283 |
92 |
TEST_TIME |
147 |
5821.91 |
0.9955 |
1.0039 |
1045 |
99 |
TEST_TIME |
148 |
5829.22 |
0.9959 |
1.0029 |
1075 |
98 |
TEST_TIME |
149 |
5822.33 |
0.9974 |
1.0047 |
1191 |
99 |
TEST_TIME |
150 |
5838.12 |
0.9953 |
1.0056 |
1634 |
99 |
TEST_TIME |
151 |
5861.62 |
0.9950 |
1.0057 |
1506 |
99 |
TEST_TIME |
152 |
5886.10 |
0.9951 |
1.0044 |
1465 |
99 |
TEST_TIME |
153 |
5897.98 |
0.9958 |
1.0057 |
1394 |
99 |
TEST_TIME |
154 |
5921.41 |
0.9953 |
1.0057 |
1449 |
99 |
TEST_TIME |
155 |
5940.53 |
0.9960 |
1.0032 |
1279 |
99 |
TEST_TIME |
156 |
5953.77 |
0.9945 |
1.0046 |
1259 |
99 |
TEST_TIME |
157 |
5960.99 |
0.9970 |
1.0035 |
1332 |
99 |
TEST_TIME |
158 |
5955.75 |
0.9980 |
1.0018 |
1438 |
97 |
TEST_TIME |
159 |
5937.99 |
0.9984 |
1.0015 |
1325 |
88 |
TEST_TIME |
160 |
5925.71 |
0.9973 |
1.0023 |
1171 |
95 |
TEST_TIME |
161 |
5913.74 |
0.9981 |
1.0017 |
1149 |
88 |
TEST_TIME |
162 |
5924.28 |
0.9972 |
1.0022 |
1083 |
99 |
TEST_TIME |
163 |
5924.01 |
0.9961 |
1.0019 |
985 |
99 |
TEST_TIME |
164 |
5904.27 |
0.9991 |
1.0017 |
1109 |
96 |
TEST_TIME |
165 |
5897.74 |
0.9967 |
1.0044 |
1082 |
98 |
TEST_TIME |
166 |
5899.66 |
0.9981 |
1.0041 |
1653 |
92 |
TEST_TIME |
167 |
5913.83 |
0.9957 |
1.0039 |
1567 |
91 |
TEST_TIME |
168 |
5916.69 |
0.9974 |
1.0052 |
1093 |
96 |
TEST_TIME |
169 |
5934.27 |
0.9963 |
1.0047 |
1210 |
99 |
TEST_TIME |
170 |
5941.42 |
0.9975 |
1.0020 |
1506 |
99 |
TEST_TIME |
171 |
5930.09 |
0.9980 |
1.0024 |
1470 |
92 |
TEST_TIME |
172 |
5930.83 |
0.9964 |
1.0030 |
1363 |
97 |
TEST_TIME |
173 |
5925.19 |
0.9982 |
1.0027 |
1436 |
91 |
TEST_TIME |
174 |
5933.43 |
0.9955 |
1.0015 |
1157 |
98 |
TEST_TIME |
175 |
5926.96 |
0.9981 |
1.0018 |
1253 |
99 |
TEST_TIME |
176 |
5915.91 |
0.9980 |
1.0033 |
1241 |
98 |
TEST_TIME |
177 |
5925.98 |
0.9959 |
1.0022 |
1309 |
99 |
TEST_TIME |
178 |
5919.63 |
0.9977 |
1.0019 |
1244 |
99 |
TEST_TIME |
179 |
5905.42 |
0.9987 |
1.0069 |
1135 |
99 |
TEST_TIME |
180 |
5917.43 |
0.9992 |
1.0000 |
181 |
98 |
Done for 10240 ms, from 7:01:52.86 to 7:02:03.10.
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 |
75079 |
73513 |
51591 |
90393 |
60442 |
25547 |
69631 |
<null> |
65668 |
119105 |
68710 |
26594 |
97270 |
55153 |
160319 |
62923 |
15170 |
463498 |
<null> |
03:47:06 |
04:05:06 |
fetches per second |
2 |
65405 |
118215 |
51032 |
<null> |
46846 |
50249 |
64848 |
63858 |
76981 |
5403 |
68153 |
31031 |
75842 |
45069 |
166072 |
82725 |
183879 |
281075 |
<null> |
04:05:07 |
04:23:07 |
fetches per second |
3 |
49644 |
56443 |
34197 |
50867 |
50986 |
<null> |
64587 |
105718 |
31961 |
83000 |
71265 |
52709 |
54457 |
57584 |
90115 |
<null> |
<null> |
<null> |
<null> |
04:23:08 |
04:41:08 |
fetches per second |
4 |
29544 |
4574 |
11696 |
7083 |
20566 |
<null> |
56064 |
142581 |
673 |
123241 |
33157 |
41711 |
19319 |
514 |
62287 |
26216 |
16246 |
16584 |
<null> |
04:41:09 |
04:59:09 |
fetches per second |
5 |
33706 |
78836 |
25079 |
83424 |
18105 |
49188 |
40523 |
38725 |
22009 |
119475 |
35197 |
1299 |
42797 |
<null> |
82426 |
195500 |
97630 |
9734 |
<null> |
04:59:10 |
05:17:10 |
fetches per second |
6 |
12046 |
2200 |
17166 |
<null> |
6679 |
<null> |
29253 |
<null> |
11721 |
2887 |
15492 |
1493 |
30172 |
4856 |
8994 |
10714 |
11506 |
161472 |
<null> |
05:17:11 |
05:35:11 |
fetches per second |
7 |
28516 |
22244 |
35194 |
<null> |
24424 |
4070 |
40789 |
<null> |
47281 |
34442 |
19955 |
21152 |
27427 |
3967 |
80302 |
<null> |
76129 |
262302 |
<null> |
05:35:12 |
05:53:12 |
fetches per second |
8 |
15689 |
12168 |
16976 |
<null> |
11536 |
<null> |
26635 |
46153 |
3378 |
<null> |
22158 |
2027 |
31618 |
14418 |
43668 |
1304 |
<null> |
19160 |
<null> |
05:53:13 |
06:11:13 |
fetches per second |
9 |
34446 |
111177 |
35427 |
<null> |
20306 |
8557 |
54672 |
16327 |
98025 |
5091 |
44494 |
13701 |
31255 |
53652 |
73980 |
79583 |
<null> |
58648 |
<null> |
06:11:14 |
06:29:14 |
fetches per second |
10 |
19919 |
6529 |
8928 |
<null> |
9142 |
24102 |
6442 |
<null> |
15469 |
2600 |
6495 |
3774 |
5619 |
1135 |
28494 |
<null> |
35042 |
151695 |
<null> |
06:29:15 |
06:47:15 |
marks per second |
1 |
16434 |
8628 |
11314 |
17514 |
12707 |
5067 |
9153 |
<null> |
9486 |
21783 |
11632 |
4594 |
9407 |
7461 |
8379 |
10538 |
2902 |
47540 |
<null> |
03:47:06 |
04:05:06 |
marks per second |
2 |
13740 |
15975 |
11349 |
<null> |
10375 |
10954 |
8415 |
9495 |
8906 |
948 |
9501 |
5380 |
8436 |
9012 |
9693 |
20693 |
14958 |
24236 |
<null> |
04:05:07 |
04:23:07 |
marks per second |
3 |
10584 |
6664 |
7217 |
7372 |
11018 |
<null> |
7273 |
18521 |
3477 |
12142 |
9954 |
8185 |
2938 |
12667 |
4912 |
<null> |
<null> |
<null> |
<null> |
04:23:08 |
04:41:08 |
marks per second |
4 |
5811 |
574 |
2702 |
1034 |
4678 |
<null> |
6956 |
19352 |
96 |
23434 |
3974 |
6608 |
1243 |
61 |
2427 |
4329 |
1318 |
331 |
<null> |
04:41:09 |
04:59:09 |
marks per second |
5 |
6816 |
9258 |
5515 |
14591 |
4056 |
13370 |
5054 |
5181 |
3490 |
17050 |
5827 |
196 |
2180 |
<null> |
4028 |
30250 |
6738 |
486 |
<null> |
04:59:10 |
05:17:10 |
marks per second |
6 |
2318 |
270 |
3655 |
<null> |
1260 |
<null> |
2429 |
<null> |
2043 |
485 |
1785 |
202 |
1439 |
686 |
339 |
1571 |
796 |
5290 |
<null> |
05:17:11 |
05:35:11 |
marks per second |
7 |
6037 |
2757 |
7695 |
<null> |
4968 |
1090 |
4639 |
<null> |
7896 |
5258 |
2457 |
2876 |
1203 |
889 |
5646 |
<null> |
12512 |
15422 |
<null> |
05:35:12 |
05:53:12 |
marks per second |
8 |
3017 |
1305 |
3598 |
<null> |
2289 |
<null> |
3053 |
7290 |
528 |
<null> |
2932 |
382 |
1249 |
2060 |
3236 |
180 |
<null> |
351 |
<null> |
05:53:13 |
06:11:13 |
marks per second |
9 |
6995 |
11955 |
6299 |
<null> |
4301 |
2041 |
5426 |
2260 |
12750 |
923 |
4528 |
2078 |
1723 |
9491 |
9253 |
15833 |
<null> |
689 |
<null> |
06:11:14 |
06:29:14 |
marks per second |
10 |
4085 |
871 |
1319 |
<null> |
1747 |
5799 |
739 |
<null> |
2033 |
399 |
743 |
529 |
205 |
175 |
2614 |
<null> |
1223 |
5631 |
<null> |
06:29:15 |
06:47:15 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:47:06 |
04:05:06 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:05:07 |
04:23:07 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
04:23:08 |
04:41:08 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:41:09 |
04:59:09 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
04:59:10 |
05:17:10 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:17:11 |
05:35:11 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
05:35:12 |
05:53:12 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
05:53:13 |
06:11:13 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:11:14 |
06:29:14 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
06:29:15 |
06:47:15 |
writes/marks*100 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:47:06 |
04:05:06 |
writes/marks*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:05:07 |
04:23:07 |
writes/marks*100 |
3 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
1 |
0 |
<null> |
<null> |
<null> |
<null> |
04:23:08 |
04:41:08 |
writes/marks*100 |
4 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
2 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
04:41:09 |
04:59:09 |
writes/marks*100 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
04:59:10 |
05:17:10 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
0 |
<null> |
05:17:11 |
05:35:11 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
0 |
<null> |
05:35:12 |
05:53:12 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
1 |
1 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
05:53:13 |
06:11:13 |
writes/marks*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:11:14 |
06:29:14 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
3 |
<null> |
5 |
0 |
<null> |
06:29:15 |
06:47:15 |
Done for 9160 ms, from 7:02:04.03 to 7:02:13.19.
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 |
1836451 |
1715104 |
121347 |
6.60 |
0 |
13712 |
45 |
121347 |
2017-08-22 03:47 |
2017-08-22 06:47 |
doc_list_biud |
1836880 |
1715104 |
121776 |
6.62 |
0 |
11419 |
15 |
121776 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_add_invoice_to_stock |
18783 |
10875 |
7908 |
42.10 |
15 |
136921 |
10422 |
7908 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_cancel_adding_invoice |
4081 |
3261 |
820 |
20.09 |
0 |
70138 |
2556 |
820 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_cancel_client_order |
6517 |
6372 |
145 |
2.22 |
0 |
2917 |
222 |
145 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_cancel_customer_reserve |
315603 |
204104 |
111499 |
35.32 |
0 |
6599 |
55 |
111499 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_cancel_pay_from_customer |
2431 |
2415 |
16 |
0.65 |
0 |
3510 |
132 |
16 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_cancel_pay_to_supplier |
1466 |
1465 |
1 |
0.06 |
0 |
2043 |
128 |
1 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_cancel_supplier_invoice |
9778 |
7662 |
2116 |
21.64 |
0 |
12277 |
393 |
2116 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_cancel_supplier_order |
1443 |
532 |
911 |
63.13 |
15 |
207512 |
17187 |
911 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_cancel_write_off |
24047 |
16012 |
8035 |
33.41 |
0 |
4477 |
137 |
8035 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_client_order |
77177 |
77177 |
0 |
0.00 |
0 |
5601 |
453 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_customer_reserve |
608698 |
608698 |
0 |
0.00 |
0 |
7176 |
151 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_fill_shopping_cart |
116937 |
116668 |
269 |
0.23 |
0 |
6833 |
89 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_fill_shopping_cart_clo_res |
608698 |
608698 |
0 |
0.00 |
0 |
2886 |
11 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_get_clo_for_invoice |
10875 |
10875 |
0 |
0.00 |
0 |
7145 |
309 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_kill_cost_storno |
31694 |
23153 |
8541 |
26.94 |
0 |
3479 |
20 |
8541 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_kill_qstorno_ret_qs2qd |
664688 |
432414 |
232274 |
34.94 |
0 |
11201 |
21 |
232274 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_kill_qty_storno |
406038 |
284364 |
121674 |
29.96 |
0 |
11388 |
65 |
121674 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_lock_selected_doc |
76404 |
65279 |
11125 |
14.56 |
0 |
1887 |
7 |
11125 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_make_cost_storno |
93577 |
93577 |
0 |
0.00 |
0 |
13572 |
410 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_multiply_rows_for_pdistr |
93577 |
93577 |
0 |
0.00 |
0 |
3260 |
57 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_multiply_rows_for_qdistr |
77177 |
77177 |
0 |
0.00 |
0 |
4197 |
150 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_pay_from_customer |
25868 |
25868 |
0 |
0.00 |
0 |
13993 |
823 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_pay_to_supplier |
21288 |
21288 |
0 |
0.00 |
0 |
8143 |
726 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_payment_common |
47156 |
47156 |
0 |
0.00 |
0 |
4665 |
59 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_qd_handle_on_cancel_clo |
6513 |
6372 |
141 |
2.16 |
0 |
2793 |
97 |
141 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_qd_handle_on_invoice_upd_sts |
14810 |
14136 |
674 |
4.55 |
0 |
9251 |
336 |
674 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_qd_handle_on_reserve_upd_sts |
35546 |
35546 |
0 |
0.00 |
0 |
7707 |
49 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_reserve_write_off |
36720 |
35546 |
1174 |
3.19 |
0 |
9719 |
506 |
1174 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_supplier_invoice |
19917 |
19824 |
93 |
0.46 |
0 |
29452 |
2953 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
sp_supplier_order |
19843 |
19667 |
176 |
0.88 |
0 |
14602 |
1947 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
srv_find_qd_qs_mism |
1095585 |
974216 |
121369 |
11.07 |
0 |
5569 |
23 |
121369 |
2017-08-22 03:47 |
2017-08-22 06:47 |
srv_make_invnt_saldo |
1654 |
1654 |
0 |
0.00 |
31 |
23900 |
2555 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
srv_make_money_saldo |
2803 |
2803 |
0 |
0.00 |
0 |
2542 |
66 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
2652 |
37721 |
15415 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_add_invoice_to_stock |
7908 |
7908 |
0 |
0.00 |
0 |
2075 |
98 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_cancel_adding_invoice |
741 |
741 |
0 |
0.00 |
0 |
2590 |
184 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_cancel_client_order |
145 |
145 |
0 |
0.00 |
0 |
1170 |
101 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_cancel_customer_reserve |
74 |
74 |
0 |
0.00 |
0 |
436 |
29 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_cancel_pay_from_customer |
16 |
16 |
0 |
0.00 |
0 |
390 |
55 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_cancel_pay_to_supplier |
1 |
1 |
0 |
0.00 |
0 |
0 |
0 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_cancel_supplier_invoice |
668 |
668 |
0 |
0.00 |
0 |
1607 |
94 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_cancel_supplier_order |
13795 |
13795 |
0 |
0.00 |
0 |
4259 |
84 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_cancel_write_off |
20 |
20 |
0 |
0.00 |
0 |
484 |
79 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_reserve_write_off |
1174 |
1174 |
0 |
0.00 |
0 |
1606 |
62 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_supplier_invoice |
93 |
93 |
0 |
0.00 |
0 |
1544 |
122 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-abend:sp_supplier_order |
176 |
176 |
0 |
0.00 |
0 |
1669 |
96 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_add_invoice_to_stock |
10875 |
10875 |
0 |
0.00 |
0 |
19734 |
556 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_cancel_adding_invoice |
1210 |
1210 |
0 |
0.00 |
0 |
13354 |
780 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_cancel_client_order |
6372 |
6372 |
0 |
0.00 |
0 |
2277 |
61 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_cancel_customer_reserve |
2406 |
2406 |
0 |
0.00 |
0 |
2044 |
66 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_cancel_pay_from_customer |
2415 |
2415 |
0 |
0.00 |
0 |
1607 |
52 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_cancel_pay_to_supplier |
1465 |
1465 |
0 |
0.00 |
0 |
2668 |
53 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_cancel_supplier_invoice |
874 |
874 |
0 |
0.00 |
0 |
2356 |
77 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_cancel_supplier_order |
532 |
532 |
0 |
0.00 |
0 |
45957 |
1678 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_cancel_write_off |
3584 |
3584 |
0 |
0.00 |
0 |
2028 |
69 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_client_order |
77177 |
77177 |
0 |
0.00 |
0 |
3510 |
74 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_customer_reserve |
3587 |
3587 |
0 |
0.00 |
0 |
2855 |
54 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_pay_from_customer |
25868 |
25868 |
0 |
0.00 |
0 |
2855 |
68 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_pay_to_supplier |
21288 |
21288 |
0 |
0.00 |
0 |
2902 |
62 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_reserve_write_off |
35546 |
35546 |
0 |
0.00 |
0 |
3510 |
71 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_supplier_invoice |
19824 |
19824 |
0 |
0.00 |
0 |
2496 |
65 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:sp_supplier_order |
19667 |
19667 |
0 |
0.00 |
0 |
3712 |
68 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:srv_make_invnt_saldo |
1654 |
1654 |
0 |
0.00 |
0 |
811 |
28 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:srv_make_money_saldo |
2803 |
2803 |
0 |
0.00 |
0 |
1170 |
29 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
265 |
83 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_add_invoice_to_stock |
37566 |
21750 |
15816 |
42.10 |
0 |
1263 |
16 |
15816 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_all_customers |
115664 |
115664 |
0 |
0.00 |
0 |
1950 |
5 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_all_suppliers |
79808 |
79270 |
538 |
0.67 |
0 |
1467 |
5 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_all_wares |
154354 |
154354 |
0 |
0.00 |
0 |
1029 |
4 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_cancel_adding_invoice |
2836 |
2420 |
416 |
14.66 |
0 |
3307 |
133 |
416 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_cancel_client_order |
13034 |
12744 |
290 |
2.22 |
0 |
1732 |
6 |
290 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_cancel_customer_prepayment |
4862 |
4830 |
32 |
0.65 |
0 |
1061 |
7 |
32 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_cancel_customer_reserve |
4960 |
4812 |
148 |
2.98 |
0 |
1045 |
9 |
148 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_cancel_payment_to_supplier |
2932 |
2930 |
2 |
0.06 |
0 |
842 |
8 |
2 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_cancel_supplier_invoice |
3084 |
1748 |
1336 |
43.32 |
0 |
890 |
16 |
1336 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_cancel_supplier_order |
2886 |
1064 |
1822 |
63.13 |
0 |
843 |
9 |
1822 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_cancel_write_off |
7208 |
7168 |
40 |
0.55 |
0 |
3666 |
98 |
40 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_max_id_clo_ord |
19843 |
19667 |
176 |
0.88 |
0 |
780 |
5 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_max_id_clo_res |
3587 |
3587 |
0 |
0.00 |
0 |
2106 |
19 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_max_id_ord_sup |
19917 |
19824 |
93 |
0.46 |
0 |
1139 |
5 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_max_non_paid_invoice |
21144 |
21144 |
0 |
0.00 |
0 |
1030 |
5 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_max_non_paid_realizn |
25868 |
25868 |
0 |
0.00 |
0 |
1264 |
5 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_min_id_clo_ord |
19843 |
19667 |
176 |
0.88 |
0 |
1591 |
7 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_min_id_clo_res |
3587 |
3587 |
0 |
0.00 |
0 |
873 |
9 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_min_id_ord_sup |
19917 |
19824 |
93 |
0.46 |
0 |
2449 |
9 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_min_non_paid_invoice |
21288 |
21288 |
0 |
0.00 |
0 |
3214 |
11 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_min_non_paid_realizn |
25868 |
25868 |
0 |
0.00 |
0 |
1840 |
9 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_our_firm |
38690 |
38690 |
0 |
0.00 |
0 |
733 |
5 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
v_reserve_write_off |
73440 |
71092 |
2348 |
3.19 |
0 |
2262 |
8 |
2348 |
2017-08-22 03:47 |
2017-08-22 06:47 |
x_lock_depdocs_on_canc_invoice |
17594 |
10049 |
7545 |
42.88 |
0 |
1388 |
26 |
7545 |
2017-08-22 03:47 |
2017-08-22 06:47 |
x_lock_depdocs_on_canc_sup_ord |
1442 |
532 |
910 |
63.10 |
0 |
795 |
47 |
910 |
2017-08-22 03:47 |
2017-08-22 06:47 |
x_make_qstorno_1000_1200 |
19843 |
19667 |
176 |
0.88 |
0 |
14024 |
1754 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
x_make_qstorno_1200_2000 |
19917 |
19824 |
93 |
0.46 |
0 |
29406 |
2747 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
x_make_qstorno_2100_3300 |
608698 |
608698 |
0 |
0.00 |
0 |
6614 |
125 |
0 |
2017-08-22 03:47 |
2017-08-22 06:47 |
Done for 304690 ms, from 7:07:17.88 to 7:12:22.57.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
104 |
sp_kill_cost_storno |
335544336 |
2017-08-22 03:47 |
2017-08-22 06:47 |
deadlock |
60 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-08-22 03:47 |
2017-08-22 06:42 |
deadlock |
9848 |
sp_lock_selected_doc |
335544336 |
2017-08-22 03:47 |
2017-08-22 06:47 |
deadlock |
141 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-08-22 03:48 |
2017-08-22 06:47 |
deadlock |
161 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-08-22 03:47 |
2017-08-22 06:44 |
deadlock |
557 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-08-22 03:47 |
2017-08-22 06:47 |
deadlock |
250 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-08-22 03:48 |
2017-08-22 06:46 |
user_exc |
176 |
x_make_qstorno_1000_1200 |
335544517 |
2017-08-22 03:47 |
2017-08-22 06:46 |
user_exc |
93 |
x_make_qstorno_1200_2000 |
335544517 |
2017-08-22 03:47 |
2017-08-22 06:45 |
Done for 8700 ms, from 7:12:29.83 to 7:12:38.53.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 419483
MON$OLDEST_ACTIVE 419484
MON$OLDEST_SNAPSHOT 419484
MON$NEXT_TRANSACTION 419484
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 787104
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.3.32798 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32798 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32798 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32798 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 419631
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 419485
Oldest active 419486
Oldest snapshot 419486
Next transaction 419487
Sequence number 0
Next attachment ID 9464
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.06, total records: 2061369
Average version length: 47.73, total versions: 1990, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 14, data page slots: 22328
Data pages: 22328, average fill: 73%
Primary pages: 22328, secondary pages: 0, swept pages: 13706
Empty pages: 5, full pages: 18900
Fill distribution:
0 - 19% = 5
20 - 39% = 3
40 - 59% = 97
60 - 79% = 22221
80 - 99% = 2
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 9975, nodes: 2061369
Average node length: 19.30, total dup: 0, max dup: 0
Average key length: 16.35, compression ratio: 1.65
Average prefix length: 13.65, average data length: 13.35
Clustering factor: 401184, ratio: 0.19
Fill distribution:
0 - 19% = 696
20 - 39% = 2318
40 - 59% = 4428
60 - 79% = 1029
80 - 99% = 1504
Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7412, nodes: 2061369
Average node length: 11.65, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 383413, ratio: 0.19
Fill distribution:
0 - 19% = 1
20 - 39% = 3511
40 - 59% = 3804
60 - 79% = 85
80 - 99% = 11
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 174473, depth: 3, leaf buckets: 3599, nodes: 2061369
Average node length: 6.81, total dup: 1503642, max dup: 49
Average key length: 3.86, compression ratio: 2.33
Average prefix length: 7.41, average data length: 1.59
Clustering factor: 365045, ratio: 0.18
Fill distribution:
0 - 19% = 162
20 - 39% = 1201
40 - 59% = 1406
60 - 79% = 286
80 - 99% = 544
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.42, total records: 621057
Average version length: 35.95, total versions: 442, max versions: 2
Average fragment length: 20.44, total fragments: 9, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7872
Data pages: 7872, average fill: 75%
Primary pages: 7867, secondary pages: 5, swept pages: 7222
Empty pages: 4, full pages: 7261
Fill distribution:
0 - 19% = 13
20 - 39% = 10
40 - 59% = 35
60 - 79% = 7803
80 - 99% = 11
Index DOC_LIST_ID_DESC (1)
Root page: 250231, depth: 3, leaf buckets: 2290, nodes: 621057
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 8.83, compression ratio: 1.02
Average prefix length: 3.16, average data length: 5.84
Clustering factor: 144343, ratio: 0.23
Fill distribution:
0 - 19% = 1
20 - 39% = 1284
40 - 59% = 956
60 - 79% = 44
80 - 99% = 5
Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 654, nodes: 621057
Average node length: 4.87, total dup: 621007, max dup: 41806
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 283509, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 564
60 - 79% = 70
80 - 99% = 20
Index PK_DOC_LIST (0)
Root page: 325990, depth: 3, leaf buckets: 1794, nodes: 621057
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.83, compression ratio: 1.02
Average prefix length: 3.16, average data length: 5.84
Clustering factor: 144343, ratio: 0.23
Fill distribution:
0 - 19% = 123
20 - 39% = 571
40 - 59% = 529
60 - 79% = 272
80 - 99% = 299
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: 62.26, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 15.64, total fragments: 357, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.67
Pointer pages: 1, data page slots: 584
Data pages: 28, average fill: 22%
Primary pages: 4, secondary pages: 24, swept pages: 4
Empty pages: 12, full pages: 3
Fill distribution:
0 - 19% = 17
20 - 39% = 6
40 - 59% = 1
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: 61.88, total records: 9738
Average version length: 70.82, total versions: 1270, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.55
Pointer pages: 2, data page slots: 1096
Data pages: 432, average fill: 27%
Primary pages: 431, secondary pages: 1, swept pages: 373
Empty pages: 46, full pages: 12
Fill distribution:
0 - 19% = 216
20 - 39% = 79
40 - 59% = 94
60 - 79% = 37
80 - 99% = 6
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 44, nodes: 9738
Average node length: 13.41, total dup: 1229, max dup: 1
Average key length: 11.43, compression ratio: 2.36
Average prefix length: 18.43, average data length: 8.57
Clustering factor: 6715, ratio: 0.69
Fill distribution:
0 - 19% = 0
20 - 39% = 31
40 - 59% = 8
60 - 79% = 5
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 15.04, 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.13
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: 46.00, total records: 60
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.39
Pointer pages: 1, data page slots: 24
Data pages: 24, average fill: 3%
Primary pages: 22, secondary pages: 2, swept pages: 15
Empty pages: 16, full pages: 0
Fill distribution:
0 - 19% = 23
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 234082, depth: 2, leaf buckets: 1, nodes: 60
Average node length: 13.00, total dup: 26, max dup: 8
Average key length: 11.37, compression ratio: 1.67
Average prefix length: 10.18, average data length: 8.82
Clustering factor: 37, ratio: 0.62
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.36, total records: 189877
Average version length: 32.01, total versions: 1558, max versions: 10
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.51
Pointer pages: 2, data page slots: 2208
Data pages: 2208, average fill: 64%
Primary pages: 2199, secondary pages: 9, swept pages: 1761
Empty pages: 23, full pages: 512
Fill distribution:
0 - 19% = 57
20 - 39% = 110
40 - 59% = 234
60 - 79% = 1806
80 - 99% = 1
Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 176, nodes: 189877
Average node length: 4.46, total dup: 189828, max dup: 10211
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 32397, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 16
40 - 59% = 78
60 - 79% = 66
80 - 99% = 16
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 199, nodes: 189877
Average node length: 5.41, total dup: 171093, max dup: 51
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 42655, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 12
40 - 59% = 79
60 - 79% = 64
80 - 99% = 43
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 210, nodes: 189877
Average node length: 5.41, total dup: 171093, max dup: 51
Average key length: 2.96, compression ratio: 7.43
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 42703, ratio: 0.22
Fill distribution:
0 - 19% = 3
20 - 39% = 11
40 - 59% = 88
60 - 79% = 82
80 - 99% = 26
Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 204, nodes: 189877
Average node length: 5.20, total dup: 171093, max dup: 51
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 42740, ratio: 0.23
Fill distribution:
0 - 19% = 3
20 - 39% = 17
40 - 59% = 90
60 - 79% = 65
80 - 99% = 29
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.94, total records: 257311
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: 2200
Data pages: 2200, average fill: 64%
Primary pages: 2200, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 2197
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2197
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 167028, depth: 2, leaf buckets: 199, nodes: 257311
Average node length: 4.50, total dup: 257130, max dup: 2202
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 44091, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 63
60 - 79% = 64
80 - 99% = 72
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.48, total records: 11302519
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.20
Pointer pages: 165, data page slots: 267912
Data pages: 267912, average fill: 87%
Primary pages: 267912, secondary pages: 0, swept pages: 3
Empty pages: 3, full pages: 267908
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 267908
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 12763, nodes: 11302519
Average node length: 5.65, total dup: 10455686, max dup: 140
Average key length: 2.18, compression ratio: 3.67
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 3703979, ratio: 0.33
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 7173
60 - 79% = 3737
80 - 99% = 1847
Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 11145, nodes: 11302519
Average node length: 4.55, total dup: 11302515, max dup: 10398347
Average key length: 1.08, compression ratio: 0.37
Average prefix length: 0.40, average data length: 0.00
Clustering factor: 323925, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11141
60 - 79% = 2
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 13739, nodes: 11302519
Average node length: 5.70, total dup: 10948985, max dup: 21344
Average key length: 2.23, compression ratio: 4.03
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 863394, ratio: 0.08
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 10238
60 - 79% = 1938
80 - 99% = 1560
Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 12997, nodes: 11302519
Average node length: 5.54, total dup: 11274312, max dup: 1552663
Average key length: 2.07, compression ratio: 18.27
Average prefix length: 37.74, average data length: 0.07
Clustering factor: 6096767, ratio: 0.54
Fill distribution:
0 - 19% = 13
20 - 39% = 3
40 - 59% = 10361
60 - 79% = 536
80 - 99% = 2084
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.05, total records: 434630
Average version length: 55.67, total versions: 563, 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: 5184
Data pages: 5184, average fill: 74%
Primary pages: 5184, secondary pages: 0, swept pages: 3772
Empty pages: 5, full pages: 4588
Fill distribution:
0 - 19% = 6
20 - 39% = 4
40 - 59% = 37
60 - 79% = 5137
80 - 99% = 0
Index PSTORNED_RCV_ID (2)
Root page: 631482, depth: 3, leaf buckets: 584, nodes: 434630
Average node length: 5.95, total dup: 365057, max dup: 580
Average key length: 3.16, compression ratio: 2.85
Average prefix length: 8.00, average data length: 1.00
Clustering factor: 57059, ratio: 0.13
Fill distribution:
0 - 19% = 9
20 - 39% = 35
40 - 59% = 374
60 - 79% = 129
80 - 99% = 37
Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 478, nodes: 434630
Average node length: 5.59, total dup: 387608, max dup: 114
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 107999, ratio: 0.25
Fill distribution:
0 - 19% = 2
20 - 39% = 11
40 - 59% = 225
60 - 79% = 163
80 - 99% = 77
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.53, total records: 2317
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.54
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 66%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 27
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 28
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.52, total records: 6335
Average version length: 72.22, total versions: 1634, 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: 1432
Data pages: 416, average fill: 19%
Primary pages: 415, secondary pages: 1, swept pages: 310
Empty pages: 213, full pages: 57
Fill distribution:
0 - 19% = 295
20 - 39% = 38
40 - 59% = 19
60 - 79% = 25
80 - 99% = 39
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 15, nodes: 6335
Average node length: 6.74, total dup: 5445, max dup: 14
Average key length: 4.76, compression ratio: 7.77
Average prefix length: 34.38, average data length: 2.62
Clustering factor: 1066, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 10
40 - 59% = 3
60 - 79% = 0
80 - 99% = 1
XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.88, total records: 974281
Average version length: 71.82, total versions: 3764, 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: 9, data page slots: 14616
Data pages: 14584, average fill: 73%
Primary pages: 14584, secondary pages: 0, swept pages: 9060
Empty pages: 62, full pages: 11398
Fill distribution:
0 - 19% = 100
20 - 39% = 185
40 - 59% = 737
60 - 79% = 13503
80 - 99% = 59
Index XQD_1000_3300_DOC (1)
Root page: 458711, depth: 3, leaf buckets: 1104, nodes: 974281
Average node length: 5.13, total dup: 947636, max dup: 125
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 108283, ratio: 0.11
Fill distribution:
0 - 19% = 17
20 - 39% = 59
40 - 59% = 804
60 - 79% = 59
80 - 99% = 165
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 246906, depth: 3, leaf buckets: 1375, nodes: 974281
Average node length: 6.25, total dup: 850332, max dup: 19
Average key length: 3.32, compression ratio: 11.14
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 185824, ratio: 0.19
Fill distribution:
0 - 19% = 31
20 - 39% = 152
40 - 59% = 879
60 - 79% = 172
80 - 99% = 141
XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 64.24, total records: 40910
Average version length: 72.12, total versions: 4220, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.12
Pointer pages: 3, data page slots: 1960
Data pages: 1072, average fill: 43%
Primary pages: 1070, secondary pages: 2, swept pages: 742
Empty pages: 250, full pages: 362
Fill distribution:
0 - 19% = 398
20 - 39% = 86
40 - 59% = 103
60 - 79% = 446
80 - 99% = 39
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 85, nodes: 40910
Average node length: 6.14, total dup: 34876, max dup: 47
Average key length: 3.84, compression ratio: 9.63
Average prefix length: 35.30, average data length: 1.70
Clustering factor: 4101, ratio: 0.10
Fill distribution:
0 - 19% = 2
20 - 39% = 50
40 - 59% = 33
60 - 79% = 0
80 - 99% = 0
XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 70.33, total records: 1525652
Average version length: 71.65, total versions: 39248, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.93
Pointer pages: 15, data page slots: 24152
Data pages: 24136, average fill: 70%
Primary pages: 24135, secondary pages: 1, swept pages: 13896
Empty pages: 294, full pages: 16560
Fill distribution:
0 - 19% = 610
20 - 39% = 962
40 - 59% = 2589
60 - 79% = 19161
80 - 99% = 814
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 138780, depth: 3, leaf buckets: 2416, nodes: 1525652
Average node length: 5.60, total dup: 1436052, max dup: 49
Average key length: 2.64, compression ratio: 14.00
Average prefix length: 36.41, average data length: 0.59
Clustering factor: 201787, ratio: 0.13
Fill distribution:
0 - 19% = 14
20 - 39% = 1167
40 - 59% = 908
60 - 79% = 187
80 - 99% = 140
XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 47.00, total records: 6302
Average version length: 71.18, total versions: 2095, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.89
Pointer pages: 3, data page slots: 1688
Data pages: 688, average fill: 12%
Primary pages: 687, secondary pages: 1, swept pages: 585
Empty pages: 364, full pages: 13
Fill distribution:
0 - 19% = 546
20 - 39% = 77
40 - 59% = 31
60 - 79% = 24
80 - 99% = 10
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 17, nodes: 6302
Average node length: 8.53, total dup: 4615, max dup: 35
Average key length: 6.36, compression ratio: 5.82
Average prefix length: 32.90, average data length: 4.10
Clustering factor: 1287, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 9
60 - 79% = 1
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.14, total records: 2629095
Average version length: 70.95, total versions: 11283, 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: 24, data page slots: 37624
Data pages: 37624, average fill: 76%
Primary pages: 37624, secondary pages: 0, swept pages: 27674
Empty pages: 31, full pages: 33365
Fill distribution:
0 - 19% = 71
20 - 39% = 94
40 - 59% = 605
60 - 79% = 36558
80 - 99% = 296
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5523, nodes: 2629095
Average node length: 6.86, total dup: 2133311, max dup: 14
Average key length: 3.88, compression ratio: 9.53
Average prefix length: 35.30, average data length: 1.70
Clustering factor: 482838, ratio: 0.18
Fill distribution:
0 - 19% = 5
20 - 39% = 3275
40 - 59% = 1831
60 - 79% = 238
80 - 99% = 174
XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.61, total records: 4530454
Average version length: 84.30, total versions: 1438, 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: 43, data page slots: 69568
Data pages: 69568, average fill: 80%
Primary pages: 69568, secondary pages: 0, swept pages: 26097
Empty pages: 0, full pages: 69327
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 21
60 - 79% = 20585
80 - 99% = 48959
Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4636, nodes: 4530454
Average node length: 5.15, total dup: 4427142, max dup: 125
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 718548, ratio: 0.16
Fill distribution:
0 - 19% = 24
20 - 39% = 70
40 - 59% = 2094
60 - 79% = 1905
80 - 99% = 543
Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 4823, nodes: 4530454
Average node length: 5.70, total dup: 4054641, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 223764, ratio: 0.05
Fill distribution:
0 - 19% = 36
20 - 39% = 148
40 - 59% = 2541
60 - 79% = 296
80 - 99% = 1802
Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5178, nodes: 4530454
Average node length: 5.81, total dup: 3963225, max dup: 27
Average key length: 2.83, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 772749, ratio: 0.17
Fill distribution:
0 - 19% = 22
20 - 39% = 74
40 - 59% = 2377
60 - 79% = 1948
80 - 99% = 757
XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 83.04, total records: 2444084
Average version length: 84.12, total versions: 6971, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 24, data page slots: 38368
Data pages: 38368, average fill: 78%
Primary pages: 38368, secondary pages: 0, swept pages: 27816
Empty pages: 43, full pages: 35948
Fill distribution:
0 - 19% = 93
20 - 39% = 128
40 - 59% = 554
60 - 79% = 15897
80 - 99% = 21696
Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2632, nodes: 2444084
Average node length: 5.15, total dup: 2386602, max dup: 153
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 374761, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 48
40 - 59% = 1585
60 - 79% = 719
80 - 99% = 275
Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 4087, nodes: 2444084
Average node length: 6.22, total dup: 2008011, max dup: 14
Average key length: 3.24, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 228224, ratio: 0.09
Fill distribution:
0 - 19% = 102
20 - 39% = 1679
40 - 59% = 1474
60 - 79% = 540
80 - 99% = 292
Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2983, nodes: 2444084
Average node length: 5.82, total dup: 2136841, max dup: 29
Average key length: 2.85, compression ratio: 3.16
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 451789, ratio: 0.18
Fill distribution:
0 - 19% = 13
20 - 39% = 48
40 - 59% = 1818
60 - 79% = 812
80 - 99% = 292
XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.47, total records: 4779375
Average version length: 85.15, total versions: 16446, 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: 46, data page slots: 74832
Data pages: 74608, average fill: 79%
Primary pages: 74608, secondary pages: 0, swept pages: 21858
Empty pages: 456, full pages: 71151
Fill distribution:
0 - 19% = 586
20 - 39% = 339
40 - 59% = 932
60 - 79% = 15988
80 - 99% = 56763
Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5072, nodes: 4779375
Average node length: 5.04, total dup: 4751279, max dup: 695
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 720216, ratio: 0.15
Fill distribution:
0 - 19% = 4
20 - 39% = 228
40 - 59% = 2911
60 - 79% = 1423
80 - 99% = 506
Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 5776, nodes: 4779375
Average node length: 5.53, total dup: 4403711, max dup: 49
Average key length: 2.54, compression ratio: 3.54
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 257513, ratio: 0.05
Fill distribution:
0 - 19% = 89
20 - 39% = 1506
40 - 59% = 2245
60 - 79% = 651
80 - 99% = 1285
Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 5708, nodes: 4779375
Average node length: 5.69, total dup: 4285908, max dup: 74
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 797280, ratio: 0.17
Fill distribution:
0 - 19% = 3
20 - 39% = 188
40 - 59% = 3381
60 - 79% = 1558
80 - 99% = 578
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.00, total records: 3291008
Average version length: 85.41, total versions: 18690, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 32, data page slots: 51312
Data pages: 51312, average fill: 79%
Primary pages: 51312, secondary pages: 0, swept pages: 34466
Empty pages: 37, full pages: 49310
Fill distribution:
0 - 19% = 62
20 - 39% = 112
40 - 59% = 394
60 - 79% = 18817
80 - 99% = 31927
Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3539, nodes: 3291008
Average node length: 5.02, total dup: 3274875, max dup: 1300
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 665987, ratio: 0.20
Fill distribution:
0 - 19% = 25
20 - 39% = 333
40 - 59% = 1873
60 - 79% = 877
80 - 99% = 431
Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5600, nodes: 3291008
Average node length: 6.23, total dup: 2699944, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 343161, ratio: 0.10
Fill distribution:
0 - 19% = 190
20 - 39% = 2393
40 - 59% = 1914
60 - 79% = 673
80 - 99% = 430
Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3889, nodes: 3291008
Average node length: 5.59, total dup: 3002023, max dup: 69
Average key length: 2.61, compression ratio: 3.45
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 708421, ratio: 0.22
Fill distribution:
0 - 19% = 21
20 - 39% = 374
40 - 59% = 1935
60 - 79% = 1066
80 - 99% = 493
XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.10, total records: 657697
Average version length: 70.33, total versions: 3191, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 9064
Data pages: 9064, average fill: 77%
Primary pages: 9064, secondary pages: 0, swept pages: 6495
Empty pages: 6, full pages: 8762
Fill distribution:
0 - 19% = 14
20 - 39% = 26
40 - 59% = 73
60 - 79% = 8857
80 - 99% = 94
Index XQS_3300_3400_DOC_ID (0)
Root page: 173718, depth: 3, leaf buckets: 780, nodes: 657697
Average node length: 5.29, total dup: 622171, max dup: 115
Average key length: 2.41, compression ratio: 3.73
Average prefix length: 8.64, average data length: 0.36
Clustering factor: 53299, ratio: 0.08
Fill distribution:
0 - 19% = 2
20 - 39% = 167
40 - 59% = 322
60 - 79% = 205
80 - 99% = 84
Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 890, nodes: 657697
Average node length: 5.91, total dup: 563451, max dup: 29
Average key length: 3.03, compression ratio: 2.97
Average prefix length: 8.11, average data length: 0.89
Clustering factor: 56163, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 219
40 - 59% = 362
60 - 79% = 202
80 - 99% = 104
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 68720 ms, from 7:12:38.92 to 7:13:47.64.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2061369 |
1990 |
0.0965 |
DOC_LIST |
621057 |
442 |
0.0711 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
9738 |
1270 |
13.0416 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
60 |
0 |
0.0000 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
189877 |
1558 |
0.8205 |
PERF_ESTIMATED |
257311 |
0 |
0.0000 |
PERF_LOG |
11302519 |
0 |
0.0000 |
PSTORNED |
434630 |
563 |
0.1295 |
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 |
2317 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
6335 |
1634 |
25.7932 |
XQD_1000_3300 |
974281 |
3764 |
0.3863 |
XQD_1200_2000 |
40910 |
4220 |
10.3153 |
XQD_2000_3300 |
1525652 |
39248 |
2.5725 |
XQD_2100_3300 |
6302 |
2095 |
33.2434 |
XQD_3300_3400 |
2629095 |
11283 |
0.4291 |
XQS_1000_1200 |
4530454 |
1438 |
0.0317 |
XQS_1000_3300 |
2444084 |
6971 |
0.2852 |
XQS_1200_2000 |
4779375 |
16446 |
0.3441 |
XQS_2100_3300 |
3291008 |
18690 |
0.5679 |
XQS_3300_3400 |
657697 |
3191 |
0.4851 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2260 ms, from 7:13:58.72 to 7:14:00.98.
07:14:01.06 Validation started
07:14:01.09 Relation 140 (DOC_LIST)
07:14:01.09 process pointer page 0 of 5
07:14:01.20 process pointer page 1 of 5
07:14:01.29 process pointer page 2 of 5
07:14:01.40 process pointer page 3 of 5
07:14:01.46 process pointer page 4 of 5
07:14:01.49 Index 1 (PK_DOC_LIST)
07:14:01.62 Index 2 (DOC_LIST_ID_DESC)
07:14:01.78 Index 3 (FK_DOC_LIST_AGENTS)
07:14:02.02 Relation 140 (DOC_LIST) is ok
07:14:02.02 Relation 141 (DOC_DATA)
07:14:02.02 process pointer page 0 of 14
07:14:02.09 process pointer page 1 of 14
07:14:02.13 process pointer page 2 of 14
07:14:02.17 process pointer page 3 of 14
07:14:02.20 process pointer page 4 of 14
07:14:02.23 process pointer page 5 of 14
07:14:02.26 process pointer page 6 of 14
07:14:02.29 process pointer page 7 of 14
07:14:02.32 process pointer page 8 of 14
07:14:02.35 process pointer page 9 of 14
07:14:02.38 process pointer page 10 of 14
07:14:02.41 process pointer page 11 of 14
07:14:02.45 process pointer page 12 of 14
07:14:02.46 process pointer page 13 of 14
07:14:02.49 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:14:03.23 Index 3 (DOC_DATA_ID_DESC)
07:14:03.63 Index 4 (FK_DOC_DATA_DOC_LIST)
07:14:04.21 Relation 141 (DOC_DATA) is ok
07:14:04.21 Relation 147 (INVNT_SALDO)
07:14:04.21 process pointer page 0 of 1
07:14:04.21 Index 1 (PK_INVNT_SALDO)
07:14:04.21 Relation 147 (INVNT_SALDO) is ok
07:14:04.21 Relation 150 (PDISTR)
07:14:04.21 process pointer page 0 of 2
07:14:04.26 process pointer page 1 of 2
07:14:04.26 Index 2 (PDISTR_SND_ID)
07:14:04.30 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:14:04.36 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:14:04.43 Index 5 (PDISTR_AGENT_ID)
07:14:04.47 Relation 150 (PDISTR) is ok
07:14:04.47 Relation 151 (PSTORNED)
07:14:04.47 process pointer page 0 of 4
07:14:04.57 process pointer page 1 of 4
07:14:04.66 process pointer page 2 of 4
07:14:04.71 process pointer page 3 of 4
07:14:04.71 Index 2 (PSTORNED_SND_ID)
07:14:04.77 Index 3 (PSTORNED_RCV_ID)
07:14:04.90 Relation 151 (PSTORNED) is ok
07:14:04.90 Relation 156 (SEMAPHORES)
07:14:04.90 process pointer page 0 of 1
07:14:04.90 Index 1 (PK_SEMAPHORES)
07:14:04.90 Index 2 (SEMAPHORES_TASK_UNQ)
07:14:04.90 Relation 156 (SEMAPHORES) is ok
07:14:04.90 Relation 157 (INVNT_TURNOVER_LOG)
07:14:04.90 process pointer page 0 of 2
07:14:04.91 process pointer page 1 of 2
07:14:04.91 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:14:04.91 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:14:04.91 Relation 160 (PERF_ESTIMATED)
07:14:04.91 process pointer page 0 of 2
07:14:05.00 process pointer page 1 of 2
07:14:05.04 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:14:05.11 Relation 160 (PERF_ESTIMATED) is ok
07:14:05.11 Relation 161 (PERF_ISQL_STAT)
07:14:05.11 process pointer page 0 of 1
07:14:05.11 Index 1 (PERF_ISQL_STAT_TRN)
07:14:05.11 Relation 161 (PERF_ISQL_STAT) is ok
07:14:05.11 Relation 162 (TRACE_STAT)
07:14:05.11 process pointer page 0 of 1
07:14:05.11 Relation 162 (TRACE_STAT) is ok
07:14:05.11 Relation 163 (PERF_LOG)
07:14:05.11 process pointer page 0 of 165
07:14:05.19 process pointer page 1 of 165
07:14:05.29 process pointer page 2 of 165
07:14:05.32 process pointer page 3 of 165
07:14:05.35 process pointer page 4 of 165
07:14:05.38 process pointer page 5 of 165
07:14:05.41 process pointer page 6 of 165
07:14:05.44 process pointer page 7 of 165
07:14:05.47 process pointer page 8 of 165
07:14:05.49 process pointer page 9 of 165
07:14:05.52 process pointer page 10 of 165
07:14:05.60 process pointer page 11 of 165
07:14:05.64 process pointer page 12 of 165
07:14:05.68 process pointer page 13 of 165
07:14:05.72 process pointer page 14 of 165
07:14:05.75 process pointer page 15 of 165
07:14:05.78 process pointer page 16 of 165
07:14:05.86 process pointer page 17 of 165
07:14:05.94 process pointer page 18 of 165
07:14:06.02 process pointer page 19 of 165
07:14:06.11 process pointer page 20 of 165
07:14:06.19 process pointer page 21 of 165
07:14:06.24 process pointer page 22 of 165
07:14:06.27 process pointer page 23 of 165
07:14:06.35 process pointer page 24 of 165
07:14:06.42 process pointer page 25 of 165
07:14:06.52 process pointer page 26 of 165
07:14:06.60 process pointer page 27 of 165
07:14:06.63 process pointer page 28 of 165
07:14:06.66 process pointer page 29 of 165
07:14:06.69 process pointer page 30 of 165
07:14:06.77 process pointer page 31 of 165
07:14:06.80 process pointer page 32 of 165
07:14:06.83 process pointer page 33 of 165
07:14:06.91 process pointer page 34 of 165
07:14:07.00 process pointer page 35 of 165
07:14:07.08 process pointer page 36 of 165
07:14:07.16 process pointer page 37 of 165
07:14:07.24 process pointer page 38 of 165
07:14:07.31 process pointer page 39 of 165
07:14:07.36 process pointer page 40 of 165
07:14:07.39 process pointer page 41 of 165
07:14:07.42 process pointer page 42 of 165
07:14:07.45 process pointer page 43 of 165
07:14:07.48 process pointer page 44 of 165
07:14:07.50 process pointer page 45 of 165
07:14:07.56 process pointer page 46 of 165
07:14:07.64 process pointer page 47 of 165
07:14:07.69 process pointer page 48 of 165
07:14:07.73 process pointer page 49 of 165
07:14:07.77 process pointer page 50 of 165
07:14:07.80 process pointer page 51 of 165
07:14:07.83 process pointer page 52 of 165
07:14:07.86 process pointer page 53 of 165
07:14:07.87 process pointer page 54 of 165
07:14:07.91 process pointer page 55 of 165
07:14:07.94 process pointer page 56 of 165
07:14:07.95 process pointer page 57 of 165
07:14:07.98 process pointer page 58 of 165
07:14:08.02 process pointer page 59 of 165
07:14:08.05 process pointer page 60 of 165
07:14:08.12 process pointer page 61 of 165
07:14:08.20 process pointer page 62 of 165
07:14:08.25 process pointer page 63 of 165
07:14:08.28 process pointer page 64 of 165
07:14:08.31 process pointer page 65 of 165
07:14:08.34 process pointer page 66 of 165
07:14:08.37 process pointer page 67 of 165
07:14:08.41 process pointer page 68 of 165
07:14:08.44 process pointer page 69 of 165
07:14:08.45 process pointer page 70 of 165
07:14:08.48 process pointer page 71 of 165
07:14:08.51 process pointer page 72 of 165
07:14:08.55 process pointer page 73 of 165
07:14:08.58 process pointer page 74 of 165
07:14:08.61 process pointer page 75 of 165
07:14:08.64 process pointer page 76 of 165
07:14:08.72 process pointer page 77 of 165
07:14:08.80 process pointer page 78 of 165
07:14:08.87 process pointer page 79 of 165
07:14:08.97 process pointer page 80 of 165
07:14:09.04 process pointer page 81 of 165
07:14:09.08 process pointer page 82 of 165
07:14:09.11 process pointer page 83 of 165
07:14:09.14 process pointer page 84 of 165
07:14:09.17 process pointer page 85 of 165
07:14:09.20 process pointer page 86 of 165
07:14:09.23 process pointer page 87 of 165
07:14:09.28 process pointer page 88 of 165
07:14:09.33 process pointer page 89 of 165
07:14:09.36 process pointer page 90 of 165
07:14:09.40 process pointer page 91 of 165
07:14:09.43 process pointer page 92 of 165
07:14:09.47 process pointer page 93 of 165
07:14:09.50 process pointer page 94 of 165
07:14:09.53 process pointer page 95 of 165
07:14:09.56 process pointer page 96 of 165
07:14:09.58 process pointer page 97 of 165
07:14:09.62 process pointer page 98 of 165
07:14:09.65 process pointer page 99 of 165
07:14:09.68 process pointer page 100 of 165
07:14:09.72 process pointer page 101 of 165
07:14:09.75 process pointer page 102 of 165
07:14:09.78 process pointer page 103 of 165
07:14:09.79 process pointer page 104 of 165
07:14:09.82 process pointer page 105 of 165
07:14:09.86 process pointer page 106 of 165
07:14:09.89 process pointer page 107 of 165
07:14:09.92 process pointer page 108 of 165
07:14:09.98 process pointer page 109 of 165
07:14:10.01 process pointer page 110 of 165
07:14:10.07 process pointer page 111 of 165
07:14:10.15 process pointer page 112 of 165
07:14:10.20 process pointer page 113 of 165
07:14:10.23 process pointer page 114 of 165
07:14:10.26 process pointer page 115 of 165
07:14:10.29 process pointer page 116 of 165
07:14:10.32 process pointer page 117 of 165
07:14:10.36 process pointer page 118 of 165
07:14:10.39 process pointer page 119 of 165
07:14:10.40 process pointer page 120 of 165
07:14:10.43 process pointer page 121 of 165
07:14:10.46 process pointer page 122 of 165
07:14:10.50 process pointer page 123 of 165
07:14:10.51 process pointer page 124 of 165
07:14:10.54 process pointer page 125 of 165
07:14:10.57 process pointer page 126 of 165
07:14:10.60 process pointer page 127 of 165
07:14:10.65 process pointer page 128 of 165
07:14:10.70 process pointer page 129 of 165
07:14:10.73 process pointer page 130 of 165
07:14:10.76 process pointer page 131 of 165
07:14:10.79 process pointer page 132 of 165
07:14:10.82 process pointer page 133 of 165
07:14:10.85 process pointer page 134 of 165
07:14:10.89 process pointer page 135 of 165
07:14:10.92 process pointer page 136 of 165
07:14:10.95 process pointer page 137 of 165
07:14:10.98 process pointer page 138 of 165
07:14:11.03 process pointer page 139 of 165
07:14:11.12 process pointer page 140 of 165
07:14:11.20 process pointer page 141 of 165
07:14:11.28 process pointer page 142 of 165
07:14:11.34 process pointer page 143 of 165
07:14:11.37 process pointer page 144 of 165
07:14:11.40 process pointer page 145 of 165
07:14:11.43 process pointer page 146 of 165
07:14:11.46 process pointer page 147 of 165
07:14:11.49 process pointer page 148 of 165
07:14:11.53 process pointer page 149 of 165
07:14:11.54 process pointer page 150 of 165
07:14:11.57 process pointer page 151 of 165
07:14:11.65 process pointer page 152 of 165
07:14:11.73 process pointer page 153 of 165
07:14:11.81 process pointer page 154 of 165
07:14:11.85 process pointer page 155 of 165
07:14:11.88 process pointer page 156 of 165
07:14:11.92 process pointer page 157 of 165
07:14:11.95 process pointer page 158 of 165
07:14:11.98 process pointer page 159 of 165
07:14:12.01 process pointer page 160 of 165
07:14:12.04 process pointer page 161 of 165
07:14:12.07 process pointer page 162 of 165
07:14:12.09 process pointer page 163 of 165
07:14:12.13 process pointer page 164 of 165
07:14:12.13 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:14:14.79 Index 2 (PERF_LOG_UNIT)
07:14:17.67 Index 3 (PERF_LOG_TRN_DESC)
07:14:19.48 Index 4 (PERF_LOG_GDSCODE)
07:14:20.68 Relation 163 (PERF_LOG) is ok
07:14:20.68 Relation 167 (V_STOPTEST)
07:14:20.68 Relation 167 (V_STOPTEST) is ok
07:14:20.68 Relation 184 (V_QDISTR_SOURCE)
07:14:20.68 Relation 184 (V_QDISTR_SOURCE) is ok
07:14:20.68 Relation 185 (V_QSTORNED_SOURCE)
07:14:20.68 Relation 185 (V_QSTORNED_SOURCE) is ok
07:14:20.68 Relation 260 (XQD_1000_1200)
07:14:20.68 process pointer page 0 of 2
07:14:20.70 process pointer page 1 of 2
07:14:20.70 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:14:20.70 Relation 260 (XQD_1000_1200) is ok
07:14:20.70 Relation 261 (XQD_1200_2000)
07:14:20.70 process pointer page 0 of 3
07:14:20.71 process pointer page 1 of 3
07:14:20.71 process pointer page 2 of 3
07:14:20.71 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:14:20.73 Relation 261 (XQD_1200_2000) is ok
07:14:20.73 Relation 262 (XQD_1000_3300)
07:14:20.73 process pointer page 0 of 9
07:14:20.79 process pointer page 1 of 9
07:14:20.85 process pointer page 2 of 9
07:14:20.89 process pointer page 3 of 9
07:14:20.93 process pointer page 4 of 9
07:14:20.96 process pointer page 5 of 9
07:14:20.99 process pointer page 6 of 9
07:14:21.09 process pointer page 7 of 9
07:14:21.12 process pointer page 8 of 9
07:14:21.18 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:14:21.48 Index 2 (XQD_1000_3300_DOC)
07:14:21.59 Relation 262 (XQD_1000_3300) is ok
07:14:21.59 Relation 263 (XQD_2000_3300)
07:14:21.59 process pointer page 0 of 15
07:14:21.62 process pointer page 1 of 15
07:14:21.65 process pointer page 2 of 15
07:14:21.67 process pointer page 3 of 15
07:14:21.71 process pointer page 4 of 15
07:14:21.76 process pointer page 5 of 15
07:14:21.84 process pointer page 6 of 15
07:14:21.87 process pointer page 7 of 15
07:14:21.95 process pointer page 8 of 15
07:14:21.98 process pointer page 9 of 15
07:14:22.04 process pointer page 10 of 15
07:14:22.07 process pointer page 11 of 15
07:14:22.10 process pointer page 12 of 15
07:14:22.15 process pointer page 13 of 15
07:14:22.24 process pointer page 14 of 15
07:14:22.30 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:14:22.59 Relation 263 (XQD_2000_3300) is ok
07:14:22.59 Relation 264 (XQD_2100_3300)
07:14:22.59 process pointer page 0 of 3
07:14:22.60 process pointer page 1 of 3
07:14:22.60 process pointer page 2 of 3
07:14:22.60 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:14:22.60 Relation 264 (XQD_2100_3300) is ok
07:14:22.60 Relation 265 (XQD_3300_3400)
07:14:22.60 process pointer page 0 of 24
07:14:22.69 process pointer page 1 of 24
07:14:22.79 process pointer page 2 of 24
07:14:22.87 process pointer page 3 of 24
07:14:22.96 process pointer page 4 of 24
07:14:23.04 process pointer page 5 of 24
07:14:23.07 process pointer page 6 of 24
07:14:23.10 process pointer page 7 of 24
07:14:23.15 process pointer page 8 of 24
07:14:23.18 process pointer page 9 of 24
07:14:23.24 process pointer page 10 of 24
07:14:23.33 process pointer page 11 of 24
07:14:23.41 process pointer page 12 of 24
07:14:23.51 process pointer page 13 of 24
07:14:23.58 process pointer page 14 of 24
07:14:23.65 process pointer page 15 of 24
07:14:23.69 process pointer page 16 of 24
07:14:23.72 process pointer page 17 of 24
07:14:23.79 process pointer page 18 of 24
07:14:23.88 process pointer page 19 of 24
07:14:23.94 process pointer page 20 of 24
07:14:23.97 process pointer page 21 of 24
07:14:24.01 process pointer page 22 of 24
07:14:24.05 process pointer page 23 of 24
07:14:24.05 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:14:24.57 Relation 265 (XQD_3300_3400) is ok
07:14:24.57 Relation 266 (XQS_1000_1200)
07:14:24.58 process pointer page 0 of 43
07:14:24.60 process pointer page 1 of 43
07:14:24.63 process pointer page 2 of 43
07:14:24.66 process pointer page 3 of 43
07:14:24.69 process pointer page 4 of 43
07:14:24.72 process pointer page 5 of 43
07:14:24.80 process pointer page 6 of 43
07:14:24.89 process pointer page 7 of 43
07:14:24.99 process pointer page 8 of 43
07:14:25.05 process pointer page 9 of 43
07:14:25.08 process pointer page 10 of 43
07:14:25.11 process pointer page 11 of 43
07:14:25.18 process pointer page 12 of 43
07:14:25.25 process pointer page 13 of 43
07:14:25.35 process pointer page 14 of 43
07:14:25.44 process pointer page 15 of 43
07:14:25.47 process pointer page 16 of 43
07:14:25.50 process pointer page 17 of 43
07:14:25.53 process pointer page 18 of 43
07:14:25.57 process pointer page 19 of 43
07:14:25.61 process pointer page 20 of 43
07:14:25.63 process pointer page 21 of 43
07:14:25.66 process pointer page 22 of 43
07:14:25.69 process pointer page 23 of 43
07:14:25.72 process pointer page 24 of 43
07:14:25.75 process pointer page 25 of 43
07:14:25.78 process pointer page 26 of 43
07:14:25.81 process pointer page 27 of 43
07:14:25.86 process pointer page 28 of 43
07:14:25.94 process pointer page 29 of 43
07:14:26.03 process pointer page 30 of 43
07:14:26.06 process pointer page 31 of 43
07:14:26.10 process pointer page 32 of 43
07:14:26.13 process pointer page 33 of 43
07:14:26.22 process pointer page 34 of 43
07:14:26.28 process pointer page 35 of 43
07:14:26.31 process pointer page 36 of 43
07:14:26.36 process pointer page 37 of 43
07:14:26.39 process pointer page 38 of 43
07:14:26.42 process pointer page 39 of 43
07:14:26.45 process pointer page 40 of 43
07:14:26.49 process pointer page 41 of 43
07:14:26.52 process pointer page 42 of 43
07:14:26.53 Index 1 (XQS_1000_1200_DOC_ID)
07:14:27.42 Index 2 (XQS_1000_1200_SND_ID)
07:14:28.48 Index 3 (XQS_1000_1200_RCV_ID)
07:14:29.28 Relation 266 (XQS_1000_1200) is ok
07:14:29.28 Relation 267 (XQS_1200_2000)
07:14:29.28 process pointer page 0 of 46
07:14:29.31 process pointer page 1 of 46
07:14:29.36 process pointer page 2 of 46
07:14:29.45 process pointer page 3 of 46
07:14:29.54 process pointer page 4 of 46
07:14:29.62 process pointer page 5 of 46
07:14:29.71 process pointer page 6 of 46
07:14:29.81 process pointer page 7 of 46
07:14:29.90 process pointer page 8 of 46
07:14:30.00 process pointer page 9 of 46
07:14:30.09 process pointer page 10 of 46
07:14:30.20 process pointer page 11 of 46
07:14:30.31 process pointer page 12 of 46
07:14:30.40 process pointer page 13 of 46
07:14:30.51 process pointer page 14 of 46
07:14:30.60 process pointer page 15 of 46
07:14:30.71 process pointer page 16 of 46
07:14:30.82 process pointer page 17 of 46
07:14:30.93 process pointer page 18 of 46
07:14:31.03 process pointer page 19 of 46
07:14:31.13 process pointer page 20 of 46
07:14:31.21 process pointer page 21 of 46
07:14:31.27 process pointer page 22 of 46
07:14:31.35 process pointer page 23 of 46
07:14:31.38 process pointer page 24 of 46
07:14:31.43 process pointer page 25 of 46
07:14:31.46 process pointer page 26 of 46
07:14:31.51 process pointer page 27 of 46
07:14:31.54 process pointer page 28 of 46
07:14:31.57 process pointer page 29 of 46
07:14:31.62 process pointer page 30 of 46
07:14:31.65 process pointer page 31 of 46
07:14:31.71 process pointer page 32 of 46
07:14:31.74 process pointer page 33 of 46
07:14:31.77 process pointer page 34 of 46
07:14:31.82 process pointer page 35 of 46
07:14:31.85 process pointer page 36 of 46
07:14:31.88 process pointer page 37 of 46
07:14:31.90 process pointer page 38 of 46
07:14:31.95 process pointer page 39 of 46
07:14:31.96 process pointer page 40 of 46
07:14:31.99 process pointer page 41 of 46
07:14:32.02 process pointer page 42 of 46
07:14:32.05 process pointer page 43 of 46
07:14:32.10 process pointer page 44 of 46
07:14:32.16 process pointer page 45 of 46
07:14:32.26 Index 1 (XQS_1200_2000_DOC_ID)
07:14:33.51 Index 2 (XQS_1200_2000_SND_ID)
07:14:34.96 Index 3 (XQS_1200_2000_RCV_ID)
07:14:36.14 Relation 267 (XQS_1200_2000) is ok
07:14:36.14 Relation 268 (XQS_1000_3300)
07:14:36.14 process pointer page 0 of 24
07:14:36.64 process pointer page 1 of 24
07:14:37.12 process pointer page 2 of 24
07:14:37.61 process pointer page 3 of 24
07:14:38.09 process pointer page 4 of 24
07:14:38.59 process pointer page 5 of 24
07:14:39.07 process pointer page 6 of 24
07:14:39.56 process pointer page 7 of 24
07:14:39.93 process pointer page 8 of 24
07:14:40.29 process pointer page 9 of 24
07:14:40.65 process pointer page 10 of 24
07:14:41.04 process pointer page 11 of 24
07:14:41.41 process pointer page 12 of 24
07:14:41.76 process pointer page 13 of 24
07:14:42.13 process pointer page 14 of 24
07:14:42.49 process pointer page 15 of 24
07:14:42.87 process pointer page 16 of 24
07:14:43.22 process pointer page 17 of 24
07:14:43.58 process pointer page 18 of 24
07:14:43.99 process pointer page 19 of 24
07:14:44.36 process pointer page 20 of 24
07:14:44.74 process pointer page 21 of 24
07:14:45.13 process pointer page 22 of 24
07:14:45.52 process pointer page 23 of 24
07:14:45.74 Index 1 (XQS_1000_3300_DOC_ID)
07:14:47.09 Index 2 (XQS_1000_3300_SND_ID)
07:14:48.59 Index 3 (XQS_1000_3300_RCV_ID)
07:14:49.98 Relation 268 (XQS_1000_3300) is ok
07:14:49.98 Relation 269 (XQS_2000_3300)
07:14:49.98 process pointer page 0 of 1
07:14:49.98 Index 1 (XQS_2000_3300_DOC_ID)
07:14:49.98 Index 2 (XQS_2000_3300_SND_ID)
07:14:49.98 Index 3 (XQS_2000_3300_RCV_ID)
07:14:49.98 Relation 269 (XQS_2000_3300) is ok
07:14:49.98 Relation 270 (XQS_2100_3300)
07:14:49.98 process pointer page 0 of 32
07:14:50.45 process pointer page 1 of 32
07:14:50.93 process pointer page 2 of 32
07:14:51.41 process pointer page 3 of 32
07:14:51.90 process pointer page 4 of 32
07:14:52.38 process pointer page 5 of 32
07:14:52.87 process pointer page 6 of 32
07:14:53.36 process pointer page 7 of 32
07:14:53.83 process pointer page 8 of 32
07:14:54.27 process pointer page 9 of 32
07:14:54.68 process pointer page 10 of 32
07:14:54.97 process pointer page 11 of 32
07:14:55.33 process pointer page 12 of 32
07:14:55.67 process pointer page 13 of 32
07:14:56.13 process pointer page 14 of 32
07:14:56.53 process pointer page 15 of 32
07:14:56.95 process pointer page 16 of 32
07:14:57.36 process pointer page 17 of 32
07:14:57.72 process pointer page 18 of 32
07:14:58.11 process pointer page 19 of 32
07:14:58.54 process pointer page 20 of 32
07:14:58.95 process pointer page 21 of 32
07:14:59.34 process pointer page 22 of 32
07:14:59.73 process pointer page 23 of 32
07:15:00.12 process pointer page 24 of 32
07:15:00.53 process pointer page 25 of 32
07:15:00.92 process pointer page 26 of 32
07:15:01.34 process pointer page 27 of 32
07:15:01.77 process pointer page 28 of 32
07:15:02.16 process pointer page 29 of 32
07:15:02.58 process pointer page 30 of 32
07:15:02.96 process pointer page 31 of 32
07:15:03.11 Index 1 (XQS_2100_3300_DOC_ID)
07:15:04.69 Index 2 (XQS_2100_3300_SND_ID)
07:15:06.33 Index 3 (XQS_2100_3300_RCV_ID)
07:15:08.26 Relation 270 (XQS_2100_3300) is ok
07:15:08.26 Relation 271 (XQS_3300_3400)
07:15:08.26 process pointer page 0 of 6
07:15:08.75 process pointer page 1 of 6
07:15:09.23 process pointer page 2 of 6
07:15:09.71 process pointer page 3 of 6
07:15:10.18 process pointer page 4 of 6
07:15:10.63 process pointer page 5 of 6
07:15:10.87 Index 1 (XQS_3300_3400_DOC_ID)
07:15:11.24 Index 2 (XQS_3300_3400_SND_ID)
07:15:11.65 Relation 271 (XQS_3300_3400) is ok
07:15:11.66 Validation finished
Done for 70820 ms, from 7:14:01.00 to 7:15:11.82.
Differences between old and current firebird.log
7:15:13.64. 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-08-22 07:15 471 oltp30_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Tue Aug 22 07:14:01 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Tue Aug 22 07:15:11 2017
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 397 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-08-22 7:15:20.99 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html