Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-07-01 6:49:34.37.
Server version: WI-V3.0.3.32741 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-07-01 06:46:32.1220 |
-1 |
<null> |
|
::1/61506 |
413511 |
9255 |
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: |
5650.98 |
2581 |
1017177 |
2017-07-01 03:46 |
2017-07-01 06:46 |
customer order: creation |
418.66 |
417 |
75358 |
2017-07-01 03:46 |
2017-07-01 06:46 |
customer order: refuse |
34.11 |
215 |
6139 |
2017-07-01 03:46 |
2017-07-01 06:46 |
order to supplier: creation |
108.02 |
1804 |
19444 |
2017-07-01 03:46 |
2017-07-01 06:46 |
order to supplier: removal |
2.88 |
15618 |
518 |
2017-07-01 03:46 |
2017-07-01 06:46 |
invoice (draft): creation |
107.07 |
2571 |
19273 |
2017-07-01 03:46 |
2017-07-01 06:46 |
invoice (draft): removal |
39.84 |
341 |
7172 |
2017-07-01 03:46 |
2017-07-01 06:46 |
invoice accept: apply |
58.70 |
8785 |
10566 |
2017-07-01 03:46 |
2017-07-01 06:46 |
invoice accept: cancel |
18.18 |
2129 |
3273 |
2017-07-01 03:46 |
2017-07-01 06:46 |
customer reserve: creation |
3207.87 |
130 |
577416 |
2017-07-01 03:46 |
2017-07-01 06:46 |
customer reserve: removal |
1077.56 |
50 |
193960 |
2017-07-01 03:46 |
2017-07-01 06:46 |
realization accept: apply |
190.94 |
475 |
34370 |
2017-07-01 03:46 |
2017-07-01 06:46 |
realization accept: cancel |
86.35 |
131 |
15543 |
2017-07-01 03:46 |
2017-07-01 06:46 |
payment from customer: creation |
139.68 |
804 |
25142 |
2017-07-01 03:46 |
2017-07-01 06:46 |
payment from customer: removal |
12.93 |
119 |
2328 |
2017-07-01 03:46 |
2017-07-01 06:46 |
payment to supplier: creation |
115.86 |
442 |
20854 |
2017-07-01 03:46 |
2017-07-01 06:46 |
payment to supplier: removal |
8.31 |
129 |
1496 |
2017-07-01 03:46 |
2017-07-01 06:46 |
service: total inventory turnovers |
9.54 |
2098 |
1717 |
2017-07-01 03:46 |
2017-07-01 06:46 |
service: total monetary turnovers |
14.43 |
63 |
2597 |
2017-07-01 03:46 |
2017-07-01 06:46 |
service: refresh index statistics |
0.07 |
12711 |
11 |
2017-07-01 03:46 |
2017-07-01 06:46 |
Done for 59670 ms, from 6:51:32.61 to 6:52:32.28.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
4330 |
92477 |
77941 |
14536 |
15.72 |
03:46:33 |
04:04:33 |
interval # 2, overall |
2 |
6169 |
123537 |
111044 |
12493 |
10.11 |
04:04:34 |
04:22:34 |
interval # 3, overall |
3 |
5902 |
120296 |
106243 |
14053 |
11.68 |
04:22:35 |
04:40:35 |
interval # 4, overall |
4 |
5583 |
117571 |
100491 |
17080 |
14.53 |
04:40:36 |
04:58:36 |
interval # 5, overall |
5 |
5756 |
121446 |
103608 |
17838 |
14.69 |
04:58:37 |
05:16:37 |
interval # 6, overall |
6 |
5361 |
110799 |
96490 |
14309 |
12.91 |
05:16:38 |
05:34:38 |
interval # 7, overall |
7 |
6076 |
127216 |
109371 |
17845 |
14.03 |
05:34:39 |
05:52:39 |
interval # 8, overall |
8 |
6156 |
128070 |
110806 |
17264 |
13.48 |
05:52:40 |
06:10:40 |
interval # 9, overall |
9 |
5742 |
120348 |
103362 |
16986 |
14.11 |
06:10:41 |
06:28:41 |
interval # 10, overall |
10 |
5435 |
107220 |
97821 |
9399 |
8.77 |
06:28:42 |
06:46:42 |
Done for 160580 ms, from 6:55:23.10 to 6:58:03.68.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
2473.65 |
0.3407 |
1.5475 |
1394 |
99 |
TEST_TIME |
2 |
2706.39 |
0.7072 |
1.2710 |
1793 |
99 |
TEST_TIME |
3 |
2920.10 |
0.7853 |
1.3397 |
1492 |
99 |
TEST_TIME |
4 |
3278.64 |
0.8951 |
1.1126 |
1281 |
99 |
TEST_TIME |
5 |
3182.31 |
0.9174 |
1.0952 |
1129 |
99 |
TEST_TIME |
6 |
3175.89 |
0.9191 |
1.0879 |
1463 |
99 |
TEST_TIME |
7 |
3201.33 |
0.9252 |
1.0961 |
1439 |
99 |
TEST_TIME |
8 |
3335.23 |
0.9207 |
1.0833 |
1724 |
99 |
TEST_TIME |
9 |
3432.83 |
0.9357 |
1.0742 |
1793 |
99 |
TEST_TIME |
10 |
3567.28 |
0.9303 |
1.0611 |
1389 |
99 |
TEST_TIME |
11 |
3641.20 |
0.9459 |
1.0683 |
1440 |
99 |
TEST_TIME |
12 |
3735.59 |
0.9546 |
1.0663 |
1350 |
99 |
TEST_TIME |
13 |
3817.60 |
0.9631 |
1.0376 |
1189 |
99 |
TEST_TIME |
14 |
3841.64 |
0.9575 |
1.0397 |
1229 |
99 |
TEST_TIME |
15 |
3939.91 |
0.9522 |
1.0522 |
1544 |
99 |
TEST_TIME |
16 |
4113.21 |
0.9448 |
1.0471 |
2050 |
99 |
TEST_TIME |
17 |
4231.97 |
0.9585 |
1.0485 |
1538 |
99 |
TEST_TIME |
18 |
4311.88 |
0.9719 |
1.0331 |
1532 |
99 |
TEST_TIME |
19 |
4362.31 |
0.9674 |
1.0276 |
1553 |
99 |
TEST_TIME |
20 |
4336.70 |
0.9820 |
1.0287 |
1406 |
99 |
TEST_TIME |
21 |
4332.16 |
0.9846 |
1.0269 |
1322 |
98 |
TEST_TIME |
22 |
4361.92 |
0.9736 |
1.0234 |
1326 |
99 |
TEST_TIME |
23 |
4410.11 |
0.9690 |
1.0284 |
1684 |
99 |
TEST_TIME |
24 |
4450.98 |
0.9765 |
1.0246 |
1506 |
99 |
TEST_TIME |
25 |
4484.05 |
0.9764 |
1.0280 |
1468 |
99 |
TEST_TIME |
26 |
4572.05 |
0.9700 |
1.0300 |
1478 |
99 |
TEST_TIME |
27 |
4615.35 |
0.9825 |
1.0189 |
1070 |
99 |
TEST_TIME |
28 |
4642.24 |
0.9771 |
1.0222 |
1371 |
99 |
TEST_TIME |
29 |
4681.86 |
0.9787 |
1.0236 |
1375 |
99 |
TEST_TIME |
30 |
4753.00 |
0.9747 |
1.0252 |
2043 |
99 |
TEST_TIME |
31 |
4864.30 |
0.9694 |
1.0300 |
2113 |
99 |
TEST_TIME |
32 |
5001.24 |
0.9705 |
1.0243 |
1772 |
99 |
TEST_TIME |
33 |
5079.79 |
0.9779 |
1.0217 |
1843 |
99 |
TEST_TIME |
34 |
5142.24 |
0.9796 |
1.0200 |
1522 |
99 |
TEST_TIME |
35 |
5170.07 |
0.9855 |
1.0186 |
1245 |
99 |
TEST_TIME |
36 |
5208.01 |
0.9831 |
1.0190 |
1189 |
99 |
TEST_TIME |
37 |
5246.42 |
0.9848 |
1.0110 |
1207 |
99 |
TEST_TIME |
38 |
5249.69 |
0.9869 |
1.0137 |
1225 |
99 |
TEST_TIME |
39 |
5246.20 |
0.9884 |
1.0087 |
1217 |
99 |
TEST_TIME |
40 |
5215.85 |
0.9936 |
1.0055 |
1232 |
97 |
TEST_TIME |
41 |
5191.17 |
0.9923 |
1.0059 |
1188 |
95 |
TEST_TIME |
42 |
5173.64 |
0.9929 |
1.0050 |
1129 |
98 |
TEST_TIME |
43 |
5129.16 |
0.9902 |
1.0091 |
1029 |
99 |
TEST_TIME |
44 |
5122.13 |
0.9876 |
1.0131 |
1209 |
99 |
TEST_TIME |
45 |
5151.21 |
0.9856 |
1.0164 |
1863 |
99 |
TEST_TIME |
46 |
5221.90 |
0.9808 |
1.0149 |
2044 |
99 |
TEST_TIME |
47 |
5269.00 |
0.9845 |
1.0154 |
1986 |
99 |
TEST_TIME |
48 |
5310.13 |
0.9870 |
1.0170 |
1636 |
99 |
TEST_TIME |
49 |
5354.68 |
0.9879 |
1.0116 |
1395 |
99 |
TEST_TIME |
50 |
5378.77 |
0.9869 |
1.0123 |
1577 |
99 |
TEST_TIME |
51 |
5408.31 |
0.9872 |
1.0106 |
1357 |
99 |
TEST_TIME |
52 |
5433.99 |
0.9865 |
1.0114 |
1502 |
99 |
TEST_TIME |
53 |
5447.75 |
0.9901 |
1.0107 |
1344 |
99 |
TEST_TIME |
54 |
5452.11 |
0.9912 |
1.0090 |
1261 |
99 |
TEST_TIME |
55 |
5450.63 |
0.9909 |
1.0124 |
1316 |
99 |
TEST_TIME |
56 |
5472.31 |
0.9904 |
1.0108 |
1223 |
99 |
TEST_TIME |
57 |
5482.99 |
0.9911 |
1.0101 |
1168 |
99 |
TEST_TIME |
58 |
5502.66 |
0.9895 |
1.0090 |
1174 |
99 |
TEST_TIME |
59 |
5492.51 |
0.9938 |
1.0070 |
1173 |
99 |
TEST_TIME |
60 |
5484.70 |
0.9916 |
1.0083 |
1561 |
99 |
TEST_TIME |
61 |
5485.66 |
0.9916 |
1.0082 |
1943 |
99 |
TEST_TIME |
62 |
5484.07 |
0.9922 |
1.0073 |
1631 |
97 |
TEST_TIME |
63 |
5493.10 |
0.9898 |
1.0075 |
1378 |
99 |
TEST_TIME |
64 |
5481.13 |
0.9939 |
1.0036 |
1711 |
99 |
TEST_TIME |
65 |
5438.12 |
0.9960 |
1.0048 |
1521 |
80 |
TEST_TIME |
66 |
5428.67 |
0.9913 |
1.0127 |
1128 |
98 |
TEST_TIME |
67 |
5441.91 |
0.9952 |
1.0063 |
1293 |
99 |
TEST_TIME |
68 |
5437.21 |
0.9923 |
1.0113 |
1431 |
99 |
TEST_TIME |
69 |
5466.89 |
0.9913 |
1.0087 |
1439 |
99 |
TEST_TIME |
70 |
5480.62 |
0.9919 |
1.0087 |
1492 |
99 |
TEST_TIME |
71 |
5488.48 |
0.9931 |
1.0045 |
1557 |
99 |
TEST_TIME |
72 |
5488.26 |
0.9909 |
1.0060 |
1302 |
99 |
TEST_TIME |
73 |
5490.11 |
0.9921 |
1.0065 |
1383 |
99 |
TEST_TIME |
74 |
5507.76 |
0.9897 |
1.0073 |
1336 |
99 |
TEST_TIME |
75 |
5521.44 |
0.9914 |
1.0100 |
1869 |
99 |
TEST_TIME |
76 |
5549.80 |
0.9916 |
1.0094 |
1976 |
99 |
TEST_TIME |
77 |
5562.34 |
0.9940 |
1.0091 |
1610 |
99 |
TEST_TIME |
78 |
5595.06 |
0.9904 |
1.0064 |
1443 |
99 |
TEST_TIME |
79 |
5599.05 |
0.9930 |
1.0073 |
1592 |
99 |
TEST_TIME |
80 |
5594.14 |
0.9956 |
1.0039 |
1639 |
98 |
TEST_TIME |
81 |
5570.59 |
0.9957 |
1.0064 |
1393 |
99 |
TEST_TIME |
82 |
5563.74 |
0.9953 |
1.0059 |
1268 |
99 |
TEST_TIME |
83 |
5555.64 |
0.9952 |
1.0023 |
1409 |
98 |
TEST_TIME |
84 |
5526.47 |
0.9955 |
1.0045 |
1500 |
92 |
TEST_TIME |
85 |
5523.60 |
0.9932 |
1.0066 |
1397 |
97 |
TEST_TIME |
86 |
5510.67 |
0.9972 |
1.0055 |
1061 |
98 |
TEST_TIME |
87 |
5499.22 |
0.9960 |
1.0058 |
1273 |
99 |
TEST_TIME |
88 |
5503.30 |
0.9937 |
1.0063 |
1294 |
99 |
TEST_TIME |
89 |
5509.54 |
0.9939 |
1.0051 |
1248 |
99 |
TEST_TIME |
90 |
5530.43 |
0.9903 |
1.0103 |
1577 |
99 |
TEST_TIME |
91 |
5567.15 |
0.9926 |
1.0066 |
1681 |
99 |
TEST_TIME |
92 |
5567.22 |
0.9957 |
1.0049 |
1971 |
98 |
TEST_TIME |
93 |
5566.71 |
0.9942 |
1.0057 |
1707 |
97 |
TEST_TIME |
94 |
5585.81 |
0.9953 |
1.0067 |
1570 |
99 |
TEST_TIME |
95 |
5603.22 |
0.9931 |
1.0064 |
1499 |
99 |
TEST_TIME |
96 |
5624.54 |
0.9929 |
1.0050 |
1489 |
99 |
TEST_TIME |
97 |
5607.55 |
0.9977 |
1.0056 |
1514 |
94 |
TEST_TIME |
98 |
5618.32 |
0.9935 |
1.0035 |
1236 |
99 |
TEST_TIME |
99 |
5611.04 |
0.9954 |
1.0047 |
1291 |
98 |
TEST_TIME |
100 |
5605.05 |
0.9958 |
1.0042 |
1227 |
99 |
TEST_TIME |
101 |
5601.93 |
0.9948 |
1.0032 |
1207 |
98 |
TEST_TIME |
102 |
5582.70 |
0.9968 |
1.0017 |
1063 |
99 |
TEST_TIME |
103 |
5560.83 |
0.9963 |
1.0009 |
891 |
93 |
TEST_TIME |
104 |
5520.09 |
0.9986 |
1.0012 |
794 |
68 |
TEST_TIME |
105 |
5508.48 |
0.9983 |
1.0022 |
1271 |
92 |
TEST_TIME |
106 |
5499.19 |
0.9944 |
1.0063 |
1591 |
98 |
TEST_TIME |
107 |
5501.97 |
0.9964 |
1.0040 |
1749 |
97 |
TEST_TIME |
108 |
5500.57 |
0.9950 |
1.0051 |
1282 |
99 |
TEST_TIME |
109 |
5498.84 |
0.9962 |
1.0027 |
1470 |
97 |
TEST_TIME |
110 |
5489.08 |
0.9954 |
1.0049 |
1576 |
98 |
TEST_TIME |
111 |
5507.64 |
0.9925 |
1.0026 |
1333 |
98 |
TEST_TIME |
112 |
5507.86 |
0.9936 |
1.0057 |
1271 |
98 |
TEST_TIME |
113 |
5517.07 |
0.9951 |
1.0043 |
1280 |
99 |
TEST_TIME |
114 |
5518.40 |
0.9952 |
1.0051 |
1297 |
99 |
TEST_TIME |
115 |
5526.26 |
0.9950 |
1.0066 |
1233 |
99 |
TEST_TIME |
116 |
5539.10 |
0.9957 |
1.0025 |
1232 |
99 |
TEST_TIME |
117 |
5533.97 |
0.9958 |
1.0045 |
1222 |
99 |
TEST_TIME |
118 |
5542.23 |
0.9945 |
1.0066 |
1079 |
99 |
TEST_TIME |
119 |
5556.23 |
0.9956 |
1.0048 |
1010 |
99 |
TEST_TIME |
120 |
5563.46 |
0.9952 |
1.0047 |
1834 |
99 |
TEST_TIME |
121 |
5567.00 |
0.9958 |
1.0049 |
1767 |
99 |
TEST_TIME |
122 |
5570.97 |
0.9959 |
1.0044 |
1602 |
99 |
TEST_TIME |
123 |
5586.57 |
0.9935 |
1.0035 |
1448 |
99 |
TEST_TIME |
124 |
5576.31 |
0.9972 |
1.0031 |
1399 |
91 |
TEST_TIME |
125 |
5569.41 |
0.9963 |
1.0039 |
1350 |
90 |
TEST_TIME |
126 |
5580.50 |
0.9939 |
1.0037 |
1402 |
96 |
TEST_TIME |
127 |
5570.60 |
0.9975 |
1.0054 |
1287 |
92 |
TEST_TIME |
128 |
5577.17 |
0.9964 |
1.0038 |
919 |
99 |
TEST_TIME |
129 |
5584.39 |
0.9948 |
1.0049 |
1223 |
99 |
TEST_TIME |
130 |
5598.92 |
0.9946 |
1.0028 |
1260 |
99 |
TEST_TIME |
131 |
5585.79 |
0.9975 |
1.0056 |
1205 |
98 |
TEST_TIME |
132 |
5596.39 |
0.9961 |
1.0044 |
1180 |
99 |
TEST_TIME |
133 |
5600.87 |
0.9961 |
1.0053 |
1177 |
99 |
TEST_TIME |
134 |
5609.49 |
0.9963 |
1.0058 |
1128 |
99 |
TEST_TIME |
135 |
5629.55 |
0.9948 |
1.0071 |
1414 |
99 |
TEST_TIME |
136 |
5655.56 |
0.9951 |
1.0043 |
1395 |
99 |
TEST_TIME |
137 |
5670.33 |
0.9944 |
1.0031 |
1740 |
98 |
TEST_TIME |
138 |
5666.70 |
0.9969 |
1.0023 |
1597 |
99 |
TEST_TIME |
139 |
5662.25 |
0.9959 |
1.0024 |
1553 |
96 |
TEST_TIME |
140 |
5665.67 |
0.9947 |
1.0046 |
1322 |
97 |
TEST_TIME |
141 |
5665.70 |
0.9984 |
1.0020 |
1540 |
94 |
TEST_TIME |
142 |
5669.76 |
0.9943 |
1.0042 |
1260 |
96 |
TEST_TIME |
143 |
5662.96 |
0.9984 |
1.0020 |
1247 |
96 |
TEST_TIME |
144 |
5654.88 |
0.9965 |
1.0039 |
1166 |
99 |
TEST_TIME |
145 |
5653.82 |
0.9972 |
1.0021 |
1310 |
99 |
TEST_TIME |
146 |
5650.00 |
0.9959 |
1.0030 |
1226 |
99 |
TEST_TIME |
147 |
5655.66 |
0.9965 |
1.0016 |
1220 |
99 |
TEST_TIME |
148 |
5640.76 |
0.9975 |
1.0029 |
1294 |
93 |
TEST_TIME |
149 |
5643.09 |
0.9957 |
1.0037 |
1053 |
97 |
TEST_TIME |
150 |
5633.42 |
0.9987 |
1.0015 |
1485 |
95 |
TEST_TIME |
151 |
5629.76 |
0.9955 |
1.0032 |
1511 |
96 |
TEST_TIME |
152 |
5626.06 |
0.9971 |
1.0028 |
1288 |
98 |
TEST_TIME |
153 |
5621.96 |
0.9969 |
1.0032 |
1083 |
98 |
TEST_TIME |
154 |
5621.87 |
0.9967 |
1.0030 |
1205 |
99 |
TEST_TIME |
155 |
5620.61 |
0.9968 |
1.0032 |
1346 |
99 |
TEST_TIME |
156 |
5623.46 |
0.9972 |
1.0033 |
1114 |
99 |
TEST_TIME |
157 |
5628.61 |
0.9962 |
1.0053 |
1464 |
99 |
TEST_TIME |
158 |
5643.83 |
0.9963 |
1.0037 |
1424 |
99 |
TEST_TIME |
159 |
5640.39 |
0.9980 |
1.0037 |
1303 |
99 |
TEST_TIME |
160 |
5654.13 |
0.9950 |
1.0038 |
1197 |
99 |
TEST_TIME |
161 |
5663.83 |
0.9958 |
1.0041 |
1174 |
99 |
TEST_TIME |
162 |
5668.26 |
0.9971 |
1.0023 |
1287 |
99 |
TEST_TIME |
163 |
5667.80 |
0.9963 |
1.0037 |
1236 |
99 |
TEST_TIME |
164 |
5667.74 |
0.9976 |
1.0014 |
1088 |
98 |
TEST_TIME |
165 |
5662.91 |
0.9962 |
1.0048 |
1108 |
99 |
TEST_TIME |
166 |
5668.36 |
0.9978 |
1.0034 |
1740 |
97 |
TEST_TIME |
167 |
5669.79 |
0.9971 |
1.0027 |
1519 |
93 |
TEST_TIME |
168 |
5677.41 |
0.9954 |
1.0021 |
1442 |
96 |
TEST_TIME |
169 |
5666.87 |
0.9980 |
1.0026 |
1475 |
94 |
TEST_TIME |
170 |
5670.34 |
0.9961 |
1.0051 |
1195 |
86 |
TEST_TIME |
171 |
5687.97 |
0.9961 |
1.0025 |
1149 |
98 |
TEST_TIME |
172 |
5676.91 |
0.9986 |
1.0011 |
1158 |
98 |
TEST_TIME |
173 |
5680.59 |
0.9962 |
1.0014 |
1281 |
96 |
TEST_TIME |
174 |
5666.64 |
0.9980 |
1.0023 |
1221 |
91 |
TEST_TIME |
175 |
5665.56 |
0.9968 |
1.0046 |
1217 |
97 |
TEST_TIME |
176 |
5670.31 |
0.9981 |
1.0035 |
1243 |
99 |
TEST_TIME |
177 |
5669.59 |
0.9982 |
1.0012 |
1267 |
99 |
TEST_TIME |
178 |
5665.93 |
0.9963 |
1.0015 |
1186 |
99 |
TEST_TIME |
179 |
5653.80 |
0.9980 |
1.0024 |
1217 |
91 |
TEST_TIME |
180 |
5642.28 |
0.9988 |
1.0015 |
727 |
95 |
Done for 8560 ms, from 6:58:05.04 to 6:58:13.60.
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 |
61742 |
110770 |
54009 |
<null> |
54657 |
<null> |
69009 |
102467 |
59935 |
25390 |
64932 |
42383 |
76682 |
73627 |
152430 |
80111 |
107077 |
297071 |
<null> |
03:46:33 |
04:04:33 |
fetches per second |
2 |
52733 |
67837 |
54554 |
<null> |
48025 |
5740 |
83108 |
94353 |
53877 |
85220 |
54481 |
31352 |
91364 |
63629 |
127037 |
46256 |
122862 |
270905 |
<null> |
04:04:34 |
04:22:34 |
fetches per second |
3 |
49153 |
66106 |
30148 |
<null> |
27773 |
<null> |
75968 |
29895 |
69903 |
29623 |
64721 |
5819 |
54383 |
<null> |
83649 |
34094 |
231080 |
148972 |
<null> |
04:22:35 |
04:40:35 |
fetches per second |
4 |
23010 |
41440 |
25143 |
9754 |
20262 |
<null> |
72074 |
42372 |
97057 |
1901 |
38298 |
36955 |
60763 |
4221 |
98730 |
62987 |
203194 |
52363 |
<null> |
04:40:36 |
04:58:36 |
fetches per second |
5 |
38531 |
47467 |
42109 |
<null> |
18860 |
<null> |
48583 |
28384 |
19170 |
41307 |
43027 |
17879 |
48590 |
27266 |
82523 |
565 |
234841 |
52352 |
<null> |
04:58:37 |
05:16:37 |
fetches per second |
6 |
15495 |
5444 |
15121 |
<null> |
19931 |
34573 |
7766 |
17503 |
3429 |
3374 |
18225 |
1782 |
23587 |
84215 |
25672 |
3136 |
<null> |
45703 |
<null> |
05:16:38 |
05:34:38 |
fetches per second |
7 |
31589 |
54478 |
33561 |
59033 |
23465 |
111315 |
65073 |
38586 |
27641 |
12014 |
41145 |
31829 |
27492 |
15370 |
48110 |
51642 |
125422 |
209844 |
<null> |
05:34:39 |
05:52:39 |
fetches per second |
8 |
26640 |
115224 |
23833 |
<null> |
20367 |
84980 |
54626 |
<null> |
108499 |
19447 |
22826 |
25010 |
47770 |
52620 |
40973 |
3174 |
48819 |
60487 |
<null> |
05:52:40 |
06:10:40 |
fetches per second |
9 |
22316 |
23582 |
16577 |
<null> |
38263 |
<null> |
57826 |
<null> |
81100 |
50209 |
38662 |
45870 |
43066 |
1411 |
53964 |
<null> |
14215 |
58286 |
<null> |
06:10:41 |
06:28:41 |
fetches per second |
10 |
11186 |
22477 |
3554 |
<null> |
22076 |
<null> |
23208 |
6175 |
39600 |
10476 |
14013 |
2657 |
18536 |
1357 |
28396 |
4420 |
13981 |
70992 |
<null> |
06:28:42 |
06:46:42 |
marks per second |
1 |
12946 |
15515 |
12030 |
<null> |
12035 |
<null> |
9045 |
17621 |
7189 |
5879 |
8722 |
7444 |
5782 |
12891 |
5314 |
14595 |
10701 |
25771 |
<null> |
03:46:33 |
04:04:33 |
marks per second |
2 |
11334 |
8855 |
12598 |
<null> |
10379 |
945 |
10797 |
14937 |
11308 |
15957 |
8617 |
4950 |
7961 |
11665 |
5360 |
6657 |
25402 |
40548 |
<null> |
04:04:34 |
04:22:34 |
marks per second |
3 |
10205 |
8216 |
6778 |
<null> |
6304 |
<null> |
8968 |
4292 |
10001 |
6273 |
9064 |
1152 |
3709 |
<null> |
7220 |
4821 |
30349 |
23806 |
<null> |
04:22:35 |
04:40:35 |
marks per second |
4 |
4972 |
5574 |
5372 |
1694 |
4417 |
<null> |
8405 |
6216 |
7801 |
260 |
5121 |
6339 |
4246 |
661 |
7029 |
11231 |
28313 |
1163 |
<null> |
04:40:36 |
04:58:36 |
marks per second |
5 |
8019 |
5112 |
9074 |
<null> |
4089 |
<null> |
6370 |
4044 |
2084 |
6461 |
5861 |
2855 |
2847 |
4240 |
10510 |
93 |
23164 |
971 |
<null> |
04:58:37 |
05:16:37 |
marks per second |
6 |
3207 |
752 |
3206 |
<null> |
3387 |
8455 |
912 |
2415 |
416 |
562 |
2591 |
277 |
880 |
16934 |
3279 |
492 |
<null> |
995 |
<null> |
05:16:38 |
05:34:38 |
marks per second |
7 |
6023 |
7551 |
6667 |
9379 |
4798 |
27947 |
7304 |
5493 |
3849 |
1969 |
3565 |
5410 |
1137 |
2936 |
6432 |
6928 |
3147 |
11157 |
<null> |
05:34:39 |
05:52:39 |
marks per second |
8 |
5488 |
15240 |
4902 |
<null> |
4469 |
22237 |
6158 |
<null> |
14607 |
3169 |
2131 |
3905 |
2390 |
7703 |
5746 |
432 |
3065 |
1487 |
<null> |
05:52:40 |
06:10:40 |
marks per second |
9 |
4556 |
2807 |
3058 |
<null> |
7652 |
<null> |
6940 |
<null> |
10650 |
7131 |
6210 |
13666 |
1100 |
209 |
7810 |
<null> |
407 |
1133 |
<null> |
06:10:41 |
06:28:41 |
marks per second |
10 |
2183 |
2348 |
544 |
<null> |
3774 |
<null> |
2749 |
855 |
5200 |
2009 |
1917 |
380 |
480 |
208 |
2559 |
795 |
298 |
843 |
<null> |
06:28:42 |
06:46:42 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:46:33 |
04:04:33 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:04:34 |
04:22:34 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
04:22:35 |
04:40:35 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:40:36 |
04:58:36 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:58:37 |
05:16:37 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
05:16:38 |
05:34:38 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:34:39 |
05:52:39 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:52:40 |
06:10:40 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
06:10:41 |
06:28:41 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:28:42 |
06:46:42 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
03:46:33 |
04:04:33 |
writes/marks*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:04:34 |
04:22:34 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
04:22:35 |
04:40:35 |
writes/marks*100 |
4 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
<null> |
04:40:36 |
04:58:36 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:58:37 |
05:16:37 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
<null> |
0 |
<null> |
05:16:38 |
05:34:38 |
writes/marks*100 |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
05:34:39 |
05:52:39 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
05:52:40 |
06:10:40 |
writes/marks*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
1 |
1 |
0 |
0 |
1 |
1 |
0 |
<null> |
2 |
0 |
<null> |
06:10:41 |
06:28:41 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
2 |
<null> |
06:28:42 |
06:46:42 |
Done for 8370 ms, from 6:58:14.56 to 6:58:22.93.
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 |
1780752 |
1640105 |
140647 |
7.89 |
0 |
9860 |
39 |
140647 |
2017-07-01 03:46 |
2017-07-01 06:46 |
doc_list_biud |
1781121 |
1640105 |
141016 |
7.91 |
0 |
8830 |
13 |
141016 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_add_invoice_to_stock |
18183 |
10566 |
7617 |
41.89 |
15 |
155844 |
8785 |
7617 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_cancel_adding_invoice |
4330 |
3273 |
1057 |
24.41 |
0 |
69872 |
2129 |
1057 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_cancel_client_order |
6274 |
6139 |
135 |
2.15 |
0 |
4571 |
215 |
135 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_cancel_customer_reserve |
324519 |
193960 |
130559 |
40.23 |
0 |
5038 |
50 |
130559 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_cancel_pay_from_customer |
2336 |
2328 |
8 |
0.34 |
0 |
1918 |
119 |
8 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_cancel_pay_to_supplier |
1499 |
1496 |
3 |
0.20 |
0 |
1545 |
129 |
3 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_cancel_supplier_invoice |
9418 |
7172 |
2246 |
23.84 |
0 |
9157 |
341 |
2246 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_cancel_supplier_order |
1461 |
518 |
943 |
64.54 |
31 |
189057 |
15618 |
943 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_cancel_write_off |
23359 |
15543 |
7816 |
33.46 |
0 |
3650 |
131 |
7816 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_client_order |
75358 |
75358 |
0 |
0.00 |
0 |
7784 |
417 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_customer_reserve |
577416 |
577416 |
0 |
0.00 |
0 |
10015 |
130 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_fill_shopping_cart |
114369 |
114075 |
294 |
0.25 |
0 |
6131 |
82 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_fill_shopping_cart_clo_res |
577416 |
577416 |
0 |
0.00 |
0 |
2714 |
9 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_get_clo_for_invoice |
10566 |
10566 |
0 |
0.00 |
0 |
4961 |
259 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_kill_cost_storno |
31158 |
22640 |
8518 |
27.33 |
0 |
1840 |
20 |
8518 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_kill_qstorno_ret_qs2qd |
681511 |
411153 |
270358 |
39.67 |
0 |
8705 |
19 |
270358 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_kill_qty_storno |
412493 |
271541 |
140952 |
34.17 |
0 |
8767 |
58 |
140952 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_lock_selected_doc |
74126 |
63380 |
10746 |
14.49 |
0 |
1123 |
6 |
10746 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_make_cost_storno |
90932 |
90932 |
0 |
0.00 |
0 |
7972 |
344 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_multiply_rows_for_pdistr |
90932 |
90932 |
0 |
0.00 |
0 |
2979 |
54 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_multiply_rows_for_qdistr |
75358 |
75358 |
0 |
0.00 |
0 |
5335 |
140 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_pay_from_customer |
25142 |
25142 |
0 |
0.00 |
0 |
7566 |
804 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_pay_to_supplier |
20854 |
20854 |
0 |
0.00 |
0 |
9063 |
442 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_payment_common |
45996 |
45996 |
0 |
0.00 |
0 |
3791 |
57 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_qd_handle_on_cancel_clo |
6267 |
6139 |
128 |
2.04 |
0 |
3510 |
92 |
128 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_qd_handle_on_invoice_upd_sts |
14739 |
13839 |
900 |
6.10 |
0 |
6630 |
288 |
900 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_qd_handle_on_reserve_upd_sts |
34370 |
34370 |
0 |
0.00 |
0 |
3932 |
45 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_reserve_write_off |
35495 |
34370 |
1125 |
3.16 |
0 |
8518 |
475 |
1125 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_supplier_invoice |
19382 |
19273 |
109 |
0.56 |
0 |
32604 |
2571 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
sp_supplier_order |
19629 |
19444 |
185 |
0.94 |
0 |
18470 |
1804 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
srv_find_qd_qs_mism |
1071479 |
930913 |
140566 |
13.11 |
0 |
4134 |
20 |
140566 |
2017-07-01 03:46 |
2017-07-01 06:46 |
srv_make_invnt_saldo |
1717 |
1717 |
0 |
0.00 |
15 |
32432 |
2098 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
srv_make_money_saldo |
2597 |
2597 |
0 |
0.00 |
0 |
3588 |
63 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
2746 |
41745 |
12711 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_add_invoice_to_stock |
7617 |
7617 |
0 |
0.00 |
0 |
4836 |
86 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_cancel_adding_invoice |
673 |
673 |
0 |
0.00 |
0 |
2215 |
213 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_cancel_client_order |
135 |
135 |
0 |
0.00 |
0 |
1575 |
83 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_cancel_customer_reserve |
81 |
81 |
0 |
0.00 |
0 |
702 |
79 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_cancel_pay_from_customer |
8 |
8 |
0 |
0.00 |
0 |
78 |
29 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_cancel_pay_to_supplier |
3 |
3 |
0 |
0.00 |
0 |
63 |
36 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_cancel_supplier_invoice |
586 |
586 |
0 |
0.00 |
0 |
1576 |
84 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_cancel_supplier_order |
16037 |
16037 |
0 |
0.00 |
0 |
6084 |
79 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_cancel_write_off |
36 |
36 |
0 |
0.00 |
0 |
312 |
51 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_reserve_write_off |
1125 |
1125 |
0 |
0.00 |
0 |
1529 |
54 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_supplier_invoice |
109 |
109 |
0 |
0.00 |
0 |
1669 |
82 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-abend:sp_supplier_order |
185 |
185 |
0 |
0.00 |
0 |
1061 |
37 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_add_invoice_to_stock |
10566 |
10566 |
0 |
0.00 |
0 |
12714 |
486 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_cancel_adding_invoice |
1217 |
1217 |
0 |
0.00 |
0 |
8081 |
576 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_cancel_client_order |
6139 |
6139 |
0 |
0.00 |
0 |
2777 |
59 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_cancel_customer_reserve |
2438 |
2438 |
0 |
0.00 |
0 |
1638 |
61 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_cancel_pay_from_customer |
2328 |
2328 |
0 |
0.00 |
0 |
2433 |
44 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_cancel_pay_to_supplier |
1496 |
1496 |
0 |
0.00 |
0 |
2278 |
49 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_cancel_supplier_invoice |
777 |
777 |
0 |
0.00 |
0 |
2824 |
64 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_cancel_supplier_order |
518 |
518 |
0 |
0.00 |
0 |
50357 |
1544 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_cancel_write_off |
3531 |
3531 |
0 |
0.00 |
0 |
3229 |
62 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_client_order |
75358 |
75358 |
0 |
0.00 |
0 |
3323 |
69 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_customer_reserve |
3453 |
3453 |
0 |
0.00 |
0 |
1638 |
52 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_pay_from_customer |
25142 |
25142 |
0 |
0.00 |
0 |
2527 |
62 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_pay_to_supplier |
20854 |
20854 |
0 |
0.00 |
0 |
2496 |
54 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_reserve_write_off |
34370 |
34370 |
0 |
0.00 |
0 |
2636 |
66 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_supplier_invoice |
19273 |
19273 |
0 |
0.00 |
0 |
2542 |
63 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:sp_supplier_order |
19444 |
19444 |
0 |
0.00 |
0 |
2558 |
63 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:srv_make_invnt_saldo |
1717 |
1717 |
0 |
0.00 |
0 |
983 |
27 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:srv_make_money_saldo |
2597 |
2597 |
0 |
0.00 |
0 |
890 |
26 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
t$perf-norm:srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
0 |
406 |
48 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_add_invoice_to_stock |
36366 |
21132 |
15234 |
41.89 |
0 |
4166 |
10 |
15234 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_all_customers |
112894 |
112894 |
0 |
0.00 |
0 |
1185 |
5 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_all_suppliers |
79660 |
79072 |
588 |
0.73 |
0 |
920 |
5 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_all_wares |
150716 |
150716 |
0 |
0.00 |
0 |
2199 |
4 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_cancel_adding_invoice |
2858 |
2434 |
424 |
14.83 |
0 |
5117 |
134 |
424 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_cancel_client_order |
12548 |
12278 |
270 |
2.15 |
0 |
1607 |
7 |
270 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_cancel_customer_prepayment |
4672 |
4656 |
16 |
0.34 |
0 |
1123 |
8 |
16 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_cancel_customer_reserve |
5038 |
4876 |
162 |
3.21 |
0 |
1076 |
9 |
162 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_cancel_payment_to_supplier |
2998 |
2992 |
6 |
0.20 |
0 |
936 |
7 |
6 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_cancel_supplier_invoice |
2726 |
1554 |
1172 |
42.99 |
0 |
1045 |
12 |
1172 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_cancel_supplier_order |
2922 |
1036 |
1886 |
64.54 |
0 |
406 |
7 |
1886 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_cancel_write_off |
7134 |
7062 |
72 |
1.00 |
0 |
3308 |
94 |
72 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_max_id_clo_ord |
19629 |
19444 |
185 |
0.94 |
0 |
1108 |
5 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_max_id_clo_res |
3453 |
3453 |
0 |
0.00 |
0 |
1622 |
18 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_max_id_ord_sup |
19382 |
19273 |
109 |
0.56 |
0 |
1311 |
5 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_max_non_paid_invoice |
20035 |
20035 |
0 |
0.00 |
0 |
733 |
5 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_max_non_paid_realizn |
25142 |
25142 |
0 |
0.00 |
0 |
1856 |
6 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_min_id_clo_ord |
19629 |
19444 |
185 |
0.94 |
0 |
1622 |
7 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_min_id_clo_res |
3453 |
3453 |
0 |
0.00 |
0 |
765 |
9 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_min_id_ord_sup |
19382 |
19273 |
109 |
0.56 |
0 |
1014 |
7 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_min_non_paid_invoice |
20854 |
20854 |
0 |
0.00 |
0 |
1529 |
10 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_min_non_paid_realizn |
25142 |
25142 |
0 |
0.00 |
0 |
1498 |
8 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_our_firm |
37822 |
37822 |
0 |
0.00 |
0 |
858 |
5 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
v_reserve_write_off |
70990 |
68740 |
2250 |
3.16 |
0 |
2200 |
8 |
2250 |
2017-07-01 03:46 |
2017-07-01 06:46 |
x_lock_depdocs_on_canc_invoice |
18311 |
9668 |
8643 |
47.20 |
0 |
1935 |
27 |
8643 |
2017-07-01 03:46 |
2017-07-01 06:46 |
x_lock_depdocs_on_canc_sup_ord |
1459 |
518 |
941 |
64.49 |
0 |
1014 |
43 |
941 |
2017-07-01 03:46 |
2017-07-01 06:46 |
x_make_qstorno_1000_1200 |
19629 |
19444 |
185 |
0.94 |
0 |
16942 |
1616 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
x_make_qstorno_1200_2000 |
19382 |
19273 |
109 |
0.56 |
0 |
31870 |
2383 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
x_make_qstorno_2100_3300 |
577416 |
577416 |
0 |
0.00 |
0 |
9984 |
109 |
0 |
2017-07-01 03:46 |
2017-07-01 06:46 |
Done for 249260 ms, from 7:02:30.24 to 7:06:39.50.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
71 |
sp_kill_cost_storno |
335544336 |
2017-07-01 03:47 |
2017-07-01 06:43 |
deadlock |
83 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-07-01 03:48 |
2017-07-01 06:43 |
deadlock |
9458 |
sp_lock_selected_doc |
335544336 |
2017-07-01 03:46 |
2017-07-01 06:46 |
deadlock |
128 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-07-01 03:46 |
2017-07-01 06:42 |
deadlock |
164 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-07-01 03:47 |
2017-07-01 06:43 |
deadlock |
617 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-07-01 03:46 |
2017-07-01 06:46 |
deadlock |
219 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-07-01 03:56 |
2017-07-01 06:46 |
user_exc |
185 |
x_make_qstorno_1000_1200 |
335544517 |
2017-07-01 03:47 |
2017-07-01 06:42 |
user_exc |
109 |
x_make_qstorno_1200_2000 |
335544517 |
2017-07-01 03:47 |
2017-07-01 06:37 |
Done for 7980 ms, from 7:06:46.03 to 7:06:54.01.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 414817
MON$OLDEST_ACTIVE 414818
MON$OLDEST_SNAPSHOT 414818
MON$NEXT_TRANSACTION 414818
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 770720
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.32741 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32741 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32741 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32741 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 414962
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 414819
Oldest active 414820
Oldest snapshot 414820
Next transaction 414821
Sequence number 0
Next attachment ID 9456
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.00, total records: 2032263
Average version length: 47.86, total versions: 3681, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 14, data page slots: 21920
Data pages: 21920, average fill: 73%
Primary pages: 21920, secondary pages: 0, swept pages: 11994
Empty pages: 3, full pages: 20669
Fill distribution:
0 - 19% = 5
20 - 39% = 4
40 - 59% = 58
60 - 79% = 21846
80 - 99% = 7
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 9881, nodes: 2032263
Average node length: 19.24, total dup: 0, max dup: 0
Average key length: 16.29, compression ratio: 1.66
Average prefix length: 13.71, average data length: 13.29
Clustering factor: 371941, ratio: 0.18
Fill distribution:
0 - 19% = 781
20 - 39% = 2426
40 - 59% = 4071
60 - 79% = 1068
80 - 99% = 1535
Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7283, nodes: 2032263
Average node length: 11.65, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 360366, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 3417
40 - 59% = 3773
60 - 79% = 85
80 - 99% = 8
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 176592, depth: 3, leaf buckets: 3494, nodes: 2032263
Average node length: 6.78, total dup: 1493554, max dup: 49
Average key length: 3.83, compression ratio: 2.35
Average prefix length: 7.44, average data length: 1.56
Clustering factor: 336864, ratio: 0.17
Fill distribution:
0 - 19% = 157
20 - 39% = 1159
40 - 59% = 1328
60 - 79% = 282
80 - 99% = 568
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.34, total records: 600562
Average version length: 35.77, total versions: 1326, max versions: 3
Average fragment length: 35.09, total fragments: 11, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7616
Data pages: 7616, average fill: 75%
Primary pages: 7611, secondary pages: 5, swept pages: 6950
Empty pages: 33, full pages: 7298
Fill distribution:
0 - 19% = 44
20 - 39% = 11
40 - 59% = 36
60 - 79% = 7507
80 - 99% = 18
Index DOC_LIST_ID_DESC (1)
Root page: 246399, depth: 3, leaf buckets: 2211, nodes: 600562
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 8.85, compression ratio: 1.02
Average prefix length: 3.15, average data length: 5.85
Clustering factor: 133537, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 1218
40 - 59% = 945
60 - 79% = 44
80 - 99% = 4
Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 620, nodes: 600562
Average node length: 4.86, total dup: 600512, max dup: 43370
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 272659, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 507
60 - 79% = 90
80 - 99% = 23
Index PK_DOC_LIST (0)
Root page: 327238, depth: 3, leaf buckets: 1659, nodes: 600562
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.15, average data length: 5.85
Clustering factor: 133537, ratio: 0.22
Fill distribution:
0 - 19% = 109
20 - 39% = 418
40 - 59% = 537
60 - 79% = 304
80 - 99% = 291
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: 67.18, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 19.93, total fragments: 385, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.55
Pointer pages: 1, data page slots: 272
Data pages: 28, average fill: 24%
Primary pages: 4, secondary pages: 24, swept pages: 4
Empty pages: 8, full pages: 3
Fill distribution:
0 - 19% = 12
20 - 39% = 12
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 292, ratio: 0.73
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 22.27, total records: 1610
Average version length: 71.21, total versions: 1106, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 4.31
Pointer pages: 1, data page slots: 600
Data pages: 432, average fill: 6%
Primary pages: 432, secondary pages: 0, swept pages: 400
Empty pages: 202, full pages: 17
Fill distribution:
0 - 19% = 410
20 - 39% = 5
40 - 59% = 0
60 - 79% = 5
80 - 99% = 12
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 9, nodes: 1610
Average node length: 17.45, total dup: 27, max dup: 1
Average key length: 15.45, compression ratio: 1.75
Average prefix length: 14.53, average data length: 12.47
Clustering factor: 1378, ratio: 0.86
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 4
60 - 79% = 0
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 15.02, 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: 12.13, total records: 483
Average version length: 45.53, total versions: 358, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 5.27
Pointer pages: 1, data page slots: 24
Data pages: 24, average fill: 22%
Primary pages: 23, secondary pages: 1, swept pages: 15
Empty pages: 5, full pages: 2
Fill distribution:
0 - 19% = 17
20 - 39% = 1
40 - 59% = 3
60 - 79% = 1
80 - 99% = 2
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 390097, depth: 2, leaf buckets: 1, nodes: 483
Average node length: 5.14, total dup: 417, max dup: 60
Average key length: 3.88, compression ratio: 4.89
Average prefix length: 17.25, average data length: 1.75
Clustering factor: 275, ratio: 0.57
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 366, Index root page: 367
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.22, total records: 207536
Average version length: 31.38, total versions: 2796, max versions: 13
Average fragment length: 34.00, total fragments: 3, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.52
Pointer pages: 2, data page slots: 2248
Data pages: 2248, average fill: 69%
Primary pages: 2243, secondary pages: 5, swept pages: 1736
Empty pages: 11, full pages: 834
Fill distribution:
0 - 19% = 30
20 - 39% = 22
40 - 59% = 111
60 - 79% = 2077
80 - 99% = 8
Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 194, nodes: 207536
Average node length: 4.50, total dup: 207487, max dup: 8150
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 36010, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 83
60 - 79% = 76
80 - 99% = 17
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 218, nodes: 207536
Average node length: 5.45, total dup: 186965, max dup: 44
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 47189, ratio: 0.23
Fill distribution:
0 - 19% = 3
20 - 39% = 13
40 - 59% = 84
60 - 79% = 58
80 - 99% = 60
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 220, nodes: 207536
Average node length: 5.45, total dup: 186965, max dup: 44
Average key length: 2.96, compression ratio: 7.43
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 47252, ratio: 0.23
Fill distribution:
0 - 19% = 1
20 - 39% = 8
40 - 59% = 90
60 - 79% = 79
80 - 99% = 42
Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 228, nodes: 207536
Average node length: 5.24, total dup: 186965, max dup: 44
Average key length: 2.75, compression ratio: 3.28
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 47311, ratio: 0.23
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 122
60 - 79% = 69
80 - 99% = 23
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.96, total records: 250901
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.14
Pointer pages: 2, data page slots: 2144
Data pages: 2144, average fill: 64%
Primary pages: 2144, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 2143
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2143
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 15887, depth: 2, leaf buckets: 200, nodes: 250901
Average node length: 4.49, total dup: 250720, max dup: 2112
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 28081, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 63
60 - 79% = 79
80 - 99% = 57
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.42, total records: 11062130
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.20
Pointer pages: 161, data page slots: 262152
Data pages: 262152, average fill: 87%
Primary pages: 262152, secondary pages: 0, swept pages: 3
Empty pages: 0, full pages: 262151
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 262151
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 12577, nodes: 11062130
Average node length: 5.64, total dup: 10215385, max dup: 144
Average key length: 2.18, compression ratio: 3.66
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 3275142, ratio: 0.30
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 7358
60 - 79% = 3406
80 - 99% = 1805
Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 10913, nodes: 11062130
Average node length: 4.55, total dup: 11062126, max dup: 10023617
Average key length: 1.09, compression ratio: 0.43
Average prefix length: 0.47, average data length: 0.00
Clustering factor: 320456, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 10909
60 - 79% = 0
80 - 99% = 3
Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 13536, nodes: 11062130
Average node length: 5.69, total dup: 10714879, max dup: 21368
Average key length: 2.23, compression ratio: 4.03
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 807517, ratio: 0.07
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 10308
60 - 79% = 1814
80 - 99% = 1411
Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 13327, nodes: 11062130
Average node length: 5.53, total dup: 11034889, max dup: 1545370
Average key length: 2.07, compression ratio: 18.27
Average prefix length: 37.77, average data length: 0.07
Clustering factor: 5798716, ratio: 0.52
Fill distribution:
0 - 19% = 11
20 - 39% = 4
40 - 59% = 11442
60 - 79% = 521
80 - 99% = 1349
PHRASES (145)
Primary pointer page: 266, Index root page: 267
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 55.01, total records: 441568
Average version length: 55.73, total versions: 810, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5248
Data pages: 5248, average fill: 74%
Primary pages: 5248, secondary pages: 0, swept pages: 3693
Empty pages: 4, full pages: 4806
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 28
60 - 79% = 5211
80 - 99% = 2
Index PSTORNED_RCV_ID (2)
Root page: 649170, depth: 3, leaf buckets: 577, nodes: 441568
Average node length: 5.87, total dup: 376056, max dup: 973
Average key length: 3.08, compression ratio: 2.92
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 54760, ratio: 0.12
Fill distribution:
0 - 19% = 13
20 - 39% = 35
40 - 59% = 327
60 - 79% = 145
80 - 99% = 57
Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 471, nodes: 441568
Average node length: 5.58, total dup: 394636, max dup: 119
Average key length: 2.79, compression ratio: 3.22
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 105111, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 8
40 - 59% = 216
60 - 79% = 154
80 - 99% = 93
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 57.63, total records: 2394
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.52
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 68%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 28
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 29
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: 27.29, total records: 9706
Average version length: 72.15, total versions: 6036, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.98
Pointer pages: 1, data page slots: 824
Data pages: 528, average fill: 24%
Primary pages: 526, secondary pages: 2, swept pages: 321
Empty pages: 265, full pages: 103
Fill distribution:
0 - 19% = 332
20 - 39% = 56
40 - 59% = 29
60 - 79% = 79
80 - 99% = 32
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 20, nodes: 9706
Average node length: 6.42, total dup: 8326, max dup: 14
Average key length: 4.43, compression ratio: 8.36
Average prefix length: 34.71, average data length: 2.29
Clustering factor: 1592, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 6
60 - 79% = 1
80 - 99% = 1
XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.74, total records: 964533
Average version length: 71.54, total versions: 5634, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 9, data page slots: 14096
Data pages: 14096, average fill: 75%
Primary pages: 14096, secondary pages: 0, swept pages: 8974
Empty pages: 7, full pages: 11782
Fill distribution:
0 - 19% = 10
20 - 39% = 25
40 - 59% = 276
60 - 79% = 13725
80 - 99% = 60
Index XQD_1000_3300_DOC (1)
Root page: 501509, depth: 3, leaf buckets: 1054, nodes: 964533
Average node length: 5.12, total dup: 938868, max dup: 125
Average key length: 2.20, compression ratio: 4.10
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 108364, ratio: 0.11
Fill distribution:
0 - 19% = 9
20 - 39% = 103
40 - 59% = 684
60 - 79% = 45
80 - 99% = 213
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 257876, depth: 3, leaf buckets: 1318, nodes: 964533
Average node length: 6.24, total dup: 842208, max dup: 26
Average key length: 3.32, compression ratio: 11.15
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 187197, ratio: 0.19
Fill distribution:
0 - 19% = 17
20 - 39% = 103
40 - 59% = 855
60 - 79% = 186
80 - 99% = 157
XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 19.58, total records: 31448
Average version length: 72.11, total versions: 22900, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 6.95
Pointer pages: 3, data page slots: 2608
Data pages: 1714, average fill: 24%
Primary pages: 1713, secondary pages: 1, swept pages: 860
Empty pages: 854, full pages: 276
Fill distribution:
0 - 19% = 1101
20 - 39% = 134
40 - 59% = 124
60 - 79% = 184
80 - 99% = 171
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 66, nodes: 31448
Average node length: 6.33, total dup: 27470, max dup: 47
Average key length: 3.64, compression ratio: 10.16
Average prefix length: 35.48, average data length: 1.52
Clustering factor: 4326, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 39
40 - 59% = 23
60 - 79% = 3
80 - 99% = 1
XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 70.38, total records: 1601812
Average version length: 71.78, total versions: 40159, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.93
Pointer pages: 15, data page slots: 24024
Data pages: 24024, average fill: 74%
Primary pages: 24022, secondary pages: 2, swept pages: 11467
Empty pages: 231, full pages: 19915
Fill distribution:
0 - 19% = 427
20 - 39% = 500
40 - 59% = 1221
60 - 79% = 20957
80 - 99% = 919
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 198798, depth: 3, leaf buckets: 2474, nodes: 1601812
Average node length: 5.60, total dup: 1507463, max dup: 99
Average key length: 2.64, compression ratio: 13.99
Average prefix length: 36.41, average data length: 0.59
Clustering factor: 193992, ratio: 0.12
Fill distribution:
0 - 19% = 9
20 - 39% = 1084
40 - 59% = 1011
60 - 79% = 213
80 - 99% = 157
XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 42.47, total records: 13558
Average version length: 71.82, total versions: 5260, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.20
Pointer pages: 4, data page slots: 1152
Data pages: 992, average fill: 17%
Primary pages: 990, secondary pages: 2, swept pages: 787
Empty pages: 462, full pages: 71
Fill distribution:
0 - 19% = 713
20 - 39% = 121
40 - 59% = 65
60 - 79% = 37
80 - 99% = 56
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 33, nodes: 13558
Average node length: 7.05, total dup: 10783, max dup: 46
Average key length: 4.92, compression ratio: 7.52
Average prefix length: 34.28, average data length: 2.72
Clustering factor: 2112, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 14
60 - 79% = 1
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 70.89, total records: 2548553
Average version length: 70.98, total versions: 17671, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.92
Pointer pages: 23, data page slots: 36088
Data pages: 36088, average fill: 77%
Primary pages: 36088, secondary pages: 0, swept pages: 25116
Empty pages: 9, full pages: 33971
Fill distribution:
0 - 19% = 36
20 - 39% = 118
40 - 59% = 322
60 - 79% = 35159
80 - 99% = 453
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5374, nodes: 2548553
Average node length: 6.86, total dup: 2067587, max dup: 17
Average key length: 3.89, compression ratio: 9.52
Average prefix length: 35.30, average data length: 1.70
Clustering factor: 449717, ratio: 0.18
Fill distribution:
0 - 19% = 7
20 - 39% = 3149
40 - 59% = 1814
60 - 79% = 246
80 - 99% = 158
XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.55, total records: 4474094
Average version length: 84.05, total versions: 1081, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 43, data page slots: 68688
Data pages: 68688, average fill: 80%
Primary pages: 68688, secondary pages: 0, swept pages: 24967
Empty pages: 3, full pages: 68323
Fill distribution:
0 - 19% = 9
20 - 39% = 4
40 - 59% = 9
60 - 79% = 20154
80 - 99% = 48512
Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4620, nodes: 4474094
Average node length: 5.15, total dup: 4372363, max dup: 125
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 701497, ratio: 0.16
Fill distribution:
0 - 19% = 22
20 - 39% = 81
40 - 59% = 2125
60 - 79% = 1907
80 - 99% = 485
Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 4646, nodes: 4474094
Average node length: 5.70, total dup: 4001576, max dup: 49
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 209321, ratio: 0.05
Fill distribution:
0 - 19% = 38
20 - 39% = 126
40 - 59% = 2304
60 - 79% = 238
80 - 99% = 1940
Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5109, nodes: 4474094
Average node length: 5.81, total dup: 3915080, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 755319, ratio: 0.17
Fill distribution:
0 - 19% = 20
20 - 39% = 93
40 - 59% = 2255
60 - 79% = 2029
80 - 99% = 712
XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 82.87, total records: 2411263
Average version length: 84.12, total versions: 9349, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 24, data page slots: 37632
Data pages: 37632, average fill: 79%
Primary pages: 37632, secondary pages: 0, swept pages: 27056
Empty pages: 32, full pages: 36005
Fill distribution:
0 - 19% = 76
20 - 39% = 112
40 - 59% = 277
60 - 79% = 15072
80 - 99% = 22095
Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2598, nodes: 2411263
Average node length: 5.15, total dup: 2354915, max dup: 142
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 366367, ratio: 0.15
Fill distribution:
0 - 19% = 4
20 - 39% = 54
40 - 59% = 1538
60 - 79% = 770
80 - 99% = 232
Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 3988, nodes: 2411263
Average node length: 6.22, total dup: 1979075, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 218028, ratio: 0.09
Fill distribution:
0 - 19% = 112
20 - 39% = 1516
40 - 59% = 1512
60 - 79% = 527
80 - 99% = 321
Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2953, nodes: 2411263
Average node length: 5.81, total dup: 2109089, max dup: 29
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 445453, ratio: 0.18
Fill distribution:
0 - 19% = 27
20 - 39% = 70
40 - 59% = 1740
60 - 79% = 834
80 - 99% = 282
XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.48, total records: 4742906
Average version length: 85.59, total versions: 13299, 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: 45, data page slots: 72824
Data pages: 72808, average fill: 80%
Primary pages: 72808, secondary pages: 0, swept pages: 18215
Empty pages: 50, full pages: 71851
Fill distribution:
0 - 19% = 66
20 - 39% = 77
40 - 59% = 277
60 - 79% = 13318
80 - 99% = 59070
Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 4942, nodes: 4742906
Average node length: 5.04, total dup: 4715032, max dup: 702
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 684184, ratio: 0.14
Fill distribution:
0 - 19% = 6
20 - 39% = 170
40 - 59% = 2749
60 - 79% = 1469
80 - 99% = 548
Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 5588, nodes: 4742906
Average node length: 5.53, total dup: 4366358, max dup: 49
Average key length: 2.55, compression ratio: 3.54
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 219734, ratio: 0.05
Fill distribution:
0 - 19% = 103
20 - 39% = 1337
40 - 59% = 2125
60 - 79% = 647
80 - 99% = 1376
Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 5556, nodes: 4742906
Average node length: 5.69, total dup: 4251811, max dup: 77
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 761406, ratio: 0.16
Fill distribution:
0 - 19% = 6
20 - 39% = 151
40 - 59% = 3138
60 - 79% = 1627
80 - 99% = 634
XQS_2000_3300 (269)
Primary pointer page: 761, Index root page: 762
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 83.08, total records: 3170077
Average version length: 84.29, total versions: 10421, 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: 31, data page slots: 49368
Data pages: 49368, average fill: 79%
Primary pages: 49368, secondary pages: 0, swept pages: 34014
Empty pages: 48, full pages: 47565
Fill distribution:
0 - 19% = 89
20 - 39% = 129
40 - 59% = 302
60 - 79% = 17743
80 - 99% = 31105
Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3478, nodes: 3170077
Average node length: 5.02, total dup: 3154255, max dup: 1232
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 628581, ratio: 0.20
Fill distribution:
0 - 19% = 17
20 - 39% = 361
40 - 59% = 1932
60 - 79% = 807
80 - 99% = 361
Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5278, nodes: 3170077
Average node length: 6.23, total dup: 2599678, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 312687, ratio: 0.10
Fill distribution:
0 - 19% = 205
20 - 39% = 1994
40 - 59% = 1915
60 - 79% = 724
80 - 99% = 440
Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3833, nodes: 3170077
Average node length: 5.60, total dup: 2885236, max dup: 67
Average key length: 2.62, compression ratio: 3.43
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 670643, ratio: 0.21
Fill distribution:
0 - 19% = 21
20 - 39% = 355
40 - 59% = 2052
60 - 79% = 992
80 - 99% = 413
XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.14, total records: 631571
Average version length: 69.29, total versions: 2797, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 8720
Data pages: 8720, average fill: 77%
Primary pages: 8720, secondary pages: 0, swept pages: 6592
Empty pages: 5, full pages: 8431
Fill distribution:
0 - 19% = 21
20 - 39% = 42
40 - 59% = 75
60 - 79% = 8517
80 - 99% = 65
Index XQS_3300_3400_DOC_ID (0)
Root page: 179535, depth: 3, leaf buckets: 756, nodes: 631571
Average node length: 5.30, total dup: 596886, max dup: 123
Average key length: 2.42, compression ratio: 3.72
Average prefix length: 8.63, average data length: 0.37
Clustering factor: 51446, ratio: 0.08
Fill distribution:
0 - 19% = 0
20 - 39% = 183
40 - 59% = 308
60 - 79% = 175
80 - 99% = 90
Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 862, nodes: 631571
Average node length: 5.92, total dup: 540375, max dup: 19
Average key length: 3.04, compression ratio: 2.96
Average prefix length: 8.10, average data length: 0.90
Clustering factor: 54469, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 202
40 - 59% = 376
60 - 79% = 189
80 - 99% = 93
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 67550 ms, from 7:06:54.46 to 7:08:02.01.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2032263 |
3681 |
0.1811 |
DOC_LIST |
600562 |
1326 |
0.2207 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
1610 |
1106 |
68.6956 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
483 |
358 |
74.1200 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
207536 |
2796 |
1.3472 |
PERF_ESTIMATED |
250901 |
0 |
0.0000 |
PERF_LOG |
11062130 |
0 |
0.0000 |
PSTORNED |
441568 |
810 |
0.1834 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
0 |
0.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2394 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
9706 |
6036 |
62.1883 |
XQD_1000_3300 |
964533 |
5634 |
0.5841 |
XQD_1200_2000 |
31448 |
22900 |
72.8186 |
XQD_2000_3300 |
1601812 |
40159 |
2.5070 |
XQD_2100_3300 |
13558 |
5260 |
38.7962 |
XQD_3300_3400 |
2548553 |
17671 |
0.6933 |
XQS_1000_1200 |
4474094 |
1081 |
0.0241 |
XQS_1000_3300 |
2411263 |
9349 |
0.3877 |
XQS_1200_2000 |
4742906 |
13299 |
0.2803 |
XQS_2100_3300 |
3170077 |
10421 |
0.3287 |
XQS_3300_3400 |
631571 |
2797 |
0.4428 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2100 ms, from 7:08:14.07 to 7:08:16.17.
07:08:16.26 Validation started
07:08:16.28 Relation 140 (DOC_LIST)
07:08:16.28 process pointer page 0 of 5
07:08:16.39 process pointer page 1 of 5
07:08:16.44 process pointer page 2 of 5
07:08:16.48 process pointer page 3 of 5
07:08:16.51 process pointer page 4 of 5
07:08:16.55 Index 1 (PK_DOC_LIST)
07:08:16.72 Index 2 (DOC_LIST_ID_DESC)
07:08:16.98 Index 3 (FK_DOC_LIST_AGENTS)
07:08:17.22 Relation 140 (DOC_LIST) is ok
07:08:17.22 Relation 141 (DOC_DATA)
07:08:17.22 process pointer page 0 of 14
07:08:17.31 process pointer page 1 of 14
07:08:17.40 process pointer page 2 of 14
07:08:17.45 process pointer page 3 of 14
07:08:17.50 process pointer page 4 of 14
07:08:17.56 process pointer page 5 of 14
07:08:17.59 process pointer page 6 of 14
07:08:17.64 process pointer page 7 of 14
07:08:17.73 process pointer page 8 of 14
07:08:17.78 process pointer page 9 of 14
07:08:17.81 process pointer page 10 of 14
07:08:17.84 process pointer page 11 of 14
07:08:17.89 process pointer page 12 of 14
07:08:17.98 process pointer page 13 of 14
07:08:18.01 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:08:18.82 Index 3 (DOC_DATA_ID_DESC)
07:08:19.46 Index 4 (FK_DOC_DATA_DOC_LIST)
07:08:19.82 Relation 141 (DOC_DATA) is ok
07:08:19.82 Relation 147 (INVNT_SALDO)
07:08:19.82 process pointer page 0 of 1
07:08:19.82 Index 1 (PK_INVNT_SALDO)
07:08:19.82 Relation 147 (INVNT_SALDO) is ok
07:08:19.82 Relation 150 (PDISTR)
07:08:19.82 process pointer page 0 of 2
07:08:19.92 process pointer page 1 of 2
07:08:19.95 Index 2 (PDISTR_SND_ID)
07:08:20.02 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:08:20.09 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:08:20.15 Index 5 (PDISTR_AGENT_ID)
07:08:20.23 Relation 150 (PDISTR) is ok
07:08:20.23 Relation 151 (PSTORNED)
07:08:20.23 process pointer page 0 of 4
07:08:20.29 process pointer page 1 of 4
07:08:20.34 process pointer page 2 of 4
07:08:20.37 process pointer page 3 of 4
07:08:20.37 Index 2 (PSTORNED_SND_ID)
07:08:20.43 Index 3 (PSTORNED_RCV_ID)
07:08:20.51 Relation 151 (PSTORNED) is ok
07:08:20.51 Relation 156 (SEMAPHORES)
07:08:20.51 process pointer page 0 of 1
07:08:20.51 Index 1 (PK_SEMAPHORES)
07:08:20.51 Index 2 (SEMAPHORES_TASK_UNQ)
07:08:20.51 Relation 156 (SEMAPHORES) is ok
07:08:20.51 Relation 157 (INVNT_TURNOVER_LOG)
07:08:20.51 process pointer page 0 of 1
07:08:20.52 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:08:20.52 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:08:20.52 Relation 160 (PERF_ESTIMATED)
07:08:20.52 process pointer page 0 of 2
07:08:20.56 process pointer page 1 of 2
07:08:20.57 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:08:20.62 Relation 160 (PERF_ESTIMATED) is ok
07:08:20.62 Relation 161 (PERF_ISQL_STAT)
07:08:20.62 process pointer page 0 of 1
07:08:20.62 Index 1 (PERF_ISQL_STAT_TRN)
07:08:20.62 Relation 161 (PERF_ISQL_STAT) is ok
07:08:20.62 Relation 162 (TRACE_STAT)
07:08:20.62 process pointer page 0 of 1
07:08:20.62 Relation 162 (TRACE_STAT) is ok
07:08:20.62 Relation 163 (PERF_LOG)
07:08:20.62 process pointer page 0 of 161
07:08:20.70 process pointer page 1 of 161
07:08:20.73 process pointer page 2 of 161
07:08:20.76 process pointer page 3 of 161
07:08:20.80 process pointer page 4 of 161
07:08:20.88 process pointer page 5 of 161
07:08:20.96 process pointer page 6 of 161
07:08:21.04 process pointer page 7 of 161
07:08:21.12 process pointer page 8 of 161
07:08:21.21 process pointer page 9 of 161
07:08:21.29 process pointer page 10 of 161
07:08:21.37 process pointer page 11 of 161
07:08:21.44 process pointer page 12 of 161
07:08:21.51 process pointer page 13 of 161
07:08:21.54 process pointer page 14 of 161
07:08:21.57 process pointer page 15 of 161
07:08:21.63 process pointer page 16 of 161
07:08:21.71 process pointer page 17 of 161
07:08:21.80 process pointer page 18 of 161
07:08:21.88 process pointer page 19 of 161
07:08:21.91 process pointer page 20 of 161
07:08:21.94 process pointer page 21 of 161
07:08:21.97 process pointer page 22 of 161
07:08:22.05 process pointer page 23 of 161
07:08:22.10 process pointer page 24 of 161
07:08:22.13 process pointer page 25 of 161
07:08:22.16 process pointer page 26 of 161
07:08:22.21 process pointer page 27 of 161
07:08:22.29 process pointer page 28 of 161
07:08:22.36 process pointer page 29 of 161
07:08:22.41 process pointer page 30 of 161
07:08:22.44 process pointer page 31 of 161
07:08:22.47 process pointer page 32 of 161
07:08:22.51 process pointer page 33 of 161
07:08:22.54 process pointer page 34 of 161
07:08:22.57 process pointer page 35 of 161
07:08:22.60 process pointer page 36 of 161
07:08:22.63 process pointer page 37 of 161
07:08:22.66 process pointer page 38 of 161
07:08:22.71 process pointer page 39 of 161
07:08:22.79 process pointer page 40 of 161
07:08:22.86 process pointer page 41 of 161
07:08:22.94 process pointer page 42 of 161
07:08:23.00 process pointer page 43 of 161
07:08:23.04 process pointer page 44 of 161
07:08:23.07 process pointer page 45 of 161
07:08:23.10 process pointer page 46 of 161
07:08:23.13 process pointer page 47 of 161
07:08:23.14 process pointer page 48 of 161
07:08:23.18 process pointer page 49 of 161
07:08:23.21 process pointer page 50 of 161
07:08:23.24 process pointer page 51 of 161
07:08:23.25 process pointer page 52 of 161
07:08:23.29 process pointer page 53 of 161
07:08:23.32 process pointer page 54 of 161
07:08:23.33 process pointer page 55 of 161
07:08:23.41 process pointer page 56 of 161
07:08:23.46 process pointer page 57 of 161
07:08:23.49 process pointer page 58 of 161
07:08:23.52 process pointer page 59 of 161
07:08:23.55 process pointer page 60 of 161
07:08:23.58 process pointer page 61 of 161
07:08:23.61 process pointer page 62 of 161
07:08:23.63 process pointer page 63 of 161
07:08:23.66 process pointer page 64 of 161
07:08:23.69 process pointer page 65 of 161
07:08:23.72 process pointer page 66 of 161
07:08:23.74 process pointer page 67 of 161
07:08:23.77 process pointer page 68 of 161
07:08:23.78 process pointer page 69 of 161
07:08:23.82 process pointer page 70 of 161
07:08:23.83 process pointer page 71 of 161
07:08:23.86 process pointer page 72 of 161
07:08:23.88 process pointer page 73 of 161
07:08:23.91 process pointer page 74 of 161
07:08:23.96 process pointer page 75 of 161
07:08:23.97 process pointer page 76 of 161
07:08:24.00 process pointer page 77 of 161
07:08:24.02 process pointer page 78 of 161
07:08:24.05 process pointer page 79 of 161
07:08:24.07 process pointer page 80 of 161
07:08:24.10 process pointer page 81 of 161
07:08:24.11 process pointer page 82 of 161
07:08:24.14 process pointer page 83 of 161
07:08:24.16 process pointer page 84 of 161
07:08:24.19 process pointer page 85 of 161
07:08:24.22 process pointer page 86 of 161
07:08:24.24 process pointer page 87 of 161
07:08:24.27 process pointer page 88 of 161
07:08:24.28 process pointer page 89 of 161
07:08:24.31 process pointer page 90 of 161
07:08:24.33 process pointer page 91 of 161
07:08:24.36 process pointer page 92 of 161
07:08:24.38 process pointer page 93 of 161
07:08:24.41 process pointer page 94 of 161
07:08:24.42 process pointer page 95 of 161
07:08:24.46 process pointer page 96 of 161
07:08:24.47 process pointer page 97 of 161
07:08:24.50 process pointer page 98 of 161
07:08:24.53 process pointer page 99 of 161
07:08:24.55 process pointer page 100 of 161
07:08:24.58 process pointer page 101 of 161
07:08:24.61 process pointer page 102 of 161
07:08:24.63 process pointer page 103 of 161
07:08:24.66 process pointer page 104 of 161
07:08:24.67 process pointer page 105 of 161
07:08:24.69 process pointer page 106 of 161
07:08:24.72 process pointer page 107 of 161
07:08:24.74 process pointer page 108 of 161
07:08:24.77 process pointer page 109 of 161
07:08:24.78 process pointer page 110 of 161
07:08:24.81 process pointer page 111 of 161
07:08:24.83 process pointer page 112 of 161
07:08:24.86 process pointer page 113 of 161
07:08:24.89 process pointer page 114 of 161
07:08:24.92 process pointer page 115 of 161
07:08:24.95 process pointer page 116 of 161
07:08:24.97 process pointer page 117 of 161
07:08:25.03 process pointer page 118 of 161
07:08:25.11 process pointer page 119 of 161
07:08:25.19 process pointer page 120 of 161
07:08:25.27 process pointer page 121 of 161
07:08:25.34 process pointer page 122 of 161
07:08:25.44 process pointer page 123 of 161
07:08:25.52 process pointer page 124 of 161
07:08:25.59 process pointer page 125 of 161
07:08:25.64 process pointer page 126 of 161
07:08:25.67 process pointer page 127 of 161
07:08:25.70 process pointer page 128 of 161
07:08:25.73 process pointer page 129 of 161
07:08:25.77 process pointer page 130 of 161
07:08:25.80 process pointer page 131 of 161
07:08:25.83 process pointer page 132 of 161
07:08:25.86 process pointer page 133 of 161
07:08:25.89 process pointer page 134 of 161
07:08:25.98 process pointer page 135 of 161
07:08:26.05 process pointer page 136 of 161
07:08:26.08 process pointer page 137 of 161
07:08:26.11 process pointer page 138 of 161
07:08:26.14 process pointer page 139 of 161
07:08:26.17 process pointer page 140 of 161
07:08:26.20 process pointer page 141 of 161
07:08:26.23 process pointer page 142 of 161
07:08:26.30 process pointer page 143 of 161
07:08:26.37 process pointer page 144 of 161
07:08:26.41 process pointer page 145 of 161
07:08:26.44 process pointer page 146 of 161
07:08:26.47 process pointer page 147 of 161
07:08:26.50 process pointer page 148 of 161
07:08:26.53 process pointer page 149 of 161
07:08:26.56 process pointer page 150 of 161
07:08:26.61 process pointer page 151 of 161
07:08:26.69 process pointer page 152 of 161
07:08:26.76 process pointer page 153 of 161
07:08:26.84 process pointer page 154 of 161
07:08:26.94 process pointer page 155 of 161
07:08:27.01 process pointer page 156 of 161
07:08:27.06 process pointer page 157 of 161
07:08:27.09 process pointer page 158 of 161
07:08:27.12 process pointer page 159 of 161
07:08:27.15 process pointer page 160 of 161
07:08:27.17 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:08:29.85 Index 2 (PERF_LOG_UNIT)
07:08:32.94 Index 3 (PERF_LOG_TRN_DESC)
07:08:34.35 Index 4 (PERF_LOG_GDSCODE)
07:08:35.36 Relation 163 (PERF_LOG) is ok
07:08:35.36 Relation 167 (V_STOPTEST)
07:08:35.36 Relation 167 (V_STOPTEST) is ok
07:08:35.36 Relation 184 (V_QDISTR_SOURCE)
07:08:35.36 Relation 184 (V_QDISTR_SOURCE) is ok
07:08:35.36 Relation 185 (V_QSTORNED_SOURCE)
07:08:35.36 Relation 185 (V_QSTORNED_SOURCE) is ok
07:08:35.36 Relation 260 (XQD_1000_1200)
07:08:35.36 process pointer page 0 of 1
07:08:35.38 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:08:35.38 Relation 260 (XQD_1000_1200) is ok
07:08:35.38 Relation 261 (XQD_1200_2000)
07:08:35.38 process pointer page 0 of 3
07:08:35.39 process pointer page 1 of 3
07:08:35.41 process pointer page 2 of 3
07:08:35.41 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:08:35.41 Relation 261 (XQD_1200_2000) is ok
07:08:35.41 Relation 262 (XQD_1000_3300)
07:08:35.41 process pointer page 0 of 9
07:08:35.44 process pointer page 1 of 9
07:08:35.45 process pointer page 2 of 9
07:08:35.48 process pointer page 3 of 9
07:08:35.52 process pointer page 4 of 9
07:08:35.55 process pointer page 5 of 9
07:08:35.59 process pointer page 6 of 9
07:08:35.67 process pointer page 7 of 9
07:08:35.75 process pointer page 8 of 9
07:08:35.77 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:08:35.92 Index 2 (XQD_1000_3300_DOC)
07:08:36.08 Relation 262 (XQD_1000_3300) is ok
07:08:36.08 Relation 263 (XQD_2000_3300)
07:08:36.08 process pointer page 0 of 15
07:08:36.12 process pointer page 1 of 15
07:08:36.16 process pointer page 2 of 15
07:08:36.19 process pointer page 3 of 15
07:08:36.30 process pointer page 4 of 15
07:08:36.33 process pointer page 5 of 15
07:08:36.37 process pointer page 6 of 15
07:08:36.44 process pointer page 7 of 15
07:08:36.53 process pointer page 8 of 15
07:08:36.58 process pointer page 9 of 15
07:08:36.61 process pointer page 10 of 15
07:08:36.65 process pointer page 11 of 15
07:08:36.69 process pointer page 12 of 15
07:08:36.72 process pointer page 13 of 15
07:08:36.73 process pointer page 14 of 15
07:08:36.79 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:08:37.20 Relation 263 (XQD_2000_3300) is ok
07:08:37.20 Relation 264 (XQD_2100_3300)
07:08:37.20 process pointer page 0 of 4
07:08:37.23 process pointer page 1 of 4
07:08:37.23 process pointer page 2 of 4
07:08:37.23 process pointer page 3 of 4
07:08:37.23 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:08:37.25 Relation 264 (XQD_2100_3300) is ok
07:08:37.25 Relation 265 (XQD_3300_3400)
07:08:37.25 process pointer page 0 of 23
07:08:37.31 process pointer page 1 of 23
07:08:37.34 process pointer page 2 of 23
07:08:37.37 process pointer page 3 of 23
07:08:37.47 process pointer page 4 of 23
07:08:37.56 process pointer page 5 of 23
07:08:37.65 process pointer page 6 of 23
07:08:37.75 process pointer page 7 of 23
07:08:37.81 process pointer page 8 of 23
07:08:37.84 process pointer page 9 of 23
07:08:37.89 process pointer page 10 of 23
07:08:37.98 process pointer page 11 of 23
07:08:38.07 process pointer page 12 of 23
07:08:38.17 process pointer page 13 of 23
07:08:38.26 process pointer page 14 of 23
07:08:38.31 process pointer page 15 of 23
07:08:38.34 process pointer page 16 of 23
07:08:38.39 process pointer page 17 of 23
07:08:38.42 process pointer page 18 of 23
07:08:38.48 process pointer page 19 of 23
07:08:38.57 process pointer page 20 of 23
07:08:38.62 process pointer page 21 of 23
07:08:38.65 process pointer page 22 of 23
07:08:38.65 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:08:39.35 Relation 265 (XQD_3300_3400) is ok
07:08:39.35 Relation 266 (XQS_1000_1200)
07:08:39.35 process pointer page 0 of 43
07:08:39.42 process pointer page 1 of 43
07:08:39.49 process pointer page 2 of 43
07:08:39.59 process pointer page 3 of 43
07:08:39.62 process pointer page 4 of 43
07:08:39.65 process pointer page 5 of 43
07:08:39.70 process pointer page 6 of 43
07:08:39.77 process pointer page 7 of 43
07:08:39.82 process pointer page 8 of 43
07:08:39.85 process pointer page 9 of 43
07:08:39.88 process pointer page 10 of 43
07:08:39.98 process pointer page 11 of 43
07:08:40.07 process pointer page 12 of 43
07:08:40.10 process pointer page 13 of 43
07:08:40.15 process pointer page 14 of 43
07:08:40.24 process pointer page 15 of 43
07:08:40.32 process pointer page 16 of 43
07:08:40.41 process pointer page 17 of 43
07:08:40.51 process pointer page 18 of 43
07:08:40.59 process pointer page 19 of 43
07:08:40.68 process pointer page 20 of 43
07:08:40.77 process pointer page 21 of 43
07:08:40.85 process pointer page 22 of 43
07:08:40.91 process pointer page 23 of 43
07:08:40.94 process pointer page 24 of 43
07:08:40.98 process pointer page 25 of 43
07:08:41.01 process pointer page 26 of 43
07:08:41.05 process pointer page 27 of 43
07:08:41.10 process pointer page 28 of 43
07:08:41.16 process pointer page 29 of 43
07:08:41.21 process pointer page 30 of 43
07:08:41.29 process pointer page 31 of 43
07:08:41.38 process pointer page 32 of 43
07:08:41.43 process pointer page 33 of 43
07:08:41.49 process pointer page 34 of 43
07:08:41.57 process pointer page 35 of 43
07:08:41.66 process pointer page 36 of 43
07:08:41.76 process pointer page 37 of 43
07:08:41.85 process pointer page 38 of 43
07:08:41.93 process pointer page 39 of 43
07:08:42.02 process pointer page 40 of 43
07:08:42.10 process pointer page 41 of 43
07:08:42.19 process pointer page 42 of 43
07:08:42.19 Index 1 (XQS_1000_1200_DOC_ID)
07:08:43.03 Index 2 (XQS_1000_1200_SND_ID)
07:08:43.91 Index 3 (XQS_1000_1200_RCV_ID)
07:08:44.66 Relation 266 (XQS_1000_1200) is ok
07:08:44.66 Relation 267 (XQS_1200_2000)
07:08:44.66 process pointer page 0 of 45
07:08:44.75 process pointer page 1 of 45
07:08:44.84 process pointer page 2 of 45
07:08:44.94 process pointer page 3 of 45
07:08:45.00 process pointer page 4 of 45
07:08:45.03 process pointer page 5 of 45
07:08:45.14 process pointer page 6 of 45
07:08:45.17 process pointer page 7 of 45
07:08:45.22 process pointer page 8 of 45
07:08:45.33 process pointer page 9 of 45
07:08:45.37 process pointer page 10 of 45
07:08:45.44 process pointer page 11 of 45
07:08:45.48 process pointer page 12 of 45
07:08:45.53 process pointer page 13 of 45
07:08:45.56 process pointer page 14 of 45
07:08:45.61 process pointer page 15 of 45
07:08:45.66 process pointer page 16 of 45
07:08:45.69 process pointer page 17 of 45
07:08:45.73 process pointer page 18 of 45
07:08:45.78 process pointer page 19 of 45
07:08:45.81 process pointer page 20 of 45
07:08:45.86 process pointer page 21 of 45
07:08:45.89 process pointer page 22 of 45
07:08:45.92 process pointer page 23 of 45
07:08:45.95 process pointer page 24 of 45
07:08:45.98 process pointer page 25 of 45
07:08:46.01 process pointer page 26 of 45
07:08:46.05 process pointer page 27 of 45
07:08:46.08 process pointer page 28 of 45
07:08:46.11 process pointer page 29 of 45
07:08:46.14 process pointer page 30 of 45
07:08:46.17 process pointer page 31 of 45
07:08:46.20 process pointer page 32 of 45
07:08:46.23 process pointer page 33 of 45
07:08:46.26 process pointer page 34 of 45
07:08:46.31 process pointer page 35 of 45
07:08:46.39 process pointer page 36 of 45
07:08:46.50 process pointer page 37 of 45
07:08:46.61 process pointer page 38 of 45
07:08:46.70 process pointer page 39 of 45
07:08:46.81 process pointer page 40 of 45
07:08:46.89 process pointer page 41 of 45
07:08:46.93 process pointer page 42 of 45
07:08:47.04 process pointer page 43 of 45
07:08:47.15 process pointer page 44 of 45
07:08:47.22 Index 1 (XQS_1200_2000_DOC_ID)
07:08:48.35 Index 2 (XQS_1200_2000_SND_ID)
07:08:49.18 Index 3 (XQS_1200_2000_RCV_ID)
07:08:51.13 Relation 267 (XQS_1200_2000) is ok
07:08:51.13 Relation 268 (XQS_1000_3300)
07:08:51.13 process pointer page 0 of 24
07:08:51.61 process pointer page 1 of 24
07:08:52.10 process pointer page 2 of 24
07:08:52.60 process pointer page 3 of 24
07:08:53.08 process pointer page 4 of 24
07:08:53.56 process pointer page 5 of 24
07:08:54.06 process pointer page 6 of 24
07:08:54.55 process pointer page 7 of 24
07:08:55.05 process pointer page 8 of 24
07:08:55.53 process pointer page 9 of 24
07:08:56.03 process pointer page 10 of 24
07:08:56.51 process pointer page 11 of 24
07:08:56.95 process pointer page 12 of 24
07:08:57.28 process pointer page 13 of 24
07:08:57.68 process pointer page 14 of 24
07:08:58.20 process pointer page 15 of 24
07:08:58.68 process pointer page 16 of 24
07:08:59.17 process pointer page 17 of 24
07:08:59.65 process pointer page 18 of 24
07:09:00.13 process pointer page 19 of 24
07:09:00.60 process pointer page 20 of 24
07:09:01.08 process pointer page 21 of 24
07:09:01.57 process pointer page 22 of 24
07:09:01.99 process pointer page 23 of 24
07:09:02.00 Index 1 (XQS_1000_3300_DOC_ID)
07:09:03.36 Index 2 (XQS_1000_3300_SND_ID)
07:09:04.67 Index 3 (XQS_1000_3300_RCV_ID)
07:09:06.23 Relation 268 (XQS_1000_3300) is ok
07:09:06.23 Relation 269 (XQS_2000_3300)
07:09:06.23 process pointer page 0 of 1
07:09:06.23 Index 1 (XQS_2000_3300_DOC_ID)
07:09:06.23 Index 2 (XQS_2000_3300_SND_ID)
07:09:06.23 Index 3 (XQS_2000_3300_RCV_ID)
07:09:06.23 Relation 269 (XQS_2000_3300) is ok
07:09:06.23 Relation 270 (XQS_2100_3300)
07:09:06.23 process pointer page 0 of 31
07:09:06.68 process pointer page 1 of 31
07:09:07.18 process pointer page 2 of 31
07:09:07.67 process pointer page 3 of 31
07:09:08.15 process pointer page 4 of 31
07:09:08.56 process pointer page 5 of 31
07:09:08.98 process pointer page 6 of 31
07:09:09.46 process pointer page 7 of 31
07:09:09.99 process pointer page 8 of 31
07:09:10.48 process pointer page 9 of 31
07:09:10.97 process pointer page 10 of 31
07:09:11.46 process pointer page 11 of 31
07:09:11.96 process pointer page 12 of 31
07:09:12.44 process pointer page 13 of 31
07:09:12.94 process pointer page 14 of 31
07:09:13.42 process pointer page 15 of 31
07:09:13.92 process pointer page 16 of 31
07:09:14.39 process pointer page 17 of 31
07:09:14.89 process pointer page 18 of 31
07:09:15.37 process pointer page 19 of 31
07:09:15.86 process pointer page 20 of 31
07:09:16.34 process pointer page 21 of 31
07:09:16.82 process pointer page 22 of 31
07:09:17.31 process pointer page 23 of 31
07:09:17.78 process pointer page 24 of 31
07:09:18.26 process pointer page 25 of 31
07:09:18.73 process pointer page 26 of 31
07:09:19.18 process pointer page 27 of 31
07:09:19.51 process pointer page 28 of 31
07:09:19.85 process pointer page 29 of 31
07:09:20.26 process pointer page 30 of 31
07:09:20.35 Index 1 (XQS_2100_3300_DOC_ID)
07:09:22.25 Index 2 (XQS_2100_3300_SND_ID)
07:09:24.30 Index 3 (XQS_2100_3300_RCV_ID)
07:09:26.17 Relation 270 (XQS_2100_3300) is ok
07:09:26.17 Relation 271 (XQS_3300_3400)
07:09:26.17 process pointer page 0 of 6
07:09:26.62 process pointer page 1 of 6
07:09:27.12 process pointer page 2 of 6
07:09:27.60 process pointer page 3 of 6
07:09:28.10 process pointer page 4 of 6
07:09:28.60 process pointer page 5 of 6
07:09:28.76 Index 1 (XQS_3300_3400_DOC_ID)
07:09:29.13 Index 2 (XQS_3300_3400_SND_ID)
07:09:29.54 Relation 271 (XQS_3300_3400) is ok
07:09:29.57 Validation finished
Done for 73460 ms, from 7:08:16.19 to 7:09:29.65.
Differences between old and current firebird.log
7:09:31.04. 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-07-01 07:09 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 Sat Jul 01 07:08:16 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sat Jul 01 07:09:29 2017
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 397 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-07-01 7:09:38.38 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html