Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-10-11 11:20:09.55.
Server version: WI-T4.0.0.760 Firebird 4.0 Alpha 1
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperServer 4.0.0 |
D:\OLTP-EMUL\OLTP40-SMALL.FDB |
ON |
0 |
786432 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp40_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB40.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp40-small.fdb |
host |
localhost |
port |
3400 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp40 |
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\oltp40-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-10-11 11:16:58.8440 |
-1 |
<null> |
|
::1/65093 |
421759 |
9075 |
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 179 minutes: |
6660.15 |
977 |
1192166 |
2017-10-11 08:17 |
2017-10-11 11:16 |
customer order: creation |
421.31 |
118 |
75415 |
2017-10-11 08:17 |
2017-10-11 11:16 |
customer order: refuse |
35.03 |
58 |
6270 |
2017-10-11 08:17 |
2017-10-11 11:16 |
order to supplier: creation |
107.93 |
477 |
19320 |
2017-10-11 08:17 |
2017-10-11 11:16 |
order to supplier: removal |
3.26 |
6523 |
583 |
2017-10-11 08:17 |
2017-10-11 11:16 |
invoice (draft): creation |
109.21 |
751 |
19548 |
2017-10-11 08:17 |
2017-10-11 11:16 |
invoice (draft): removal |
48.36 |
128 |
8657 |
2017-10-11 08:17 |
2017-10-11 11:16 |
invoice accept: apply |
62.52 |
2768 |
11191 |
2017-10-11 08:17 |
2017-10-11 11:16 |
invoice accept: cancel |
21.57 |
620 |
3861 |
2017-10-11 08:17 |
2017-10-11 11:16 |
customer reserve: creation |
3783.89 |
37 |
677316 |
2017-10-11 08:17 |
2017-10-11 11:16 |
customer reserve: removal |
1471.89 |
14 |
263469 |
2017-10-11 08:17 |
2017-10-11 11:16 |
realization accept: apply |
198.51 |
121 |
35533 |
2017-10-11 08:17 |
2017-10-11 11:16 |
realization accept: cancel |
95.46 |
35 |
17088 |
2017-10-11 08:17 |
2017-10-11 11:16 |
payment from customer: creation |
141.41 |
209 |
25313 |
2017-10-11 08:17 |
2017-10-11 11:16 |
payment from customer: removal |
13.27 |
34 |
2376 |
2017-10-11 08:17 |
2017-10-11 11:16 |
payment to supplier: creation |
115.44 |
556 |
20663 |
2017-10-11 08:17 |
2017-10-11 11:16 |
payment to supplier: removal |
7.91 |
38 |
1415 |
2017-10-11 08:17 |
2017-10-11 11:16 |
service: total inventory turnovers |
11.50 |
592 |
2058 |
2017-10-11 08:17 |
2017-10-11 11:16 |
service: total monetary turnovers |
11.61 |
22 |
2078 |
2017-10-11 08:17 |
2017-10-11 11:16 |
service: refresh index statistics |
0.07 |
5458 |
12 |
2017-10-11 08:17 |
2017-10-11 11:16 |
Done for 124130 ms, from 11:23:12.90 to 11:25:17.03.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
5277 |
107990 |
94992 |
12998 |
12.04 |
08:16:59 |
08:34:59 |
interval # 2, overall |
2 |
6943 |
143606 |
124972 |
18634 |
12.98 |
08:35:00 |
08:53:00 |
interval # 3, overall |
3 |
6662 |
138779 |
119917 |
18862 |
13.59 |
08:53:01 |
09:11:01 |
interval # 4, overall |
4 |
7046 |
147891 |
126819 |
21072 |
14.25 |
09:11:02 |
09:29:02 |
interval # 5, overall |
5 |
7197 |
148249 |
129550 |
18699 |
12.61 |
09:29:03 |
09:47:03 |
interval # 6, overall |
6 |
6902 |
158453 |
124235 |
34218 |
21.60 |
09:47:04 |
10:05:04 |
interval # 7, overall |
7 |
7047 |
154618 |
126850 |
27768 |
17.96 |
10:05:05 |
10:23:05 |
interval # 8, overall |
8 |
6650 |
143278 |
119702 |
23576 |
16.45 |
10:23:06 |
10:41:06 |
interval # 9, overall |
9 |
5848 |
131732 |
105265 |
26467 |
20.09 |
10:41:07 |
10:59:07 |
interval # 10, overall |
10 |
6659 |
145900 |
119864 |
26036 |
17.85 |
10:59:08 |
11:17:08 |
Done for 274690 ms, from 11:29:51.82 to 11:34:26.51.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
1720.45 |
0.0005 |
2.0634 |
2106 |
26 |
TEST_TIME |
2 |
2979.92 |
0.5958 |
1.3344 |
2243 |
27 |
TEST_TIME |
3 |
3170.37 |
0.8362 |
1.2111 |
1504 |
100 |
TEST_TIME |
4 |
3337.73 |
0.8633 |
1.1645 |
1595 |
100 |
TEST_TIME |
5 |
3458.98 |
0.8991 |
1.1091 |
1380 |
100 |
TEST_TIME |
6 |
3490.85 |
0.9160 |
1.0979 |
1605 |
100 |
TEST_TIME |
7 |
3604.71 |
0.9115 |
1.0754 |
1275 |
100 |
TEST_TIME |
8 |
3734.98 |
0.9098 |
1.0951 |
1882 |
100 |
TEST_TIME |
9 |
3928.16 |
0.9266 |
1.0750 |
1837 |
100 |
TEST_TIME |
10 |
4073.12 |
0.9332 |
1.0599 |
1628 |
100 |
TEST_TIME |
11 |
4172.88 |
0.9408 |
1.0642 |
1736 |
100 |
TEST_TIME |
12 |
4306.42 |
0.9453 |
1.0479 |
1548 |
100 |
TEST_TIME |
13 |
4352.28 |
0.9572 |
1.0512 |
1355 |
100 |
TEST_TIME |
14 |
4420.81 |
0.9610 |
1.0345 |
1309 |
100 |
TEST_TIME |
15 |
4495.45 |
0.9496 |
1.0567 |
1931 |
100 |
TEST_TIME |
16 |
4671.48 |
0.9533 |
1.0452 |
2155 |
100 |
TEST_TIME |
17 |
4839.35 |
0.9497 |
1.0569 |
2103 |
100 |
TEST_TIME |
18 |
5035.41 |
0.9593 |
1.0474 |
1865 |
100 |
TEST_TIME |
19 |
5190.83 |
0.9625 |
1.0365 |
1707 |
100 |
TEST_TIME |
20 |
5294.00 |
0.9655 |
1.0323 |
1759 |
100 |
TEST_TIME |
21 |
5343.84 |
0.9740 |
1.0184 |
1380 |
100 |
TEST_TIME |
22 |
5334.14 |
0.9738 |
1.0230 |
1133 |
100 |
TEST_TIME |
23 |
5365.73 |
0.9730 |
1.0262 |
1547 |
100 |
TEST_TIME |
24 |
5427.08 |
0.9723 |
1.0247 |
1482 |
100 |
TEST_TIME |
25 |
5485.50 |
0.9732 |
1.0230 |
1460 |
100 |
TEST_TIME |
26 |
5502.54 |
0.9807 |
1.0204 |
1241 |
100 |
TEST_TIME |
27 |
5515.31 |
0.9803 |
1.0194 |
1404 |
100 |
TEST_TIME |
28 |
5526.12 |
0.9811 |
1.0173 |
1397 |
100 |
TEST_TIME |
29 |
5532.89 |
0.9815 |
1.0176 |
1319 |
100 |
TEST_TIME |
30 |
5602.45 |
0.9715 |
1.0279 |
1954 |
100 |
TEST_TIME |
31 |
5700.70 |
0.9776 |
1.0243 |
2118 |
100 |
TEST_TIME |
32 |
5785.44 |
0.9777 |
1.0222 |
1554 |
100 |
TEST_TIME |
33 |
5853.30 |
0.9798 |
1.0231 |
1859 |
100 |
TEST_TIME |
34 |
5918.91 |
0.9821 |
1.0184 |
1724 |
100 |
TEST_TIME |
35 |
5948.48 |
0.9844 |
1.0147 |
1506 |
100 |
TEST_TIME |
36 |
6006.87 |
0.9822 |
1.0169 |
1701 |
100 |
TEST_TIME |
37 |
6044.01 |
0.9834 |
1.0170 |
1375 |
100 |
TEST_TIME |
38 |
6079.89 |
0.9849 |
1.0139 |
1432 |
100 |
TEST_TIME |
39 |
6087.60 |
0.9867 |
1.0116 |
1338 |
100 |
TEST_TIME |
40 |
6062.20 |
0.9905 |
1.0120 |
1258 |
100 |
TEST_TIME |
41 |
6030.23 |
0.9926 |
1.0087 |
1105 |
100 |
TEST_TIME |
42 |
5998.74 |
0.9898 |
1.0053 |
1045 |
100 |
TEST_TIME |
43 |
5925.40 |
0.9940 |
1.0107 |
887 |
100 |
TEST_TIME |
44 |
5922.52 |
0.9885 |
1.0110 |
1271 |
100 |
TEST_TIME |
45 |
5957.59 |
0.9827 |
1.0157 |
2017 |
100 |
TEST_TIME |
46 |
6037.87 |
0.9805 |
1.0145 |
1950 |
100 |
TEST_TIME |
47 |
6089.22 |
0.9845 |
1.0124 |
1939 |
100 |
TEST_TIME |
48 |
6146.15 |
0.9821 |
1.0127 |
1686 |
100 |
TEST_TIME |
49 |
6175.76 |
0.9875 |
1.0158 |
1533 |
100 |
TEST_TIME |
50 |
6200.48 |
0.9916 |
1.0121 |
1349 |
100 |
TEST_TIME |
51 |
6207.29 |
0.9912 |
1.0096 |
1452 |
100 |
TEST_TIME |
52 |
6216.94 |
0.9886 |
1.0115 |
1497 |
100 |
TEST_TIME |
53 |
6240.95 |
0.9886 |
1.0095 |
1407 |
100 |
TEST_TIME |
54 |
6238.13 |
0.9913 |
1.0087 |
1294 |
100 |
TEST_TIME |
55 |
6246.74 |
0.9890 |
1.0117 |
1172 |
99 |
TEST_TIME |
56 |
6267.49 |
0.9903 |
1.0076 |
1213 |
100 |
TEST_TIME |
57 |
6257.21 |
0.9915 |
1.0123 |
1212 |
100 |
TEST_TIME |
58 |
6274.12 |
0.9922 |
1.0074 |
1084 |
100 |
TEST_TIME |
59 |
6274.51 |
0.9902 |
1.0073 |
1215 |
100 |
TEST_TIME |
60 |
6286.86 |
0.9885 |
1.0129 |
1962 |
100 |
TEST_TIME |
61 |
6324.86 |
0.9903 |
1.0128 |
1705 |
100 |
TEST_TIME |
62 |
6351.35 |
0.9924 |
1.0093 |
1457 |
100 |
TEST_TIME |
63 |
6381.30 |
0.9888 |
1.0080 |
1580 |
100 |
TEST_TIME |
64 |
6394.30 |
0.9905 |
1.0083 |
1622 |
100 |
TEST_TIME |
65 |
6407.22 |
0.9908 |
1.0087 |
1583 |
100 |
TEST_TIME |
66 |
6421.14 |
0.9913 |
1.0075 |
1482 |
100 |
TEST_TIME |
67 |
6436.87 |
0.9901 |
1.0066 |
1422 |
100 |
TEST_TIME |
68 |
6456.15 |
0.9889 |
1.0108 |
1283 |
100 |
TEST_TIME |
69 |
6477.17 |
0.9929 |
1.0070 |
1376 |
100 |
TEST_TIME |
70 |
6476.45 |
0.9927 |
1.0063 |
1236 |
100 |
TEST_TIME |
71 |
6444.43 |
0.9971 |
1.0039 |
1341 |
94 |
TEST_TIME |
72 |
6424.02 |
0.9931 |
1.0079 |
1234 |
99 |
TEST_TIME |
73 |
6422.47 |
0.9943 |
1.0076 |
1198 |
100 |
TEST_TIME |
74 |
6437.17 |
0.9918 |
1.0073 |
1107 |
100 |
TEST_TIME |
75 |
6460.95 |
0.9902 |
1.0098 |
1732 |
100 |
TEST_TIME |
76 |
6498.84 |
0.9907 |
1.0106 |
1790 |
100 |
TEST_TIME |
77 |
6539.95 |
0.9912 |
1.0084 |
1682 |
100 |
TEST_TIME |
78 |
6561.54 |
0.9922 |
1.0093 |
1508 |
100 |
TEST_TIME |
79 |
6588.52 |
0.9925 |
1.0082 |
1617 |
100 |
TEST_TIME |
80 |
6606.69 |
0.9928 |
1.0062 |
1494 |
100 |
TEST_TIME |
81 |
6590.18 |
0.9963 |
1.0025 |
1420 |
99 |
TEST_TIME |
82 |
6573.52 |
0.9928 |
1.0049 |
1131 |
100 |
TEST_TIME |
83 |
6558.99 |
0.9950 |
1.0050 |
1130 |
100 |
TEST_TIME |
84 |
6553.17 |
0.9939 |
1.0083 |
1186 |
100 |
TEST_TIME |
85 |
6561.24 |
0.9952 |
1.0061 |
1214 |
100 |
TEST_TIME |
86 |
6557.22 |
0.9950 |
1.0056 |
1303 |
100 |
TEST_TIME |
87 |
6558.07 |
0.9941 |
1.0071 |
1249 |
100 |
TEST_TIME |
88 |
6558.94 |
0.9955 |
1.0051 |
1215 |
100 |
TEST_TIME |
89 |
6549.22 |
0.9953 |
1.0054 |
1186 |
100 |
TEST_TIME |
90 |
6562.28 |
0.9923 |
1.0081 |
1440 |
100 |
TEST_TIME |
91 |
6598.24 |
0.9918 |
1.0079 |
1820 |
100 |
TEST_TIME |
92 |
6633.40 |
0.9917 |
1.0079 |
1700 |
100 |
TEST_TIME |
93 |
6645.52 |
0.9952 |
1.0062 |
1584 |
100 |
TEST_TIME |
94 |
6659.96 |
0.9933 |
1.0067 |
1503 |
100 |
TEST_TIME |
95 |
6667.22 |
0.9950 |
1.0061 |
1557 |
100 |
TEST_TIME |
96 |
6673.99 |
0.9946 |
1.0050 |
1430 |
100 |
TEST_TIME |
97 |
6669.22 |
0.9953 |
1.0049 |
1311 |
100 |
TEST_TIME |
98 |
6670.52 |
0.9944 |
1.0060 |
1279 |
100 |
TEST_TIME |
99 |
6671.00 |
0.9958 |
1.0038 |
1114 |
100 |
TEST_TIME |
100 |
6654.39 |
0.9962 |
1.0032 |
1275 |
100 |
TEST_TIME |
101 |
6646.14 |
0.9945 |
1.0042 |
1122 |
100 |
TEST_TIME |
102 |
6636.68 |
0.9958 |
1.0047 |
1155 |
100 |
TEST_TIME |
103 |
6622.99 |
0.9970 |
1.0016 |
1203 |
100 |
TEST_TIME |
104 |
6588.02 |
0.9974 |
1.0030 |
1127 |
96 |
TEST_TIME |
105 |
6579.81 |
0.9947 |
1.0057 |
1313 |
95 |
TEST_TIME |
106 |
6600.69 |
0.9931 |
1.0047 |
1444 |
100 |
TEST_TIME |
107 |
6606.85 |
0.9946 |
1.0060 |
1646 |
100 |
TEST_TIME |
108 |
6622.50 |
0.9944 |
1.0067 |
1577 |
100 |
TEST_TIME |
109 |
6631.97 |
0.9960 |
1.0041 |
1666 |
100 |
TEST_TIME |
110 |
6638.83 |
0.9940 |
1.0044 |
1432 |
100 |
TEST_TIME |
111 |
6636.07 |
0.9958 |
1.0042 |
1336 |
100 |
TEST_TIME |
112 |
6635.08 |
0.9954 |
1.0059 |
1394 |
100 |
TEST_TIME |
113 |
6644.96 |
0.9957 |
1.0054 |
1244 |
100 |
TEST_TIME |
114 |
6646.97 |
0.9963 |
1.0035 |
1236 |
100 |
TEST_TIME |
115 |
6634.52 |
0.9967 |
1.0037 |
1347 |
100 |
TEST_TIME |
116 |
6634.57 |
0.9950 |
1.0043 |
1269 |
100 |
TEST_TIME |
117 |
6631.37 |
0.9962 |
1.0036 |
1190 |
100 |
TEST_TIME |
118 |
6632.37 |
0.9951 |
1.0040 |
1115 |
100 |
TEST_TIME |
119 |
6628.37 |
0.9961 |
1.0028 |
1096 |
100 |
TEST_TIME |
120 |
6619.15 |
0.9959 |
1.0040 |
1607 |
100 |
TEST_TIME |
121 |
6643.95 |
0.9919 |
1.0056 |
1399 |
100 |
TEST_TIME |
122 |
6660.73 |
0.9948 |
1.0035 |
1459 |
100 |
TEST_TIME |
123 |
6664.79 |
0.9947 |
1.0047 |
1578 |
100 |
TEST_TIME |
124 |
6676.73 |
0.9948 |
1.0056 |
1458 |
100 |
TEST_TIME |
125 |
6683.87 |
0.9965 |
1.0041 |
1330 |
100 |
TEST_TIME |
126 |
6687.53 |
0.9955 |
1.0050 |
1268 |
100 |
TEST_TIME |
127 |
6679.44 |
0.9983 |
1.0033 |
1244 |
98 |
TEST_TIME |
128 |
6682.32 |
0.9950 |
1.0032 |
1085 |
100 |
TEST_TIME |
129 |
6662.51 |
0.9984 |
1.0011 |
1373 |
99 |
TEST_TIME |
130 |
6651.87 |
0.9970 |
1.0019 |
1392 |
96 |
TEST_TIME |
131 |
6641.88 |
0.9958 |
1.0030 |
1051 |
100 |
TEST_TIME |
132 |
6630.26 |
0.9971 |
1.0027 |
1317 |
100 |
TEST_TIME |
133 |
6621.36 |
0.9967 |
1.0028 |
1225 |
100 |
TEST_TIME |
134 |
6627.07 |
0.9945 |
1.0036 |
1121 |
100 |
TEST_TIME |
135 |
6633.00 |
0.9952 |
1.0035 |
1656 |
100 |
TEST_TIME |
136 |
6636.17 |
0.9957 |
1.0036 |
1806 |
100 |
TEST_TIME |
137 |
6651.17 |
0.9941 |
1.0044 |
1510 |
100 |
TEST_TIME |
138 |
6655.83 |
0.9964 |
1.0052 |
1479 |
100 |
TEST_TIME |
139 |
6666.81 |
0.9964 |
1.0044 |
1382 |
100 |
TEST_TIME |
140 |
6680.95 |
0.9951 |
1.0055 |
1324 |
100 |
TEST_TIME |
141 |
6695.01 |
0.9963 |
1.0035 |
1280 |
100 |
TEST_TIME |
142 |
6693.52 |
0.9966 |
1.0030 |
1203 |
100 |
TEST_TIME |
143 |
6690.53 |
0.9965 |
1.0031 |
1205 |
100 |
TEST_TIME |
144 |
6692.92 |
0.9958 |
1.0030 |
1100 |
100 |
TEST_TIME |
145 |
6682.11 |
0.9977 |
1.0031 |
1174 |
100 |
TEST_TIME |
146 |
6677.88 |
0.9969 |
1.0020 |
1254 |
100 |
TEST_TIME |
147 |
6651.92 |
0.9991 |
1.0013 |
1253 |
97 |
TEST_TIME |
148 |
6632.63 |
0.9974 |
1.0034 |
1070 |
94 |
TEST_TIME |
149 |
6622.73 |
0.9991 |
1.0011 |
1057 |
92 |
TEST_TIME |
150 |
6603.01 |
0.9974 |
1.0021 |
1273 |
90 |
TEST_TIME |
151 |
6600.90 |
0.9957 |
1.0040 |
1150 |
99 |
TEST_TIME |
152 |
6606.66 |
0.9966 |
1.0029 |
1197 |
100 |
TEST_TIME |
153 |
6598.55 |
0.9976 |
1.0026 |
1456 |
100 |
TEST_TIME |
154 |
6606.74 |
0.9948 |
1.0033 |
1297 |
100 |
TEST_TIME |
155 |
6605.43 |
0.9971 |
1.0024 |
1241 |
100 |
TEST_TIME |
156 |
6607.20 |
0.9957 |
1.0031 |
1217 |
100 |
TEST_TIME |
157 |
6610.28 |
0.9962 |
1.0030 |
1264 |
100 |
TEST_TIME |
158 |
6606.19 |
0.9972 |
1.0025 |
1216 |
100 |
TEST_TIME |
159 |
6601.35 |
0.9970 |
1.0029 |
1198 |
100 |
TEST_TIME |
160 |
6601.45 |
0.9966 |
1.0036 |
1104 |
100 |
TEST_TIME |
161 |
6602.07 |
0.9973 |
1.0027 |
1103 |
100 |
TEST_TIME |
162 |
6596.71 |
0.9973 |
1.0016 |
1122 |
100 |
TEST_TIME |
163 |
6591.11 |
0.9963 |
1.0028 |
1159 |
100 |
TEST_TIME |
164 |
6586.64 |
0.9974 |
1.0047 |
1109 |
100 |
TEST_TIME |
165 |
6601.39 |
0.9964 |
1.0039 |
1473 |
100 |
TEST_TIME |
166 |
6606.75 |
0.9970 |
1.0032 |
1609 |
100 |
TEST_TIME |
167 |
6606.71 |
0.9973 |
1.0025 |
1472 |
100 |
TEST_TIME |
168 |
6609.46 |
0.9961 |
1.0028 |
1428 |
100 |
TEST_TIME |
169 |
6609.56 |
0.9969 |
1.0043 |
1298 |
100 |
TEST_TIME |
170 |
6620.03 |
0.9968 |
1.0023 |
1296 |
100 |
TEST_TIME |
171 |
6626.61 |
0.9955 |
1.0028 |
1210 |
100 |
TEST_TIME |
172 |
6630.44 |
0.9964 |
1.0028 |
1138 |
100 |
TEST_TIME |
173 |
6628.66 |
0.9973 |
1.0020 |
1124 |
100 |
TEST_TIME |
174 |
6623.37 |
0.9971 |
1.0032 |
1059 |
100 |
TEST_TIME |
175 |
6618.36 |
0.9984 |
1.0022 |
1106 |
100 |
TEST_TIME |
176 |
6612.80 |
0.9973 |
1.0022 |
933 |
100 |
TEST_TIME |
177 |
6601.42 |
0.9983 |
1.0017 |
1185 |
100 |
TEST_TIME |
178 |
6604.17 |
0.9956 |
1.0030 |
876 |
100 |
TEST_TIME |
179 |
6607.22 |
0.9970 |
1.0023 |
1089 |
100 |
TEST_TIME |
180 |
6601.91 |
0.9976 |
1.0032 |
1669 |
100 |
TEST_TIME |
181 |
6586.55 |
1.0000 |
1.0000 |
28 |
28 |
Done for 10760 ms, from 11:34:27.66 to 11:34:38.42.
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 |
64832 |
108228 |
67026 |
84265 |
66729 |
<null> |
94037 |
74062 |
44002 |
92123 |
78233 |
112519 |
68870 |
69000 |
136205 |
134597 |
175477 |
389555 |
<null> |
08:16:59 |
08:34:59 |
fetches per second |
2 |
81486 |
150343 |
59447 |
110799 |
75377 |
164923 |
89770 |
138108 |
86792 |
138389 |
76121 |
17565 |
82072 |
74693 |
192856 |
88083 |
267803 |
950000 |
<null> |
08:35:00 |
08:53:00 |
fetches per second |
3 |
66052 |
90031 |
56568 |
<null> |
76636 |
<null> |
97599 |
104052 |
132666 |
91973 |
86230 |
45519 |
97273 |
116636 |
192453 |
154620 |
<null> |
50918 |
1470 |
08:53:01 |
09:11:01 |
fetches per second |
4 |
76371 |
109879 |
62969 |
<null> |
72643 |
<null> |
105759 |
89990 |
16728 |
166333 |
87176 |
33722 |
83770 |
86666 |
175934 |
34131 |
216859 |
<null> |
<null> |
09:11:02 |
09:29:02 |
fetches per second |
5 |
71526 |
129184 |
55899 |
<null> |
64930 |
<null> |
105619 |
<null> |
<null> |
178515 |
85027 |
51055 |
98900 |
49428 |
188444 |
51826 |
<null> |
855000 |
<null> |
09:29:03 |
09:47:03 |
fetches per second |
6 |
68656 |
83087 |
47218 |
<null> |
67725 |
<null> |
99843 |
<null> |
69489 |
49342 |
87518 |
83571 |
107009 |
46375 |
202927 |
<null> |
189979 |
292000 |
<null> |
09:47:04 |
10:05:04 |
fetches per second |
7 |
93758 |
99536 |
59922 |
129467 |
72140 |
53466 |
97233 |
81106 |
122201 |
<null> |
63005 |
37204 |
103953 |
<null> |
186494 |
<null> |
226411 |
408266 |
<null> |
10:05:05 |
10:23:05 |
fetches per second |
8 |
68567 |
99558 |
48233 |
7690 |
40173 |
57886 |
80513 |
105208 |
103869 |
42052 |
88388 |
74690 |
83529 |
46340 |
159806 |
1573 |
279327 |
<null> |
<null> |
10:23:06 |
10:41:06 |
fetches per second |
9 |
66530 |
163623 |
62639 |
91842 |
56711 |
<null> |
88840 |
<null> |
9005 |
78108 |
64846 |
92277 |
94918 |
113666 |
177310 |
138114 |
<null> |
<null> |
<null> |
10:41:07 |
10:59:07 |
fetches per second |
10 |
58775 |
92756 |
55734 |
115491 |
74964 |
97363 |
74276 |
113247 |
158200 |
16408 |
82800 |
33379 |
90662 |
85234 |
163481 |
31040 |
39298 |
1016333 |
<null> |
10:59:08 |
11:17:08 |
marks per second |
1 |
14344 |
14380 |
14879 |
17624 |
15262 |
<null> |
14651 |
15651 |
5818 |
16383 |
14600 |
17354 |
6523 |
11718 |
6375 |
21125 |
23246 |
38972 |
<null> |
08:16:59 |
08:34:59 |
marks per second |
2 |
17814 |
21679 |
13235 |
23189 |
17231 |
39769 |
13933 |
23932 |
14666 |
25671 |
14280 |
3154 |
6765 |
13442 |
3504 |
8833 |
32421 |
76000 |
<null> |
08:35:00 |
08:53:00 |
marks per second |
3 |
14125 |
12870 |
12527 |
<null> |
17203 |
<null> |
13442 |
19837 |
15270 |
20003 |
12782 |
7234 |
7728 |
18386 |
4075 |
23200 |
<null> |
3189 |
189 |
08:53:01 |
09:11:01 |
marks per second |
4 |
15930 |
15310 |
13471 |
<null> |
16472 |
<null> |
14038 |
15265 |
2127 |
20555 |
12516 |
5966 |
7273 |
14222 |
2817 |
5015 |
15231 |
<null> |
<null> |
09:11:02 |
09:29:02 |
marks per second |
5 |
15446 |
16879 |
11980 |
<null> |
14906 |
<null> |
13724 |
<null> |
<null> |
33737 |
14070 |
8345 |
5964 |
10904 |
2799 |
4608 |
<null> |
96000 |
<null> |
09:29:03 |
09:47:03 |
marks per second |
6 |
14526 |
12745 |
10158 |
<null> |
14822 |
<null> |
14137 |
<null> |
10760 |
7443 |
14845 |
13870 |
6007 |
7062 |
2312 |
<null> |
27373 |
9700 |
<null> |
09:47:04 |
10:05:04 |
marks per second |
7 |
19885 |
12758 |
13254 |
27164 |
15889 |
13794 |
13384 |
12725 |
16819 |
<null> |
10799 |
4756 |
6115 |
<null> |
1813 |
<null> |
48991 |
34500 |
<null> |
10:05:05 |
10:23:05 |
marks per second |
8 |
14743 |
12654 |
10978 |
1330 |
9207 |
13652 |
11534 |
17875 |
11167 |
6687 |
12666 |
11820 |
4408 |
6221 |
1476 |
230 |
13828 |
<null> |
<null> |
10:23:06 |
10:41:06 |
marks per second |
9 |
14227 |
22376 |
13004 |
16292 |
12147 |
<null> |
11844 |
<null> |
1277 |
13984 |
8141 |
15125 |
4529 |
18833 |
3522 |
23700 |
<null> |
<null> |
<null> |
10:41:07 |
10:59:07 |
marks per second |
10 |
12693 |
13082 |
11625 |
20085 |
15301 |
25515 |
10389 |
18759 |
18600 |
3010 |
7772 |
5659 |
3789 |
12826 |
5026 |
5040 |
4518 |
86277 |
<null> |
10:59:08 |
11:17:08 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:16:59 |
08:34:59 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:35:00 |
08:53:00 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
08:53:01 |
09:11:01 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
09:11:02 |
09:29:02 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
09:29:03 |
09:47:03 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
09:47:04 |
10:05:04 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
<null> |
10:05:05 |
10:23:05 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
10:23:06 |
10:41:06 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
<null> |
10:41:07 |
10:59:07 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:59:08 |
11:17:08 |
writes/marks*100 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
1 |
0 |
1 |
1 |
0 |
<null> |
08:16:59 |
08:34:59 |
writes/marks*100 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:35:00 |
08:53:00 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
08:53:01 |
09:11:01 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
<null> |
<null> |
09:11:02 |
09:29:02 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
09:29:03 |
09:47:03 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
2 |
0 |
<null> |
09:47:04 |
10:05:04 |
writes/marks*100 |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
<null> |
0 |
<null> |
1 |
0 |
<null> |
10:05:05 |
10:23:05 |
writes/marks*100 |
8 |
1 |
2 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
<null> |
<null> |
10:23:06 |
10:41:06 |
writes/marks*100 |
9 |
1 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
<null> |
10:41:07 |
10:59:07 |
writes/marks*100 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
10:59:08 |
11:17:08 |
Done for 10530 ms, from 11:34:39.75 to 11:34:50.28.
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 |
2125997 |
1907655 |
218342 |
10.27 |
0 |
25272 |
13 |
218342 |
2017-10-11 08:16 |
2017-10-11 11:16 |
doc_list_biud |
2126479 |
1907655 |
218824 |
10.29 |
0 |
16786 |
4 |
218824 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_add_invoice_to_stock |
18325 |
11191 |
7134 |
38.93 |
0 |
113630 |
2768 |
7134 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_cancel_adding_invoice |
5156 |
3861 |
1295 |
25.11 |
0 |
78842 |
620 |
1295 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_cancel_client_order |
6395 |
6270 |
125 |
1.95 |
0 |
3089 |
58 |
125 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_cancel_customer_reserve |
470620 |
263469 |
207151 |
44.01 |
0 |
6068 |
14 |
207151 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_cancel_pay_from_customer |
2391 |
2376 |
15 |
0.62 |
0 |
2012 |
34 |
15 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_cancel_pay_to_supplier |
1416 |
1415 |
1 |
0.07 |
0 |
1716 |
38 |
1 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_cancel_supplier_invoice |
11133 |
8657 |
2476 |
22.24 |
0 |
17051 |
128 |
2476 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_cancel_supplier_order |
1482 |
583 |
899 |
60.66 |
31 |
119917 |
6523 |
899 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_cancel_write_off |
25557 |
17088 |
8469 |
33.13 |
0 |
4836 |
35 |
8469 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_client_order |
75415 |
75415 |
0 |
0.00 |
0 |
25491 |
118 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_customer_reserve |
677316 |
677316 |
0 |
0.00 |
0 |
24586 |
37 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_fill_shopping_cart |
114621 |
114283 |
338 |
0.29 |
0 |
2980 |
25 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_fill_shopping_cart_clo_res |
677316 |
677316 |
0 |
0.00 |
0 |
3634 |
2 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_get_clo_for_invoice |
11191 |
11191 |
0 |
0.00 |
0 |
5647 |
85 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_kill_cost_storno |
34136 |
24740 |
9396 |
27.52 |
0 |
1576 |
3 |
9396 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_kill_qstorno_ret_qs2qd |
977791 |
553266 |
424525 |
43.41 |
0 |
16676 |
5 |
424525 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_kill_qty_storno |
565402 |
346652 |
218750 |
38.68 |
0 |
16676 |
17 |
218750 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_lock_selected_doc |
75027 |
65589 |
9438 |
12.57 |
0 |
2184 |
2 |
9438 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_make_cost_storno |
92700 |
92700 |
0 |
0.00 |
0 |
20217 |
177 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_multiply_rows_for_pdistr |
92700 |
92700 |
0 |
0.00 |
0 |
24570 |
13 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_multiply_rows_for_qdistr |
75415 |
75415 |
0 |
0.00 |
0 |
24336 |
39 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_pay_from_customer |
25313 |
25313 |
0 |
0.00 |
0 |
25896 |
209 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_pay_to_supplier |
20663 |
20663 |
0 |
0.00 |
0 |
26099 |
556 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_payment_common |
45976 |
45976 |
0 |
0.00 |
0 |
2403 |
21 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_qd_handle_on_cancel_clo |
6391 |
6270 |
121 |
1.89 |
0 |
2995 |
25 |
121 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_qd_handle_on_invoice_upd_sts |
16196 |
15052 |
1144 |
7.06 |
0 |
6115 |
91 |
1144 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_qd_handle_on_reserve_upd_sts |
35533 |
35533 |
0 |
0.00 |
0 |
15444 |
13 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_reserve_write_off |
35960 |
35533 |
427 |
1.18 |
0 |
16708 |
121 |
427 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_supplier_invoice |
19670 |
19548 |
122 |
0.62 |
0 |
32511 |
751 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
sp_supplier_order |
19536 |
19320 |
216 |
1.10 |
0 |
31559 |
477 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
srv_find_qd_qs_mism |
1320650 |
1102270 |
218380 |
16.53 |
0 |
3729 |
5 |
218380 |
2017-10-11 08:16 |
2017-10-11 11:16 |
srv_make_invnt_saldo |
2058 |
2058 |
0 |
0.00 |
0 |
16786 |
592 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
srv_make_money_saldo |
2078 |
2078 |
0 |
0.00 |
0 |
2028 |
22 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
1591 |
22604 |
5458 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_add_invoice_to_stock |
7134 |
7134 |
0 |
0.00 |
0 |
1934 |
22 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_cancel_adding_invoice |
781 |
781 |
0 |
0.00 |
0 |
1529 |
30 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_cancel_client_order |
125 |
125 |
0 |
0.00 |
0 |
1700 |
54 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_cancel_customer_reserve |
29 |
29 |
0 |
0.00 |
0 |
156 |
15 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_cancel_pay_from_customer |
15 |
15 |
0 |
0.00 |
0 |
16 |
5 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_cancel_pay_to_supplier |
1 |
1 |
0 |
0.00 |
0 |
0 |
0 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_cancel_supplier_invoice |
559 |
559 |
0 |
0.00 |
0 |
733 |
19 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_cancel_supplier_order |
24545 |
24545 |
0 |
0.00 |
0 |
3370 |
27 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_cancel_write_off |
25 |
25 |
0 |
0.00 |
0 |
312 |
28 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_reserve_write_off |
427 |
427 |
0 |
0.00 |
0 |
1076 |
14 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_supplier_invoice |
122 |
122 |
0 |
0.00 |
0 |
1607 |
34 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-abend:sp_supplier_order |
216 |
216 |
0 |
0.00 |
0 |
156 |
8 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_add_invoice_to_stock |
11191 |
11191 |
0 |
0.00 |
0 |
20420 |
192 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_cancel_adding_invoice |
1277 |
1277 |
0 |
0.00 |
0 |
7145 |
199 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_cancel_client_order |
6270 |
6270 |
0 |
0.00 |
0 |
2012 |
15 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_cancel_customer_reserve |
2448 |
2448 |
0 |
0.00 |
0 |
1778 |
17 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_cancel_pay_from_customer |
2376 |
2376 |
0 |
0.00 |
0 |
2044 |
13 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_cancel_pay_to_supplier |
1415 |
1415 |
0 |
0.00 |
0 |
1263 |
14 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_cancel_supplier_invoice |
911 |
911 |
0 |
0.00 |
0 |
1716 |
15 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_cancel_supplier_order |
583 |
583 |
0 |
0.00 |
0 |
21855 |
696 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_cancel_write_off |
3585 |
3585 |
0 |
0.00 |
0 |
1061 |
14 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_client_order |
75415 |
75415 |
0 |
0.00 |
0 |
12651 |
19 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_customer_reserve |
3620 |
3620 |
0 |
0.00 |
0 |
1529 |
13 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_pay_from_customer |
25313 |
25313 |
0 |
0.00 |
0 |
2277 |
14 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_pay_to_supplier |
20663 |
20663 |
0 |
0.00 |
0 |
2169 |
14 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_reserve_write_off |
35533 |
35533 |
0 |
0.00 |
0 |
2792 |
16 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_supplier_invoice |
19548 |
19548 |
0 |
0.00 |
0 |
3401 |
15 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:sp_supplier_order |
19320 |
19320 |
0 |
0.00 |
0 |
1716 |
14 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:srv_make_invnt_saldo |
2058 |
2058 |
0 |
0.00 |
0 |
1482 |
8 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:srv_make_money_saldo |
2078 |
2078 |
0 |
0.00 |
0 |
1342 |
9 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
32 |
13 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_add_invoice_to_stock |
36650 |
22382 |
14268 |
38.93 |
0 |
2075 |
3 |
14268 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_all_customers |
113272 |
113272 |
0 |
0.00 |
0 |
780 |
1 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_all_suppliers |
78412 |
77736 |
676 |
0.86 |
0 |
1014 |
1 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_all_wares |
150830 |
150830 |
0 |
0.00 |
0 |
733 |
1 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_cancel_adding_invoice |
3002 |
2554 |
448 |
14.92 |
0 |
2325 |
38 |
448 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_cancel_client_order |
12790 |
12540 |
250 |
1.95 |
0 |
1591 |
2 |
250 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_cancel_customer_prepayment |
4782 |
4752 |
30 |
0.62 |
0 |
1606 |
2 |
30 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_cancel_customer_reserve |
4954 |
4896 |
58 |
1.17 |
0 |
655 |
2 |
58 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_cancel_payment_to_supplier |
2832 |
2830 |
2 |
0.07 |
0 |
952 |
3 |
2 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_cancel_supplier_invoice |
2940 |
1822 |
1118 |
38.02 |
0 |
125 |
2 |
1118 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_cancel_supplier_order |
2964 |
1166 |
1798 |
60.66 |
0 |
670 |
3 |
1798 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_cancel_write_off |
7220 |
7170 |
50 |
0.69 |
0 |
3369 |
28 |
50 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_max_id_clo_ord |
19536 |
19320 |
216 |
1.10 |
0 |
936 |
1 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_max_id_clo_res |
3620 |
3620 |
0 |
0.00 |
0 |
1185 |
5 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_max_id_ord_sup |
19670 |
19548 |
122 |
0.62 |
0 |
592 |
1 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_max_non_paid_invoice |
20663 |
20663 |
0 |
0.00 |
0 |
718 |
1 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_max_non_paid_realizn |
25313 |
25313 |
0 |
0.00 |
0 |
983 |
1 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_min_id_clo_ord |
19536 |
19320 |
216 |
1.10 |
0 |
624 |
2 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_min_id_clo_res |
3620 |
3620 |
0 |
0.00 |
0 |
592 |
3 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_min_id_ord_sup |
19670 |
19548 |
122 |
0.62 |
0 |
1560 |
2 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_min_non_paid_invoice |
20663 |
20663 |
0 |
0.00 |
0 |
624 |
2 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_min_non_paid_realizn |
25313 |
25313 |
0 |
0.00 |
0 |
436 |
2 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_our_firm |
37558 |
37558 |
0 |
0.00 |
0 |
764 |
1 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
v_reserve_write_off |
71920 |
71066 |
854 |
1.18 |
0 |
2355 |
2 |
854 |
2017-10-11 08:16 |
2017-10-11 11:16 |
x_lock_depdocs_on_canc_invoice |
22140 |
11607 |
10533 |
47.57 |
0 |
1232 |
7 |
10533 |
2017-10-11 08:16 |
2017-10-11 11:16 |
x_lock_depdocs_on_canc_sup_ord |
1479 |
583 |
896 |
60.58 |
0 |
3292 |
18 |
896 |
2017-10-11 08:16 |
2017-10-11 11:16 |
x_make_qstorno_1000_1200 |
19536 |
19320 |
216 |
1.10 |
0 |
31434 |
420 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
x_make_qstorno_1200_2000 |
19670 |
19548 |
122 |
0.62 |
0 |
32199 |
690 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
x_make_qstorno_2100_3300 |
677316 |
677316 |
0 |
0.00 |
0 |
24570 |
31 |
0 |
2017-10-11 08:16 |
2017-10-11 11:16 |
Done for 523440 ms, from 11:43:21.93 to 11:52:05.37.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
53 |
sp_kill_cost_storno |
335544336 |
2017-10-11 08:18 |
2017-10-11 11:16 |
deadlock |
83 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-10-11 08:21 |
2017-10-11 11:11 |
deadlock |
8184 |
sp_lock_selected_doc |
335544336 |
2017-10-11 08:17 |
2017-10-11 11:16 |
deadlock |
121 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-10-11 08:17 |
2017-10-11 11:13 |
deadlock |
221 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-10-11 08:17 |
2017-10-11 11:15 |
deadlock |
605 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-10-11 08:17 |
2017-10-11 11:16 |
deadlock |
162 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-10-11 08:20 |
2017-10-11 11:13 |
user_exc |
216 |
x_make_qstorno_1000_1200 |
335544517 |
2017-10-11 08:18 |
2017-10-11 11:15 |
user_exc |
122 |
x_make_qstorno_1200_2000 |
335544517 |
2017-10-11 08:17 |
2017-10-11 11:15 |
Done for 15990 ms, from 11:52:20.69 to 11:52:36.68.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 422371
MON$OLDEST_ACTIVE 422372
MON$OLDEST_SNAPSHOT 422372
MON$NEXT_TRANSACTION 422372
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 852672
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.760 Firebird 4.0 Alpha 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.760 Firebird 4.0 Alpha 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.760 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.760 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 422408
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 422373
Oldest active 422374
Oldest snapshot 422374
Next transaction 422375
Sequence number 0
Next attachment ID 9296
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.27
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 339, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 338, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.11, total records: 2040220
Average version length: 47.66, total versions: 1075, 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: 22040
Data pages: 22040, average fill: 73%
Primary pages: 22040, secondary pages: 0, swept pages: 13694
Empty pages: 7, full pages: 20951
Fill distribution:
0 - 19% = 8
20 - 39% = 14
40 - 59% = 112
60 - 79% = 21900
80 - 99% = 6
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 9846, nodes: 2040220
Average node length: 19.36, total dup: 0, max dup: 0
Average key length: 16.40, compression ratio: 1.65
Average prefix length: 13.59, average data length: 13.41
Clustering factor: 280546, ratio: 0.14
Fill distribution:
0 - 19% = 852
20 - 39% = 2614
40 - 59% = 3360
60 - 79% = 1177
80 - 99% = 1843
Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7314, nodes: 2040220
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.69, compression ratio: 1.04
Average prefix length: 3.31, average data length: 5.69
Clustering factor: 279214, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 3533
40 - 59% = 3594
60 - 79% = 166
80 - 99% = 20
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 176192, depth: 3, leaf buckets: 3282, nodes: 2040220
Average node length: 6.84, total dup: 1477257, max dup: 49
Average key length: 3.89, compression ratio: 2.31
Average prefix length: 7.38, average data length: 1.62
Clustering factor: 247502, ratio: 0.12
Fill distribution:
0 - 19% = 113
20 - 39% = 1029
40 - 59% = 1006
60 - 79% = 475
80 - 99% = 659
DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.47, total records: 625396
Average version length: 61.59, total versions: 295, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7872
Data pages: 7872, average fill: 76%
Primary pages: 7871, secondary pages: 1, swept pages: 7235
Empty pages: 1, full pages: 7811
Fill distribution:
0 - 19% = 4
20 - 39% = 2
40 - 59% = 8
60 - 79% = 7843
80 - 99% = 15
Index DOC_LIST_ID_DESC (1)
Root page: 248030, depth: 3, leaf buckets: 2241, nodes: 625396
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 122646, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 1141
40 - 59% = 998
60 - 79% = 87
80 - 99% = 15
Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 652, nodes: 625396
Average node length: 4.87, total dup: 625346, max dup: 37200
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 281119, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 547
60 - 79% = 81
80 - 99% = 23
Index PK_DOC_LIST (0)
Root page: 330927, depth: 3, leaf buckets: 1506, nodes: 625396
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 122646, ratio: 0.20
Fill distribution:
0 - 19% = 70
20 - 39% = 245
40 - 59% = 409
60 - 79% = 405
80 - 99% = 377
DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 343, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 64.23, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 16.64, total fragments: 362, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.62
Pointer pages: 1, data page slots: 56
Data pages: 52, average fill: 14%
Primary pages: 4, secondary pages: 48, swept pages: 4
Empty pages: 28, full pages: 3
Fill distribution:
0 - 19% = 39
20 - 39% = 9
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 285, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 25.89, total records: 2838
Average version length: 71.04, total versions: 1805, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 3.71
Pointer pages: 1, data page slots: 200
Data pages: 128, average fill: 29%
Primary pages: 127, secondary pages: 1, swept pages: 26
Empty pages: 29, full pages: 7
Fill distribution:
0 - 19% = 54
20 - 39% = 30
40 - 59% = 31
60 - 79% = 9
80 - 99% = 4
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 14, nodes: 2838
Average node length: 15.82, total dup: 31, max dup: 1
Average key length: 13.94, compression ratio: 1.94
Average prefix length: 16.04, average data length: 10.96
Clustering factor: 2174, ratio: 0.77
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 5
60 - 79% = 2
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 14.86, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 1.00, total fragments: 1, max fragments: 1
Average unpacked length: 32.00, compression ratio: 2.15
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 15%
Primary pages: 1, secondary pages: 1, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 19.74, total records: 163
Average version length: 45.33, total versions: 94, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.24
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 10%
Primary pages: 16, secondary pages: 0, swept pages: 5
Empty pages: 7, full pages: 0
Fill distribution:
0 - 19% = 13
20 - 39% = 2
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 743512, depth: 2, leaf buckets: 1, nodes: 163
Average node length: 8.07, total dup: 111, max dup: 23
Average key length: 6.87, compression ratio: 2.77
Average prefix length: 14.44, average data length: 4.56
Clustering factor: 106, ratio: 0.65
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 356, Index root page: 357
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 241, Index root page: 242
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 244, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 243, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 19.98, total records: 782427
Average version length: 42.58, total versions: 150, max versions: 3
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.20
Pointer pages: 3, data page slots: 4728
Data pages: 4728, average fill: 75%
Primary pages: 4727, secondary pages: 1, swept pages: 3822
Empty pages: 8, full pages: 4248
Fill distribution:
0 - 19% = 9
20 - 39% = 5
40 - 59% = 23
60 - 79% = 4081
80 - 99% = 610
Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 270, nodes: 254804
Average node length: 4.88, total dup: 254755, max dup: 20793
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 35722, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 29
40 - 59% = 146
60 - 79% = 80
80 - 99% = 15
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 322, nodes: 254804
Average node length: 5.81, total dup: 230171, max dup: 60
Average key length: 2.94, compression ratio: 7.48
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 40584, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 42
40 - 59% = 143
60 - 79% = 110
80 - 99% = 27
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 312, nodes: 254804
Average node length: 5.81, total dup: 230171, max dup: 60
Average key length: 2.94, compression ratio: 7.49
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 40594, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 40
40 - 59% = 126
60 - 79% = 100
80 - 99% = 46
Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 314, nodes: 254804
Average node length: 5.60, total dup: 230171, max dup: 60
Average key length: 2.72, compression ratio: 3.30
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 40603, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 49
40 - 59% = 145
60 - 79% = 81
80 - 99% = 37
PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.98, total records: 252162
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.14
Pointer pages: 2, data page slots: 2160
Data pages: 2160, average fill: 64%
Primary pages: 2160, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 2155
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2155
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 395222, depth: 2, leaf buckets: 199, nodes: 252162
Average node length: 4.49, total dup: 251981, max dup: 2242
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 68580, ratio: 0.27
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 65
60 - 79% = 74
80 - 99% = 60
PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 349, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.86, total records: 12918556
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.17
Pointer pages: 189, data page slots: 307088
Data pages: 307088, average fill: 87%
Primary pages: 307088, secondary pages: 0, swept pages: 3
Empty pages: 4, full pages: 307082
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 307082
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 15710, nodes: 12918556
Average node length: 5.70, total dup: 12053040, max dup: 147
Average key length: 2.17, compression ratio: 3.69
Average prefix length: 7.87, average data length: 0.12
Clustering factor: 2059349, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 11148
60 - 79% = 2923
80 - 99% = 1638
Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 13043, nodes: 12918556
Average node length: 4.66, total dup: 12918552, max dup: 11338926
Average key length: 1.12, compression ratio: 0.54
Average prefix length: 0.61, average data length: 0.00
Clustering factor: 364459, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 13040
60 - 79% = 1
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 16372, nodes: 12918556
Average node length: 5.74, total dup: 12572321, max dup: 28530
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 665359, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 13386
60 - 79% = 1697
80 - 99% = 1289
Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 15747, nodes: 12918556
Average node length: 5.60, total dup: 12899238, max dup: 2050929
Average key length: 2.06, compression ratio: 18.41
Average prefix length: 37.91, average data length: 0.06
Clustering factor: 5510624, ratio: 0.43
Fill distribution:
0 - 19% = 15
20 - 39% = 0
40 - 59% = 13744
60 - 79% = 280
80 - 99% = 1708
PHRASES (145)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 283, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 54.65, total records: 333505
Average version length: 54.78, total versions: 185, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 3, data page slots: 3928
Data pages: 3928, average fill: 75%
Primary pages: 3928, secondary pages: 0, swept pages: 2630
Empty pages: 4, full pages: 3834
Fill distribution:
0 - 19% = 7
20 - 39% = 2
40 - 59% = 5
60 - 79% = 3913
80 - 99% = 1
Index PSTORNED_RCV_ID (2)
Root page: 1549, depth: 2, leaf buckets: 461, nodes: 333505
Average node length: 6.17, total dup: 266945, max dup: 851
Average key length: 3.45, compression ratio: 2.61
Average prefix length: 7.75, average data length: 1.25
Clustering factor: 42596, ratio: 0.13
Fill distribution:
0 - 19% = 3
20 - 39% = 31
40 - 59% = 300
60 - 79% = 89
80 - 99% = 38
Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 352, nodes: 333505
Average node length: 5.50, total dup: 298946, max dup: 172
Average key length: 2.79, compression ratio: 3.23
Average prefix length: 8.32, average data length: 0.68
Clustering factor: 81683, ratio: 0.24
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 151
60 - 79% = 134
80 - 99% = 62
RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 310, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 245, Index root page: 246
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 248, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 247, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 330, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 331, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 218, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 226, Index root page: 227
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 219, Index root page: 220
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 222, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 221, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 211, Index root page: 212
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 215, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.43, total records: 2439
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.55
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 69%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 29
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 29
80 - 99% = 0
WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 38.86, total records: 4585
Average version length: 72.22, total versions: 2118, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.50
Pointer pages: 1, data page slots: 272
Data pages: 232, average fill: 25%
Primary pages: 232, secondary pages: 0, swept pages: 92
Empty pages: 87, full pages: 27
Fill distribution:
0 - 19% = 130
20 - 39% = 33
40 - 59% = 34
60 - 79% = 26
80 - 99% = 9
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 11, nodes: 4585
Average node length: 6.96, total dup: 3981, max dup: 14
Average key length: 5.01, compression ratio: 7.38
Average prefix length: 34.12, average data length: 2.88
Clustering factor: 703, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 4
60 - 79% = 1
80 - 99% = 0
XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 72.01, total records: 674665
Average version length: 71.97, total versions: 1669, 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: 7, data page slots: 10168
Data pages: 10144, average fill: 73%
Primary pages: 10144, secondary pages: 0, swept pages: 6953
Empty pages: 2, full pages: 7438
Fill distribution:
0 - 19% = 14
20 - 39% = 115
40 - 59% = 627
60 - 79% = 9380
80 - 99% = 8
Index XQD_1000_3300_DOC (1)
Root page: 715637, depth: 3, leaf buckets: 614, nodes: 674665
Average node length: 5.09, total dup: 656100, max dup: 124
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 72001, ratio: 0.11
Fill distribution:
0 - 19% = 6
20 - 39% = 70
40 - 59% = 236
60 - 79% = 24
80 - 99% = 278
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 315276, depth: 3, leaf buckets: 932, nodes: 674665
Average node length: 6.21, total dup: 588889, max dup: 21
Average key length: 3.32, compression ratio: 11.15
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 132303, ratio: 0.20
Fill distribution:
0 - 19% = 23
20 - 39% = 149
40 - 59% = 459
60 - 79% = 152
80 - 99% = 149
XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 15.00, total records: 94975
Average version length: 72.12, total versions: 4053, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 9.06
Pointer pages: 2, data page slots: 2424
Data pages: 2248, average fill: 20%
Primary pages: 2245, secondary pages: 3, swept pages: 1264
Empty pages: 708, full pages: 152
Fill distribution:
0 - 19% = 1473
20 - 39% = 287
40 - 59% = 239
60 - 79% = 180
80 - 99% = 69
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 27, nodes: 13663
Average node length: 5.85, total dup: 12098, max dup: 47
Average key length: 3.84, compression ratio: 9.63
Average prefix length: 35.27, average data length: 1.73
Clustering factor: 1781, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 7
60 - 79% = 2
80 - 99% = 0
XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 46.29, total records: 2429305
Average version length: 71.17, total versions: 12671, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.94
Pointer pages: 19, data page slots: 30064
Data pages: 30032, average fill: 63%
Primary pages: 30032, secondary pages: 0, swept pages: 7980
Empty pages: 290, full pages: 28537
Fill distribution:
0 - 19% = 456
20 - 39% = 7031
40 - 59% = 1654
60 - 79% = 17539
80 - 99% = 3352
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 190893, depth: 3, leaf buckets: 2270, nodes: 1447955
Average node length: 5.56, total dup: 1370042, max dup: 49
Average key length: 2.59, compression ratio: 14.27
Average prefix length: 36.46, average data length: 0.54
Clustering factor: 116082, ratio: 0.08
Fill distribution:
0 - 19% = 20
20 - 39% = 1073
40 - 59% = 850
60 - 79% = 167
80 - 99% = 160
XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.01, total records: 4377029
Average version length: 71.13, total versions: 23, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.09
Pointer pages: 17, data page slots: 27560
Data pages: 27552, average fill: 51%
Primary pages: 27552, secondary pages: 0, swept pages: 10014
Empty pages: 32, full pages: 27356
Fill distribution:
0 - 19% = 69
20 - 39% = 9664
40 - 59% = 5891
60 - 79% = 11770
80 - 99% = 158
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 3, nodes: 782
Average node length: 11.32, total dup: 552, max dup: 11
Average key length: 8.32, compression ratio: 4.45
Average prefix length: 30.97, average data length: 6.03
Clustering factor: 159, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 62.53, total records: 3177944
Average version length: 71.24, total versions: 5113, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.18
Pointer pages: 25, data page slots: 40536
Data pages: 40536, average fill: 77%
Primary pages: 40536, secondary pages: 0, swept pages: 28299
Empty pages: 22, full pages: 39869
Fill distribution:
0 - 19% = 46
20 - 39% = 356
40 - 59% = 787
60 - 79% = 36968
80 - 99% = 2379
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5610, nodes: 2728645
Average node length: 6.86, total dup: 2211009, max dup: 14
Average key length: 3.88, compression ratio: 9.53
Average prefix length: 35.31, average data length: 1.69
Clustering factor: 404880, ratio: 0.15
Fill distribution:
0 - 19% = 10
20 - 39% = 3046
40 - 59% = 2001
60 - 79% = 343
80 - 99% = 210
XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.61, total records: 4448698
Average version length: 83.48, total versions: 308, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 42, data page slots: 68272
Data pages: 68272, average fill: 80%
Primary pages: 68272, secondary pages: 0, swept pages: 25168
Empty pages: 4, full pages: 68177
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 4
60 - 79% = 19530
80 - 99% = 48733
Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4625, nodes: 4448698
Average node length: 5.15, total dup: 4347816, max dup: 125
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 661622, ratio: 0.15
Fill distribution:
0 - 19% = 22
20 - 39% = 61
40 - 59% = 2141
60 - 79% = 2005
80 - 99% = 396
Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 3951, nodes: 4448698
Average node length: 5.70, total dup: 3975370, max dup: 49
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 125793, ratio: 0.03
Fill distribution:
0 - 19% = 23
20 - 39% = 80
40 - 59% = 985
60 - 79% = 258
80 - 99% = 2605
Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5155, nodes: 4448698
Average node length: 5.81, total dup: 3892226, max dup: 14
Average key length: 2.83, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 714338, ratio: 0.16
Fill distribution:
0 - 19% = 37
20 - 39% = 76
40 - 59% = 2312
60 - 79% = 2161
80 - 99% = 569
XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 83.41, total records: 2671424
Average version length: 83.89, total versions: 5664, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 26, data page slots: 41352
Data pages: 41352, average fill: 80%
Primary pages: 41352, secondary pages: 0, swept pages: 29755
Empty pages: 8, full pages: 40960
Fill distribution:
0 - 19% = 21
20 - 39% = 23
40 - 59% = 82
60 - 79% = 13418
80 - 99% = 27808
Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2817, nodes: 2671424
Average node length: 5.15, total dup: 2609296, max dup: 143
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 417310, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 38
40 - 59% = 1622
60 - 79% = 833
80 - 99% = 324
Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4006, nodes: 2671424
Average node length: 6.25, total dup: 2182405, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 190277, ratio: 0.07
Fill distribution:
0 - 19% = 79
20 - 39% = 1260
40 - 59% = 1441
60 - 79% = 675
80 - 99% = 551
Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 3197, nodes: 2671424
Average node length: 5.81, total dup: 2336415, max dup: 36
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 507036, ratio: 0.19
Fill distribution:
0 - 19% = 21
20 - 39% = 51
40 - 59% = 1822
60 - 79% = 949
80 - 99% = 354
XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.72, total records: 4713452
Average version length: 84.40, total versions: 3807, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 45, data page slots: 72192
Data pages: 72192, average fill: 81%
Primary pages: 72192, secondary pages: 0, swept pages: 14848
Empty pages: 136, full pages: 71668
Fill distribution:
0 - 19% = 159
20 - 39% = 75
40 - 59% = 146
60 - 79% = 10231
80 - 99% = 61581
Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 4784, nodes: 4713452
Average node length: 5.04, total dup: 4685944, max dup: 757
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 669112, ratio: 0.14
Fill distribution:
0 - 19% = 6
20 - 39% = 105
40 - 59% = 2554
60 - 79% = 1491
80 - 99% = 628
Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5101, nodes: 4713452
Average node length: 5.50, total dup: 4356083, max dup: 49
Average key length: 2.52, compression ratio: 3.57
Average prefix length: 8.56, average data length: 0.44
Clustering factor: 126686, ratio: 0.03
Fill distribution:
0 - 19% = 121
20 - 39% = 1075
40 - 59% = 1528
60 - 79% = 680
80 - 99% = 1697
Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5423, nodes: 4713452
Average node length: 5.69, total dup: 4220963, max dup: 68
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 740539, ratio: 0.16
Fill distribution:
0 - 19% = 8
20 - 39% = 93
40 - 59% = 2944
60 - 79% = 1664
80 - 99% = 714
XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 823, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 825, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 824, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.51, total records: 3278207
Average version length: 83.88, total versions: 4605, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 31, data page slots: 50536
Data pages: 50536, average fill: 80%
Primary pages: 50536, secondary pages: 0, swept pages: 34710
Empty pages: 2, full pages: 50318
Fill distribution:
0 - 19% = 5
20 - 39% = 18
40 - 59% = 64
60 - 79% = 13511
80 - 99% = 36938
Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3586, nodes: 3278207
Average node length: 5.02, total dup: 3262602, max dup: 1229
Average key length: 2.04, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 590744, ratio: 0.18
Fill distribution:
0 - 19% = 13
20 - 39% = 391
40 - 59% = 1993
60 - 79% = 806
80 - 99% = 383
Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 4891, nodes: 3278207
Average node length: 6.25, total dup: 2679404, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 244843, ratio: 0.07
Fill distribution:
0 - 19% = 124
20 - 39% = 1558
40 - 59% = 1634
60 - 79% = 832
80 - 99% = 743
Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 3980, nodes: 3278207
Average node length: 5.57, total dup: 2997655, max dup: 57
Average key length: 2.59, compression ratio: 3.47
Average prefix length: 8.49, average data length: 0.51
Clustering factor: 638692, ratio: 0.19
Fill distribution:
0 - 19% = 11
20 - 39% = 412
40 - 59% = 2198
60 - 79% = 926
80 - 99% = 433
XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.41, total records: 550737
Average version length: 69.50, total versions: 667, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 5, data page slots: 7608
Data pages: 7608, average fill: 77%
Primary pages: 7608, secondary pages: 0, swept pages: 5704
Empty pages: 8, full pages: 7299
Fill distribution:
0 - 19% = 17
20 - 39% = 24
40 - 59% = 67
60 - 79% = 7484
80 - 99% = 16
Index XQS_3300_3400_DOC_ID (0)
Root page: 218800, depth: 3, leaf buckets: 664, nodes: 550737
Average node length: 5.32, total dup: 516846, max dup: 113
Average key length: 2.47, compression ratio: 3.65
Average prefix length: 8.59, average data length: 0.41
Clustering factor: 49370, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 148
40 - 59% = 259
60 - 79% = 196
80 - 99% = 59
Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 729, nodes: 550737
Average node length: 5.92, total dup: 469293, max dup: 14
Average key length: 3.07, compression ratio: 2.94
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 51451, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 146
40 - 59% = 309
60 - 79% = 198
80 - 99% = 74
ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 672, Index root page: 673
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 676, Index root page: 677
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 682, Index root page: 683
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 692, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 684, Index root page: 685
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 693, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 678, Index root page: 679
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 686, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 687, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 680, Index root page: 681
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 689, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 688, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 691, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 690, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 622, Index root page: 623
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 620, Index root page: 621
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 271, Index root page: 272
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 284, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 88550 ms, from 11:52:37.26 to 11:54:05.81.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2040220 |
1075 |
0.0526 |
DOC_LIST |
625396 |
295 |
0.0471 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
2838 |
1805 |
63.6011 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
163 |
94 |
57.6687 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
782427 |
150 |
0.0191 |
PERF_ESTIMATED |
252162 |
0 |
0.0000 |
PERF_LOG |
12918556 |
0 |
0.0000 |
PSTORNED |
333505 |
185 |
0.0554 |
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 |
2439 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
4585 |
2118 |
46.1941 |
XQD_1000_3300 |
674665 |
1669 |
0.2473 |
XQD_1200_2000 |
94975 |
4053 |
4.2674 |
XQD_2000_3300 |
2429305 |
12671 |
0.5215 |
XQD_2100_3300 |
4377029 |
23 |
0.0005 |
XQD_3300_3400 |
3177944 |
5113 |
0.1608 |
XQS_1000_1200 |
4448698 |
308 |
0.0069 |
XQS_1000_3300 |
2671424 |
5664 |
0.2120 |
XQS_1200_2000 |
4713452 |
3807 |
0.0807 |
XQS_2100_3300 |
3278207 |
4605 |
0.1404 |
XQS_3300_3400 |
550737 |
667 |
0.1211 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2510 ms, from 11:54:17.04 to 11:54:19.55.
11:54:19.66 Validation started
11:54:19.69 Relation 140 (DOC_LIST)
11:54:19.69 process pointer page 0 of 5
11:54:19.78 process pointer page 1 of 5
11:54:19.88 process pointer page 2 of 5
11:54:19.97 process pointer page 3 of 5
11:54:20.08 process pointer page 4 of 5
11:54:20.16 Index 1 (PK_DOC_LIST)
11:54:20.39 Index 2 (DOC_LIST_ID_DESC)
11:54:20.53 Index 3 (FK_DOC_LIST_AGENTS)
11:54:20.63 Relation 140 (DOC_LIST) is ok
11:54:20.63 Relation 141 (DOC_DATA)
11:54:20.63 process pointer page 0 of 14
11:54:20.70 process pointer page 1 of 14
11:54:20.80 process pointer page 2 of 14
11:54:20.89 process pointer page 3 of 14
11:54:20.99 process pointer page 4 of 14
11:54:21.09 process pointer page 5 of 14
11:54:21.19 process pointer page 6 of 14
11:54:21.28 process pointer page 7 of 14
11:54:21.36 process pointer page 8 of 14
11:54:21.45 process pointer page 9 of 14
11:54:21.55 process pointer page 10 of 14
11:54:21.64 process pointer page 11 of 14
11:54:21.73 process pointer page 12 of 14
11:54:21.83 process pointer page 13 of 14
11:54:21.87 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:54:22.86 Index 3 (DOC_DATA_ID_DESC)
11:54:23.67 Index 4 (FK_DOC_DATA_DOC_LIST)
11:54:24.20 Relation 141 (DOC_DATA) is ok
11:54:24.20 Relation 147 (INVNT_SALDO)
11:54:24.20 process pointer page 0 of 1
11:54:24.21 Index 1 (PK_INVNT_SALDO)
11:54:24.21 Relation 147 (INVNT_SALDO) is ok
11:54:24.21 Relation 150 (PDISTR)
11:54:24.21 process pointer page 0 of 3
11:54:24.25 process pointer page 1 of 3
11:54:24.34 process pointer page 2 of 3
11:54:24.42 Index 2 (PDISTR_SND_ID)
11:54:24.51 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:54:24.62 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:54:24.71 Index 5 (PDISTR_AGENT_ID)
11:54:24.81 Relation 150 (PDISTR) is ok
11:54:24.81 Relation 151 (PSTORNED)
11:54:24.81 process pointer page 0 of 3
11:54:24.90 process pointer page 1 of 3
11:54:24.99 process pointer page 2 of 3
11:54:25.03 Index 2 (PSTORNED_SND_ID)
11:54:25.14 Index 3 (PSTORNED_RCV_ID)
11:54:25.28 Relation 151 (PSTORNED) is ok
11:54:25.28 Relation 156 (SEMAPHORES)
11:54:25.28 process pointer page 0 of 1
11:54:25.28 Index 1 (PK_SEMAPHORES)
11:54:25.28 Index 2 (SEMAPHORES_TASK_UNQ)
11:54:25.28 Relation 156 (SEMAPHORES) is ok
11:54:25.28 Relation 157 (INVNT_TURNOVER_LOG)
11:54:25.28 process pointer page 0 of 1
11:54:25.29 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:54:25.29 Relation 157 (INVNT_TURNOVER_LOG) is ok
11:54:25.29 Relation 160 (PERF_ESTIMATED)
11:54:25.29 process pointer page 0 of 2
11:54:25.38 process pointer page 1 of 2
11:54:25.42 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:54:25.49 Relation 160 (PERF_ESTIMATED) is ok
11:54:25.49 Relation 161 (PERF_ISQL_STAT)
11:54:25.49 process pointer page 0 of 1
11:54:25.49 Index 1 (PERF_ISQL_STAT_TRN)
11:54:25.49 Relation 161 (PERF_ISQL_STAT) is ok
11:54:25.49 Relation 162 (TRACE_STAT)
11:54:25.49 process pointer page 0 of 1
11:54:25.49 Relation 162 (TRACE_STAT) is ok
11:54:25.49 Relation 163 (PERF_LOG)
11:54:25.49 process pointer page 0 of 189
11:54:25.59 process pointer page 1 of 189
11:54:25.67 process pointer page 2 of 189
11:54:25.74 process pointer page 3 of 189
11:54:25.82 process pointer page 4 of 189
11:54:25.92 process pointer page 5 of 189
11:54:25.99 process pointer page 6 of 189
11:54:26.07 process pointer page 7 of 189
11:54:26.15 process pointer page 8 of 189
11:54:26.24 process pointer page 9 of 189
11:54:26.32 process pointer page 10 of 189
11:54:26.40 process pointer page 11 of 189
11:54:26.49 process pointer page 12 of 189
11:54:26.57 process pointer page 13 of 189
11:54:26.65 process pointer page 14 of 189
11:54:26.73 process pointer page 15 of 189
11:54:26.82 process pointer page 16 of 189
11:54:26.90 process pointer page 17 of 189
11:54:26.98 process pointer page 18 of 189
11:54:27.07 process pointer page 19 of 189
11:54:27.15 process pointer page 20 of 189
11:54:27.23 process pointer page 21 of 189
11:54:27.30 process pointer page 22 of 189
11:54:27.38 process pointer page 23 of 189
11:54:27.46 process pointer page 24 of 189
11:54:27.55 process pointer page 25 of 189
11:54:27.63 process pointer page 26 of 189
11:54:27.71 process pointer page 27 of 189
11:54:27.79 process pointer page 28 of 189
11:54:27.87 process pointer page 29 of 189
11:54:27.94 process pointer page 30 of 189
11:54:28.02 process pointer page 31 of 189
11:54:28.11 process pointer page 32 of 189
11:54:28.19 process pointer page 33 of 189
11:54:28.27 process pointer page 34 of 189
11:54:28.35 process pointer page 35 of 189
11:54:28.43 process pointer page 36 of 189
11:54:28.50 process pointer page 37 of 189
11:54:28.58 process pointer page 38 of 189
11:54:28.68 process pointer page 39 of 189
11:54:28.75 process pointer page 40 of 189
11:54:28.83 process pointer page 41 of 189
11:54:28.91 process pointer page 42 of 189
11:54:28.99 process pointer page 43 of 189
11:54:29.07 process pointer page 44 of 189
11:54:29.14 process pointer page 45 of 189
11:54:29.22 process pointer page 46 of 189
11:54:29.32 process pointer page 47 of 189
11:54:29.39 process pointer page 48 of 189
11:54:29.47 process pointer page 49 of 189
11:54:29.55 process pointer page 50 of 189
11:54:29.63 process pointer page 51 of 189
11:54:29.71 process pointer page 52 of 189
11:54:29.78 process pointer page 53 of 189
11:54:29.86 process pointer page 54 of 189
11:54:29.94 process pointer page 55 of 189
11:54:30.03 process pointer page 56 of 189
11:54:30.11 process pointer page 57 of 189
11:54:30.19 process pointer page 58 of 189
11:54:30.27 process pointer page 59 of 189
11:54:30.35 process pointer page 60 of 189
11:54:30.42 process pointer page 61 of 189
11:54:30.50 process pointer page 62 of 189
11:54:30.58 process pointer page 63 of 189
11:54:30.66 process pointer page 64 of 189
11:54:30.75 process pointer page 65 of 189
11:54:30.83 process pointer page 66 of 189
11:54:30.91 process pointer page 67 of 189
11:54:30.99 process pointer page 68 of 189
11:54:31.06 process pointer page 69 of 189
11:54:31.14 process pointer page 70 of 189
11:54:31.22 process pointer page 71 of 189
11:54:31.31 process pointer page 72 of 189
11:54:31.39 process pointer page 73 of 189
11:54:31.47 process pointer page 74 of 189
11:54:31.55 process pointer page 75 of 189
11:54:31.62 process pointer page 76 of 189
11:54:31.70 process pointer page 77 of 189
11:54:31.78 process pointer page 78 of 189
11:54:31.86 process pointer page 79 of 189
11:54:31.95 process pointer page 80 of 189
11:54:32.03 process pointer page 81 of 189
11:54:32.11 process pointer page 82 of 189
11:54:32.19 process pointer page 83 of 189
11:54:32.26 process pointer page 84 of 189
11:54:32.34 process pointer page 85 of 189
11:54:32.44 process pointer page 86 of 189
11:54:32.51 process pointer page 87 of 189
11:54:32.59 process pointer page 88 of 189
11:54:32.67 process pointer page 89 of 189
11:54:32.75 process pointer page 90 of 189
11:54:32.83 process pointer page 91 of 189
11:54:32.90 process pointer page 92 of 189
11:54:33.00 process pointer page 93 of 189
11:54:33.08 process pointer page 94 of 189
11:54:33.15 process pointer page 95 of 189
11:54:33.23 process pointer page 96 of 189
11:54:33.31 process pointer page 97 of 189
11:54:33.39 process pointer page 98 of 189
11:54:33.47 process pointer page 99 of 189
11:54:33.54 process pointer page 100 of 189
11:54:33.64 process pointer page 101 of 189
11:54:33.72 process pointer page 102 of 189
11:54:33.79 process pointer page 103 of 189
11:54:33.87 process pointer page 104 of 189
11:54:33.95 process pointer page 105 of 189
11:54:34.03 process pointer page 106 of 189
11:54:34.11 process pointer page 107 of 189
11:54:34.20 process pointer page 108 of 189
11:54:34.28 process pointer page 109 of 189
11:54:34.35 process pointer page 110 of 189
11:54:34.43 process pointer page 111 of 189
11:54:34.51 process pointer page 112 of 189
11:54:34.59 process pointer page 113 of 189
11:54:34.68 process pointer page 114 of 189
11:54:34.76 process pointer page 115 of 189
11:54:34.84 process pointer page 116 of 189
11:54:34.92 process pointer page 117 of 189
11:54:34.99 process pointer page 118 of 189
11:54:35.07 process pointer page 119 of 189
11:54:35.15 process pointer page 120 of 189
11:54:35.24 process pointer page 121 of 189
11:54:35.32 process pointer page 122 of 189
11:54:35.40 process pointer page 123 of 189
11:54:35.48 process pointer page 124 of 189
11:54:35.56 process pointer page 125 of 189
11:54:35.63 process pointer page 126 of 189
11:54:35.73 process pointer page 127 of 189
11:54:35.81 process pointer page 128 of 189
11:54:35.88 process pointer page 129 of 189
11:54:35.98 process pointer page 130 of 189
11:54:36.06 process pointer page 131 of 189
11:54:36.13 process pointer page 132 of 189
11:54:36.21 process pointer page 133 of 189
11:54:36.29 process pointer page 134 of 189
11:54:36.34 process pointer page 135 of 189
11:54:36.37 process pointer page 136 of 189
11:54:36.40 process pointer page 137 of 189
11:54:36.48 process pointer page 138 of 189
11:54:36.55 process pointer page 139 of 189
11:54:36.63 process pointer page 140 of 189
11:54:36.73 process pointer page 141 of 189
11:54:36.80 process pointer page 142 of 189
11:54:36.88 process pointer page 143 of 189
11:54:36.98 process pointer page 144 of 189
11:54:37.05 process pointer page 145 of 189
11:54:37.13 process pointer page 146 of 189
11:54:37.21 process pointer page 147 of 189
11:54:37.32 process pointer page 148 of 189
11:54:37.41 process pointer page 149 of 189
11:54:37.49 process pointer page 150 of 189
11:54:37.58 process pointer page 151 of 189
11:54:37.66 process pointer page 152 of 189
11:54:37.74 process pointer page 153 of 189
11:54:37.82 process pointer page 154 of 189
11:54:37.90 process pointer page 155 of 189
11:54:37.97 process pointer page 156 of 189
11:54:38.07 process pointer page 157 of 189
11:54:38.15 process pointer page 158 of 189
11:54:38.22 process pointer page 159 of 189
11:54:38.30 process pointer page 160 of 189
11:54:38.38 process pointer page 161 of 189
11:54:38.47 process pointer page 162 of 189
11:54:38.55 process pointer page 163 of 189
11:54:38.63 process pointer page 164 of 189
11:54:38.71 process pointer page 165 of 189
11:54:38.79 process pointer page 166 of 189
11:54:38.86 process pointer page 167 of 189
11:54:38.94 process pointer page 168 of 189
11:54:39.02 process pointer page 169 of 189
11:54:39.10 process pointer page 170 of 189
11:54:39.19 process pointer page 171 of 189
11:54:39.27 process pointer page 172 of 189
11:54:39.35 process pointer page 173 of 189
11:54:39.42 process pointer page 174 of 189
11:54:39.50 process pointer page 175 of 189
11:54:39.60 process pointer page 176 of 189
11:54:39.63 process pointer page 177 of 189
11:54:39.67 process pointer page 178 of 189
11:54:39.75 process pointer page 179 of 189
11:54:39.85 process pointer page 180 of 189
11:54:39.92 process pointer page 181 of 189
11:54:40.00 process pointer page 182 of 189
11:54:40.08 process pointer page 183 of 189
11:54:40.16 process pointer page 184 of 189
11:54:40.24 process pointer page 185 of 189
11:54:40.31 process pointer page 186 of 189
11:54:40.41 process pointer page 187 of 189
11:54:40.49 process pointer page 188 of 189
11:54:40.50 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:54:44.60 Index 2 (PERF_LOG_UNIT)
11:54:49.33 Index 3 (PERF_LOG_TRN_DESC)
11:54:52.83 Index 4 (PERF_LOG_GDSCODE)
11:54:55.84 Relation 163 (PERF_LOG) is ok
11:54:55.85 Relation 167 (V_STOPTEST)
11:54:55.85 Relation 167 (V_STOPTEST) is ok
11:54:55.85 Relation 184 (V_QDISTR_SOURCE)
11:54:55.85 Relation 184 (V_QDISTR_SOURCE) is ok
11:54:55.85 Relation 185 (V_QSTORNED_SOURCE)
11:54:55.85 Relation 185 (V_QSTORNED_SOURCE) is ok
11:54:55.85 Relation 260 (XQD_1000_1200)
11:54:55.85 process pointer page 0 of 1
11:54:55.87 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:54:55.87 Relation 260 (XQD_1000_1200) is ok
11:54:55.87 Relation 261 (XQD_1200_2000)
11:54:55.87 process pointer page 0 of 2
11:54:55.93 process pointer page 1 of 2
11:54:55.96 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:54:55.96 Relation 261 (XQD_1200_2000) is ok
11:54:55.96 Relation 262 (XQD_1000_3300)
11:54:55.96 process pointer page 0 of 7
11:54:56.05 process pointer page 1 of 7
11:54:56.13 process pointer page 2 of 7
11:54:56.23 process pointer page 3 of 7
11:54:56.30 process pointer page 4 of 7
11:54:56.40 process pointer page 5 of 7
11:54:56.48 process pointer page 6 of 7
11:54:56.51 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:54:56.76 Index 2 (XQD_1000_3300_DOC)
11:54:56.96 Relation 262 (XQD_1000_3300) is ok
11:54:56.96 Relation 263 (XQD_2000_3300)
11:54:56.96 process pointer page 0 of 19
11:54:57.04 process pointer page 1 of 19
11:54:57.12 process pointer page 2 of 19
11:54:57.19 process pointer page 3 of 19
11:54:57.27 process pointer page 4 of 19
11:54:57.35 process pointer page 5 of 19
11:54:57.43 process pointer page 6 of 19
11:54:57.52 process pointer page 7 of 19
11:54:57.60 process pointer page 8 of 19
11:54:57.68 process pointer page 9 of 19
11:54:57.75 process pointer page 10 of 19
11:54:57.85 process pointer page 11 of 19
11:54:57.93 process pointer page 12 of 19
11:54:58.00 process pointer page 13 of 19
11:54:58.08 process pointer page 14 of 19
11:54:58.18 process pointer page 15 of 19
11:54:58.25 process pointer page 16 of 19
11:54:58.35 process pointer page 17 of 19
11:54:58.43 process pointer page 18 of 19
11:54:58.46 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:54:58.94 Relation 263 (XQD_2000_3300) is ok
11:54:58.94 Relation 264 (XQD_2100_3300)
11:54:58.94 process pointer page 0 of 17
11:54:59.02 process pointer page 1 of 17
11:54:59.08 process pointer page 2 of 17
11:54:59.11 process pointer page 3 of 17
11:54:59.16 process pointer page 4 of 17
11:54:59.21 process pointer page 5 of 17
11:54:59.24 process pointer page 6 of 17
11:54:59.30 process pointer page 7 of 17
11:54:59.33 process pointer page 8 of 17
11:54:59.39 process pointer page 9 of 17
11:54:59.42 process pointer page 10 of 17
11:54:59.44 process pointer page 11 of 17
11:54:59.47 process pointer page 12 of 17
11:54:59.50 process pointer page 13 of 17
11:54:59.58 process pointer page 14 of 17
11:54:59.64 process pointer page 15 of 17
11:54:59.67 process pointer page 16 of 17
11:54:59.69 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:54:59.69 Relation 264 (XQD_2100_3300) is ok
11:54:59.69 Relation 265 (XQD_3300_3400)
11:54:59.69 process pointer page 0 of 25
11:54:59.77 process pointer page 1 of 25
11:54:59.86 process pointer page 2 of 25
11:54:59.95 process pointer page 3 of 25
11:55:00.05 process pointer page 4 of 25
11:55:00.11 process pointer page 5 of 25
11:55:00.14 process pointer page 6 of 25
11:55:00.19 process pointer page 7 of 25
11:55:00.22 process pointer page 8 of 25
11:55:00.28 process pointer page 9 of 25
11:55:00.38 process pointer page 10 of 25
11:55:00.47 process pointer page 11 of 25
11:55:00.55 process pointer page 12 of 25
11:55:00.64 process pointer page 13 of 25
11:55:00.73 process pointer page 14 of 25
11:55:00.81 process pointer page 15 of 25
11:55:00.91 process pointer page 16 of 25
11:55:01.00 process pointer page 17 of 25
11:55:01.09 process pointer page 18 of 25
11:55:01.19 process pointer page 19 of 25
11:55:01.30 process pointer page 20 of 25
11:55:01.39 process pointer page 21 of 25
11:55:01.48 process pointer page 22 of 25
11:55:01.58 process pointer page 23 of 25
11:55:01.65 process pointer page 24 of 25
11:55:01.73 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:55:02.87 Relation 265 (XQD_3300_3400) is ok
11:55:02.87 Relation 266 (XQS_1000_1200)
11:55:02.87 process pointer page 0 of 42
11:55:02.97 process pointer page 1 of 42
11:55:03.06 process pointer page 2 of 42
11:55:03.15 process pointer page 3 of 42
11:55:03.25 process pointer page 4 of 42
11:55:03.34 process pointer page 5 of 42
11:55:03.43 process pointer page 6 of 42
11:55:03.54 process pointer page 7 of 42
11:55:03.65 process pointer page 8 of 42
11:55:03.76 process pointer page 9 of 42
11:55:03.87 process pointer page 10 of 42
11:55:03.96 process pointer page 11 of 42
11:55:04.21 process pointer page 12 of 42
11:55:04.49 process pointer page 13 of 42
11:55:04.81 process pointer page 14 of 42
11:55:05.09 process pointer page 15 of 42
11:55:05.38 process pointer page 16 of 42
11:55:05.65 process pointer page 17 of 42
11:55:05.93 process pointer page 18 of 42
11:55:06.23 process pointer page 19 of 42
11:55:06.51 process pointer page 20 of 42
11:55:06.79 process pointer page 21 of 42
11:55:07.08 process pointer page 22 of 42
11:55:07.36 process pointer page 23 of 42
11:55:07.66 process pointer page 24 of 42
11:55:07.96 process pointer page 25 of 42
11:55:08.25 process pointer page 26 of 42
11:55:08.57 process pointer page 27 of 42
11:55:08.88 process pointer page 28 of 42
11:55:09.19 process pointer page 29 of 42
11:55:09.52 process pointer page 30 of 42
11:55:09.83 process pointer page 31 of 42
11:55:10.16 process pointer page 32 of 42
11:55:10.48 process pointer page 33 of 42
11:55:10.81 process pointer page 34 of 42
11:55:11.14 process pointer page 35 of 42
11:55:11.50 process pointer page 36 of 42
11:55:11.81 process pointer page 37 of 42
11:55:12.14 process pointer page 38 of 42
11:55:12.47 process pointer page 39 of 42
11:55:12.78 process pointer page 40 of 42
11:55:13.11 process pointer page 41 of 42
11:55:13.40 Index 1 (XQS_1000_1200_DOC_ID)
11:55:15.77 Index 2 (XQS_1000_1200_SND_ID)
11:55:18.27 Index 3 (XQS_1000_1200_RCV_ID)
11:55:20.20 Relation 266 (XQS_1000_1200) is ok
11:55:20.20 Relation 267 (XQS_1200_2000)
11:55:20.22 process pointer page 0 of 45
11:55:20.62 process pointer page 1 of 45
11:55:21.05 process pointer page 2 of 45
11:55:21.45 process pointer page 3 of 45
11:55:21.87 process pointer page 4 of 45
11:55:22.28 process pointer page 5 of 45
11:55:22.70 process pointer page 6 of 45
11:55:23.12 process pointer page 7 of 45
11:55:23.59 process pointer page 8 of 45
11:55:24.01 process pointer page 9 of 45
11:55:24.45 process pointer page 10 of 45
11:55:24.87 process pointer page 11 of 45
11:55:25.30 process pointer page 12 of 45
11:55:25.69 process pointer page 13 of 45
11:55:26.13 process pointer page 14 of 45
11:55:26.55 process pointer page 15 of 45
11:55:26.99 process pointer page 16 of 45
11:55:27.44 process pointer page 17 of 45
11:55:27.86 process pointer page 18 of 45
11:55:28.30 process pointer page 19 of 45
11:55:28.74 process pointer page 20 of 45
11:55:29.17 process pointer page 21 of 45
11:55:29.58 process pointer page 22 of 45
11:55:30.02 process pointer page 23 of 45
11:55:30.45 process pointer page 24 of 45
11:55:30.87 process pointer page 25 of 45
11:55:31.33 process pointer page 26 of 45
11:55:31.76 process pointer page 27 of 45
11:55:32.20 process pointer page 28 of 45
11:55:32.62 process pointer page 29 of 45
11:55:33.06 process pointer page 30 of 45
11:55:33.48 process pointer page 31 of 45
11:55:33.92 process pointer page 32 of 45
11:55:34.35 process pointer page 33 of 45
11:55:34.79 process pointer page 34 of 45
11:55:35.23 process pointer page 35 of 45
11:55:35.69 process pointer page 36 of 45
11:55:36.15 process pointer page 37 of 45
11:55:36.58 process pointer page 38 of 45
11:55:37.02 process pointer page 39 of 45
11:55:37.49 process pointer page 40 of 45
11:55:37.91 process pointer page 41 of 45
11:55:38.35 process pointer page 42 of 45
11:55:38.77 process pointer page 43 of 45
11:55:39.19 process pointer page 44 of 45
11:55:39.28 Index 1 (XQS_1200_2000_DOC_ID)
11:55:41.90 Index 2 (XQS_1200_2000_SND_ID)
11:55:44.74 Index 3 (XQS_1200_2000_RCV_ID)
11:55:47.13 Relation 267 (XQS_1200_2000) is ok
11:55:47.13 Relation 268 (XQS_1000_3300)
11:55:47.13 process pointer page 0 of 26
11:55:47.63 process pointer page 1 of 26
11:55:48.11 process pointer page 2 of 26
11:55:48.63 process pointer page 3 of 26
11:55:49.13 process pointer page 4 of 26
11:55:49.66 process pointer page 5 of 26
11:55:50.16 process pointer page 6 of 26
11:55:50.64 process pointer page 7 of 26
11:55:51.14 process pointer page 8 of 26
11:55:51.65 process pointer page 9 of 26
11:55:52.12 process pointer page 10 of 26
11:55:52.60 process pointer page 11 of 26
11:55:53.07 process pointer page 12 of 26
11:55:53.52 process pointer page 13 of 26
11:55:53.99 process pointer page 14 of 26
11:55:54.45 process pointer page 15 of 26
11:55:54.91 process pointer page 16 of 26
11:55:55.37 process pointer page 17 of 26
11:55:55.83 process pointer page 18 of 26
11:55:56.27 process pointer page 19 of 26
11:55:56.72 process pointer page 20 of 26
11:55:57.19 process pointer page 21 of 26
11:55:57.64 process pointer page 22 of 26
11:55:58.10 process pointer page 23 of 26
11:55:58.53 process pointer page 24 of 26
11:55:58.86 process pointer page 25 of 26
11:55:58.95 Index 1 (XQS_1000_3300_DOC_ID)
11:56:00.26 Index 2 (XQS_1000_3300_SND_ID)
11:56:02.06 Index 3 (XQS_1000_3300_RCV_ID)
11:56:03.79 Relation 268 (XQS_1000_3300) is ok
11:56:03.79 Relation 269 (XQS_2000_3300)
11:56:03.79 process pointer page 0 of 1
11:56:03.79 Index 1 (XQS_2000_3300_DOC_ID)
11:56:03.79 Index 2 (XQS_2000_3300_SND_ID)
11:56:03.79 Index 3 (XQS_2000_3300_RCV_ID)
11:56:03.79 Relation 269 (XQS_2000_3300) is ok
11:56:03.79 Relation 270 (XQS_2100_3300)
11:56:03.79 process pointer page 0 of 31
11:56:04.27 process pointer page 1 of 31
11:56:04.76 process pointer page 2 of 31
11:56:05.24 process pointer page 3 of 31
11:56:05.72 process pointer page 4 of 31
11:56:06.25 process pointer page 5 of 31
11:56:06.71 process pointer page 6 of 31
11:56:07.17 process pointer page 7 of 31
11:56:07.64 process pointer page 8 of 31
11:56:08.10 process pointer page 9 of 31
11:56:08.53 process pointer page 10 of 31
11:56:08.97 process pointer page 11 of 31
11:56:09.39 process pointer page 12 of 31
11:56:09.83 process pointer page 13 of 31
11:56:10.26 process pointer page 14 of 31
11:56:10.70 process pointer page 15 of 31
11:56:11.14 process pointer page 16 of 31
11:56:11.57 process pointer page 17 of 31
11:56:12.01 process pointer page 18 of 31
11:56:12.45 process pointer page 19 of 31
11:56:12.88 process pointer page 20 of 31
11:56:13.37 process pointer page 21 of 31
11:56:13.80 process pointer page 22 of 31
11:56:14.24 process pointer page 23 of 31
11:56:14.68 process pointer page 24 of 31
11:56:15.10 process pointer page 25 of 31
11:56:15.55 process pointer page 26 of 31
11:56:15.99 process pointer page 27 of 31
11:56:16.43 process pointer page 28 of 31
11:56:16.85 process pointer page 29 of 31
11:56:17.22 process pointer page 30 of 31
11:56:17.52 Index 1 (XQS_2100_3300_DOC_ID)
11:56:19.48 Index 2 (XQS_2100_3300_SND_ID)
11:56:21.62 Index 3 (XQS_2100_3300_RCV_ID)
11:56:23.66 Relation 270 (XQS_2100_3300) is ok
11:56:23.66 Relation 271 (XQS_3300_3400)
11:56:23.66 process pointer page 0 of 5
11:56:24.15 process pointer page 1 of 5
11:56:24.62 process pointer page 2 of 5
11:56:25.07 process pointer page 3 of 5
11:56:25.50 process pointer page 4 of 5
11:56:25.75 Index 1 (XQS_3300_3400_DOC_ID)
11:56:26.08 Index 2 (XQS_3300_3400_SND_ID)
11:56:26.43 Relation 271 (XQS_3300_3400) is ok
11:56:26.46 Validation finished
Done for 126990 ms, from 11:54:19.58 to 11:56:26.57.
Differences between old and current firebird.log
11:56:28.20. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-10-11 11:56 477 oltp40_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Wed Oct 11 11:54:19 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Wed Oct 11 11:56:26 2017
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-10-11 11:56:36.97 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html