Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-04-11 6:51:18.71.
Server version: WI-V3.0.3.32714 Firebird 3.0
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperServer 3.0.3 |
D:\OLTP-EMUL\OLTP30-SMALL.FDB |
ON |
0 |
786432 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp30_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB30.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp30-small.fdb |
host |
localhost |
port |
3333 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp30 |
working_mode |
small_03 |
warm_time |
0 |
test_time |
180 |
idle_time |
0 |
use_mtee |
0 |
is_embed |
0 |
remove_isql_logs |
if_no_severe_errors |
no_auto_undo |
1 |
detailed_info |
0 |
mon_unit_perf |
0 |
trc_unit_perf |
1 |
init_buff |
32768 |
create_with_fw |
sync |
create_with_sweep |
0 |
wait_if_not_exists |
0 |
wait_after_create |
0 |
init_docs |
100000 |
wait_for_copy |
0 |
create_with_debug_objects |
1 |
create_with_split_heavy_tabs |
1 |
create_with_separate_qdistr_idx |
0 |
create_with_compound_columns_order |
most_selective_first |
make_html |
1 |
run_db_statistics |
1 |
run_db_validation |
1 |
file_name_with_test_params |
regular |
file_name_this_host_info |
cpu_8x3Ghz_ram_16gb |
upload_report |
1 |
max_snapshots_to_store |
720 |
replace_instance |
1 |
etalon_dbnm |
E:\OLTP-EMUL\oltp30-docs_100000-fw__ON.fdb |
used_in_replication |
0 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2017-04-11 06:48:00.7800 |
-1 |
<null> |
|
::1/57920 |
457174 |
9382 |
2 |
CATEGORY |
SETTING |
VAL |
COMMON |
TRACED_UNITS |
,, |
COMMON |
ENABLE_MON_QUERY |
0 |
COMMON |
HALT_TEST_ON_ERRORS |
,CK, |
COMMON |
QMISM_VERIFY_BITSET |
1 |
COMMON |
RECALC_IDX_MIN_INTERVAL |
15 |
COMMON |
ENABLE_RESERVES_WHEN_ADD_INVOICE |
1 |
COMMON |
ORDER_FOR_OUR_FIRM_PERCENT |
25 |
COMMON |
ENABLE_FILL_PHRASES |
0 |
COMMON |
RANDOM_SEEK_VIA_ROWS_LIMIT |
0 |
COMMON |
C_INVOICE_MIN_PURCHASE |
1000 |
COMMON |
C_INVOICE_MAX_PURCHASE |
2000 |
COMMON |
C_INVOICE_MIN_PROFIT_PRC |
35 |
COMMON |
C_INVOICE_MAX_PROFIT_PRC |
80 |
COMMON |
C_MIN_COST_TO_BE_SPLITTED |
1000 |
COMMON |
C_ROWS_TO_MULTIPLY |
10 |
COMMON |
C_PAYMENT_FROM_CLIENT_MIN_TOTAL |
1000 |
COMMON |
C_PAYMENT_FROM_CLIENT_MAX_TOTAL |
5000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MIN_TOTAL |
2000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MAX_TOTAL |
15000 |
COMMON |
BUILD_WITH_SPLIT_HEAVY_TABS |
1 |
COMMON |
BUILD_WITH_SEPAR_QDISTR_IDX |
0 |
COMMON |
BUILD_WITH_QD_COMPOUND_ORDR |
MOST_SELECTIVE_FIRST |
SMALL_03 |
C_WARES_MAX_ID |
400 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_ROWS |
10 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_ROWS |
50 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_QTY |
15 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_QTY |
50 |
SMALL_03 |
C_NUMBER_OF_AGENTS |
50 |
TAB_NAME |
IDX_NAME |
IDX_KEY |
XQD_1000_1200 |
XQD_1000_1200_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1000_3300 |
XQD_1000_3300_DOC |
DOC_ID |
XQD_1000_3300 |
XQD_1000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1200_2000 |
XQD_1200_2000_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2000_3300 |
XQD_2000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2100_3300 |
XQD_2100_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_3300_3400 |
XQD_3300_3400_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
Performance reports
ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
6222.98 |
3298 |
1120136 |
2017-04-11 03:48 |
2017-04-11 06:48 |
customer order: creation |
489.97 |
467 |
88195 |
2017-04-11 03:48 |
2017-04-11 06:48 |
customer order: refuse |
40.38 |
235 |
7269 |
2017-04-11 03:48 |
2017-04-11 06:48 |
order to supplier: creation |
123.77 |
2019 |
22279 |
2017-04-11 03:48 |
2017-04-11 06:48 |
order to supplier: removal |
3.16 |
19468 |
565 |
2017-04-11 03:48 |
2017-04-11 06:48 |
invoice (draft): creation |
125.77 |
2813 |
22639 |
2017-04-11 03:48 |
2017-04-11 06:48 |
invoice (draft): removal |
42.00 |
454 |
7518 |
2017-04-11 03:48 |
2017-04-11 06:48 |
invoice accept: apply |
69.14 |
11642 |
12446 |
2017-04-11 03:48 |
2017-04-11 06:48 |
invoice accept: cancel |
18.78 |
2684 |
3362 |
2017-04-11 03:48 |
2017-04-11 06:48 |
customer reserve: creation |
3578.29 |
188 |
644092 |
2017-04-11 03:48 |
2017-04-11 06:48 |
customer reserve: removal |
1065.46 |
66 |
190718 |
2017-04-11 03:48 |
2017-04-11 06:48 |
realization accept: apply |
225.68 |
537 |
40623 |
2017-04-11 03:48 |
2017-04-11 06:48 |
realization accept: cancel |
92.78 |
152 |
16701 |
2017-04-11 03:48 |
2017-04-11 06:48 |
payment from customer: creation |
162.97 |
1005 |
29334 |
2017-04-11 03:48 |
2017-04-11 06:48 |
payment from customer: removal |
15.47 |
138 |
2784 |
2017-04-11 03:48 |
2017-04-11 06:48 |
payment to supplier: creation |
134.72 |
943 |
24250 |
2017-04-11 03:48 |
2017-04-11 06:48 |
payment to supplier: removal |
9.97 |
136 |
1784 |
2017-04-11 03:48 |
2017-04-11 06:48 |
service: total inventory turnovers |
10.93 |
2764 |
1957 |
2017-04-11 03:48 |
2017-04-11 06:48 |
service: total monetary turnovers |
20.16 |
63 |
3608 |
2017-04-11 03:48 |
2017-04-11 06:48 |
service: refresh index statistics |
0.07 |
16889 |
12 |
2017-04-11 03:48 |
2017-04-11 06:48 |
Done for 135860 ms, from 6:54:31.29 to 6:56:47.15.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
5799 |
120112 |
104378 |
15734 |
13.10 |
03:48:01 |
04:06:01 |
interval # 2, overall |
2 |
6573 |
135404 |
118308 |
17096 |
12.63 |
04:06:02 |
04:24:02 |
interval # 3, overall |
3 |
6738 |
131202 |
121283 |
9919 |
7.56 |
04:24:03 |
04:42:03 |
interval # 4, overall |
4 |
6421 |
130838 |
115569 |
15269 |
11.67 |
04:42:04 |
05:00:04 |
interval # 5, overall |
5 |
5917 |
120449 |
106506 |
13943 |
11.58 |
05:00:05 |
05:18:05 |
interval # 6, overall |
6 |
6020 |
121664 |
108365 |
13299 |
10.93 |
05:18:06 |
05:36:06 |
interval # 7, overall |
7 |
6260 |
128059 |
112680 |
15379 |
12.01 |
05:36:07 |
05:54:07 |
interval # 8, overall |
8 |
6112 |
123690 |
110015 |
13675 |
11.06 |
05:54:08 |
06:12:08 |
interval # 9, overall |
9 |
6090 |
126913 |
109621 |
17292 |
13.63 |
06:12:09 |
06:30:09 |
interval # 10, overall |
10 |
6301 |
133582 |
113411 |
20171 |
15.10 |
06:30:10 |
06:48:10 |
Done for 315090 ms, from 7:01:58.83 to 7:07:13.92.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
6826.40 |
0.7468 |
1.2593 |
1758 |
17 |
TEST_TIME |
2 |
5304.00 |
0.8105 |
1.2025 |
2074 |
19 |
TEST_TIME |
3 |
4782.85 |
0.8894 |
1.1344 |
1548 |
17 |
TEST_TIME |
4 |
4596.29 |
0.8854 |
1.1218 |
1952 |
19 |
TEST_TIME |
5 |
4621.26 |
0.8927 |
1.1076 |
1687 |
17 |
TEST_TIME |
6 |
4733.11 |
0.9012 |
1.0937 |
1482 |
18 |
TEST_TIME |
7 |
4806.80 |
0.9231 |
1.0801 |
1819 |
20 |
TEST_TIME |
8 |
4998.78 |
0.9088 |
1.0949 |
2120 |
16 |
TEST_TIME |
9 |
5274.82 |
0.9223 |
1.0786 |
2247 |
19 |
TEST_TIME |
10 |
5504.97 |
0.9302 |
1.0735 |
2005 |
27 |
TEST_TIME |
11 |
5585.20 |
0.9619 |
1.0452 |
1479 |
34 |
TEST_TIME |
12 |
5609.01 |
0.9541 |
1.0450 |
1661 |
99 |
TEST_TIME |
13 |
5659.57 |
0.9561 |
1.0599 |
1988 |
99 |
TEST_TIME |
14 |
5800.75 |
0.9614 |
1.0363 |
1713 |
99 |
TEST_TIME |
15 |
5857.21 |
0.9579 |
1.0403 |
1873 |
99 |
TEST_TIME |
16 |
5911.19 |
0.9664 |
1.0336 |
1780 |
99 |
TEST_TIME |
17 |
5940.77 |
0.9680 |
1.0325 |
1673 |
99 |
TEST_TIME |
18 |
5952.34 |
0.9733 |
1.0284 |
1526 |
99 |
TEST_TIME |
19 |
5975.93 |
0.9704 |
1.0285 |
1591 |
99 |
TEST_TIME |
20 |
5990.42 |
0.9747 |
1.0243 |
1287 |
99 |
TEST_TIME |
21 |
6003.82 |
0.9773 |
1.0167 |
1252 |
99 |
TEST_TIME |
22 |
6002.03 |
0.9745 |
1.0316 |
1959 |
99 |
TEST_TIME |
23 |
6081.57 |
0.9739 |
1.0316 |
2045 |
99 |
TEST_TIME |
24 |
6196.17 |
0.9703 |
1.0258 |
1984 |
99 |
TEST_TIME |
25 |
6261.03 |
0.9746 |
1.0288 |
1865 |
99 |
TEST_TIME |
26 |
6340.62 |
0.9768 |
1.0226 |
1944 |
99 |
TEST_TIME |
27 |
6374.47 |
0.9795 |
1.0117 |
1772 |
99 |
TEST_TIME |
28 |
6344.43 |
0.9802 |
1.0133 |
1657 |
98 |
TEST_TIME |
29 |
6314.09 |
0.9836 |
1.0168 |
1384 |
67 |
TEST_TIME |
30 |
6315.71 |
0.9827 |
1.0156 |
1204 |
60 |
TEST_TIME |
31 |
6279.79 |
0.9885 |
1.0182 |
1324 |
99 |
TEST_TIME |
32 |
6281.99 |
0.9862 |
1.0164 |
1728 |
99 |
TEST_TIME |
33 |
6310.39 |
0.9813 |
1.0117 |
1594 |
99 |
TEST_TIME |
34 |
6274.68 |
0.9876 |
1.0138 |
1497 |
99 |
TEST_TIME |
35 |
6275.91 |
0.9846 |
1.0129 |
1274 |
99 |
TEST_TIME |
36 |
6279.66 |
0.9842 |
1.0154 |
1296 |
99 |
TEST_TIME |
37 |
6332.03 |
0.9798 |
1.0188 |
2212 |
99 |
TEST_TIME |
38 |
6421.62 |
0.9781 |
1.0222 |
2380 |
99 |
TEST_TIME |
39 |
6497.20 |
0.9844 |
1.0112 |
2149 |
99 |
TEST_TIME |
40 |
6493.45 |
0.9865 |
1.0175 |
1842 |
96 |
TEST_TIME |
41 |
6523.72 |
0.9881 |
1.0138 |
1574 |
99 |
TEST_TIME |
42 |
6511.17 |
0.9917 |
1.0099 |
2103 |
99 |
TEST_TIME |
43 |
6478.62 |
0.9914 |
1.0085 |
1575 |
95 |
TEST_TIME |
44 |
6493.96 |
0.9903 |
1.0066 |
1653 |
99 |
TEST_TIME |
45 |
6492.71 |
0.9844 |
1.0111 |
1356 |
99 |
TEST_TIME |
46 |
6513.70 |
0.9859 |
1.0130 |
1373 |
99 |
TEST_TIME |
47 |
6529.95 |
0.9890 |
1.0105 |
1382 |
99 |
TEST_TIME |
48 |
6529.40 |
0.9895 |
1.0078 |
1422 |
99 |
TEST_TIME |
49 |
6479.19 |
0.9949 |
1.0102 |
1382 |
98 |
TEST_TIME |
50 |
6456.92 |
0.9934 |
1.0045 |
1453 |
99 |
TEST_TIME |
51 |
6397.39 |
0.9940 |
1.0062 |
1451 |
97 |
TEST_TIME |
52 |
6399.84 |
0.9865 |
1.0079 |
1521 |
99 |
TEST_TIME |
53 |
6416.32 |
0.9923 |
1.0081 |
1820 |
98 |
TEST_TIME |
54 |
6408.02 |
0.9908 |
1.0130 |
1889 |
99 |
TEST_TIME |
55 |
6434.36 |
0.9916 |
1.0080 |
2305 |
98 |
TEST_TIME |
56 |
6429.08 |
0.9909 |
1.0148 |
1873 |
97 |
TEST_TIME |
57 |
6464.71 |
0.9915 |
1.0071 |
1394 |
97 |
TEST_TIME |
58 |
6452.42 |
0.9923 |
1.0057 |
1767 |
98 |
TEST_TIME |
59 |
6434.77 |
0.9914 |
1.0091 |
1540 |
99 |
TEST_TIME |
60 |
6452.32 |
0.9896 |
1.0088 |
1566 |
99 |
TEST_TIME |
61 |
6458.77 |
0.9913 |
1.0088 |
1371 |
99 |
TEST_TIME |
62 |
6461.84 |
0.9921 |
1.0087 |
1566 |
99 |
TEST_TIME |
63 |
6462.41 |
0.9926 |
1.0070 |
1364 |
99 |
TEST_TIME |
64 |
6436.45 |
0.9953 |
1.0072 |
1564 |
98 |
TEST_TIME |
65 |
6418.21 |
0.9945 |
1.0062 |
1417 |
98 |
TEST_TIME |
66 |
6403.77 |
0.9932 |
1.0047 |
1390 |
99 |
TEST_TIME |
67 |
6377.59 |
0.9938 |
1.0049 |
1899 |
97 |
TEST_TIME |
68 |
6376.31 |
0.9903 |
1.0111 |
1795 |
99 |
TEST_TIME |
69 |
6382.50 |
0.9959 |
1.0093 |
1841 |
97 |
TEST_TIME |
70 |
6411.79 |
0.9909 |
1.0083 |
1822 |
99 |
TEST_TIME |
71 |
6420.34 |
0.9927 |
1.0064 |
1809 |
99 |
TEST_TIME |
72 |
6408.66 |
0.9942 |
1.0056 |
2015 |
96 |
TEST_TIME |
73 |
6391.31 |
0.9946 |
1.0077 |
1475 |
94 |
TEST_TIME |
74 |
6382.68 |
0.9954 |
1.0068 |
1619 |
97 |
TEST_TIME |
75 |
6375.07 |
0.9950 |
1.0051 |
1650 |
99 |
TEST_TIME |
76 |
6364.60 |
0.9935 |
1.0082 |
1473 |
98 |
TEST_TIME |
77 |
6363.92 |
0.9952 |
1.0059 |
1523 |
97 |
TEST_TIME |
78 |
6346.19 |
0.9958 |
1.0072 |
1393 |
98 |
TEST_TIME |
79 |
6331.26 |
0.9968 |
1.0069 |
1466 |
97 |
TEST_TIME |
80 |
6309.89 |
0.9977 |
1.0065 |
1291 |
99 |
TEST_TIME |
81 |
6304.80 |
0.9949 |
1.0056 |
1370 |
99 |
TEST_TIME |
82 |
6298.55 |
0.9944 |
1.0038 |
1940 |
99 |
TEST_TIME |
83 |
6294.42 |
0.9924 |
1.0075 |
2211 |
98 |
TEST_TIME |
84 |
6304.25 |
0.9939 |
1.0087 |
1971 |
90 |
TEST_TIME |
85 |
6328.97 |
0.9937 |
1.0080 |
1627 |
99 |
TEST_TIME |
86 |
6334.28 |
0.9955 |
1.0046 |
1874 |
99 |
TEST_TIME |
87 |
6326.31 |
0.9943 |
1.0060 |
1798 |
99 |
TEST_TIME |
88 |
6317.42 |
0.9959 |
1.0038 |
1941 |
97 |
TEST_TIME |
89 |
6302.56 |
0.9948 |
1.0057 |
1756 |
94 |
TEST_TIME |
90 |
6303.85 |
0.9943 |
1.0083 |
1560 |
97 |
TEST_TIME |
91 |
6308.39 |
0.9965 |
1.0026 |
1525 |
98 |
TEST_TIME |
92 |
6282.04 |
0.9959 |
1.0038 |
1682 |
97 |
TEST_TIME |
93 |
6267.46 |
0.9953 |
1.0030 |
1573 |
96 |
TEST_TIME |
94 |
6245.03 |
0.9959 |
1.0059 |
1457 |
97 |
TEST_TIME |
95 |
6249.10 |
0.9959 |
1.0046 |
1396 |
99 |
TEST_TIME |
96 |
6231.52 |
0.9970 |
1.0056 |
1286 |
98 |
TEST_TIME |
97 |
6245.53 |
0.9931 |
1.0052 |
1961 |
99 |
TEST_TIME |
98 |
6255.05 |
0.9935 |
1.0087 |
1942 |
99 |
TEST_TIME |
99 |
6275.22 |
0.9953 |
1.0069 |
1832 |
99 |
TEST_TIME |
100 |
6286.39 |
0.9958 |
1.0039 |
1976 |
99 |
TEST_TIME |
101 |
6287.36 |
0.9957 |
1.0031 |
1796 |
98 |
TEST_TIME |
102 |
6280.93 |
0.9943 |
1.0052 |
1537 |
99 |
TEST_TIME |
103 |
6301.28 |
0.9922 |
1.0049 |
1603 |
99 |
TEST_TIME |
104 |
6285.60 |
0.9978 |
1.0027 |
1687 |
94 |
TEST_TIME |
105 |
6271.08 |
0.9954 |
1.0042 |
1582 |
97 |
TEST_TIME |
106 |
6273.98 |
0.9944 |
1.0041 |
1457 |
99 |
TEST_TIME |
107 |
6257.64 |
0.9974 |
1.0039 |
1481 |
98 |
TEST_TIME |
108 |
6243.36 |
0.9969 |
1.0043 |
1431 |
96 |
TEST_TIME |
109 |
6240.82 |
0.9955 |
1.0057 |
1359 |
95 |
TEST_TIME |
110 |
6243.86 |
0.9961 |
1.0033 |
1269 |
98 |
TEST_TIME |
111 |
6242.74 |
0.9944 |
1.0082 |
1216 |
99 |
TEST_TIME |
112 |
6272.59 |
0.9945 |
1.0036 |
1846 |
99 |
TEST_TIME |
113 |
6273.51 |
0.9946 |
1.0036 |
2054 |
99 |
TEST_TIME |
114 |
6276.33 |
0.9943 |
1.0072 |
1836 |
96 |
TEST_TIME |
115 |
6297.96 |
0.9950 |
1.0049 |
1692 |
99 |
TEST_TIME |
116 |
6292.53 |
0.9971 |
1.0036 |
2010 |
95 |
TEST_TIME |
117 |
6288.15 |
0.9957 |
1.0040 |
1917 |
92 |
TEST_TIME |
118 |
6291.03 |
0.9951 |
1.0038 |
1644 |
98 |
TEST_TIME |
119 |
6279.85 |
0.9979 |
1.0025 |
1692 |
92 |
TEST_TIME |
120 |
6283.11 |
0.9936 |
1.0056 |
1364 |
95 |
TEST_TIME |
121 |
6277.25 |
0.9982 |
1.0021 |
1308 |
98 |
TEST_TIME |
122 |
6266.12 |
0.9956 |
1.0024 |
1503 |
94 |
TEST_TIME |
123 |
6278.20 |
0.9924 |
1.0037 |
1325 |
98 |
TEST_TIME |
124 |
6265.23 |
0.9977 |
1.0048 |
1460 |
96 |
TEST_TIME |
125 |
6266.57 |
0.9965 |
1.0030 |
1261 |
99 |
TEST_TIME |
126 |
6266.75 |
0.9950 |
1.0051 |
1128 |
99 |
TEST_TIME |
127 |
6282.97 |
0.9949 |
1.0062 |
1958 |
99 |
TEST_TIME |
128 |
6301.19 |
0.9954 |
1.0071 |
1802 |
99 |
TEST_TIME |
129 |
6310.24 |
0.9979 |
1.0024 |
1681 |
95 |
TEST_TIME |
130 |
6288.07 |
0.9982 |
1.0019 |
1065 |
72 |
TEST_TIME |
131 |
6266.41 |
0.9977 |
1.0025 |
1176 |
72 |
TEST_TIME |
132 |
6256.84 |
0.9965 |
1.0062 |
1315 |
87 |
TEST_TIME |
133 |
6273.67 |
0.9959 |
1.0021 |
1430 |
99 |
TEST_TIME |
134 |
6275.09 |
0.9944 |
1.0021 |
1511 |
96 |
TEST_TIME |
135 |
6265.74 |
0.9962 |
1.0044 |
1533 |
92 |
TEST_TIME |
136 |
6265.67 |
0.9970 |
1.0022 |
1100 |
98 |
TEST_TIME |
137 |
6256.97 |
0.9963 |
1.0029 |
1352 |
98 |
TEST_TIME |
138 |
6250.49 |
0.9967 |
1.0025 |
1443 |
97 |
TEST_TIME |
139 |
6248.67 |
0.9955 |
1.0030 |
1434 |
98 |
TEST_TIME |
140 |
6237.91 |
0.9975 |
1.0026 |
1384 |
94 |
TEST_TIME |
141 |
6230.11 |
0.9967 |
1.0045 |
1188 |
98 |
TEST_TIME |
142 |
6225.76 |
0.9981 |
1.0027 |
1428 |
98 |
TEST_TIME |
143 |
6224.29 |
0.9959 |
1.0060 |
1492 |
96 |
TEST_TIME |
144 |
6248.62 |
0.9952 |
1.0033 |
1683 |
99 |
TEST_TIME |
145 |
6241.23 |
0.9975 |
1.0030 |
2013 |
96 |
TEST_TIME |
146 |
6238.03 |
0.9966 |
1.0033 |
1720 |
93 |
TEST_TIME |
147 |
6240.26 |
0.9961 |
1.0039 |
1695 |
91 |
TEST_TIME |
148 |
6250.16 |
0.9964 |
1.0032 |
1528 |
94 |
TEST_TIME |
149 |
6256.73 |
0.9954 |
1.0037 |
1351 |
98 |
TEST_TIME |
150 |
6254.92 |
0.9973 |
1.0028 |
1490 |
98 |
TEST_TIME |
151 |
6252.50 |
0.9966 |
1.0026 |
1259 |
99 |
TEST_TIME |
152 |
6256.01 |
0.9954 |
1.0037 |
1419 |
99 |
TEST_TIME |
153 |
6259.02 |
0.9966 |
1.0025 |
1473 |
98 |
TEST_TIME |
154 |
6248.69 |
0.9977 |
1.0035 |
1398 |
97 |
TEST_TIME |
155 |
6240.22 |
0.9984 |
1.0015 |
1251 |
92 |
TEST_TIME |
156 |
6217.14 |
0.9987 |
1.0013 |
1103 |
70 |
TEST_TIME |
157 |
6200.84 |
0.9976 |
1.0025 |
1298 |
82 |
TEST_TIME |
158 |
6207.29 |
0.9951 |
1.0028 |
1742 |
91 |
TEST_TIME |
159 |
6207.50 |
0.9964 |
1.0039 |
1522 |
96 |
TEST_TIME |
160 |
6213.67 |
0.9966 |
1.0027 |
1916 |
95 |
TEST_TIME |
161 |
6215.01 |
0.9962 |
1.0027 |
1876 |
92 |
TEST_TIME |
162 |
6219.95 |
0.9957 |
1.0047 |
1548 |
92 |
TEST_TIME |
163 |
6231.49 |
0.9967 |
1.0028 |
1614 |
91 |
TEST_TIME |
164 |
6224.36 |
0.9978 |
1.0028 |
1613 |
85 |
TEST_TIME |
165 |
6217.50 |
0.9978 |
1.0026 |
1357 |
88 |
TEST_TIME |
166 |
6212.34 |
0.9974 |
1.0033 |
1131 |
97 |
TEST_TIME |
167 |
6210.28 |
0.9976 |
1.0017 |
1541 |
97 |
TEST_TIME |
168 |
6207.08 |
0.9963 |
1.0050 |
1143 |
99 |
TEST_TIME |
169 |
6227.05 |
0.9959 |
1.0028 |
1063 |
99 |
TEST_TIME |
170 |
6225.04 |
0.9972 |
1.0030 |
1214 |
99 |
TEST_TIME |
171 |
6233.16 |
0.9958 |
1.0020 |
1340 |
98 |
TEST_TIME |
172 |
6219.24 |
0.9984 |
1.0021 |
1464 |
96 |
TEST_TIME |
173 |
6224.84 |
0.9979 |
1.0028 |
2010 |
97 |
TEST_TIME |
174 |
6230.93 |
0.9962 |
1.0057 |
1424 |
97 |
TEST_TIME |
175 |
6252.85 |
0.9966 |
1.0028 |
1668 |
98 |
TEST_TIME |
176 |
6246.18 |
0.9981 |
1.0015 |
1617 |
97 |
TEST_TIME |
177 |
6238.84 |
0.9970 |
1.0028 |
1662 |
94 |
TEST_TIME |
178 |
6239.08 |
0.9971 |
1.0030 |
1391 |
94 |
TEST_TIME |
179 |
6234.71 |
0.9981 |
1.0030 |
1261 |
92 |
TEST_TIME |
180 |
6219.33 |
0.9999 |
1.0005 |
94 |
78 |
Done for 11460 ms, from 7:07:15.75 to 7:07:27.21.
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 |
55367 |
73767 |
45797 |
<null> |
55147 |
91374 |
82980 |
53377 |
59433 |
54915 |
52602 |
64192 |
80682 |
65909 |
124811 |
66037 |
262572 |
497234 |
<null> |
03:48:01 |
04:06:01 |
fetches per second |
2 |
50850 |
84065 |
47552 |
127829 |
78895 |
<null> |
85607 |
28635 |
50925 |
104965 |
90811 |
48442 |
91122 |
49576 |
132185 |
1217 |
25976 |
580500 |
<null> |
04:06:02 |
04:24:02 |
fetches per second |
3 |
27603 |
145103 |
20905 |
<null> |
22501 |
<null> |
40152 |
3386 |
52467 |
102286 |
54179 |
52482 |
42994 |
20635 |
98995 |
4526 |
7692 |
235253 |
<null> |
04:24:03 |
04:42:03 |
fetches per second |
4 |
13632 |
7142 |
12353 |
58548 |
12683 |
149777 |
30105 |
6355 |
27300 |
4283 |
19126 |
53250 |
27000 |
34379 |
33564 |
7144 |
313294 |
385966 |
<null> |
04:42:04 |
05:00:04 |
fetches per second |
5 |
11697 |
18175 |
17039 |
<null> |
15648 |
59450 |
31231 |
5716 |
52536 |
6397 |
17374 |
2724 |
14801 |
13940 |
40593 |
4385 |
110675 |
61543 |
<null> |
05:00:05 |
05:18:05 |
fetches per second |
6 |
10557 |
12602 |
16555 |
7791 |
20614 |
2388 |
7611 |
29949 |
3029 |
9852 |
16370 |
1845 |
22936 |
1107 |
24750 |
66500 |
61006 |
46431 |
578 |
05:18:06 |
05:36:06 |
fetches per second |
7 |
10661 |
3541 |
19932 |
<null> |
18456 |
68685 |
12016 |
<null> |
4938 |
3402 |
8081 |
15735 |
41791 |
3175 |
13748 |
3216 |
18746 |
66069 |
<null> |
05:36:07 |
05:54:07 |
fetches per second |
8 |
11766 |
6692 |
10542 |
<null> |
20730 |
<null> |
9124 |
3705 |
4968 |
<null> |
34255 |
4445 |
12064 |
6105 |
38671 |
5130 |
29282 |
27642 |
<null> |
05:54:08 |
06:12:08 |
fetches per second |
9 |
8730 |
3464 |
14967 |
16551 |
15651 |
<null> |
30292 |
118956 |
826 |
<null> |
5220 |
3904 |
24761 |
3717 |
25077 |
1940 |
18188 |
15495 |
<null> |
06:12:09 |
06:30:09 |
fetches per second |
10 |
8699 |
5528 |
11476 |
101329 |
18025 |
<null> |
21184 |
<null> |
16626 |
5646 |
15396 |
2376 |
16695 |
6902 |
61364 |
4990 |
<null> |
143140 |
<null> |
06:30:10 |
06:48:10 |
marks per second |
1 |
11937 |
9617 |
9451 |
<null> |
11766 |
16482 |
10767 |
10050 |
8258 |
11230 |
8520 |
11431 |
5473 |
11080 |
4322 |
12130 |
13382 |
29975 |
<null> |
03:48:01 |
04:06:01 |
marks per second |
2 |
10514 |
11150 |
10184 |
23141 |
17214 |
<null> |
11123 |
5549 |
7462 |
17862 |
14032 |
7108 |
5820 |
8026 |
3876 |
199 |
3827 |
34000 |
<null> |
04:06:02 |
04:24:02 |
marks per second |
3 |
5762 |
19295 |
4575 |
<null> |
4411 |
<null> |
4821 |
566 |
6983 |
17304 |
7633 |
8299 |
2218 |
3332 |
1866 |
674 |
1356 |
21681 |
<null> |
04:24:03 |
04:42:03 |
marks per second |
4 |
2765 |
805 |
2388 |
8436 |
2484 |
25777 |
3388 |
910 |
3421 |
771 |
2674 |
7833 |
1397 |
5274 |
797 |
1048 |
37979 |
4071 |
<null> |
04:42:04 |
05:00:04 |
marks per second |
5 |
2473 |
2629 |
3219 |
<null> |
3376 |
15106 |
3175 |
983 |
10804 |
1092 |
1857 |
424 |
460 |
2654 |
1915 |
790 |
2773 |
1279 |
<null> |
05:00:05 |
05:18:05 |
marks per second |
6 |
2253 |
1722 |
3371 |
1618 |
3093 |
551 |
842 |
4232 |
295 |
1412 |
1353 |
367 |
623 |
219 |
1241 |
12857 |
4146 |
1379 |
77 |
05:18:06 |
05:36:06 |
marks per second |
7 |
2236 |
482 |
3528 |
<null> |
3522 |
16593 |
1441 |
<null> |
518 |
503 |
831 |
2383 |
1884 |
499 |
969 |
470 |
410 |
1163 |
<null> |
05:36:07 |
05:54:07 |
marks per second |
8 |
2392 |
872 |
1862 |
<null> |
3845 |
<null> |
1210 |
503 |
504 |
<null> |
5423 |
668 |
266 |
1109 |
3239 |
791 |
855 |
618 |
<null> |
05:54:08 |
06:12:08 |
marks per second |
9 |
1754 |
395 |
2871 |
2899 |
3120 |
<null> |
3217 |
21600 |
94 |
<null> |
570 |
572 |
680 |
634 |
2234 |
286 |
1391 |
415 |
<null> |
06:12:09 |
06:30:09 |
marks per second |
10 |
1858 |
711 |
1789 |
16229 |
2677 |
<null> |
1690 |
<null> |
1456 |
1051 |
1224 |
337 |
348 |
1341 |
2252 |
943 |
<null> |
1411 |
<null> |
06:30:10 |
06:48:10 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:48:01 |
04:06:01 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:06:02 |
04:24:02 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:24:03 |
04:42:03 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:42:04 |
05:00:04 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:00:05 |
05:18:05 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
05:18:06 |
05:36:06 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:36:07 |
05:54:07 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:54:08 |
06:12:08 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:12:09 |
06:30:09 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:30:10 |
06:48:10 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
03:48:01 |
04:06:01 |
writes/marks*100 |
2 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:06:02 |
04:24:02 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
3 |
0 |
<null> |
04:24:03 |
04:42:03 |
writes/marks*100 |
4 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
3 |
3 |
0 |
<null> |
04:42:04 |
05:00:04 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
05:00:05 |
05:18:05 |
writes/marks*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
05:18:06 |
05:36:06 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
2 |
0 |
3 |
0 |
<null> |
05:36:07 |
05:54:07 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
1 |
1 |
<null> |
0 |
1 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
05:54:08 |
06:12:08 |
writes/marks*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
06:12:09 |
06:30:09 |
writes/marks*100 |
10 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:30:10 |
06:48:10 |
Done for 10340 ms, from 7:07:28.34 to 7:07:38.68.
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 |
1956156 |
1816924 |
139232 |
7.11 |
0 |
10406 |
56 |
139232 |
2017-04-11 03:48 |
2017-04-11 06:48 |
doc_list_biud |
1956573 |
1816924 |
139649 |
7.13 |
0 |
5896 |
16 |
139649 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_add_invoice_to_stock |
21202 |
12446 |
8756 |
41.29 |
15 |
211944 |
11642 |
8756 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_cancel_adding_invoice |
4210 |
3362 |
848 |
20.14 |
0 |
44476 |
2684 |
848 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_cancel_client_order |
7432 |
7269 |
163 |
2.19 |
0 |
3307 |
235 |
163 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_cancel_customer_reserve |
319991 |
190718 |
129273 |
40.39 |
0 |
3463 |
66 |
129273 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_cancel_pay_from_customer |
2794 |
2784 |
10 |
0.35 |
0 |
5538 |
138 |
10 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_cancel_pay_to_supplier |
1784 |
1784 |
0 |
0.00 |
0 |
2168 |
136 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_cancel_supplier_invoice |
9597 |
7518 |
2079 |
21.66 |
0 |
6100 |
454 |
2079 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_cancel_supplier_order |
1675 |
565 |
1110 |
66.26 |
16 |
149902 |
19468 |
1110 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_cancel_write_off |
24907 |
16701 |
8206 |
32.94 |
0 |
4664 |
152 |
8206 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_client_order |
88195 |
88195 |
0 |
0.00 |
0 |
6988 |
467 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_customer_reserve |
644092 |
644092 |
0 |
0.00 |
0 |
13431 |
188 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_fill_shopping_cart |
133394 |
133113 |
281 |
0.21 |
0 |
4290 |
93 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_fill_shopping_cart_clo_res |
644092 |
644092 |
0 |
0.00 |
0 |
3432 |
13 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_get_clo_for_invoice |
12446 |
12446 |
0 |
0.00 |
0 |
7004 |
304 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_kill_cost_storno |
33325 |
24631 |
8694 |
26.08 |
0 |
2465 |
19 |
8694 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_kill_qstorno_ret_qs2qd |
674100 |
406220 |
267880 |
39.73 |
0 |
5351 |
25 |
267880 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_kill_qty_storno |
418788 |
279202 |
139586 |
33.33 |
0 |
5881 |
74 |
139586 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_lock_selected_doc |
86762 |
74664 |
12098 |
13.94 |
0 |
2496 |
7 |
12098 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_make_cost_storno |
106653 |
106653 |
0 |
0.00 |
0 |
10359 |
516 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_multiply_rows_for_pdistr |
106653 |
106653 |
0 |
0.00 |
0 |
2870 |
56 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_multiply_rows_for_qdistr |
88195 |
88195 |
0 |
0.00 |
0 |
6692 |
154 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_pay_from_customer |
29334 |
29334 |
0 |
0.00 |
0 |
7598 |
1005 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_pay_to_supplier |
24250 |
24250 |
0 |
0.00 |
0 |
11388 |
943 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_payment_common |
53584 |
53584 |
0 |
0.00 |
0 |
3448 |
63 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_qd_handle_on_cancel_clo |
7427 |
7269 |
158 |
2.12 |
0 |
2481 |
104 |
158 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_qd_handle_on_invoice_upd_sts |
16485 |
15808 |
677 |
4.10 |
0 |
5866 |
338 |
677 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_qd_handle_on_reserve_upd_sts |
40623 |
40623 |
0 |
0.00 |
0 |
2949 |
47 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_reserve_write_off |
41674 |
40623 |
1051 |
2.52 |
0 |
8190 |
537 |
1051 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_supplier_invoice |
22755 |
22639 |
116 |
0.50 |
0 |
23728 |
2813 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
sp_supplier_order |
22444 |
22279 |
165 |
0.73 |
0 |
12105 |
2019 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
srv_find_qd_qs_mism |
1158197 |
1018987 |
139210 |
12.01 |
0 |
5569 |
26 |
139210 |
2017-04-11 03:48 |
2017-04-11 06:48 |
srv_make_invnt_saldo |
1957 |
1957 |
0 |
0.00 |
0 |
22324 |
2764 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
srv_make_money_saldo |
3608 |
3608 |
0 |
0.00 |
0 |
4259 |
63 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
2730 |
43461 |
16889 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_add_invoice_to_stock |
8756 |
8756 |
0 |
0.00 |
0 |
1966 |
100 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_cancel_adding_invoice |
675 |
675 |
0 |
0.00 |
0 |
2511 |
190 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_cancel_client_order |
163 |
163 |
0 |
0.00 |
0 |
1263 |
101 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_cancel_customer_reserve |
66 |
66 |
0 |
0.00 |
0 |
858 |
54 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_cancel_pay_from_customer |
10 |
10 |
0 |
0.00 |
0 |
202 |
65 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_cancel_supplier_invoice |
689 |
689 |
0 |
0.00 |
0 |
1840 |
90 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_cancel_supplier_order |
16069 |
16069 |
0 |
0.00 |
0 |
3603 |
132 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_cancel_write_off |
24 |
24 |
0 |
0.00 |
0 |
327 |
79 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_reserve_write_off |
1051 |
1051 |
0 |
0.00 |
0 |
1404 |
72 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_supplier_invoice |
116 |
116 |
0 |
0.00 |
0 |
764 |
61 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-abend:sp_supplier_order |
165 |
165 |
0 |
0.00 |
0 |
1155 |
99 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_add_invoice_to_stock |
12446 |
12446 |
0 |
0.00 |
0 |
11934 |
627 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_cancel_adding_invoice |
1388 |
1388 |
0 |
0.00 |
0 |
9001 |
722 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_cancel_client_order |
7269 |
7269 |
0 |
0.00 |
0 |
2059 |
70 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_cancel_customer_reserve |
2684 |
2684 |
0 |
0.00 |
0 |
1560 |
71 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_cancel_pay_from_customer |
2784 |
2784 |
0 |
0.00 |
0 |
1482 |
58 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_cancel_pay_to_supplier |
1784 |
1784 |
0 |
0.00 |
0 |
1575 |
53 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_cancel_supplier_invoice |
1022 |
1022 |
0 |
0.00 |
0 |
1279 |
70 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_cancel_supplier_order |
565 |
565 |
0 |
0.00 |
0 |
24538 |
1782 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_cancel_write_off |
4099 |
4099 |
0 |
0.00 |
0 |
1763 |
73 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_client_order |
88195 |
88195 |
0 |
0.00 |
0 |
2293 |
80 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_customer_reserve |
4084 |
4084 |
0 |
0.00 |
0 |
1591 |
58 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_pay_from_customer |
29334 |
29334 |
0 |
0.00 |
0 |
2122 |
71 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_pay_to_supplier |
24250 |
24250 |
0 |
0.00 |
0 |
2527 |
68 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_reserve_write_off |
40623 |
40623 |
0 |
0.00 |
0 |
2980 |
75 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_supplier_invoice |
22639 |
22639 |
0 |
0.00 |
0 |
2621 |
73 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:sp_supplier_order |
22279 |
22279 |
0 |
0.00 |
0 |
3916 |
75 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:srv_make_invnt_saldo |
1957 |
1957 |
0 |
0.00 |
0 |
749 |
25 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:srv_make_money_saldo |
3608 |
3608 |
0 |
0.00 |
0 |
1123 |
31 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
234 |
35 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_add_invoice_to_stock |
42404 |
24892 |
17512 |
41.29 |
0 |
1123 |
9 |
17512 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_all_customers |
132588 |
132588 |
0 |
0.00 |
0 |
1045 |
5 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_all_suppliers |
90398 |
89836 |
562 |
0.62 |
0 |
1576 |
5 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_all_wares |
176390 |
176390 |
0 |
0.00 |
0 |
936 |
4 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_cancel_adding_invoice |
3234 |
2776 |
458 |
14.16 |
0 |
3572 |
166 |
458 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_cancel_client_order |
14864 |
14538 |
326 |
2.19 |
0 |
1060 |
6 |
326 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_cancel_customer_prepayment |
5588 |
5568 |
20 |
0.35 |
0 |
889 |
8 |
20 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_cancel_customer_reserve |
5500 |
5368 |
132 |
2.40 |
0 |
1092 |
9 |
132 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_cancel_payment_to_supplier |
3568 |
3568 |
0 |
0.00 |
0 |
936 |
8 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_cancel_supplier_invoice |
3422 |
2044 |
1378 |
40.26 |
0 |
842 |
10 |
1378 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_cancel_supplier_order |
3350 |
1130 |
2220 |
66.26 |
0 |
967 |
10 |
2220 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_cancel_write_off |
8246 |
8198 |
48 |
0.58 |
0 |
3494 |
96 |
48 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_max_id_clo_ord |
22444 |
22279 |
165 |
0.73 |
0 |
624 |
5 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_max_id_clo_res |
4084 |
4084 |
0 |
0.00 |
0 |
1389 |
19 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_max_id_ord_sup |
22755 |
22639 |
116 |
0.50 |
0 |
1045 |
5 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_max_non_paid_invoice |
24250 |
24250 |
0 |
0.00 |
0 |
967 |
6 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_max_non_paid_realizn |
29334 |
29334 |
0 |
0.00 |
0 |
1123 |
6 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_min_id_clo_ord |
22444 |
22279 |
165 |
0.73 |
0 |
1358 |
8 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_min_id_clo_res |
4084 |
4084 |
0 |
0.00 |
0 |
998 |
9 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_min_id_ord_sup |
22755 |
22639 |
116 |
0.50 |
0 |
1358 |
7 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_min_non_paid_invoice |
24250 |
24250 |
0 |
0.00 |
0 |
1732 |
10 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_min_non_paid_realizn |
29334 |
29334 |
0 |
0.00 |
0 |
1513 |
9 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_our_firm |
43802 |
43802 |
0 |
0.00 |
0 |
749 |
5 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
v_reserve_write_off |
83348 |
81246 |
2102 |
2.52 |
0 |
1607 |
8 |
2102 |
2017-04-11 03:48 |
2017-04-11 06:48 |
x_lock_depdocs_on_canc_invoice |
18706 |
9858 |
8848 |
47.30 |
0 |
1981 |
32 |
8848 |
2017-04-11 03:48 |
2017-04-11 06:48 |
x_lock_depdocs_on_canc_sup_ord |
1674 |
565 |
1109 |
66.24 |
0 |
1295 |
62 |
1109 |
2017-04-11 03:48 |
2017-04-11 06:48 |
x_make_qstorno_1000_1200 |
22444 |
22279 |
165 |
0.73 |
0 |
11091 |
1810 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
x_make_qstorno_1200_2000 |
22755 |
22639 |
116 |
0.50 |
0 |
23354 |
2603 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
x_make_qstorno_2100_3300 |
644092 |
644092 |
0 |
0.00 |
0 |
12870 |
159 |
0 |
2017-04-11 03:48 |
2017-04-11 06:48 |
Done for 419840 ms, from 7:14:42.77 to 7:21:42.61.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
62 |
sp_kill_cost_storno |
335544336 |
2017-04-11 03:49 |
2017-04-11 06:46 |
deadlock |
96 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-04-11 03:57 |
2017-04-11 06:46 |
deadlock |
2282 |
sp_lock_selected_doc |
335544336 |
2017-04-11 03:48 |
2017-04-11 06:47 |
deadlock |
158 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-04-11 03:49 |
2017-04-11 06:47 |
deadlock |
158 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-04-11 03:49 |
2017-04-11 06:46 |
deadlock |
51 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-04-11 04:00 |
2017-04-11 06:37 |
deadlock |
16 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-04-11 04:00 |
2017-04-11 05:28 |
user_exc |
165 |
x_make_qstorno_1000_1200 |
335544517 |
2017-04-11 03:48 |
2017-04-11 06:47 |
user_exc |
116 |
x_make_qstorno_1200_2000 |
335544517 |
2017-04-11 03:48 |
2017-04-11 06:47 |
concurrent_transaction |
8321 |
sp_lock_selected_doc |
335544878 |
2017-04-11 03:48 |
2017-04-11 06:47 |
concurrent_transaction |
676 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2017-04-11 03:48 |
2017-04-11 06:47 |
concurrent_transaction |
271 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2017-04-11 03:53 |
2017-04-11 06:47 |
Done for 6770 ms, from 7:21:48.14 to 7:21:54.91.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 458199
MON$OLDEST_ACTIVE 458200
MON$OLDEST_SNAPSHOT 458200
MON$NEXT_TRANSACTION 458200
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:12:20.4040
MON$PAGES 852672
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.3.32714 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32714 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32714 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32714 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 458376
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 458201
Oldest active 458202
Oldest snapshot 458202
Next transaction 458203
Sequence number 0
Next attachment ID 9599
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:12:20
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 33.58, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.11, total records: 2273024
Average version length: 47.56, total versions: 2866, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 16, data page slots: 24576
Data pages: 24576, average fill: 73%
Primary pages: 24576, secondary pages: 0, swept pages: 15142
Empty pages: 4, full pages: 22478
Fill distribution:
0 - 19% = 5
20 - 39% = 12
40 - 59% = 49
60 - 79% = 24504
80 - 99% = 6
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 11051, nodes: 2273024
Average node length: 19.33, total dup: 0, max dup: 0
Average key length: 16.37, compression ratio: 1.65
Average prefix length: 13.62, average data length: 13.38
Clustering factor: 495207, ratio: 0.22
Fill distribution:
0 - 19% = 735
20 - 39% = 2368
40 - 59% = 5303
60 - 79% = 1231
80 - 99% = 1414
Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 8101, nodes: 2273024
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.68, compression ratio: 1.04
Average prefix length: 3.32, average data length: 5.68
Clustering factor: 462427, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 3653
40 - 59% = 4376
60 - 79% = 63
80 - 99% = 9
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 174173, depth: 3, leaf buckets: 4056, nodes: 2273024
Average node length: 6.83, total dup: 1651373, max dup: 49
Average key length: 3.88, compression ratio: 2.32
Average prefix length: 7.40, average data length: 1.60
Clustering factor: 454436, ratio: 0.20
Fill distribution:
0 - 19% = 184
20 - 39% = 1220
40 - 59% = 1875
60 - 79% = 259
80 - 99% = 518
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.46, total records: 690398
Average version length: 35.46, total versions: 785, max versions: 3
Average fragment length: 25.58, total fragments: 12, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8720
Data pages: 8720, average fill: 75%
Primary pages: 8717, secondary pages: 3, swept pages: 8036
Empty pages: 4, full pages: 8212
Fill distribution:
0 - 19% = 7
20 - 39% = 6
40 - 59% = 27
60 - 79% = 8659
80 - 99% = 21
Index DOC_LIST_ID_DESC (1)
Root page: 244032, depth: 3, leaf buckets: 2527, nodes: 690398
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 170297, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 1352
40 - 59% = 1139
60 - 79% = 33
80 - 99% = 3
Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 724, nodes: 690398
Average node length: 4.88, total dup: 690348, max dup: 46302
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 315073, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 622
60 - 79% = 78
80 - 99% = 24
Index PK_DOC_LIST (0)
Root page: 327484, depth: 3, leaf buckets: 2117, nodes: 690398
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.80, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 170297, ratio: 0.25
Fill distribution:
0 - 19% = 163
20 - 39% = 631
40 - 59% = 843
60 - 79% = 213
80 - 99% = 267
DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 65.92, total records: 400
Average version length: 20.64, total versions: 149760, max versions: 1240
Average fragment length: 18.90, total fragments: 386, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.58
Pointer pages: 2, data page slots: 1920
Data pages: 1920, average fill: 42%
Primary pages: 10, secondary pages: 1910, swept pages: 1
Empty pages: 6, full pages: 6
Fill distribution:
0 - 19% = 6
20 - 39% = 424
40 - 59% = 1483
60 - 79% = 3
80 - 99% = 4
Index PK_INVNT_SALDO (0)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 292, ratio: 0.73
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 5.55, total records: 63782
Average version length: 71.15, total versions: 58814, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 17.31
Pointer pages: 2, data page slots: 1584
Data pages: 1352, average fill: 61%
Primary pages: 1351, secondary pages: 1, swept pages: 14
Empty pages: 244, full pages: 771
Fill distribution:
0 - 19% = 298
20 - 39% = 68
40 - 59% = 105
60 - 79% = 259
80 - 99% = 622
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 206, nodes: 63782
Average node length: 13.99, total dup: 1696, max dup: 2
Average key length: 11.65, compression ratio: 2.32
Average prefix length: 18.32, average data length: 8.68
Clustering factor: 55343, ratio: 0.87
Fill distribution:
0 - 19% = 0
20 - 39% = 27
40 - 59% = 125
60 - 79% = 48
80 - 99% = 6
MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 15.00, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.13
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 273, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 34.18, total records: 135
Average version length: 45.80, total versions: 35, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.87
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 4%
Primary pages: 39, secondary pages: 1, swept pages: 33
Empty pages: 28, full pages: 0
Fill distribution:
0 - 19% = 37
20 - 39% = 3
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 374038, depth: 2, leaf buckets: 1, nodes: 135
Average node length: 8.24, total dup: 95, max dup: 20
Average key length: 6.53, compression ratio: 2.91
Average prefix length: 14.76, average data length: 4.24
Clustering factor: 66, ratio: 0.49
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 366, Index root page: 367
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 39.28, total records: 292246
Average version length: 32.83, total versions: 34959, max versions: 16
Average fragment length: 33.50, total fragments: 2, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.63
Pointer pages: 2, data page slots: 3128
Data pages: 3128, average fill: 72%
Primary pages: 3112, secondary pages: 16, swept pages: 420
Empty pages: 18, full pages: 2871
Fill distribution:
0 - 19% = 76
20 - 39% = 113
40 - 59% = 29
60 - 79% = 2619
80 - 99% = 291
Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 257, nodes: 292246
Average node length: 4.64, total dup: 292197, max dup: 15425
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 50928, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 85
60 - 79% = 117
80 - 99% = 47
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 322, nodes: 292246
Average node length: 5.58, total dup: 263471, max dup: 100
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 66826, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 28
40 - 59% = 134
60 - 79% = 92
80 - 99% = 68
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 331, nodes: 292246
Average node length: 5.58, total dup: 263471, max dup: 100
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 67077, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 25
40 - 59% = 140
60 - 79% = 119
80 - 99% = 47
Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 314, nodes: 292246
Average node length: 5.37, total dup: 263471, max dup: 100
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 66849, ratio: 0.23
Fill distribution:
0 - 19% = 2
20 - 39% = 31
40 - 59% = 123
60 - 79% = 99
80 - 99% = 59
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.91, total records: 289364
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 2, data page slots: 2472
Data pages: 2472, average fill: 64%
Primary pages: 2472, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 2469
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2469
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 300779, depth: 2, leaf buckets: 230, nodes: 289364
Average node length: 4.56, total dup: 289183, max dup: 2379
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 24368, ratio: 0.08
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 89
60 - 79% = 62
80 - 99% = 78
PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.57, total records: 11996413
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.19
Pointer pages: 175, data page slots: 284360
Data pages: 284360, average fill: 87%
Primary pages: 284360, secondary pages: 0, swept pages: 3
Empty pages: 0, full pages: 284359
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 284359
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 13384, nodes: 11996413
Average node length: 5.67, total dup: 11139413, max dup: 149
Average key length: 2.17, compression ratio: 3.68
Average prefix length: 7.87, average data length: 0.13
Clustering factor: 4559721, ratio: 0.38
Fill distribution:
0 - 19% = 12
20 - 39% = 0
40 - 59% = 7096
60 - 79% = 4161
80 - 99% = 2115
Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 11907, nodes: 11996413
Average node length: 4.59, total dup: 11996408, max dup: 10961575
Average key length: 1.09, compression ratio: 0.40
Average prefix length: 0.43, average data length: 0.00
Clustering factor: 362212, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 11876
60 - 79% = 0
80 - 99% = 30
Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 14477, nodes: 11996413
Average node length: 5.74, total dup: 11608031, max dup: 19891
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 1053850, ratio: 0.09
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 10412
60 - 79% = 2204
80 - 99% = 1854
Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 14597, nodes: 11996413
Average node length: 5.57, total dup: 11964637, max dup: 1574729
Average key length: 2.07, compression ratio: 18.22
Average prefix length: 37.72, average data length: 0.07
Clustering factor: 6860373, ratio: 0.57
Fill distribution:
0 - 19% = 18
20 - 39% = 0
40 - 59% = 12538
60 - 79% = 593
80 - 99% = 1448
PHRASES (145)
Primary pointer page: 266, Index root page: 267
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.70, total records: 432137
Average version length: 55.86, total versions: 3004, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 4, data page slots: 5112
Data pages: 5112, average fill: 75%
Primary pages: 5112, secondary pages: 0, swept pages: 3105
Empty pages: 0, full pages: 4983
Fill distribution:
0 - 19% = 2
20 - 39% = 5
40 - 59% = 9
60 - 79% = 5089
80 - 99% = 7
Index PSTORNED_RCV_ID (2)
Root page: 706902, depth: 3, leaf buckets: 591, nodes: 432137
Average node length: 6.03, total dup: 357368, max dup: 598
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 56372, ratio: 0.13
Fill distribution:
0 - 19% = 17
20 - 39% = 32
40 - 59% = 373
60 - 79% = 115
80 - 99% = 54
Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 456, nodes: 432137
Average node length: 5.58, total dup: 385989, max dup: 132
Average key length: 2.80, compression ratio: 3.21
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 104650, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 196
60 - 79% = 166
80 - 99% = 90
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 4257, max versions: 2863
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 85%
Primary pages: 1, secondary pages: 15, swept pages: 0
Empty pages: 0, full pages: 14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 14
Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 57.75, total records: 3286
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.51
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 75%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 39
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 39
80 - 99% = 0
WARES (144)
Primary pointer page: 264, Index root page: 265
Total formats: 1, used formats: 1
Average record length: 78.23, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 78%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 67
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.86, total dup: 0, max dup: 0
Average key length: 51.84, compression ratio: 1.00
Average prefix length: 2.73, average data length: 48.86
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 2.46, total records: 95777
Average version length: 72.20, total versions: 92524, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 55.23
Pointer pages: 2, data page slots: 1760
Data pages: 1416, average fill: 88%
Primary pages: 1413, secondary pages: 3, swept pages: 0
Empty pages: 61, full pages: 1342
Fill distribution:
0 - 19% = 70
20 - 39% = 2
40 - 59% = 1
60 - 79% = 63
80 - 99% = 1280
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 127, nodes: 95777
Average node length: 5.82, total dup: 83739, max dup: 14
Average key length: 3.36, compression ratio: 11.00
Average prefix length: 35.76, average data length: 1.24
Clustering factor: 15038, ratio: 0.16
Fill distribution:
0 - 19% = 13
20 - 39% = 8
40 - 59% = 53
60 - 79% = 39
80 - 99% = 14
XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 68.50, total records: 1309595
Average version length: 71.80, total versions: 66810, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.99
Pointer pages: 12, data page slots: 18920
Data pages: 18920, average fill: 77%
Primary pages: 18920, secondary pages: 0, swept pages: 5524
Empty pages: 33, full pages: 17870
Fill distribution:
0 - 19% = 49
20 - 39% = 61
40 - 59% = 245
60 - 79% = 17021
80 - 99% = 1544
Index XQD_1000_3300_DOC (1)
Root page: 427144, depth: 3, leaf buckets: 1511, nodes: 1309595
Average node length: 5.13, total dup: 1275797, max dup: 122
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 147721, ratio: 0.11
Fill distribution:
0 - 19% = 17
20 - 39% = 86
40 - 59% = 1153
60 - 79% = 59
80 - 99% = 196
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 258731, depth: 3, leaf buckets: 1862, nodes: 1309595
Average node length: 6.26, total dup: 1144144, max dup: 29
Average key length: 3.31, compression ratio: 11.17
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 251423, ratio: 0.19
Fill distribution:
0 - 19% = 13
20 - 39% = 120
40 - 59% = 1452
60 - 79% = 143
80 - 99% = 134
XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 3.84, total records: 138548
Average version length: 72.12, total versions: 131189, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 35.42
Pointer pages: 3, data page slots: 4584
Data pages: 2672, average fill: 68%
Primary pages: 2669, secondary pages: 3, swept pages: 14
Empty pages: 211, full pages: 1650
Fill distribution:
0 - 19% = 327
20 - 39% = 272
40 - 59% = 316
60 - 79% = 232
80 - 99% = 1525
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 761964, depth: 3, leaf buckets: 205, nodes: 138548
Average node length: 5.83, total dup: 124101, max dup: 55
Average key length: 3.16, compression ratio: 11.70
Average prefix length: 35.94, average data length: 1.06
Clustering factor: 19024, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 57
40 - 59% = 103
60 - 79% = 40
80 - 99% = 5
XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 65.99, total records: 1929644
Average version length: 71.95, total versions: 165662, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.06
Pointer pages: 18, data page slots: 28944
Data pages: 28800, average fill: 75%
Primary pages: 28800, secondary pages: 0, swept pages: 7776
Empty pages: 116, full pages: 23927
Fill distribution:
0 - 19% = 256
20 - 39% = 545
40 - 59% = 1593
60 - 79% = 22095
80 - 99% = 4311
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 175162, depth: 3, leaf buckets: 3055, nodes: 1929644
Average node length: 5.65, total dup: 1808440, max dup: 99
Average key length: 2.69, compression ratio: 13.78
Average prefix length: 36.38, average data length: 0.62
Clustering factor: 266114, ratio: 0.14
Fill distribution:
0 - 19% = 12
20 - 39% = 1433
40 - 59% = 1193
60 - 79% = 244
80 - 99% = 173
XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 0.32, total records: 109944
Average version length: 71.84, total versions: 109445, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 419.16
Pointer pages: 3, data page slots: 2744
Data pages: 2144, average fill: 67%
Primary pages: 2142, secondary pages: 2, swept pages: 45
Empty pages: 214, full pages: 1299
Fill distribution:
0 - 19% = 279
20 - 39% = 159
40 - 59% = 224
60 - 79% = 389
80 - 99% = 1093
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 160, nodes: 109944
Average node length: 5.36, total dup: 101339, max dup: 99
Average key length: 2.96, compression ratio: 12.49
Average prefix length: 36.11, average data length: 0.89
Clustering factor: 12055, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 48
40 - 59% = 95
60 - 79% = 15
80 - 99% = 1
XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 70.26, total records: 2899601
Average version length: 71.30, total versions: 52235, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.94
Pointer pages: 25, data page slots: 40792
Data pages: 40792, average fill: 78%
Primary pages: 40792, secondary pages: 0, swept pages: 20649
Empty pages: 1, full pages: 40280
Fill distribution:
0 - 19% = 3
20 - 39% = 4
40 - 59% = 42
60 - 79% = 39081
80 - 99% = 1662
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5769, nodes: 2899601
Average node length: 6.88, total dup: 2346118, max dup: 17
Average key length: 3.91, compression ratio: 9.47
Average prefix length: 35.28, average data length: 1.72
Clustering factor: 572459, ratio: 0.20
Fill distribution:
0 - 19% = 12
20 - 39% = 2698
40 - 59% = 2576
60 - 79% = 272
80 - 99% = 211
XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.67, total records: 4976992
Average version length: 84.74, total versions: 9485, 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: 47, data page slots: 76496
Data pages: 76496, average fill: 80%
Primary pages: 76496, secondary pages: 0, swept pages: 27243
Empty pages: 4, full pages: 76487
Fill distribution:
0 - 19% = 4
20 - 39% = 5
40 - 59% = 0
60 - 79% = 21518
80 - 99% = 54969
Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 5084, nodes: 4976992
Average node length: 5.16, total dup: 4863241, max dup: 123
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 801592, ratio: 0.16
Fill distribution:
0 - 19% = 24
20 - 39% = 115
40 - 59% = 2229
60 - 79% = 2067
80 - 99% = 649
Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 5631, nodes: 4976992
Average node length: 5.70, total dup: 4455895, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 274495, ratio: 0.06
Fill distribution:
0 - 19% = 60
20 - 39% = 175
40 - 59% = 3397
60 - 79% = 386
80 - 99% = 1613
Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5666, nodes: 4976992
Average node length: 5.81, total dup: 4354703, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 860411, ratio: 0.17
Fill distribution:
0 - 19% = 22
20 - 39% = 126
40 - 59% = 2485
60 - 79% = 2140
80 - 99% = 893
XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 82.26, total records: 2529243
Average version length: 83.96, total versions: 32492, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 25, data page slots: 39248
Data pages: 39248, average fill: 79%
Primary pages: 39248, secondary pages: 0, swept pages: 24185
Empty pages: 2, full pages: 38695
Fill distribution:
0 - 19% = 9
20 - 39% = 30
40 - 59% = 113
60 - 79% = 15409
80 - 99% = 23687
Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2690, nodes: 2529243
Average node length: 5.15, total dup: 2470474, max dup: 201
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 408068, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 40
40 - 59% = 1569
60 - 79% = 805
80 - 99% = 274
Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 4360, nodes: 2529243
Average node length: 6.24, total dup: 2069806, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 268921, ratio: 0.11
Fill distribution:
0 - 19% = 127
20 - 39% = 1743
40 - 59% = 1767
60 - 79% = 467
80 - 99% = 256
Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 3069, nodes: 2529243
Average node length: 5.81, total dup: 2214812, max dup: 44
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 487509, ratio: 0.19
Fill distribution:
0 - 19% = 11
20 - 39% = 52
40 - 59% = 1808
60 - 79% = 898
80 - 99% = 300
XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.32, total records: 5314098
Average version length: 85.57, total versions: 39320, 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: 51, data page slots: 82216
Data pages: 82072, average fill: 80%
Primary pages: 82072, secondary pages: 0, swept pages: 19841
Empty pages: 60, full pages: 80424
Fill distribution:
0 - 19% = 98
20 - 39% = 181
40 - 59% = 519
60 - 79% = 16415
80 - 99% = 64859
Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5615, nodes: 5314098
Average node length: 5.04, total dup: 5283407, max dup: 658
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 790554, ratio: 0.15
Fill distribution:
0 - 19% = 7
20 - 39% = 258
40 - 59% = 3184
60 - 79% = 1568
80 - 99% = 598
Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6574, nodes: 5314098
Average node length: 5.54, total dup: 4887673, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 310269, ratio: 0.06
Fill distribution:
0 - 19% = 80
20 - 39% = 1675
40 - 59% = 2900
60 - 79% = 633
80 - 99% = 1286
Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 6307, nodes: 5314098
Average node length: 5.68, total dup: 4770326, max dup: 80
Average key length: 2.69, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 878189, ratio: 0.17
Fill distribution:
0 - 19% = 5
20 - 39% = 223
40 - 59% = 3634
60 - 79% = 1772
80 - 99% = 673
XQS_2000_3300 (269)
Primary pointer page: 761, Index root page: 762
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 82.76, total records: 3546893
Average version length: 84.25, total versions: 36596, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 34, data page slots: 55016
Data pages: 55016, average fill: 80%
Primary pages: 55016, secondary pages: 0, swept pages: 33055
Empty pages: 7, full pages: 54771
Fill distribution:
0 - 19% = 13
20 - 39% = 37
40 - 59% = 75
60 - 79% = 20044
80 - 99% = 34847
Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3829, nodes: 3546893
Average node length: 5.03, total dup: 3529184, max dup: 1887
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 751678, ratio: 0.21
Fill distribution:
0 - 19% = 16
20 - 39% = 366
40 - 59% = 2060
60 - 79% = 949
80 - 99% = 438
Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 6200, nodes: 3546893
Average node length: 6.26, total dup: 2898701, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 420421, ratio: 0.12
Fill distribution:
0 - 19% = 241
20 - 39% = 2422
40 - 59% = 2559
60 - 79% = 609
80 - 99% = 369
Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 4177, nodes: 3546893
Average node length: 5.60, total dup: 3231232, max dup: 99
Average key length: 2.62, compression ratio: 3.44
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 796871, ratio: 0.22
Fill distribution:
0 - 19% = 12
20 - 39% = 365
40 - 59% = 2104
60 - 79% = 1189
80 - 99% = 507
XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 68.86, total records: 668758
Average version length: 69.65, total versions: 5827, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.98
Pointer pages: 6, data page slots: 9152
Data pages: 9152, average fill: 78%
Primary pages: 9152, secondary pages: 0, swept pages: 6484
Empty pages: 2, full pages: 9073
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 13
60 - 79% = 8965
80 - 99% = 170
Index XQS_3300_3400_DOC_ID (0)
Root page: 127816, depth: 3, leaf buckets: 812, nodes: 668758
Average node length: 5.33, total dup: 628772, max dup: 141
Average key length: 2.46, compression ratio: 3.67
Average prefix length: 8.60, average data length: 0.40
Clustering factor: 58177, ratio: 0.09
Fill distribution:
0 - 19% = 4
20 - 39% = 179
40 - 59% = 337
60 - 79% = 205
80 - 99% = 87
Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 928, nodes: 668758
Average node length: 5.94, total dup: 570212, max dup: 29
Average key length: 3.06, compression ratio: 2.94
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 61719, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 245
40 - 59% = 379
60 - 79% = 215
80 - 99% = 88
ZDOC_DATA (230)
Primary pointer page: 644, Index root page: 645
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 642, Index root page: 643
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 646, Index root page: 647
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 652, Index root page: 653
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 662, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 654, Index root page: 655
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 663, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 648, Index root page: 649
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 656, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 657, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 650, Index root page: 651
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 659, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 658, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 661, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 660, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 640, Index root page: 641
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 614, Index root page: 615
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 268, Index root page: 269
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 149030 ms, from 7:21:55.14 to 7:24:24.17.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2273024 |
2866 |
0.1260 |
DOC_LIST |
690398 |
785 |
0.1137 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
149760 |
37440.0000 |
INVNT_TURNOVER_LOG |
63782 |
58814 |
92.2109 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
135 |
35 |
25.9259 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
292246 |
34959 |
11.9621 |
PERF_ESTIMATED |
289364 |
0 |
0.0000 |
PERF_LOG |
11996413 |
0 |
0.0000 |
PSTORNED |
432137 |
3004 |
0.6951 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
4257 |
106425.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
3286 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
95777 |
92524 |
96.6035 |
XQD_1000_3300 |
1309595 |
66810 |
5.1015 |
XQD_1200_2000 |
138548 |
131189 |
94.6884 |
XQD_2000_3300 |
1929644 |
165662 |
8.5851 |
XQD_2100_3300 |
109944 |
109445 |
99.5461 |
XQD_3300_3400 |
2899601 |
52235 |
1.8014 |
XQS_1000_1200 |
4976992 |
9485 |
0.1905 |
XQS_1000_3300 |
2529243 |
32492 |
1.2846 |
XQS_1200_2000 |
5314098 |
39320 |
0.7399 |
XQS_2100_3300 |
3546893 |
36596 |
1.0317 |
XQS_3300_3400 |
668758 |
5827 |
0.8713 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 1500 ms, from 7:24:28.49 to 7:24:29.99.
07:24:30.08 Validation started
07:24:30.10 Relation 140 (DOC_LIST)
07:24:30.10 process pointer page 0 of 6
07:24:30.15 process pointer page 1 of 6
07:24:30.19 process pointer page 2 of 6
07:24:30.24 process pointer page 3 of 6
07:24:30.27 process pointer page 4 of 6
07:24:30.30 process pointer page 5 of 6
07:24:30.32 Index 1 (PK_DOC_LIST)
07:24:30.41 Index 2 (DOC_LIST_ID_DESC)
07:24:30.54 Index 3 (FK_DOC_LIST_AGENTS)
07:24:30.61 Relation 140 (DOC_LIST) is ok
07:24:30.61 Relation 141 (DOC_DATA)
07:24:30.61 process pointer page 0 of 16
07:24:30.63 process pointer page 1 of 16
07:24:30.66 process pointer page 2 of 16
07:24:30.71 process pointer page 3 of 16
07:24:30.74 process pointer page 4 of 16
07:24:30.79 process pointer page 5 of 16
07:24:30.83 process pointer page 6 of 16
07:24:30.89 process pointer page 7 of 16
07:24:30.99 process pointer page 8 of 16
07:24:31.07 process pointer page 9 of 16
07:24:31.10 process pointer page 10 of 16
07:24:31.14 process pointer page 11 of 16
07:24:31.21 process pointer page 12 of 16
07:24:31.27 process pointer page 13 of 16
07:24:31.32 process pointer page 14 of 16
07:24:31.35 process pointer page 15 of 16
07:24:31.35 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:24:31.75 Index 3 (DOC_DATA_ID_DESC)
07:24:32.19 Index 4 (FK_DOC_DATA_DOC_LIST)
07:24:32.59 Relation 141 (DOC_DATA) is ok
07:24:32.59 Relation 147 (INVNT_SALDO)
07:24:32.59 process pointer page 0 of 2
07:24:32.95 process pointer page 1 of 2
07:24:32.97 Index 1 (PK_INVNT_SALDO)
07:24:32.97 Relation 147 (INVNT_SALDO) is ok
07:24:32.97 Relation 150 (PDISTR)
07:24:32.97 process pointer page 0 of 2
07:24:33.08 process pointer page 1 of 2
07:24:33.20 Index 2 (PDISTR_SND_ID)
07:24:33.30 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:24:33.34 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:24:33.37 Index 5 (PDISTR_AGENT_ID)
07:24:33.41 Relation 150 (PDISTR) is ok
07:24:33.41 Relation 151 (PSTORNED)
07:24:33.41 process pointer page 0 of 4
07:24:33.45 process pointer page 1 of 4
07:24:33.48 process pointer page 2 of 4
07:24:33.53 process pointer page 3 of 4
07:24:33.53 Index 2 (PSTORNED_SND_ID)
07:24:33.58 Index 3 (PSTORNED_RCV_ID)
07:24:33.62 Relation 151 (PSTORNED) is ok
07:24:33.62 Relation 156 (SEMAPHORES)
07:24:33.64 process pointer page 0 of 1
07:24:33.64 Index 1 (PK_SEMAPHORES)
07:24:33.64 Index 2 (SEMAPHORES_TASK_UNQ)
07:24:33.64 Relation 156 (SEMAPHORES) is ok
07:24:33.64 Relation 157 (INVNT_TURNOVER_LOG)
07:24:33.64 process pointer page 0 of 2
07:24:33.69 process pointer page 1 of 2
07:24:33.73 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:24:33.78 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:24:33.78 Relation 160 (PERF_ESTIMATED)
07:24:33.78 process pointer page 0 of 2
07:24:33.87 process pointer page 1 of 2
07:24:33.92 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:24:33.98 Relation 160 (PERF_ESTIMATED) is ok
07:24:33.98 Relation 161 (PERF_ISQL_STAT)
07:24:33.98 process pointer page 0 of 1
07:24:33.98 Index 1 (PERF_ISQL_STAT_TRN)
07:24:33.98 Relation 161 (PERF_ISQL_STAT) is ok
07:24:33.98 Relation 162 (TRACE_STAT)
07:24:33.98 process pointer page 0 of 1
07:24:34.00 Relation 162 (TRACE_STAT) is ok
07:24:34.00 Relation 163 (PERF_LOG)
07:24:34.00 process pointer page 0 of 175
07:24:34.08 process pointer page 1 of 175
07:24:34.15 process pointer page 2 of 175
07:24:34.23 process pointer page 3 of 175
07:24:34.28 process pointer page 4 of 175
07:24:34.31 process pointer page 5 of 175
07:24:34.34 process pointer page 6 of 175
07:24:34.37 process pointer page 7 of 175
07:24:34.42 process pointer page 8 of 175
07:24:34.44 process pointer page 9 of 175
07:24:34.47 process pointer page 10 of 175
07:24:34.50 process pointer page 11 of 175
07:24:34.53 process pointer page 12 of 175
07:24:34.56 process pointer page 13 of 175
07:24:34.58 process pointer page 14 of 175
07:24:34.61 process pointer page 15 of 175
07:24:34.64 process pointer page 16 of 175
07:24:34.67 process pointer page 17 of 175
07:24:34.70 process pointer page 18 of 175
07:24:34.76 process pointer page 19 of 175
07:24:34.84 process pointer page 20 of 175
07:24:34.92 process pointer page 21 of 175
07:24:34.95 process pointer page 22 of 175
07:24:35.03 process pointer page 23 of 175
07:24:35.11 process pointer page 24 of 175
07:24:35.18 process pointer page 25 of 175
07:24:35.23 process pointer page 26 of 175
07:24:35.26 process pointer page 27 of 175
07:24:35.29 process pointer page 28 of 175
07:24:35.34 process pointer page 29 of 175
07:24:35.37 process pointer page 30 of 175
07:24:35.40 process pointer page 31 of 175
07:24:35.43 process pointer page 32 of 175
07:24:35.47 process pointer page 33 of 175
07:24:35.50 process pointer page 34 of 175
07:24:35.53 process pointer page 35 of 175
07:24:35.56 process pointer page 36 of 175
07:24:35.59 process pointer page 37 of 175
07:24:35.61 process pointer page 38 of 175
07:24:35.68 process pointer page 39 of 175
07:24:36.07 process pointer page 40 of 175
07:24:36.48 process pointer page 41 of 175
07:24:36.85 process pointer page 42 of 175
07:24:37.24 process pointer page 43 of 175
07:24:37.60 process pointer page 44 of 175
07:24:38.04 process pointer page 45 of 175
07:24:38.43 process pointer page 46 of 175
07:24:38.79 process pointer page 47 of 175
07:24:39.21 process pointer page 48 of 175
07:24:39.58 process pointer page 49 of 175
07:24:39.93 process pointer page 50 of 175
07:24:40.29 process pointer page 51 of 175
07:24:40.74 process pointer page 52 of 175
07:24:41.17 process pointer page 53 of 175
07:24:41.61 process pointer page 54 of 175
07:24:42.00 process pointer page 55 of 175
07:24:42.41 process pointer page 56 of 175
07:24:42.73 process pointer page 57 of 175
07:24:43.14 process pointer page 58 of 175
07:24:43.55 process pointer page 59 of 175
07:24:43.86 process pointer page 60 of 175
07:24:44.26 process pointer page 61 of 175
07:24:44.67 process pointer page 62 of 175
07:24:45.07 process pointer page 63 of 175
07:24:45.53 process pointer page 64 of 175
07:24:45.92 process pointer page 65 of 175
07:24:46.37 process pointer page 66 of 175
07:24:46.82 process pointer page 67 of 175
07:24:47.26 process pointer page 68 of 175
07:24:47.68 process pointer page 69 of 175
07:24:48.05 process pointer page 70 of 175
07:24:48.48 process pointer page 71 of 175
07:24:48.90 process pointer page 72 of 175
07:24:49.26 process pointer page 73 of 175
07:24:49.66 process pointer page 74 of 175
07:24:50.00 process pointer page 75 of 175
07:24:50.44 process pointer page 76 of 175
07:24:50.86 process pointer page 77 of 175
07:24:51.22 process pointer page 78 of 175
07:24:51.60 process pointer page 79 of 175
07:24:52.05 process pointer page 80 of 175
07:24:52.50 process pointer page 81 of 175
07:24:52.91 process pointer page 82 of 175
07:24:53.34 process pointer page 83 of 175
07:24:53.80 process pointer page 84 of 175
07:24:54.22 process pointer page 85 of 175
07:24:54.64 process pointer page 86 of 175
07:24:55.09 process pointer page 87 of 175
07:24:55.54 process pointer page 88 of 175
07:24:55.92 process pointer page 89 of 175
07:24:56.26 process pointer page 90 of 175
07:24:56.68 process pointer page 91 of 175
07:24:57.07 process pointer page 92 of 175
07:24:57.49 process pointer page 93 of 175
07:24:57.82 process pointer page 94 of 175
07:24:58.21 process pointer page 95 of 175
07:24:58.65 process pointer page 96 of 175
07:24:59.01 process pointer page 97 of 175
07:24:59.44 process pointer page 98 of 175
07:24:59.85 process pointer page 99 of 175
07:25:00.28 process pointer page 100 of 175
07:25:00.71 process pointer page 101 of 175
07:25:01.03 process pointer page 102 of 175
07:25:01.41 process pointer page 103 of 175
07:25:01.81 process pointer page 104 of 175
07:25:02.16 process pointer page 105 of 175
07:25:02.61 process pointer page 106 of 175
07:25:03.00 process pointer page 107 of 175
07:25:03.39 process pointer page 108 of 175
07:25:03.81 process pointer page 109 of 175
07:25:04.15 process pointer page 110 of 175
07:25:04.61 process pointer page 111 of 175
07:25:04.95 process pointer page 112 of 175
07:25:05.12 process pointer page 113 of 175
07:25:05.31 process pointer page 114 of 175
07:25:05.51 process pointer page 115 of 175
07:25:05.74 process pointer page 116 of 175
07:25:05.95 process pointer page 117 of 175
07:25:06.13 process pointer page 118 of 175
07:25:06.34 process pointer page 119 of 175
07:25:06.60 process pointer page 120 of 175
07:25:06.85 process pointer page 121 of 175
07:25:07.07 process pointer page 122 of 175
07:25:07.35 process pointer page 123 of 175
07:25:07.59 process pointer page 124 of 175
07:25:07.80 process pointer page 125 of 175
07:25:07.96 process pointer page 126 of 175
07:25:08.15 process pointer page 127 of 175
07:25:08.37 process pointer page 128 of 175
07:25:08.58 process pointer page 129 of 175
07:25:08.80 process pointer page 130 of 175
07:25:09.02 process pointer page 131 of 175
07:25:09.22 process pointer page 132 of 175
07:25:09.49 process pointer page 133 of 175
07:25:09.69 process pointer page 134 of 175
07:25:09.93 process pointer page 135 of 175
07:25:10.10 process pointer page 136 of 175
07:25:10.32 process pointer page 137 of 175
07:25:10.53 process pointer page 138 of 175
07:25:10.77 process pointer page 139 of 175
07:25:10.99 process pointer page 140 of 175
07:25:11.14 process pointer page 141 of 175
07:25:11.28 process pointer page 142 of 175
07:25:11.50 process pointer page 143 of 175
07:25:11.74 process pointer page 144 of 175
07:25:12.02 process pointer page 145 of 175
07:25:12.23 process pointer page 146 of 175
07:25:12.53 process pointer page 147 of 175
07:25:12.78 process pointer page 148 of 175
07:25:12.94 process pointer page 149 of 175
07:25:13.06 process pointer page 150 of 175
07:25:13.23 process pointer page 151 of 175
07:25:13.47 process pointer page 152 of 175
07:25:13.78 process pointer page 153 of 175
07:25:14.01 process pointer page 154 of 175
07:25:14.18 process pointer page 155 of 175
07:25:14.37 process pointer page 156 of 175
07:25:14.62 process pointer page 157 of 175
07:25:14.90 process pointer page 158 of 175
07:25:15.17 process pointer page 159 of 175
07:25:15.45 process pointer page 160 of 175
07:25:15.70 process pointer page 161 of 175
07:25:15.90 process pointer page 162 of 175
07:25:16.09 process pointer page 163 of 175
07:25:16.18 process pointer page 164 of 175
07:25:16.37 process pointer page 165 of 175
07:25:16.54 process pointer page 166 of 175
07:25:16.76 process pointer page 167 of 175
07:25:16.98 process pointer page 168 of 175
07:25:17.23 process pointer page 169 of 175
07:25:17.38 process pointer page 170 of 175
07:25:17.55 process pointer page 171 of 175
07:25:17.77 process pointer page 172 of 175
07:25:17.98 process pointer page 173 of 175
07:25:18.15 process pointer page 174 of 175
07:25:18.16 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:25:22.30 Index 2 (PERF_LOG_UNIT)
07:25:27.09 Index 3 (PERF_LOG_TRN_DESC)
07:25:31.03 Index 4 (PERF_LOG_GDSCODE)
07:25:34.56 Relation 163 (PERF_LOG) is ok
07:25:34.57 Relation 167 (V_STOPTEST)
07:25:34.57 Relation 167 (V_STOPTEST) is ok
07:25:34.57 Relation 184 (V_QDISTR_SOURCE)
07:25:34.57 Relation 184 (V_QDISTR_SOURCE) is ok
07:25:34.57 Relation 185 (V_QSTORNED_SOURCE)
07:25:34.57 Relation 185 (V_QSTORNED_SOURCE) is ok
07:25:34.57 Relation 260 (XQD_1000_1200)
07:25:34.57 process pointer page 0 of 2
07:25:34.68 process pointer page 1 of 2
07:25:34.84 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:25:34.89 Relation 260 (XQD_1000_1200) is ok
07:25:34.89 Relation 261 (XQD_1200_2000)
07:25:34.89 process pointer page 0 of 3
07:25:35.18 process pointer page 1 of 3
07:25:35.21 process pointer page 2 of 3
07:25:35.35 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:25:35.42 Relation 261 (XQD_1200_2000) is ok
07:25:35.42 Relation 262 (XQD_1000_3300)
07:25:35.42 process pointer page 0 of 12
07:25:35.87 process pointer page 1 of 12
07:25:36.31 process pointer page 2 of 12
07:25:36.73 process pointer page 3 of 12
07:25:37.18 process pointer page 4 of 12
07:25:37.66 process pointer page 5 of 12
07:25:38.11 process pointer page 6 of 12
07:25:38.50 process pointer page 7 of 12
07:25:38.85 process pointer page 8 of 12
07:25:39.08 process pointer page 9 of 12
07:25:39.24 process pointer page 10 of 12
07:25:39.46 process pointer page 11 of 12
07:25:39.60 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:25:40.14 Index 2 (XQD_1000_3300_DOC)
07:25:40.69 Relation 262 (XQD_1000_3300) is ok
07:25:40.69 Relation 263 (XQD_2000_3300)
07:25:40.69 process pointer page 0 of 18
07:25:41.09 process pointer page 1 of 18
07:25:41.55 process pointer page 2 of 18
07:25:41.97 process pointer page 3 of 18
07:25:42.40 process pointer page 4 of 18
07:25:42.78 process pointer page 5 of 18
07:25:43.23 process pointer page 6 of 18
07:25:43.64 process pointer page 7 of 18
07:25:44.11 process pointer page 8 of 18
07:25:44.54 process pointer page 9 of 18
07:25:45.01 process pointer page 10 of 18
07:25:45.46 process pointer page 11 of 18
07:25:45.79 process pointer page 12 of 18
07:25:46.15 process pointer page 13 of 18
07:25:46.46 process pointer page 14 of 18
07:25:46.65 process pointer page 15 of 18
07:25:46.90 process pointer page 16 of 18
07:25:47.16 process pointer page 17 of 18
07:25:47.33 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:25:48.21 Relation 263 (XQD_2000_3300) is ok
07:25:48.21 Relation 264 (XQD_2100_3300)
07:25:48.21 process pointer page 0 of 3
07:25:48.38 process pointer page 1 of 3
07:25:48.47 process pointer page 2 of 3
07:25:48.47 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:25:48.50 Relation 264 (XQD_2100_3300) is ok
07:25:48.50 Relation 265 (XQD_3300_3400)
07:25:48.50 process pointer page 0 of 25
07:25:48.93 process pointer page 1 of 25
07:25:49.41 process pointer page 2 of 25
07:25:49.85 process pointer page 3 of 25
07:25:50.31 process pointer page 4 of 25
07:25:50.81 process pointer page 5 of 25
07:25:51.30 process pointer page 6 of 25
07:25:51.72 process pointer page 7 of 25
07:25:52.19 process pointer page 8 of 25
07:25:52.61 process pointer page 9 of 25
07:25:53.08 process pointer page 10 of 25
07:25:53.54 process pointer page 11 of 25
07:25:53.95 process pointer page 12 of 25
07:25:54.40 process pointer page 13 of 25
07:25:54.90 process pointer page 14 of 25
07:25:55.37 process pointer page 15 of 25
07:25:55.79 process pointer page 16 of 25
07:25:56.21 process pointer page 17 of 25
07:25:56.65 process pointer page 18 of 25
07:25:56.99 process pointer page 19 of 25
07:25:57.30 process pointer page 20 of 25
07:25:57.61 process pointer page 21 of 25
07:25:57.94 process pointer page 22 of 25
07:25:58.11 process pointer page 23 of 25
07:25:58.35 process pointer page 24 of 25
07:25:58.58 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:26:00.44 Relation 265 (XQD_3300_3400) is ok
07:26:00.44 Relation 266 (XQS_1000_1200)
07:26:00.44 process pointer page 0 of 47
07:26:00.92 process pointer page 1 of 47
07:26:01.37 process pointer page 2 of 47
07:26:01.81 process pointer page 3 of 47
07:26:02.17 process pointer page 4 of 47
07:26:02.61 process pointer page 5 of 47
07:26:03.03 process pointer page 6 of 47
07:26:03.48 process pointer page 7 of 47
07:26:03.93 process pointer page 8 of 47
07:26:04.35 process pointer page 9 of 47
07:26:04.79 process pointer page 10 of 47
07:26:05.20 process pointer page 11 of 47
07:26:05.63 process pointer page 12 of 47
07:26:06.05 process pointer page 13 of 47
07:26:06.51 process pointer page 14 of 47
07:26:06.97 process pointer page 15 of 47
07:26:07.44 process pointer page 16 of 47
07:26:07.93 process pointer page 17 of 47
07:26:08.32 process pointer page 18 of 47
07:26:08.80 process pointer page 19 of 47
07:26:09.21 process pointer page 20 of 47
07:26:09.64 process pointer page 21 of 47
07:26:10.09 process pointer page 22 of 47
07:26:10.53 process pointer page 23 of 47
07:26:11.02 process pointer page 24 of 47
07:26:11.41 process pointer page 25 of 47
07:26:11.90 process pointer page 26 of 47
07:26:12.28 process pointer page 27 of 47
07:26:12.75 process pointer page 28 of 47
07:26:13.18 process pointer page 29 of 47
07:26:13.65 process pointer page 30 of 47
07:26:14.14 process pointer page 31 of 47
07:26:14.59 process pointer page 32 of 47
07:26:15.06 process pointer page 33 of 47
07:26:15.55 process pointer page 34 of 47
07:26:15.94 process pointer page 35 of 47
07:26:16.23 process pointer page 36 of 47
07:26:16.57 process pointer page 37 of 47
07:26:16.85 process pointer page 38 of 47
07:26:17.18 process pointer page 39 of 47
07:26:17.44 process pointer page 40 of 47
07:26:17.77 process pointer page 41 of 47
07:26:18.07 process pointer page 42 of 47
07:26:18.38 process pointer page 43 of 47
07:26:18.67 process pointer page 44 of 47
07:26:19.00 process pointer page 45 of 47
07:26:19.27 process pointer page 46 of 47
07:26:19.49 Index 1 (XQS_1000_1200_DOC_ID)
07:26:21.31 Index 2 (XQS_1000_1200_SND_ID)
07:26:23.17 Index 3 (XQS_1000_1200_RCV_ID)
07:26:25.10 Relation 266 (XQS_1000_1200) is ok
07:26:25.10 Relation 267 (XQS_1200_2000)
07:26:25.10 process pointer page 0 of 51
07:26:25.46 process pointer page 1 of 51
07:26:25.90 process pointer page 2 of 51
07:26:26.27 process pointer page 3 of 51
07:26:26.69 process pointer page 4 of 51
07:26:27.05 process pointer page 5 of 51
07:26:27.40 process pointer page 6 of 51
07:26:27.82 process pointer page 7 of 51
07:26:28.24 process pointer page 8 of 51
07:26:28.67 process pointer page 9 of 51
07:26:29.10 process pointer page 10 of 51
07:26:29.45 process pointer page 11 of 51
07:26:29.88 process pointer page 12 of 51
07:26:30.31 process pointer page 13 of 51
07:26:30.78 process pointer page 14 of 51
07:26:31.22 process pointer page 15 of 51
07:26:31.67 process pointer page 16 of 51
07:26:32.14 process pointer page 17 of 51
07:26:32.59 process pointer page 18 of 51
07:26:33.06 process pointer page 19 of 51
07:26:33.45 process pointer page 20 of 51
07:26:33.93 process pointer page 21 of 51
07:26:34.29 process pointer page 22 of 51
07:26:34.74 process pointer page 23 of 51
07:26:35.23 process pointer page 24 of 51
07:26:35.66 process pointer page 25 of 51
07:26:36.13 process pointer page 26 of 51
07:26:36.58 process pointer page 27 of 51
07:26:37.05 process pointer page 28 of 51
07:26:37.49 process pointer page 29 of 51
07:26:37.94 process pointer page 30 of 51
07:26:38.32 process pointer page 31 of 51
07:26:38.75 process pointer page 32 of 51
07:26:39.22 process pointer page 33 of 51
07:26:39.61 process pointer page 34 of 51
07:26:40.11 process pointer page 35 of 51
07:26:40.55 process pointer page 36 of 51
07:26:41.00 process pointer page 37 of 51
07:26:41.44 process pointer page 38 of 51
07:26:41.87 process pointer page 39 of 51
07:26:42.34 process pointer page 40 of 51
07:26:42.73 process pointer page 41 of 51
07:26:43.21 process pointer page 42 of 51
07:26:43.60 process pointer page 43 of 51
07:26:44.07 process pointer page 44 of 51
07:26:44.54 process pointer page 45 of 51
07:26:44.93 process pointer page 46 of 51
07:26:45.38 process pointer page 47 of 51
07:26:45.79 process pointer page 48 of 51
07:26:46.22 process pointer page 49 of 51
07:26:46.61 process pointer page 50 of 51
07:26:46.75 Index 1 (XQS_1200_2000_DOC_ID)
07:26:48.94 Index 2 (XQS_1200_2000_SND_ID)
07:26:51.04 Index 3 (XQS_1200_2000_RCV_ID)
07:26:53.53 Relation 267 (XQS_1200_2000) is ok
07:26:53.53 Relation 268 (XQS_1000_3300)
07:26:53.53 process pointer page 0 of 25
07:26:53.87 process pointer page 1 of 25
07:26:54.35 process pointer page 2 of 25
07:26:54.79 process pointer page 3 of 25
07:26:55.27 process pointer page 4 of 25
07:26:55.72 process pointer page 5 of 25
07:26:56.18 process pointer page 6 of 25
07:26:56.65 process pointer page 7 of 25
07:26:57.13 process pointer page 8 of 25
07:26:57.61 process pointer page 9 of 25
07:26:58.03 process pointer page 10 of 25
07:26:58.52 process pointer page 11 of 25
07:26:58.91 process pointer page 12 of 25
07:26:59.39 process pointer page 13 of 25
07:26:59.84 process pointer page 14 of 25
07:27:00.31 process pointer page 15 of 25
07:27:00.78 process pointer page 16 of 25
07:27:01.23 process pointer page 17 of 25
07:27:01.72 process pointer page 18 of 25
07:27:02.15 process pointer page 19 of 25
07:27:02.64 process pointer page 20 of 25
07:27:03.04 process pointer page 21 of 25
07:27:03.51 process pointer page 22 of 25
07:27:03.98 process pointer page 23 of 25
07:27:04.40 process pointer page 24 of 25
07:27:04.41 Index 1 (XQS_1000_3300_DOC_ID)
07:27:05.60 Index 2 (XQS_1000_3300_SND_ID)
07:27:06.83 Index 3 (XQS_1000_3300_RCV_ID)
07:27:08.30 Relation 268 (XQS_1000_3300) is ok
07:27:08.30 Relation 269 (XQS_2000_3300)
07:27:08.30 process pointer page 0 of 1
07:27:08.30 Index 1 (XQS_2000_3300_DOC_ID)
07:27:08.30 Index 2 (XQS_2000_3300_SND_ID)
07:27:08.30 Index 3 (XQS_2000_3300_RCV_ID)
07:27:08.30 Relation 269 (XQS_2000_3300) is ok
07:27:08.30 Relation 270 (XQS_2100_3300)
07:27:08.30 process pointer page 0 of 34
07:27:08.72 process pointer page 1 of 34
07:27:09.14 process pointer page 2 of 34
07:27:09.61 process pointer page 3 of 34
07:27:10.05 process pointer page 4 of 34
07:27:10.51 process pointer page 5 of 34
07:27:10.95 process pointer page 6 of 34
07:27:11.34 process pointer page 7 of 34
07:27:11.82 process pointer page 8 of 34
07:27:12.28 process pointer page 9 of 34
07:27:12.76 process pointer page 10 of 34
07:27:13.23 process pointer page 11 of 34
07:27:13.66 process pointer page 12 of 34
07:27:14.10 process pointer page 13 of 34
07:27:14.49 process pointer page 14 of 34
07:27:14.94 process pointer page 15 of 34
07:27:15.40 process pointer page 16 of 34
07:27:15.86 process pointer page 17 of 34
07:27:16.24 process pointer page 18 of 34
07:27:16.68 process pointer page 19 of 34
07:27:17.08 process pointer page 20 of 34
07:27:17.52 process pointer page 21 of 34
07:27:17.97 process pointer page 22 of 34
07:27:18.33 process pointer page 23 of 34
07:27:18.78 process pointer page 24 of 34
07:27:19.17 process pointer page 25 of 34
07:27:19.62 process pointer page 26 of 34
07:27:20.05 process pointer page 27 of 34
07:27:20.45 process pointer page 28 of 34
07:27:20.89 process pointer page 29 of 34
07:27:21.29 process pointer page 30 of 34
07:27:21.70 process pointer page 31 of 34
07:27:22.12 process pointer page 32 of 34
07:27:22.54 process pointer page 33 of 34
07:27:22.82 Index 1 (XQS_2100_3300_DOC_ID)
07:27:24.32 Index 2 (XQS_2100_3300_SND_ID)
07:27:25.88 Index 3 (XQS_2100_3300_RCV_ID)
07:27:27.85 Relation 270 (XQS_2100_3300) is ok
07:27:27.85 Relation 271 (XQS_3300_3400)
07:27:27.85 process pointer page 0 of 6
07:27:28.24 process pointer page 1 of 6
07:27:28.66 process pointer page 2 of 6
07:27:29.11 process pointer page 3 of 6
07:27:29.50 process pointer page 4 of 6
07:27:29.92 process pointer page 5 of 6
07:27:30.15 Index 1 (XQS_3300_3400_DOC_ID)
07:27:30.53 Index 2 (XQS_3300_3400_SND_ID)
07:27:30.95 Relation 271 (XQS_3300_3400) is ok
07:27:31.00 Validation finished
Done for 181120 ms, from 7:24:30.02 to 7:27:31.14.
Differences between old and current firebird.log
7:27:32.67. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-04-11 07:27 471 oltp30_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Tue Apr 11 07:24:30 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Tue Apr 11 07:27:30 2017
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-04-11 7:27:37.50 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html