Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-07-27 11:20:15.90.
Server version: WI-T4.0.0.700 Firebird 4.0 Alpha 1
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperServer 4.0.0 |
D:\OLTP-EMUL\OLTP40-SMALL.FDB |
ON |
0 |
786432 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp40_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB40.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp40-small.fdb |
host |
localhost |
port |
3400 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp40 |
working_mode |
small_03 |
warm_time |
0 |
test_time |
180 |
idle_time |
0 |
use_mtee |
0 |
is_embed |
0 |
remove_isql_logs |
if_no_severe_errors |
no_auto_undo |
1 |
detailed_info |
0 |
mon_unit_perf |
0 |
trc_unit_perf |
1 |
init_buff |
32768 |
create_with_fw |
sync |
create_with_sweep |
0 |
wait_if_not_exists |
0 |
wait_after_create |
0 |
init_docs |
100000 |
wait_for_copy |
0 |
create_with_debug_objects |
1 |
create_with_split_heavy_tabs |
1 |
create_with_separate_qdistr_idx |
0 |
create_with_compound_columns_order |
most_selective_first |
make_html |
1 |
run_db_statistics |
1 |
run_db_validation |
1 |
file_name_with_test_params |
regular |
file_name_this_host_info |
cpu_8x3Ghz_ram_16gb |
upload_report |
1 |
max_snapshots_to_store |
720 |
replace_instance |
1 |
etalon_dbnm |
E:\OLTP-EMUL\oltp40-docs_100000-fw__ON.fdb |
used_in_replication |
0 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2017-07-27 11:16:38.1840 |
-1 |
<null> |
|
::1/53157 |
390709 |
8990 |
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: |
5199.96 |
2691 |
935992 |
2017-07-27 08:16 |
2017-07-27 11:16 |
customer order: creation |
390.31 |
428 |
70255 |
2017-07-27 08:16 |
2017-07-27 11:16 |
customer order: refuse |
31.98 |
229 |
5756 |
2017-07-27 08:16 |
2017-07-27 11:16 |
order to supplier: creation |
100.10 |
1846 |
18018 |
2017-07-27 08:16 |
2017-07-27 11:16 |
order to supplier: removal |
2.42 |
17610 |
436 |
2017-07-27 08:16 |
2017-07-27 11:16 |
invoice (draft): creation |
100.34 |
2632 |
18061 |
2017-07-27 08:16 |
2017-07-27 11:16 |
invoice (draft): removal |
35.57 |
393 |
6402 |
2017-07-27 08:16 |
2017-07-27 11:16 |
invoice accept: apply |
54.83 |
10872 |
9870 |
2017-07-27 08:16 |
2017-07-27 11:16 |
invoice accept: cancel |
15.73 |
3001 |
2832 |
2017-07-27 08:16 |
2017-07-27 11:16 |
customer reserve: creation |
2984.22 |
164 |
537160 |
2017-07-27 08:16 |
2017-07-27 11:16 |
customer reserve: removal |
947.22 |
63 |
170500 |
2017-07-27 08:16 |
2017-07-27 11:16 |
realization accept: apply |
181.99 |
428 |
32758 |
2017-07-27 08:16 |
2017-07-27 11:16 |
realization accept: cancel |
73.65 |
144 |
13257 |
2017-07-27 08:16 |
2017-07-27 11:16 |
payment from customer: creation |
130.84 |
1279 |
23551 |
2017-07-27 08:16 |
2017-07-27 11:16 |
payment from customer: removal |
12.27 |
117 |
2208 |
2017-07-27 08:16 |
2017-07-27 11:16 |
payment to supplier: creation |
108.07 |
1867 |
19453 |
2017-07-27 08:16 |
2017-07-27 11:16 |
payment to supplier: removal |
7.71 |
107 |
1387 |
2017-07-27 08:16 |
2017-07-27 11:16 |
service: total inventory turnovers |
8.41 |
2625 |
1514 |
2017-07-27 08:16 |
2017-07-27 11:16 |
service: total monetary turnovers |
14.23 |
74 |
2562 |
2017-07-27 08:16 |
2017-07-27 11:16 |
service: refresh index statistics |
0.07 |
7254 |
12 |
2017-07-27 08:16 |
2017-07-27 11:16 |
Done for 81770 ms, from 11:22:28.86 to 11:23:50.63.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
4137 |
88156 |
74466 |
13690 |
15.53 |
08:16:39 |
08:34:38 |
interval # 2, overall |
2 |
5417 |
114242 |
97507 |
16735 |
14.65 |
08:34:39 |
08:52:38 |
interval # 3, overall |
3 |
5624 |
115487 |
101238 |
14249 |
12.34 |
08:52:39 |
09:10:38 |
interval # 4, overall |
4 |
5607 |
115683 |
100933 |
14750 |
12.75 |
09:10:39 |
09:28:38 |
interval # 5, overall |
5 |
5948 |
125040 |
107069 |
17971 |
14.37 |
09:28:39 |
09:46:38 |
interval # 6, overall |
6 |
4914 |
97101 |
88447 |
8654 |
8.91 |
09:46:39 |
10:04:38 |
interval # 7, overall |
7 |
5854 |
121704 |
105375 |
16329 |
13.42 |
10:04:39 |
10:22:38 |
interval # 8, overall |
8 |
5217 |
107424 |
93903 |
13521 |
12.59 |
10:22:39 |
10:40:38 |
interval # 9, overall |
9 |
4395 |
88824 |
79118 |
9706 |
10.93 |
10:40:39 |
10:58:38 |
interval # 10, overall |
10 |
4885 |
98676 |
87936 |
10740 |
10.88 |
10:58:39 |
11:16:38 |
Done for 131830 ms, from 11:25:58.40 to 11:28:10.23.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
2875.27 |
0.4110 |
1.5803 |
1413 |
16 |
TEST_TIME |
2 |
2899.64 |
0.7837 |
1.2786 |
1188 |
30 |
TEST_TIME |
3 |
2928.24 |
0.8444 |
1.1428 |
1212 |
100 |
TEST_TIME |
4 |
2956.14 |
0.8541 |
1.1109 |
1316 |
100 |
TEST_TIME |
5 |
2902.65 |
0.9052 |
1.1038 |
1465 |
100 |
TEST_TIME |
6 |
2997.17 |
0.8908 |
1.1029 |
1647 |
100 |
TEST_TIME |
7 |
3125.97 |
0.9064 |
1.0962 |
1469 |
100 |
TEST_TIME |
8 |
3235.66 |
0.9268 |
1.0852 |
1395 |
100 |
TEST_TIME |
9 |
3389.90 |
0.9207 |
1.0736 |
1528 |
100 |
TEST_TIME |
10 |
3533.80 |
0.9285 |
1.0615 |
1682 |
100 |
TEST_TIME |
11 |
3657.48 |
0.9324 |
1.0615 |
1782 |
100 |
TEST_TIME |
12 |
3795.09 |
0.9378 |
1.0486 |
1520 |
100 |
TEST_TIME |
13 |
3865.13 |
0.9505 |
1.0554 |
1599 |
100 |
TEST_TIME |
14 |
3937.01 |
0.9622 |
1.0527 |
1427 |
100 |
TEST_TIME |
15 |
3992.50 |
0.9689 |
1.0292 |
1096 |
100 |
TEST_TIME |
16 |
3978.69 |
0.9683 |
1.0397 |
1223 |
100 |
TEST_TIME |
17 |
4029.97 |
0.9660 |
1.0413 |
1267 |
100 |
TEST_TIME |
18 |
4114.39 |
0.9633 |
1.0366 |
1671 |
100 |
TEST_TIME |
19 |
4228.72 |
0.9555 |
1.0357 |
1676 |
100 |
TEST_TIME |
20 |
4291.13 |
0.9704 |
1.0414 |
1716 |
100 |
TEST_TIME |
21 |
4369.11 |
0.9742 |
1.0251 |
1028 |
100 |
TEST_TIME |
22 |
4403.94 |
0.9708 |
1.0307 |
1489 |
100 |
TEST_TIME |
23 |
4438.43 |
0.9783 |
1.0151 |
1311 |
100 |
TEST_TIME |
24 |
4431.91 |
0.9742 |
1.0181 |
1079 |
100 |
TEST_TIME |
25 |
4450.28 |
0.9733 |
1.0258 |
1340 |
100 |
TEST_TIME |
26 |
4486.01 |
0.9788 |
1.0252 |
1452 |
100 |
TEST_TIME |
27 |
4519.47 |
0.9799 |
1.0231 |
1400 |
100 |
TEST_TIME |
28 |
4542.63 |
0.9816 |
1.0184 |
1146 |
100 |
TEST_TIME |
29 |
4559.37 |
0.9800 |
1.0215 |
1263 |
100 |
TEST_TIME |
30 |
4590.55 |
0.9810 |
1.0180 |
1165 |
100 |
TEST_TIME |
31 |
4595.16 |
0.9842 |
1.0234 |
1255 |
100 |
TEST_TIME |
32 |
4629.49 |
0.9841 |
1.0143 |
1251 |
100 |
TEST_TIME |
33 |
4667.59 |
0.9757 |
1.0257 |
1731 |
100 |
TEST_TIME |
34 |
4714.70 |
0.9859 |
1.0139 |
1848 |
100 |
TEST_TIME |
35 |
4744.32 |
0.9788 |
1.0170 |
1525 |
99 |
TEST_TIME |
36 |
4770.95 |
0.9832 |
1.0137 |
1460 |
100 |
TEST_TIME |
37 |
4813.51 |
0.9776 |
1.0209 |
1681 |
100 |
TEST_TIME |
38 |
4867.35 |
0.9831 |
1.0174 |
1343 |
100 |
TEST_TIME |
39 |
4880.75 |
0.9893 |
1.0065 |
1490 |
100 |
TEST_TIME |
40 |
4856.34 |
0.9863 |
1.0120 |
1469 |
96 |
TEST_TIME |
41 |
4861.35 |
0.9863 |
1.0152 |
1237 |
99 |
TEST_TIME |
42 |
4856.42 |
0.9921 |
1.0105 |
1300 |
97 |
TEST_TIME |
43 |
4879.73 |
0.9823 |
1.0106 |
976 |
99 |
TEST_TIME |
44 |
4864.65 |
0.9907 |
1.0121 |
1241 |
100 |
TEST_TIME |
45 |
4847.23 |
0.9932 |
1.0069 |
983 |
100 |
TEST_TIME |
46 |
4824.13 |
0.9897 |
1.0075 |
1088 |
100 |
TEST_TIME |
47 |
4791.41 |
0.9928 |
1.0058 |
1148 |
97 |
TEST_TIME |
48 |
4816.87 |
0.9796 |
1.0123 |
1232 |
100 |
TEST_TIME |
49 |
4850.22 |
0.9848 |
1.0173 |
1703 |
100 |
TEST_TIME |
50 |
4898.87 |
0.9871 |
1.0186 |
1646 |
100 |
TEST_TIME |
51 |
4946.40 |
0.9890 |
1.0065 |
1676 |
100 |
TEST_TIME |
52 |
4935.27 |
0.9894 |
1.0103 |
1557 |
96 |
TEST_TIME |
53 |
4977.23 |
0.9829 |
1.0157 |
1281 |
100 |
TEST_TIME |
54 |
5029.79 |
0.9865 |
1.0134 |
1240 |
100 |
TEST_TIME |
55 |
5056.87 |
0.9897 |
1.0062 |
1219 |
100 |
TEST_TIME |
56 |
5022.50 |
0.9950 |
1.0071 |
1425 |
96 |
TEST_TIME |
57 |
5027.22 |
0.9885 |
1.0100 |
1234 |
100 |
TEST_TIME |
58 |
5032.99 |
0.9915 |
1.0080 |
1178 |
100 |
TEST_TIME |
59 |
5028.97 |
0.9917 |
1.0076 |
1290 |
100 |
TEST_TIME |
60 |
5027.45 |
0.9911 |
1.0089 |
1245 |
100 |
TEST_TIME |
61 |
5031.05 |
0.9916 |
1.0092 |
1231 |
100 |
TEST_TIME |
62 |
5036.76 |
0.9918 |
1.0069 |
1089 |
100 |
TEST_TIME |
63 |
5053.16 |
0.9877 |
1.0157 |
1327 |
100 |
TEST_TIME |
64 |
5087.65 |
0.9931 |
1.0086 |
1452 |
100 |
TEST_TIME |
65 |
5086.34 |
0.9938 |
1.0072 |
1687 |
100 |
TEST_TIME |
66 |
5088.19 |
0.9916 |
1.0087 |
1291 |
100 |
TEST_TIME |
67 |
5114.30 |
0.9886 |
1.0100 |
1271 |
100 |
TEST_TIME |
68 |
5136.03 |
0.9909 |
1.0077 |
1289 |
100 |
TEST_TIME |
69 |
5151.83 |
0.9901 |
1.0061 |
1211 |
100 |
TEST_TIME |
70 |
5143.26 |
0.9934 |
1.0070 |
1187 |
100 |
TEST_TIME |
71 |
5157.02 |
0.9902 |
1.0105 |
1236 |
100 |
TEST_TIME |
72 |
5178.43 |
0.9927 |
1.0071 |
1195 |
100 |
TEST_TIME |
73 |
5186.08 |
0.9919 |
1.0071 |
1193 |
100 |
TEST_TIME |
74 |
5184.19 |
0.9939 |
1.0066 |
1257 |
100 |
TEST_TIME |
75 |
5180.40 |
0.9939 |
1.0066 |
1148 |
100 |
TEST_TIME |
76 |
5179.69 |
0.9935 |
1.0057 |
1147 |
100 |
TEST_TIME |
77 |
5177.36 |
0.9931 |
1.0058 |
1118 |
100 |
TEST_TIME |
78 |
5204.34 |
0.9879 |
1.0093 |
1605 |
100 |
TEST_TIME |
79 |
5231.76 |
0.9914 |
1.0091 |
1359 |
100 |
TEST_TIME |
80 |
5231.03 |
0.9966 |
1.0048 |
1658 |
98 |
TEST_TIME |
81 |
5226.74 |
0.9932 |
1.0056 |
1458 |
95 |
TEST_TIME |
82 |
5245.36 |
0.9898 |
1.0076 |
1105 |
100 |
TEST_TIME |
83 |
5266.14 |
0.9915 |
1.0078 |
1547 |
100 |
TEST_TIME |
84 |
5294.88 |
0.9904 |
1.0069 |
1251 |
100 |
TEST_TIME |
85 |
5311.08 |
0.9923 |
1.0071 |
1262 |
100 |
TEST_TIME |
86 |
5317.35 |
0.9942 |
1.0067 |
1259 |
100 |
TEST_TIME |
87 |
5323.41 |
0.9940 |
1.0064 |
1280 |
100 |
TEST_TIME |
88 |
5334.34 |
0.9931 |
1.0055 |
1175 |
100 |
TEST_TIME |
89 |
5330.60 |
0.9949 |
1.0056 |
1219 |
100 |
TEST_TIME |
90 |
5329.51 |
0.9946 |
1.0061 |
1050 |
100 |
TEST_TIME |
91 |
5323.79 |
0.9961 |
1.0018 |
1099 |
99 |
TEST_TIME |
92 |
5290.28 |
0.9972 |
1.0031 |
1158 |
90 |
TEST_TIME |
93 |
5287.98 |
0.9928 |
1.0045 |
1263 |
100 |
TEST_TIME |
94 |
5276.61 |
0.9960 |
1.0049 |
1412 |
94 |
TEST_TIME |
95 |
5300.36 |
0.9967 |
1.0020 |
1035 |
96 |
TEST_TIME |
96 |
5290.30 |
0.9934 |
1.0057 |
1383 |
98 |
TEST_TIME |
97 |
5288.08 |
0.9958 |
1.0039 |
1471 |
92 |
TEST_TIME |
98 |
5288.36 |
0.9936 |
1.0069 |
1216 |
94 |
TEST_TIME |
99 |
5279.96 |
0.9984 |
1.0020 |
1227 |
94 |
TEST_TIME |
100 |
5250.14 |
0.9977 |
1.0026 |
1036 |
77 |
TEST_TIME |
101 |
5236.08 |
0.9953 |
1.0057 |
980 |
94 |
TEST_TIME |
102 |
5230.10 |
0.9970 |
1.0033 |
1233 |
92 |
TEST_TIME |
103 |
5228.64 |
0.9938 |
1.0073 |
1081 |
97 |
TEST_TIME |
104 |
5237.11 |
0.9960 |
1.0029 |
1250 |
96 |
TEST_TIME |
105 |
5244.57 |
0.9920 |
1.0066 |
991 |
100 |
TEST_TIME |
106 |
5254.83 |
0.9951 |
1.0051 |
1254 |
100 |
TEST_TIME |
107 |
5259.79 |
0.9947 |
1.0055 |
1287 |
100 |
TEST_TIME |
108 |
5261.67 |
0.9959 |
1.0035 |
1882 |
100 |
TEST_TIME |
109 |
5252.63 |
0.9960 |
1.0075 |
1321 |
92 |
TEST_TIME |
110 |
5268.27 |
0.9954 |
1.0027 |
1309 |
97 |
TEST_TIME |
111 |
5265.25 |
0.9942 |
1.0074 |
1276 |
97 |
TEST_TIME |
112 |
5284.92 |
0.9947 |
1.0052 |
1357 |
100 |
TEST_TIME |
113 |
5312.29 |
0.9912 |
1.0055 |
1367 |
99 |
TEST_TIME |
114 |
5319.59 |
0.9953 |
1.0050 |
950 |
100 |
TEST_TIME |
115 |
5337.87 |
0.9929 |
1.0038 |
1123 |
100 |
TEST_TIME |
116 |
5325.67 |
0.9974 |
1.0056 |
1239 |
99 |
TEST_TIME |
117 |
5332.19 |
0.9958 |
1.0043 |
1205 |
100 |
TEST_TIME |
118 |
5331.83 |
0.9959 |
1.0043 |
1343 |
100 |
TEST_TIME |
119 |
5337.58 |
0.9948 |
1.0034 |
1126 |
100 |
TEST_TIME |
120 |
5340.93 |
0.9947 |
1.0052 |
1073 |
100 |
TEST_TIME |
121 |
5347.33 |
0.9957 |
1.0037 |
1120 |
100 |
TEST_TIME |
122 |
5341.09 |
0.9972 |
1.0035 |
1151 |
99 |
TEST_TIME |
123 |
5331.29 |
0.9974 |
1.0044 |
1781 |
98 |
TEST_TIME |
124 |
5343.43 |
0.9940 |
1.0031 |
1440 |
97 |
TEST_TIME |
125 |
5347.13 |
0.9952 |
1.0026 |
1643 |
100 |
TEST_TIME |
126 |
5337.37 |
0.9964 |
1.0049 |
1451 |
95 |
TEST_TIME |
127 |
5338.18 |
0.9968 |
1.0064 |
1225 |
99 |
TEST_TIME |
128 |
5343.31 |
0.9976 |
1.0035 |
1451 |
100 |
TEST_TIME |
129 |
5342.92 |
0.9970 |
1.0023 |
1456 |
100 |
TEST_TIME |
130 |
5336.68 |
0.9957 |
1.0037 |
1456 |
98 |
TEST_TIME |
131 |
5326.53 |
0.9979 |
1.0021 |
1326 |
85 |
TEST_TIME |
132 |
5318.62 |
0.9960 |
1.0060 |
1077 |
96 |
TEST_TIME |
133 |
5326.17 |
0.9971 |
1.0030 |
1106 |
100 |
TEST_TIME |
134 |
5329.09 |
0.9950 |
1.0045 |
1074 |
100 |
TEST_TIME |
135 |
5329.90 |
0.9969 |
1.0033 |
985 |
100 |
TEST_TIME |
136 |
5334.34 |
0.9951 |
1.0030 |
1066 |
99 |
TEST_TIME |
137 |
5334.79 |
0.9956 |
1.0041 |
1025 |
100 |
TEST_TIME |
138 |
5335.58 |
0.9967 |
1.0020 |
1313 |
100 |
TEST_TIME |
139 |
5332.15 |
0.9955 |
1.0043 |
1495 |
97 |
TEST_TIME |
140 |
5334.83 |
0.9967 |
1.0047 |
1528 |
93 |
TEST_TIME |
141 |
5341.84 |
0.9963 |
1.0028 |
1468 |
96 |
TEST_TIME |
142 |
5334.61 |
0.9971 |
1.0039 |
1517 |
94 |
TEST_TIME |
143 |
5332.72 |
0.9972 |
1.0026 |
1407 |
90 |
TEST_TIME |
144 |
5324.96 |
0.9971 |
1.0037 |
1309 |
86 |
TEST_TIME |
145 |
5319.16 |
0.9978 |
1.0028 |
1116 |
86 |
TEST_TIME |
146 |
5316.68 |
0.9964 |
1.0018 |
1071 |
97 |
TEST_TIME |
147 |
5310.70 |
0.9961 |
1.0019 |
1184 |
98 |
TEST_TIME |
148 |
5294.10 |
0.9983 |
1.0015 |
1261 |
90 |
TEST_TIME |
149 |
5287.35 |
0.9961 |
1.0031 |
1147 |
96 |
TEST_TIME |
150 |
5282.55 |
0.9973 |
1.0029 |
1160 |
100 |
TEST_TIME |
151 |
5271.24 |
0.9984 |
1.0012 |
1293 |
97 |
TEST_TIME |
152 |
5261.85 |
0.9964 |
1.0025 |
1146 |
96 |
TEST_TIME |
153 |
5248.74 |
0.9984 |
1.0024 |
1235 |
89 |
TEST_TIME |
154 |
5247.76 |
0.9961 |
1.0027 |
1467 |
89 |
TEST_TIME |
155 |
5248.10 |
0.9962 |
1.0041 |
1324 |
90 |
TEST_TIME |
156 |
5260.08 |
0.9954 |
1.0016 |
1304 |
94 |
TEST_TIME |
157 |
5246.68 |
0.9978 |
1.0028 |
1421 |
89 |
TEST_TIME |
158 |
5244.64 |
0.9968 |
1.0056 |
1170 |
86 |
TEST_TIME |
159 |
5249.39 |
0.9983 |
1.0013 |
1133 |
83 |
TEST_TIME |
160 |
5241.07 |
0.9966 |
1.0018 |
1165 |
79 |
TEST_TIME |
161 |
5234.39 |
0.9978 |
1.0019 |
1159 |
94 |
TEST_TIME |
162 |
5229.16 |
0.9977 |
1.0031 |
1199 |
92 |
TEST_TIME |
163 |
5222.73 |
0.9981 |
1.0023 |
1211 |
90 |
TEST_TIME |
164 |
5215.67 |
0.9976 |
1.0020 |
1171 |
82 |
TEST_TIME |
165 |
5205.57 |
0.9979 |
1.0021 |
1126 |
83 |
TEST_TIME |
166 |
5201.35 |
0.9969 |
1.0047 |
723 |
85 |
TEST_TIME |
167 |
5209.87 |
0.9971 |
1.0032 |
785 |
100 |
TEST_TIME |
168 |
5214.75 |
0.9963 |
1.0032 |
1398 |
100 |
TEST_TIME |
169 |
5212.04 |
0.9978 |
1.0039 |
1590 |
95 |
TEST_TIME |
170 |
5213.39 |
0.9977 |
1.0026 |
1314 |
91 |
TEST_TIME |
171 |
5224.87 |
0.9970 |
1.0019 |
1307 |
90 |
TEST_TIME |
172 |
5221.47 |
0.9967 |
1.0047 |
1209 |
100 |
TEST_TIME |
173 |
5225.55 |
0.9981 |
1.0015 |
1532 |
100 |
TEST_TIME |
174 |
5211.86 |
0.9983 |
1.0021 |
1385 |
93 |
TEST_TIME |
175 |
5207.22 |
0.9973 |
1.0052 |
1208 |
94 |
TEST_TIME |
176 |
5210.27 |
0.9989 |
1.0038 |
1264 |
91 |
TEST_TIME |
177 |
5212.92 |
0.9978 |
1.0013 |
690 |
100 |
TEST_TIME |
178 |
5201.56 |
0.9978 |
1.0025 |
1365 |
96 |
TEST_TIME |
179 |
5192.31 |
0.9987 |
1.0016 |
1212 |
89 |
TEST_TIME |
180 |
5184.97 |
0.9975 |
1.0028 |
625 |
96 |
Done for 8130 ms, from 11:28:10.88 to 11:28:19.01.
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 |
77734 |
111793 |
65140 |
<null> |
61115 |
72210 |
75533 |
<null> |
79241 |
210750 |
95568 |
84314 |
80076 |
82091 |
187250 |
105574 |
129671 |
111600 |
<null> |
08:16:39 |
08:34:38 |
fetches per second |
2 |
46847 |
48310 |
72817 |
101546 |
50784 |
22661 |
61090 |
<null> |
33413 |
82917 |
61200 |
30445 |
100879 |
90849 |
156494 |
170833 |
145117 |
132221 |
<null> |
08:34:39 |
08:52:38 |
fetches per second |
3 |
39456 |
36674 |
10268 |
<null> |
32391 |
<null> |
66102 |
94671 |
56182 |
64576 |
42697 |
46944 |
69909 |
3163 |
112578 |
17725 |
147993 |
<null> |
<null> |
08:52:39 |
09:10:38 |
fetches per second |
4 |
50409 |
94270 |
75471 |
<null> |
25506 |
93824 |
76329 |
85704 |
36437 |
50168 |
64514 |
48037 |
54406 |
92352 |
90865 |
115818 |
310673 |
<null> |
<null> |
09:10:39 |
09:28:38 |
fetches per second |
5 |
64434 |
96083 |
62341 |
<null> |
46704 |
146362 |
92376 |
106007 |
31628 |
207485 |
85543 |
56512 |
121819 |
98109 |
119247 |
<null> |
190959 |
65266 |
<null> |
09:28:39 |
09:46:38 |
fetches per second |
6 |
11819 |
3971 |
17493 |
<null> |
4795 |
1041 |
15757 |
3758 |
10630 |
4039 |
4877 |
2169 |
33231 |
5190 |
13134 |
7292 |
<null> |
39809 |
<null> |
09:46:39 |
10:04:38 |
fetches per second |
7 |
35624 |
45781 |
19011 |
<null> |
27312 |
<null> |
32898 |
102293 |
49926 |
<null> |
30404 |
11351 |
29807 |
18349 |
57981 |
5553 |
19705 |
57052 |
<null> |
10:04:39 |
10:22:38 |
fetches per second |
8 |
17176 |
4377 |
15733 |
61902 |
19131 |
275500 |
35163 |
4915 |
2392 |
<null> |
22121 |
14124 |
29278 |
3471 |
31371 |
<null> |
55913 |
<null> |
<null> |
10:22:39 |
10:40:38 |
fetches per second |
9 |
2071 |
2742 |
4226 |
6768 |
4569 |
<null> |
3429 |
<null> |
4674 |
4105 |
2504 |
1957 |
3399 |
4728 |
5236 |
3575 |
7911 |
402446 |
<null> |
10:40:39 |
10:58:38 |
fetches per second |
10 |
9333 |
32689 |
7194 |
<null> |
8960 |
<null> |
14171 |
2566 |
11697 |
3554 |
14738 |
1297 |
16732 |
4005 |
21923 |
1502 |
72955 |
62687 |
<null> |
10:58:39 |
11:16:38 |
marks per second |
1 |
17449 |
14236 |
14861 |
<null> |
14194 |
17355 |
12400 |
<null> |
11423 |
40500 |
17984 |
14356 |
7994 |
13556 |
6926 |
17278 |
24580 |
8400 |
<null> |
08:16:39 |
08:34:38 |
marks per second |
2 |
10349 |
6877 |
16697 |
21065 |
11341 |
4840 |
8110 |
<null> |
5745 |
14358 |
11668 |
4709 |
5482 |
16783 |
3223 |
32472 |
20743 |
15270 |
<null> |
08:34:39 |
08:52:38 |
marks per second |
3 |
8820 |
5381 |
2207 |
<null> |
7452 |
<null> |
8314 |
15958 |
8305 |
9461 |
6249 |
7810 |
2677 |
529 |
2287 |
3698 |
20355 |
<null> |
<null> |
08:52:39 |
09:10:38 |
marks per second |
4 |
10663 |
12959 |
16944 |
<null> |
5533 |
22228 |
11343 |
14000 |
5588 |
8566 |
8864 |
8465 |
1506 |
15996 |
1461 |
11426 |
37124 |
<null> |
<null> |
09:10:39 |
09:28:38 |
marks per second |
5 |
13384 |
11905 |
14163 |
<null> |
10826 |
36221 |
12954 |
17679 |
4580 |
35028 |
14838 |
9557 |
4251 |
12276 |
1796 |
<null> |
29675 |
8400 |
<null> |
09:28:39 |
09:46:38 |
marks per second |
6 |
2595 |
502 |
3673 |
<null> |
774 |
264 |
1991 |
610 |
1980 |
659 |
783 |
425 |
1237 |
1372 |
771 |
1070 |
<null> |
864 |
<null> |
09:46:39 |
10:04:38 |
marks per second |
7 |
7335 |
6060 |
3935 |
<null> |
6124 |
<null> |
5242 |
17696 |
6348 |
<null> |
4470 |
1405 |
1500 |
2748 |
3142 |
815 |
998 |
827 |
<null> |
10:04:39 |
10:22:38 |
marks per second |
8 |
3804 |
582 |
2782 |
15985 |
4231 |
55571 |
4830 |
822 |
240 |
<null> |
3357 |
2054 |
1096 |
509 |
563 |
<null> |
10907 |
<null> |
<null> |
10:22:39 |
10:40:38 |
marks per second |
9 |
442 |
377 |
716 |
1662 |
763 |
<null> |
514 |
<null> |
743 |
732 |
442 |
298 |
80 |
732 |
155 |
566 |
1268 |
1745 |
<null> |
10:40:39 |
10:58:38 |
marks per second |
10 |
1971 |
3441 |
1392 |
<null> |
1829 |
<null> |
1656 |
392 |
1579 |
695 |
3317 |
213 |
813 |
680 |
575 |
221 |
1441 |
934 |
<null> |
10:58:39 |
11:16:38 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:16:39 |
08:34:38 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:34:39 |
08:52:38 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
08:52:39 |
09:10:38 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
09:10:39 |
09:28:38 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
09:28:39 |
09:46:38 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
09:46:39 |
10:04:38 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:04:39 |
10:22:38 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
<null> |
10:22:39 |
10:40:38 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:40:39 |
10:58:38 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:58:39 |
11:16:38 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
08:16:39 |
08:34:38 |
writes/marks*100 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:34:39 |
08:52:38 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
<null> |
<null> |
08:52:39 |
09:10:38 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
09:10:39 |
09:28:38 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
2 |
0 |
<null> |
09:28:39 |
09:46:38 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
<null> |
09:46:39 |
10:04:38 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
7 |
1 |
<null> |
10:04:39 |
10:22:38 |
writes/marks*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
<null> |
<null> |
10:22:39 |
10:40:38 |
writes/marks*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
2 |
0 |
<null> |
10:40:39 |
10:58:38 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
10:58:39 |
11:16:38 |
Done for 8480 ms, from 11:28:19.67 to 11:28:28.15.
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 |
1641283 |
1514720 |
126563 |
7.71 |
0 |
26339 |
68 |
126563 |
2017-07-27 08:16 |
2017-07-27 11:16 |
doc_list_biud |
1641704 |
1514720 |
126984 |
7.73 |
0 |
12091 |
15 |
126984 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_add_invoice_to_stock |
16785 |
9870 |
6915 |
41.19 |
15 |
210820 |
10872 |
6915 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_cancel_adding_invoice |
3656 |
2832 |
824 |
22.53 |
0 |
104651 |
3001 |
824 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_cancel_client_order |
5868 |
5756 |
112 |
1.90 |
0 |
8246 |
229 |
112 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_cancel_customer_reserve |
287882 |
170500 |
117382 |
40.77 |
0 |
11983 |
63 |
117382 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_cancel_pay_from_customer |
2216 |
2208 |
8 |
0.36 |
0 |
3639 |
117 |
8 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_cancel_pay_to_supplier |
1388 |
1387 |
1 |
0.07 |
0 |
5298 |
107 |
1 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_cancel_supplier_invoice |
8442 |
6402 |
2040 |
24.16 |
0 |
11556 |
393 |
2040 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_cancel_supplier_order |
1360 |
436 |
924 |
67.94 |
44 |
183363 |
17610 |
924 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_cancel_write_off |
20621 |
13257 |
7364 |
35.71 |
0 |
10255 |
144 |
7364 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_client_order |
70255 |
70255 |
0 |
0.00 |
0 |
14133 |
428 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_customer_reserve |
537160 |
537160 |
0 |
0.00 |
0 |
24072 |
164 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_fill_shopping_cart |
106588 |
106334 |
254 |
0.23 |
0 |
9689 |
86 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_fill_shopping_cart_clo_res |
537160 |
537160 |
0 |
0.00 |
0 |
6005 |
13 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_get_clo_for_invoice |
9870 |
9870 |
0 |
0.00 |
0 |
13640 |
314 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_kill_cost_storno |
27525 |
19684 |
7841 |
28.48 |
0 |
2590 |
11 |
7841 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_kill_qstorno_ret_qs2qd |
604560 |
361095 |
243465 |
40.27 |
0 |
11317 |
22 |
243465 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_kill_qty_storno |
368731 |
241811 |
126920 |
34.42 |
0 |
12077 |
67 |
126920 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_lock_selected_doc |
69070 |
59720 |
9350 |
13.53 |
0 |
1604 |
6 |
9350 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_make_cost_storno |
85632 |
85632 |
0 |
0.00 |
0 |
26261 |
781 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_multiply_rows_for_pdistr |
85632 |
85632 |
0 |
0.00 |
0 |
14744 |
44 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_multiply_rows_for_qdistr |
70255 |
70255 |
0 |
0.00 |
0 |
12506 |
139 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_pay_from_customer |
23551 |
23551 |
0 |
0.00 |
13 |
26446 |
1279 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_pay_to_supplier |
19453 |
19453 |
0 |
0.00 |
0 |
25936 |
1867 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_payment_common |
43004 |
43004 |
0 |
0.00 |
0 |
5282 |
56 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_qd_handle_on_cancel_clo |
5865 |
5756 |
109 |
1.85 |
0 |
7174 |
96 |
109 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_qd_handle_on_invoice_upd_sts |
13344 |
12702 |
642 |
4.81 |
0 |
12064 |
322 |
642 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_qd_handle_on_reserve_upd_sts |
32758 |
32758 |
0 |
0.00 |
0 |
6051 |
42 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_reserve_write_off |
33279 |
32758 |
521 |
1.56 |
0 |
17409 |
428 |
521 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_supplier_invoice |
18157 |
18061 |
96 |
0.52 |
5 |
33393 |
2632 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
sp_supplier_order |
18176 |
18018 |
158 |
0.86 |
0 |
27972 |
1846 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
srv_find_qd_qs_mism |
981539 |
854966 |
126573 |
12.89 |
0 |
13917 |
26 |
126573 |
2017-07-27 08:16 |
2017-07-27 11:16 |
srv_make_invnt_saldo |
1514 |
1514 |
0 |
0.00 |
5 |
35549 |
2625 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
srv_make_money_saldo |
2562 |
2562 |
0 |
0.00 |
0 |
3601 |
74 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
1892 |
38241 |
7254 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_add_invoice_to_stock |
6915 |
6915 |
0 |
0.00 |
0 |
11711 |
89 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_cancel_adding_invoice |
671 |
671 |
0 |
0.00 |
0 |
1715 |
150 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_cancel_client_order |
112 |
112 |
0 |
0.00 |
0 |
1051 |
84 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_cancel_customer_reserve |
41 |
41 |
0 |
0.00 |
0 |
613 |
50 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_cancel_pay_from_customer |
8 |
8 |
0 |
0.00 |
1 |
32 |
12 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_cancel_pay_to_supplier |
1 |
1 |
0 |
0.00 |
4 |
4 |
4 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_cancel_supplier_invoice |
577 |
577 |
0 |
0.00 |
0 |
2004 |
67 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_cancel_supplier_order |
14490 |
14490 |
0 |
0.00 |
0 |
13252 |
74 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_cancel_write_off |
16 |
16 |
0 |
0.00 |
1 |
225 |
51 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_reserve_write_off |
521 |
521 |
0 |
0.00 |
0 |
3811 |
72 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_supplier_invoice |
96 |
96 |
0 |
0.00 |
1 |
499 |
40 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-abend:sp_supplier_order |
158 |
158 |
0 |
0.00 |
0 |
5441 |
85 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_add_invoice_to_stock |
9870 |
9870 |
0 |
0.00 |
0 |
13738 |
543 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_cancel_adding_invoice |
1135 |
1135 |
0 |
0.00 |
1 |
11599 |
665 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_cancel_client_order |
5756 |
5756 |
0 |
0.00 |
0 |
13102 |
52 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_cancel_customer_reserve |
2118 |
2118 |
0 |
0.00 |
0 |
1800 |
44 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_cancel_pay_from_customer |
2208 |
2208 |
0 |
0.00 |
0 |
1555 |
36 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_cancel_pay_to_supplier |
1387 |
1387 |
0 |
0.00 |
0 |
1201 |
32 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_cancel_supplier_invoice |
809 |
809 |
0 |
0.00 |
0 |
1841 |
57 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_cancel_supplier_order |
436 |
436 |
0 |
0.00 |
2 |
41609 |
1332 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_cancel_write_off |
3243 |
3243 |
0 |
0.00 |
0 |
2910 |
48 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_client_order |
70255 |
70255 |
0 |
0.00 |
0 |
20526 |
56 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_customer_reserve |
3211 |
3211 |
0 |
0.00 |
0 |
1986 |
38 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_pay_from_customer |
23551 |
23551 |
0 |
0.00 |
0 |
11930 |
52 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_pay_to_supplier |
19453 |
19453 |
0 |
0.00 |
0 |
9882 |
54 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_reserve_write_off |
32758 |
32758 |
0 |
0.00 |
0 |
14316 |
52 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_supplier_invoice |
18061 |
18061 |
0 |
0.00 |
0 |
6824 |
52 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:sp_supplier_order |
18018 |
18018 |
0 |
0.00 |
0 |
11983 |
59 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:srv_make_invnt_saldo |
1514 |
1514 |
0 |
0.00 |
0 |
3844 |
22 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:srv_make_money_saldo |
2562 |
2562 |
0 |
0.00 |
0 |
1244 |
20 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
4 |
321 |
51 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_add_invoice_to_stock |
33570 |
19740 |
13830 |
41.19 |
0 |
4593 |
23 |
13830 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_all_customers |
105302 |
105302 |
0 |
0.00 |
0 |
1074 |
5 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_all_suppliers |
72666 |
72158 |
508 |
0.69 |
0 |
2502 |
5 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_all_wares |
140510 |
140510 |
0 |
0.00 |
0 |
2298 |
4 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_cancel_adding_invoice |
2740 |
2270 |
470 |
17.15 |
0 |
16412 |
162 |
470 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_cancel_client_order |
11736 |
11512 |
224 |
1.90 |
0 |
2145 |
6 |
224 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_cancel_customer_prepayment |
4432 |
4416 |
16 |
0.36 |
0 |
1724 |
8 |
16 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_cancel_customer_reserve |
4318 |
4236 |
82 |
1.89 |
0 |
1306 |
7 |
82 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_cancel_payment_to_supplier |
2776 |
2774 |
2 |
0.07 |
0 |
1272 |
8 |
2 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_cancel_supplier_invoice |
2772 |
1618 |
1154 |
41.63 |
0 |
2992 |
25 |
1154 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_cancel_supplier_order |
2720 |
872 |
1848 |
67.94 |
0 |
242 |
5 |
1848 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_cancel_write_off |
6518 |
6486 |
32 |
0.49 |
0 |
8467 |
96 |
32 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_max_id_clo_ord |
18176 |
18018 |
158 |
0.86 |
0 |
1336 |
5 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_max_id_clo_res |
3211 |
3211 |
0 |
0.00 |
0 |
2412 |
15 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_max_id_ord_sup |
18157 |
18061 |
96 |
0.52 |
0 |
897 |
5 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_max_non_paid_invoice |
19453 |
19453 |
0 |
0.00 |
0 |
728 |
5 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_max_non_paid_realizn |
23551 |
23551 |
0 |
0.00 |
0 |
1126 |
5 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_min_id_clo_ord |
18176 |
18018 |
158 |
0.86 |
0 |
4285 |
6 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_min_id_clo_res |
3211 |
3211 |
0 |
0.00 |
0 |
2159 |
10 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_min_id_ord_sup |
18157 |
18061 |
96 |
0.52 |
0 |
3075 |
7 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_min_non_paid_invoice |
19453 |
19453 |
0 |
0.00 |
0 |
1047 |
5 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_min_non_paid_realizn |
23551 |
23551 |
0 |
0.00 |
0 |
789 |
5 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_our_firm |
35208 |
35208 |
0 |
0.00 |
0 |
1074 |
5 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
v_reserve_write_off |
66558 |
65516 |
1042 |
1.56 |
0 |
1722 |
7 |
1042 |
2017-07-27 08:16 |
2017-07-27 11:16 |
x_lock_depdocs_on_canc_invoice |
16094 |
8425 |
7669 |
47.65 |
0 |
1495 |
28 |
7669 |
2017-07-27 08:16 |
2017-07-27 11:16 |
x_lock_depdocs_on_canc_sup_ord |
1360 |
436 |
924 |
67.94 |
0 |
1324 |
42 |
924 |
2017-07-27 08:16 |
2017-07-27 11:16 |
x_make_qstorno_1000_1200 |
18176 |
18018 |
158 |
0.86 |
0 |
26431 |
1655 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
x_make_qstorno_1200_2000 |
18157 |
18061 |
96 |
0.52 |
0 |
32953 |
2441 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
x_make_qstorno_2100_3300 |
537160 |
537160 |
0 |
0.00 |
0 |
24053 |
135 |
0 |
2017-07-27 08:16 |
2017-07-27 11:16 |
Done for 251720 ms, from 11:32:00.64 to 11:36:12.36.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
35 |
sp_kill_cost_storno |
335544336 |
2017-07-27 08:20 |
2017-07-27 11:02 |
deadlock |
93 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-07-27 08:17 |
2017-07-27 11:16 |
deadlock |
8077 |
sp_lock_selected_doc |
335544336 |
2017-07-27 08:16 |
2017-07-27 11:16 |
deadlock |
109 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-07-27 08:19 |
2017-07-27 11:15 |
deadlock |
168 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-07-27 08:17 |
2017-07-27 11:13 |
deadlock |
617 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-07-27 08:16 |
2017-07-27 11:16 |
deadlock |
241 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-07-27 08:17 |
2017-07-27 11:16 |
user_exc |
158 |
x_make_qstorno_1000_1200 |
335544517 |
2017-07-27 08:17 |
2017-07-27 11:14 |
user_exc |
96 |
x_make_qstorno_1200_2000 |
335544517 |
2017-07-27 08:19 |
2017-07-27 11:14 |
Done for 8920 ms, from 11:36:20.38 to 11:36:29.30.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 393065
MON$OLDEST_ACTIVE 393066
MON$OLDEST_SNAPSHOT 393066
MON$NEXT_TRANSACTION 393066
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 754336
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.700 Firebird 4.0 Alpha 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.700 Firebird 4.0 Alpha 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.700 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.700 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 393108
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 393067
Oldest active 393068
Oldest snapshot 393068
Next transaction 393069
Sequence number 0
Next attachment ID 9219
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.27
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 339, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 338, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.00, total records: 1943377
Average version length: 47.61, total versions: 1334, 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: 13, data page slots: 20920
Data pages: 20920, average fill: 73%
Primary pages: 20920, secondary pages: 0, swept pages: 12260
Empty pages: 7, full pages: 19637
Fill distribution:
0 - 19% = 7
20 - 39% = 3
40 - 59% = 30
60 - 79% = 20878
80 - 99% = 2
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 9181, nodes: 1943377
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: 339317, ratio: 0.17
Fill distribution:
0 - 19% = 745
20 - 39% = 1925
40 - 59% = 3892
60 - 79% = 1040
80 - 99% = 1579
Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 6876, nodes: 1943377
Average node length: 11.66, total dup: 0, max dup: 0
Average key length: 8.71, compression ratio: 1.03
Average prefix length: 3.29, average data length: 5.71
Clustering factor: 323892, ratio: 0.17
Fill distribution:
0 - 19% = 4
20 - 39% = 2887
40 - 59% = 3898
60 - 79% = 81
80 - 99% = 6
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 170571, depth: 3, leaf buckets: 3176, nodes: 1943377
Average node length: 6.78, total dup: 1427442, max dup: 49
Average key length: 3.83, compression ratio: 2.35
Average prefix length: 7.43, average data length: 1.57
Clustering factor: 307361, ratio: 0.16
Fill distribution:
0 - 19% = 106
20 - 39% = 878
40 - 59% = 1338
60 - 79% = 292
80 - 99% = 562
DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.42, total records: 575497
Average version length: 61.61, total versions: 266, max versions: 2
Average fragment length: 8.00, total fragments: 1, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7248
Data pages: 7248, average fill: 75%
Primary pages: 7247, secondary pages: 1, swept pages: 6763
Empty pages: 4, full pages: 7005
Fill distribution:
0 - 19% = 5
20 - 39% = 5
40 - 59% = 9
60 - 79% = 7217
80 - 99% = 12
Index DOC_LIST_ID_DESC (1)
Root page: 250676, depth: 3, leaf buckets: 2089, nodes: 575497
Average node length: 11.69, 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: 120881, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 1042
40 - 59% = 1009
60 - 79% = 36
80 - 99% = 2
Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 600, nodes: 575497
Average node length: 4.86, total dup: 575447, max dup: 39677
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 257438, ratio: 0.45
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 503
60 - 79% = 80
80 - 99% = 16
Index PK_DOC_LIST (0)
Root page: 341899, depth: 3, leaf buckets: 1589, nodes: 575497
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.16, average data length: 5.84
Clustering factor: 120881, ratio: 0.21
Fill distribution:
0 - 19% = 106
20 - 39% = 323
40 - 59% = 628
60 - 79% = 261
80 - 99% = 271
DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 343, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 63.80, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 16.36, total fragments: 367, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.63
Pointer pages: 1, data page slots: 560
Data pages: 20, average fill: 31%
Primary pages: 7, secondary pages: 13, swept pages: 4
Empty pages: 7, full pages: 3
Fill distribution:
0 - 19% = 9
20 - 39% = 5
40 - 59% = 2
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 285, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 55.87, total records: 6187
Average version length: 71.04, total versions: 1333, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.72
Pointer pages: 1, data page slots: 504
Data pages: 328, average fill: 23%
Primary pages: 327, secondary pages: 1, swept pages: 222
Empty pages: 86, full pages: 15
Fill distribution:
0 - 19% = 198
20 - 39% = 54
40 - 59% = 34
60 - 79% = 36
80 - 99% = 6
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 26, nodes: 6187
Average node length: 14.68, total dup: 112, max dup: 1
Average key length: 12.71, compression ratio: 2.13
Average prefix length: 17.27, average data length: 9.73
Clustering factor: 5021, ratio: 0.81
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 10
60 - 79% = 4
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 14.94, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 1.00, total fragments: 1, max fragments: 1
Average unpacked length: 32.00, compression ratio: 2.14
Pointer pages: 1, data page slots: 16
Data pages: 9, average fill: 4%
Primary pages: 1, secondary pages: 8, swept pages: 1
Empty pages: 7, full pages: 0
Fill distribution:
0 - 19% = 8
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 25.61, total records: 176
Average version length: 45.35, total versions: 79, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 2.50
Pointer pages: 1, data page slots: 32
Data pages: 24, average fill: 8%
Primary pages: 23, secondary pages: 1, swept pages: 15
Empty pages: 13, full pages: 1
Fill distribution:
0 - 19% = 22
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 309600, depth: 2, leaf buckets: 1, nodes: 176
Average node length: 7.46, total dup: 130, max dup: 17
Average key length: 5.91, compression ratio: 3.22
Average prefix length: 15.35, average data length: 3.65
Clustering factor: 73, ratio: 0.41
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 356, Index root page: 357
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 241, Index root page: 242
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 244, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 243, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 20.64, total records: 824071
Average version length: 42.70, total versions: 319, max versions: 12
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.10
Pointer pages: 4, data page slots: 5064
Data pages: 5064, average fill: 75%
Primary pages: 5062, secondary pages: 2, swept pages: 4249
Empty pages: 5, full pages: 4585
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 14
60 - 79% = 4472
80 - 99% = 572
Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 304, nodes: 285865
Average node length: 4.88, total dup: 285816, max dup: 16067
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 39413, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 35
40 - 59% = 155
60 - 79% = 100
80 - 99% = 13
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 327, nodes: 285865
Average node length: 5.81, total dup: 258258, max dup: 81
Average key length: 2.93, compression ratio: 7.50
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 44549, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 25
40 - 59% = 120
60 - 79% = 130
80 - 99% = 51
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 331, nodes: 285865
Average node length: 5.81, total dup: 258258, max dup: 81
Average key length: 2.93, compression ratio: 7.50
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 44583, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 31
40 - 59% = 122
60 - 79% = 121
80 - 99% = 57
Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 332, nodes: 285865
Average node length: 5.60, total dup: 258258, max dup: 81
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 44557, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 43
40 - 59% = 137
60 - 79% = 104
80 - 99% = 48
PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.98, total records: 233709
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: 2000
Data pages: 2000, average fill: 64%
Primary pages: 2000, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 1997
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1997
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 220226, depth: 2, leaf buckets: 183, nodes: 233709
Average node length: 4.45, total dup: 233528, max dup: 1881
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 32364, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 48
60 - 79% = 85
80 - 99% = 50
PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 349, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 152.73, total records: 10273762
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.10
Pointer pages: 151, data page slots: 244904
Data pages: 244904, average fill: 87%
Primary pages: 244904, secondary pages: 0, swept pages: 3
Empty pages: 1, full pages: 244902
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 244902
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 12927, nodes: 10273762
Average node length: 6.01, total dup: 5466818, max dup: 133
Average key length: 2.59, compression ratio: 3.09
Average prefix length: 7.46, average data length: 0.53
Clustering factor: 5578081, ratio: 0.54
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 8336
60 - 79% = 2971
80 - 99% = 1616
Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 10045, nodes: 10273762
Average node length: 4.51, total dup: 10273758, max dup: 9340106
Average key length: 1.09, compression ratio: 0.42
Average prefix length: 0.45, average data length: 0.00
Clustering factor: 294848, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 10040
60 - 79% = 1
80 - 99% = 3
Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 12562, nodes: 10273762
Average node length: 5.66, total dup: 9944958, max dup: 25218
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 727856, ratio: 0.07
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 9728
60 - 79% = 1561
80 - 99% = 1269
Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 12281, nodes: 10273762
Average node length: 5.58, total dup: 10153115, max dup: 727653
Average key length: 2.16, compression ratio: 17.48
Average prefix length: 37.66, average data length: 0.15
Clustering factor: 7175862, ratio: 0.70
Fill distribution:
0 - 19% = 25
20 - 39% = 4
40 - 59% = 9767
60 - 79% = 1107
80 - 99% = 1378
PHRASES (145)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 283, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 54.59, total records: 306501
Average version length: 55.08, total versions: 160, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.47
Pointer pages: 3, data page slots: 3608
Data pages: 3608, average fill: 75%
Primary pages: 3608, secondary pages: 0, swept pages: 2413
Empty pages: 6, full pages: 3507
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 3
60 - 79% = 3598
80 - 99% = 0
Index PSTORNED_RCV_ID (2)
Root page: 1549, depth: 2, leaf buckets: 439, nodes: 306501
Average node length: 6.13, total dup: 245752, max dup: 999
Average key length: 3.44, compression ratio: 2.62
Average prefix length: 7.76, average data length: 1.24
Clustering factor: 37370, ratio: 0.12
Fill distribution:
0 - 19% = 5
20 - 39% = 15
40 - 59% = 338
60 - 79% = 57
80 - 99% = 24
Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 320, nodes: 306501
Average node length: 5.47, total dup: 275024, max dup: 240
Average key length: 2.78, compression ratio: 3.24
Average prefix length: 8.32, average data length: 0.68
Clustering factor: 69378, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 143
60 - 79% = 115
80 - 99% = 57
RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 310, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 245, Index root page: 246
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 248, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 247, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 330, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 331, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 218, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 226, Index root page: 227
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 219, Index root page: 220
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 222, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 221, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 211, Index root page: 212
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 215, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.59, total records: 2356
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.53
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 67%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 28
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 0
60 - 79% = 28
80 - 99% = 0
WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 45.76, total records: 6930
Average version length: 72.27, total versions: 2539, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.97
Pointer pages: 2, data page slots: 1096
Data pages: 433, average fill: 20%
Primary pages: 432, secondary pages: 1, swept pages: 336
Empty pages: 207, full pages: 40
Fill distribution:
0 - 19% = 287
20 - 39% = 48
40 - 59% = 37
60 - 79% = 46
80 - 99% = 15
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 13, nodes: 6930
Average node length: 6.65, total dup: 5967, max dup: 14
Average key length: 4.65, compression ratio: 7.95
Average prefix length: 34.48, average data length: 2.52
Clustering factor: 1150, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 5
60 - 79% = 2
80 - 99% = 0
XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.86, total records: 858503
Average version length: 71.84, total versions: 3900, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 8, data page slots: 12728
Data pages: 12728, average fill: 74%
Primary pages: 12728, secondary pages: 0, swept pages: 8452
Empty pages: 4, full pages: 9799
Fill distribution:
0 - 19% = 10
20 - 39% = 64
40 - 59% = 459
60 - 79% = 12150
80 - 99% = 45
Index XQD_1000_3300_DOC (1)
Root page: 513307, depth: 3, leaf buckets: 948, nodes: 858503
Average node length: 5.10, total dup: 836256, max dup: 119
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 97319, ratio: 0.11
Fill distribution:
0 - 19% = 8
20 - 39% = 51
40 - 59% = 683
60 - 79% = 46
80 - 99% = 160
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 284584, depth: 3, leaf buckets: 1184, nodes: 858503
Average node length: 6.22, total dup: 750119, max dup: 29
Average key length: 3.31, compression ratio: 11.18
Average prefix length: 35.82, average data length: 1.18
Clustering factor: 166135, ratio: 0.19
Fill distribution:
0 - 19% = 15
20 - 39% = 83
40 - 59% = 792
60 - 79% = 177
80 - 99% = 117
XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 15.13, total records: 80839
Average version length: 72.11, total versions: 10707, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 8.99
Pointer pages: 3, data page slots: 3248
Data pages: 2904, average fill: 17%
Primary pages: 2903, secondary pages: 1, swept pages: 1744
Empty pages: 728, full pages: 112
Fill distribution:
0 - 19% = 2008
20 - 39% = 508
40 - 59% = 210
60 - 79% = 101
80 - 99% = 77
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 43, nodes: 20114
Average node length: 6.40, total dup: 17556, max dup: 49
Average key length: 3.83, compression ratio: 9.66
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 2247, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 27
40 - 59% = 12
60 - 79% = 2
80 - 99% = 1
XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 52.77, total records: 2013339
Average version length: 71.38, total versions: 26579, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.58
Pointer pages: 16, data page slots: 25760
Data pages: 25760, average fill: 68%
Primary pages: 25760, secondary pages: 0, swept pages: 11475
Empty pages: 157, full pages: 22390
Fill distribution:
0 - 19% = 283
20 - 39% = 3279
40 - 59% = 1795
60 - 79% = 17705
80 - 99% = 2698
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 142134, depth: 3, leaf buckets: 2196, nodes: 1425104
Average node length: 5.65, total dup: 1335496, max dup: 83
Average key length: 2.69, compression ratio: 13.78
Average prefix length: 36.38, average data length: 0.62
Clustering factor: 176997, ratio: 0.12
Fill distribution:
0 - 19% = 13
20 - 39% = 931
40 - 59% = 905
60 - 79% = 181
80 - 99% = 166
XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.01, total records: 3323092
Average version length: 70.99, total versions: 94, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.09
Pointer pages: 13, data page slots: 21088
Data pages: 21088, average fill: 50%
Primary pages: 21088, secondary pages: 0, swept pages: 7525
Empty pages: 8, full pages: 20544
Fill distribution:
0 - 19% = 87
20 - 39% = 7339
40 - 59% = 4764
60 - 79% = 8812
80 - 99% = 86
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 4, nodes: 727
Average node length: 13.00, total dup: 490, max dup: 13
Average key length: 10.00, compression ratio: 3.70
Average prefix length: 29.32, average data length: 7.68
Clustering factor: 181, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 63.10, total records: 2815462
Average version length: 70.74, total versions: 8589, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.16
Pointer pages: 23, data page slots: 36344
Data pages: 36344, average fill: 76%
Primary pages: 36344, secondary pages: 0, swept pages: 26078
Empty pages: 10, full pages: 34502
Fill distribution:
0 - 19% = 25
20 - 39% = 243
40 - 59% = 714
60 - 79% = 33251
80 - 99% = 2111
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 4978, nodes: 2454371
Average node length: 6.85, total dup: 1994866, max dup: 14
Average key length: 3.87, compression ratio: 9.55
Average prefix length: 35.31, average data length: 1.69
Clustering factor: 431881, ratio: 0.18
Fill distribution:
0 - 19% = 8
20 - 39% = 2521
40 - 59% = 2013
60 - 79% = 266
80 - 99% = 170
XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.41, total records: 4230069
Average version length: 84.19, total versions: 1143, 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: 40, data page slots: 64920
Data pages: 64920, average fill: 80%
Primary pages: 64920, secondary pages: 0, swept pages: 23129
Empty pages: 4, full pages: 64537
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 32
60 - 79% = 19475
80 - 99% = 45407
Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4358, nodes: 4230069
Average node length: 5.15, total dup: 4133747, max dup: 125
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 655812, ratio: 0.16
Fill distribution:
0 - 19% = 25
20 - 39% = 77
40 - 59% = 1971
60 - 79% = 1799
80 - 99% = 486
Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 4329, nodes: 4230069
Average node length: 5.71, total dup: 3781103, max dup: 49
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.38, average data length: 0.62
Clustering factor: 187165, ratio: 0.04
Fill distribution:
0 - 19% = 37
20 - 39% = 91
40 - 59% = 2063
60 - 79% = 277
80 - 99% = 1861
Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 4849, nodes: 4230069
Average node length: 5.81, total dup: 3700929, max dup: 27
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 708161, ratio: 0.17
Fill distribution:
0 - 19% = 33
20 - 39% = 79
40 - 59% = 2171
60 - 79% = 1884
80 - 99% = 682
XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 82.81, total records: 2319471
Average version length: 83.02, total versions: 5523, 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: 23, data page slots: 35960
Data pages: 35960, average fill: 79%
Primary pages: 35960, secondary pages: 0, swept pages: 26148
Empty pages: 14, full pages: 35045
Fill distribution:
0 - 19% = 25
20 - 39% = 26
40 - 59% = 153
60 - 79% = 14903
80 - 99% = 20853
Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2464, nodes: 2319471
Average node length: 5.15, total dup: 2265185, max dup: 187
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 342869, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 41
40 - 59% = 1437
60 - 79% = 717
80 - 99% = 268
Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 3742, nodes: 2319471
Average node length: 6.21, total dup: 1908673, max dup: 14
Average key length: 3.24, compression ratio: 2.78
Average prefix length: 7.94, average data length: 1.06
Clustering factor: 194210, ratio: 0.08
Fill distribution:
0 - 19% = 105
20 - 39% = 1275
40 - 59% = 1525
60 - 79% = 526
80 - 99% = 311
Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 2816, nodes: 2319471
Average node length: 5.81, total dup: 2028746, max dup: 29
Average key length: 2.84, compression ratio: 3.16
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 419013, ratio: 0.18
Fill distribution:
0 - 19% = 17
20 - 39% = 45
40 - 59% = 1678
60 - 79% = 801
80 - 99% = 275
XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.43, total records: 4476005
Average version length: 85.25, total versions: 7488, 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: 68976
Data pages: 68968, average fill: 80%
Primary pages: 68968, secondary pages: 0, swept pages: 16523
Empty pages: 133, full pages: 67232
Fill distribution:
0 - 19% = 181
20 - 39% = 143
40 - 59% = 499
60 - 79% = 13363
80 - 99% = 54782
Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 4676, nodes: 4476005
Average node length: 5.04, total dup: 4449638, max dup: 688
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 633451, ratio: 0.14
Fill distribution:
0 - 19% = 6
20 - 39% = 172
40 - 59% = 2629
60 - 79% = 1339
80 - 99% = 530
Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5213, nodes: 4476005
Average node length: 5.55, total dup: 4110169, max dup: 49
Average key length: 2.56, compression ratio: 3.51
Average prefix length: 8.52, average data length: 0.48
Clustering factor: 205349, ratio: 0.05
Fill distribution:
0 - 19% = 78
20 - 39% = 1131
40 - 59% = 2134
60 - 79% = 528
80 - 99% = 1342
Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5247, nodes: 4476005
Average node length: 5.69, total dup: 4008975, max dup: 72
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 712341, ratio: 0.16
Fill distribution:
0 - 19% = 7
20 - 39% = 161
40 - 59% = 2915
60 - 79% = 1545
80 - 99% = 619
XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 823, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 825, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 824, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.08, total records: 3074374
Average version length: 83.17, total versions: 5015, 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: 30, data page slots: 47616
Data pages: 47616, average fill: 79%
Primary pages: 47616, secondary pages: 0, swept pages: 33839
Empty pages: 16, full pages: 46594
Fill distribution:
0 - 19% = 23
20 - 39% = 41
40 - 59% = 184
60 - 79% = 17651
80 - 99% = 29717
Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3304, nodes: 3074374
Average node length: 5.02, total dup: 3059061, max dup: 1263
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 629796, ratio: 0.20
Fill distribution:
0 - 19% = 12
20 - 39% = 305
40 - 59% = 1776
60 - 79% = 823
80 - 99% = 388
Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 5038, nodes: 3074374
Average node length: 6.22, total dup: 2525180, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 287277, ratio: 0.09
Fill distribution:
0 - 19% = 183
20 - 39% = 1802
40 - 59% = 1962
60 - 79% = 634
80 - 99% = 457
Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 3653, nodes: 3074374
Average node length: 5.61, total dup: 2796226, max dup: 56
Average key length: 2.63, compression ratio: 3.42
Average prefix length: 8.46, average data length: 0.54
Clustering factor: 668391, ratio: 0.22
Fill distribution:
0 - 19% = 11
20 - 39% = 306
40 - 59% = 1936
60 - 79% = 936
80 - 99% = 464
XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.26, total records: 624607
Average version length: 69.21, total versions: 1030, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 6, data page slots: 8536
Data pages: 8536, average fill: 77%
Primary pages: 8536, secondary pages: 0, swept pages: 6240
Empty pages: 5, full pages: 8441
Fill distribution:
0 - 19% = 5
20 - 39% = 2
40 - 59% = 6
60 - 79% = 8498
80 - 99% = 25
Index XQS_3300_3400_DOC_ID (0)
Root page: 170099, depth: 3, leaf buckets: 724, nodes: 624607
Average node length: 5.30, total dup: 589635, max dup: 117
Average key length: 2.43, compression ratio: 3.71
Average prefix length: 8.63, average data length: 0.37
Clustering factor: 50927, ratio: 0.08
Fill distribution:
0 - 19% = 3
20 - 39% = 121
40 - 59% = 326
60 - 79% = 181
80 - 99% = 93
Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 798, nodes: 624607
Average node length: 5.92, total dup: 534010, max dup: 14
Average key length: 3.05, compression ratio: 2.95
Average prefix length: 8.10, average data length: 0.90
Clustering factor: 54282, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 128
40 - 59% = 336
60 - 79% = 243
80 - 99% = 91
ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 672, Index root page: 673
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 676, Index root page: 677
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 682, Index root page: 683
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 692, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 684, Index root page: 685
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 693, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 678, Index root page: 679
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 686, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 687, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 680, Index root page: 681
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 689, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 688, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 691, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 690, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 622, Index root page: 623
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 620, Index root page: 621
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 271, Index root page: 272
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 284, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 74010 ms, from 11:36:29.84 to 11:37:43.85.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
1943377 |
1334 |
0.0686 |
DOC_LIST |
575497 |
266 |
0.0462 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
6187 |
1333 |
21.5451 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
176 |
79 |
44.8863 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
824071 |
319 |
0.0387 |
PERF_ESTIMATED |
233709 |
0 |
0.0000 |
PERF_LOG |
10273762 |
0 |
0.0000 |
PSTORNED |
306501 |
160 |
0.0522 |
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 |
2356 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
6930 |
2539 |
36.6378 |
XQD_1000_3300 |
858503 |
3900 |
0.4542 |
XQD_1200_2000 |
80839 |
10707 |
13.2448 |
XQD_2000_3300 |
2013339 |
26579 |
1.3201 |
XQD_2100_3300 |
3323092 |
94 |
0.0028 |
XQD_3300_3400 |
2815462 |
8589 |
0.3050 |
XQS_1000_1200 |
4230069 |
1143 |
0.0270 |
XQS_1000_3300 |
2319471 |
5523 |
0.2381 |
XQS_1200_2000 |
4476005 |
7488 |
0.1672 |
XQS_2100_3300 |
3074374 |
5015 |
0.1631 |
XQS_3300_3400 |
624607 |
1030 |
0.1649 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 1880 ms, from 11:37:54.20 to 11:37:56.08.
11:37:56.38 Validation started
11:37:56.41 Relation 140 (DOC_LIST)
11:37:56.41 process pointer page 0 of 5
11:37:56.46 process pointer page 1 of 5
11:37:56.51 process pointer page 2 of 5
11:37:56.55 process pointer page 3 of 5
11:37:56.60 process pointer page 4 of 5
11:37:56.61 Index 1 (PK_DOC_LIST)
11:37:56.70 Index 2 (DOC_LIST_ID_DESC)
11:37:56.78 Index 3 (FK_DOC_LIST_AGENTS)
11:37:56.94 Relation 140 (DOC_LIST) is ok
11:37:56.94 Relation 141 (DOC_DATA)
11:37:56.94 process pointer page 0 of 13
11:37:56.97 process pointer page 1 of 13
11:37:57.01 process pointer page 2 of 13
11:37:57.05 process pointer page 3 of 13
11:37:57.08 process pointer page 4 of 13
11:37:57.11 process pointer page 5 of 13
11:37:57.14 process pointer page 6 of 13
11:37:57.24 process pointer page 7 of 13
11:37:57.28 process pointer page 8 of 13
11:37:57.35 process pointer page 9 of 13
11:37:57.44 process pointer page 10 of 13
11:37:57.53 process pointer page 11 of 13
11:37:57.62 process pointer page 12 of 13
11:37:57.70 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:37:58.40 Index 3 (DOC_DATA_ID_DESC)
11:37:58.97 Index 4 (FK_DOC_DATA_DOC_LIST)
11:37:59.37 Relation 141 (DOC_DATA) is ok
11:37:59.37 Relation 147 (INVNT_SALDO)
11:37:59.37 process pointer page 0 of 1
11:37:59.37 Index 1 (PK_INVNT_SALDO)
11:37:59.37 Relation 147 (INVNT_SALDO) is ok
11:37:59.37 Relation 150 (PDISTR)
11:37:59.37 process pointer page 0 of 4
11:37:59.40 process pointer page 1 of 4
11:37:59.44 process pointer page 2 of 4
11:37:59.53 process pointer page 3 of 4
11:37:59.54 Index 2 (PDISTR_SND_ID)
11:37:59.58 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:37:59.67 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:37:59.77 Index 5 (PDISTR_AGENT_ID)
11:37:59.87 Relation 150 (PDISTR) is ok
11:37:59.87 Relation 151 (PSTORNED)
11:37:59.87 process pointer page 0 of 3
11:37:59.96 process pointer page 1 of 3
11:38:00.05 process pointer page 2 of 3
11:38:00.07 Index 2 (PSTORNED_SND_ID)
11:38:00.17 Index 3 (PSTORNED_RCV_ID)
11:38:00.26 Relation 151 (PSTORNED) is ok
11:38:00.26 Relation 156 (SEMAPHORES)
11:38:00.26 process pointer page 0 of 1
11:38:00.26 Index 1 (PK_SEMAPHORES)
11:38:00.26 Index 2 (SEMAPHORES_TASK_UNQ)
11:38:00.26 Relation 156 (SEMAPHORES) is ok
11:38:00.26 Relation 157 (INVNT_TURNOVER_LOG)
11:38:00.26 process pointer page 0 of 1
11:38:00.28 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:38:00.28 Relation 157 (INVNT_TURNOVER_LOG) is ok
11:38:00.28 Relation 160 (PERF_ESTIMATED)
11:38:00.28 process pointer page 0 of 2
11:38:00.38 process pointer page 1 of 2
11:38:00.40 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:38:00.47 Relation 160 (PERF_ESTIMATED) is ok
11:38:00.47 Relation 161 (PERF_ISQL_STAT)
11:38:00.47 process pointer page 0 of 1
11:38:00.47 Index 1 (PERF_ISQL_STAT_TRN)
11:38:00.47 Relation 161 (PERF_ISQL_STAT) is ok
11:38:00.47 Relation 162 (TRACE_STAT)
11:38:00.47 process pointer page 0 of 1
11:38:00.47 Relation 162 (TRACE_STAT) is ok
11:38:00.47 Relation 163 (PERF_LOG)
11:38:00.47 process pointer page 0 of 151
11:38:00.55 process pointer page 1 of 151
11:38:00.63 process pointer page 2 of 151
11:38:00.72 process pointer page 3 of 151
11:38:00.80 process pointer page 4 of 151
11:38:00.88 process pointer page 5 of 151
11:38:00.92 process pointer page 6 of 151
11:38:00.98 process pointer page 7 of 151
11:38:01.05 process pointer page 8 of 151
11:38:01.08 process pointer page 9 of 151
11:38:01.12 process pointer page 10 of 151
11:38:01.16 process pointer page 11 of 151
11:38:01.24 process pointer page 12 of 151
11:38:01.28 process pointer page 13 of 151
11:38:01.34 process pointer page 14 of 151
11:38:01.37 process pointer page 15 of 151
11:38:01.43 process pointer page 16 of 151
11:38:01.52 process pointer page 17 of 151
11:38:01.60 process pointer page 18 of 151
11:38:01.68 process pointer page 19 of 151
11:38:01.77 process pointer page 20 of 151
11:38:01.85 process pointer page 21 of 151
11:38:01.93 process pointer page 22 of 151
11:38:02.02 process pointer page 23 of 151
11:38:02.10 process pointer page 24 of 151
11:38:02.19 process pointer page 25 of 151
11:38:02.27 process pointer page 26 of 151
11:38:02.35 process pointer page 27 of 151
11:38:02.43 process pointer page 28 of 151
11:38:02.50 process pointer page 29 of 151
11:38:02.53 process pointer page 30 of 151
11:38:02.57 process pointer page 31 of 151
11:38:02.61 process pointer page 32 of 151
11:38:02.69 process pointer page 33 of 151
11:38:02.72 process pointer page 34 of 151
11:38:02.78 process pointer page 35 of 151
11:38:02.87 process pointer page 36 of 151
11:38:02.95 process pointer page 37 of 151
11:38:03.03 process pointer page 38 of 151
11:38:03.07 process pointer page 39 of 151
11:38:03.10 process pointer page 40 of 151
11:38:03.14 process pointer page 41 of 151
11:38:03.21 process pointer page 42 of 151
11:38:03.29 process pointer page 43 of 151
11:38:03.33 process pointer page 44 of 151
11:38:03.38 process pointer page 45 of 151
11:38:03.45 process pointer page 46 of 151
11:38:03.48 process pointer page 47 of 151
11:38:03.56 process pointer page 48 of 151
11:38:03.64 process pointer page 49 of 151
11:38:03.72 process pointer page 50 of 151
11:38:03.80 process pointer page 51 of 151
11:38:03.89 process pointer page 52 of 151
11:38:03.97 process pointer page 53 of 151
11:38:04.02 process pointer page 54 of 151
11:38:04.05 process pointer page 55 of 151
11:38:04.08 process pointer page 56 of 151
11:38:04.12 process pointer page 57 of 151
11:38:04.15 process pointer page 58 of 151
11:38:04.18 process pointer page 59 of 151
11:38:04.21 process pointer page 60 of 151
11:38:04.24 process pointer page 61 of 151
11:38:04.27 process pointer page 62 of 151
11:38:04.30 process pointer page 63 of 151
11:38:04.32 process pointer page 64 of 151
11:38:04.35 process pointer page 65 of 151
11:38:04.37 process pointer page 66 of 151
11:38:04.39 process pointer page 67 of 151
11:38:04.42 process pointer page 68 of 151
11:38:04.44 process pointer page 69 of 151
11:38:04.47 process pointer page 70 of 151
11:38:04.49 process pointer page 71 of 151
11:38:04.52 process pointer page 72 of 151
11:38:04.55 process pointer page 73 of 151
11:38:04.57 process pointer page 74 of 151
11:38:04.60 process pointer page 75 of 151
11:38:04.63 process pointer page 76 of 151
11:38:04.66 process pointer page 77 of 151
11:38:04.69 process pointer page 78 of 151
11:38:04.72 process pointer page 79 of 151
11:38:04.74 process pointer page 80 of 151
11:38:04.77 process pointer page 81 of 151
11:38:04.79 process pointer page 82 of 151
11:38:04.82 process pointer page 83 of 151
11:38:04.84 process pointer page 84 of 151
11:38:04.86 process pointer page 85 of 151
11:38:04.89 process pointer page 86 of 151
11:38:04.92 process pointer page 87 of 151
11:38:04.95 process pointer page 88 of 151
11:38:04.98 process pointer page 89 of 151
11:38:05.06 process pointer page 90 of 151
11:38:05.11 process pointer page 91 of 151
11:38:05.15 process pointer page 92 of 151
11:38:05.21 process pointer page 93 of 151
11:38:05.24 process pointer page 94 of 151
11:38:05.27 process pointer page 95 of 151
11:38:05.33 process pointer page 96 of 151
11:38:05.41 process pointer page 97 of 151
11:38:05.49 process pointer page 98 of 151
11:38:05.58 process pointer page 99 of 151
11:38:05.66 process pointer page 100 of 151
11:38:05.75 process pointer page 101 of 151
11:38:05.79 process pointer page 102 of 151
11:38:05.82 process pointer page 103 of 151
11:38:05.85 process pointer page 104 of 151
11:38:05.88 process pointer page 105 of 151
11:38:05.96 process pointer page 106 of 151
11:38:06.04 process pointer page 107 of 151
11:38:06.13 process pointer page 108 of 151
11:38:06.21 process pointer page 109 of 151
11:38:06.29 process pointer page 110 of 151
11:38:06.32 process pointer page 111 of 151
11:38:06.36 process pointer page 112 of 151
11:38:06.39 process pointer page 113 of 151
11:38:06.42 process pointer page 114 of 151
11:38:06.45 process pointer page 115 of 151
11:38:06.49 process pointer page 116 of 151
11:38:06.52 process pointer page 117 of 151
11:38:06.55 process pointer page 118 of 151
11:38:06.58 process pointer page 119 of 151
11:38:06.61 process pointer page 120 of 151
11:38:06.63 process pointer page 121 of 151
11:38:06.66 process pointer page 122 of 151
11:38:06.69 process pointer page 123 of 151
11:38:06.72 process pointer page 124 of 151
11:38:06.75 process pointer page 125 of 151
11:38:06.84 process pointer page 126 of 151
11:38:06.87 process pointer page 127 of 151
11:38:06.93 process pointer page 128 of 151
11:38:06.97 process pointer page 129 of 151
11:38:07.02 process pointer page 130 of 151
11:38:07.07 process pointer page 131 of 151
11:38:07.11 process pointer page 132 of 151
11:38:07.15 process pointer page 133 of 151
11:38:07.18 process pointer page 134 of 151
11:38:07.22 process pointer page 135 of 151
11:38:07.26 process pointer page 136 of 151
11:38:07.29 process pointer page 137 of 151
11:38:07.32 process pointer page 138 of 151
11:38:07.34 process pointer page 139 of 151
11:38:07.37 process pointer page 140 of 151
11:38:07.39 process pointer page 141 of 151
11:38:07.42 process pointer page 142 of 151
11:38:07.44 process pointer page 143 of 151
11:38:07.47 process pointer page 144 of 151
11:38:07.49 process pointer page 145 of 151
11:38:07.51 process pointer page 146 of 151
11:38:07.54 process pointer page 147 of 151
11:38:07.56 process pointer page 148 of 151
11:38:07.59 process pointer page 149 of 151
11:38:07.61 process pointer page 150 of 151
11:38:07.61 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:38:08.77 Index 2 (PERF_LOG_UNIT)
11:38:11.07 Index 3 (PERF_LOG_TRN_DESC)
11:38:12.03 Index 4 (PERF_LOG_GDSCODE)
11:38:13.19 Relation 163 (PERF_LOG) is ok
11:38:13.19 Relation 167 (V_STOPTEST)
11:38:13.19 Relation 167 (V_STOPTEST) is ok
11:38:13.19 Relation 184 (V_QDISTR_SOURCE)
11:38:13.19 Relation 184 (V_QDISTR_SOURCE) is ok
11:38:13.19 Relation 185 (V_QSTORNED_SOURCE)
11:38:13.19 Relation 185 (V_QSTORNED_SOURCE) is ok
11:38:13.19 Relation 260 (XQD_1000_1200)
11:38:13.19 process pointer page 0 of 2
11:38:13.20 process pointer page 1 of 2
11:38:13.20 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:38:13.21 Relation 260 (XQD_1000_1200) is ok
11:38:13.21 Relation 261 (XQD_1200_2000)
11:38:13.21 process pointer page 0 of 3
11:38:13.23 process pointer page 1 of 3
11:38:13.26 process pointer page 2 of 3
11:38:13.26 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:38:13.26 Relation 261 (XQD_1200_2000) is ok
11:38:13.26 Relation 262 (XQD_1000_3300)
11:38:13.26 process pointer page 0 of 8
11:38:13.30 process pointer page 1 of 8
11:38:13.39 process pointer page 2 of 8
11:38:13.49 process pointer page 3 of 8
11:38:13.56 process pointer page 4 of 8
11:38:13.59 process pointer page 5 of 8
11:38:13.63 process pointer page 6 of 8
11:38:13.67 process pointer page 7 of 8
11:38:13.70 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:38:13.89 Index 2 (XQD_1000_3300_DOC)
11:38:13.98 Relation 262 (XQD_1000_3300) is ok
11:38:13.98 Relation 263 (XQD_2000_3300)
11:38:13.98 process pointer page 0 of 16
11:38:14.02 process pointer page 1 of 16
11:38:14.05 process pointer page 2 of 16
11:38:14.08 process pointer page 3 of 16
11:38:14.11 process pointer page 4 of 16
11:38:14.14 process pointer page 5 of 16
11:38:14.16 process pointer page 6 of 16
11:38:14.19 process pointer page 7 of 16
11:38:14.22 process pointer page 8 of 16
11:38:14.24 process pointer page 9 of 16
11:38:14.27 process pointer page 10 of 16
11:38:14.30 process pointer page 11 of 16
11:38:14.33 process pointer page 12 of 16
11:38:14.36 process pointer page 13 of 16
11:38:14.40 process pointer page 14 of 16
11:38:14.42 process pointer page 15 of 16
11:38:14.44 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:38:14.58 Relation 263 (XQD_2000_3300) is ok
11:38:14.58 Relation 264 (XQD_2100_3300)
11:38:14.58 process pointer page 0 of 13
11:38:14.60 process pointer page 1 of 13
11:38:14.62 process pointer page 2 of 13
11:38:14.64 process pointer page 3 of 13
11:38:14.66 process pointer page 4 of 13
11:38:14.68 process pointer page 5 of 13
11:38:14.70 process pointer page 6 of 13
11:38:14.72 process pointer page 7 of 13
11:38:14.74 process pointer page 8 of 13
11:38:14.76 process pointer page 9 of 13
11:38:14.78 process pointer page 10 of 13
11:38:14.80 process pointer page 11 of 13
11:38:14.82 process pointer page 12 of 13
11:38:14.84 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:38:14.84 Relation 264 (XQD_2100_3300) is ok
11:38:14.84 Relation 265 (XQD_3300_3400)
11:38:14.84 process pointer page 0 of 23
11:38:14.87 process pointer page 1 of 23
11:38:14.90 process pointer page 2 of 23
11:38:14.93 process pointer page 3 of 23
11:38:14.96 process pointer page 4 of 23
11:38:14.99 process pointer page 5 of 23
11:38:15.02 process pointer page 6 of 23
11:38:15.05 process pointer page 7 of 23
11:38:15.08 process pointer page 8 of 23
11:38:15.11 process pointer page 9 of 23
11:38:15.14 process pointer page 10 of 23
11:38:15.18 process pointer page 11 of 23
11:38:15.21 process pointer page 12 of 23
11:38:15.24 process pointer page 13 of 23
11:38:15.27 process pointer page 14 of 23
11:38:15.30 process pointer page 15 of 23
11:38:15.34 process pointer page 16 of 23
11:38:15.37 process pointer page 17 of 23
11:38:15.40 process pointer page 18 of 23
11:38:15.43 process pointer page 19 of 23
11:38:15.46 process pointer page 20 of 23
11:38:15.49 process pointer page 21 of 23
11:38:15.52 process pointer page 22 of 23
11:38:15.53 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:38:15.81 Relation 265 (XQD_3300_3400) is ok
11:38:15.81 Relation 266 (XQS_1000_1200)
11:38:15.81 process pointer page 0 of 40
11:38:15.84 process pointer page 1 of 40
11:38:15.89 process pointer page 2 of 40
11:38:15.93 process pointer page 3 of 40
11:38:16.01 process pointer page 4 of 40
11:38:16.12 process pointer page 5 of 40
11:38:16.23 process pointer page 6 of 40
11:38:16.33 process pointer page 7 of 40
11:38:16.44 process pointer page 8 of 40
11:38:16.54 process pointer page 9 of 40
11:38:16.65 process pointer page 10 of 40
11:38:16.76 process pointer page 11 of 40
11:38:16.87 process pointer page 12 of 40
11:38:16.92 process pointer page 13 of 40
11:38:16.97 process pointer page 14 of 40
11:38:17.01 process pointer page 15 of 40
11:38:17.06 process pointer page 16 of 40
11:38:17.09 process pointer page 17 of 40
11:38:17.18 process pointer page 18 of 40
11:38:17.47 process pointer page 19 of 40
11:38:17.77 process pointer page 20 of 40
11:38:18.07 process pointer page 21 of 40
11:38:18.34 process pointer page 22 of 40
11:38:18.63 process pointer page 23 of 40
11:38:18.91 process pointer page 24 of 40
11:38:19.20 process pointer page 25 of 40
11:38:19.49 process pointer page 26 of 40
11:38:19.80 process pointer page 27 of 40
11:38:20.10 process pointer page 28 of 40
11:38:20.41 process pointer page 29 of 40
11:38:20.74 process pointer page 30 of 40
11:38:21.06 process pointer page 31 of 40
11:38:21.39 process pointer page 32 of 40
11:38:21.74 process pointer page 33 of 40
11:38:22.06 process pointer page 34 of 40
11:38:22.39 process pointer page 35 of 40
11:38:22.73 process pointer page 36 of 40
11:38:23.06 process pointer page 37 of 40
11:38:23.39 process pointer page 38 of 40
11:38:23.71 process pointer page 39 of 40
11:38:23.98 Index 1 (XQS_1000_1200_DOC_ID)
11:38:25.82 Index 2 (XQS_1000_1200_SND_ID)
11:38:27.98 Index 3 (XQS_1000_1200_RCV_ID)
11:38:29.63 Relation 266 (XQS_1000_1200) is ok
11:38:29.63 Relation 267 (XQS_1200_2000)
11:38:29.63 process pointer page 0 of 43
11:38:30.02 process pointer page 1 of 43
11:38:30.44 process pointer page 2 of 43
11:38:30.86 process pointer page 3 of 43
11:38:31.30 process pointer page 4 of 43
11:38:31.72 process pointer page 5 of 43
11:38:32.15 process pointer page 6 of 43
11:38:32.59 process pointer page 7 of 43
11:38:33.02 process pointer page 8 of 43
11:38:33.45 process pointer page 9 of 43
11:38:33.89 process pointer page 10 of 43
11:38:34.32 process pointer page 11 of 43
11:38:34.75 process pointer page 12 of 43
11:38:35.20 process pointer page 13 of 43
11:38:35.61 process pointer page 14 of 43
11:38:36.04 process pointer page 15 of 43
11:38:36.52 process pointer page 16 of 43
11:38:36.99 process pointer page 17 of 43
11:38:37.43 process pointer page 18 of 43
11:38:37.91 process pointer page 19 of 43
11:38:38.30 process pointer page 20 of 43
11:38:38.64 process pointer page 21 of 43
11:38:39.07 process pointer page 22 of 43
11:38:39.52 process pointer page 23 of 43
11:38:39.99 process pointer page 24 of 43
11:38:40.43 process pointer page 25 of 43
11:38:40.86 process pointer page 26 of 43
11:38:41.30 process pointer page 27 of 43
11:38:41.75 process pointer page 28 of 43
11:38:42.19 process pointer page 29 of 43
11:38:42.62 process pointer page 30 of 43
11:38:43.05 process pointer page 31 of 43
11:38:43.49 process pointer page 32 of 43
11:38:43.91 process pointer page 33 of 43
11:38:44.35 process pointer page 34 of 43
11:38:44.78 process pointer page 35 of 43
11:38:45.20 process pointer page 36 of 43
11:38:45.64 process pointer page 37 of 43
11:38:46.06 process pointer page 38 of 43
11:38:46.47 process pointer page 39 of 43
11:38:46.93 process pointer page 40 of 43
11:38:47.35 process pointer page 41 of 43
11:38:47.74 process pointer page 42 of 43
11:38:47.83 Index 1 (XQS_1200_2000_DOC_ID)
11:38:49.60 Index 2 (XQS_1200_2000_SND_ID)
11:38:51.72 Index 3 (XQS_1200_2000_RCV_ID)
11:38:53.72 Relation 267 (XQS_1200_2000) is ok
11:38:53.72 Relation 268 (XQS_1000_3300)
11:38:53.72 process pointer page 0 of 23
11:38:54.20 process pointer page 1 of 23
11:38:54.70 process pointer page 2 of 23
11:38:55.20 process pointer page 3 of 23
11:38:55.70 process pointer page 4 of 23
11:38:56.21 process pointer page 5 of 23
11:38:56.71 process pointer page 6 of 23
11:38:57.20 process pointer page 7 of 23
11:38:57.70 process pointer page 8 of 23
11:38:58.20 process pointer page 9 of 23
11:38:58.70 process pointer page 10 of 23
11:38:59.20 process pointer page 11 of 23
11:38:59.69 process pointer page 12 of 23
11:39:00.18 process pointer page 13 of 23
11:39:00.66 process pointer page 14 of 23
11:39:01.11 process pointer page 15 of 23
11:39:01.60 process pointer page 16 of 23
11:39:02.10 process pointer page 17 of 23
11:39:02.57 process pointer page 18 of 23
11:39:03.04 process pointer page 19 of 23
11:39:03.48 process pointer page 20 of 23
11:39:03.94 process pointer page 21 of 23
11:39:04.36 process pointer page 22 of 23
11:39:04.38 Index 1 (XQS_1000_3300_DOC_ID)
11:39:05.78 Index 2 (XQS_1000_3300_SND_ID)
11:39:07.06 Index 3 (XQS_1000_3300_RCV_ID)
11:39:08.63 Relation 268 (XQS_1000_3300) is ok
11:39:08.63 Relation 269 (XQS_2000_3300)
11:39:08.63 process pointer page 0 of 1
11:39:08.63 Index 1 (XQS_2000_3300_DOC_ID)
11:39:08.63 Index 2 (XQS_2000_3300_SND_ID)
11:39:08.63 Index 3 (XQS_2000_3300_RCV_ID)
11:39:08.63 Relation 269 (XQS_2000_3300) is ok
11:39:08.63 Relation 270 (XQS_2100_3300)
11:39:08.63 process pointer page 0 of 30
11:39:09.13 process pointer page 1 of 30
11:39:09.65 process pointer page 2 of 30
11:39:10.11 process pointer page 3 of 30
11:39:10.44 process pointer page 4 of 30
11:39:10.79 process pointer page 5 of 30
11:39:11.12 process pointer page 6 of 30
11:39:11.48 process pointer page 7 of 30
11:39:11.82 process pointer page 8 of 30
11:39:12.30 process pointer page 9 of 30
11:39:12.66 process pointer page 10 of 30
11:39:13.01 process pointer page 11 of 30
11:39:13.34 process pointer page 12 of 30
11:39:13.66 process pointer page 13 of 30
11:39:14.00 process pointer page 14 of 30
11:39:14.34 process pointer page 15 of 30
11:39:14.67 process pointer page 16 of 30
11:39:15.01 process pointer page 17 of 30
11:39:15.45 process pointer page 18 of 30
11:39:15.87 process pointer page 19 of 30
11:39:16.31 process pointer page 20 of 30
11:39:16.78 process pointer page 21 of 30
11:39:17.25 process pointer page 22 of 30
11:39:17.70 process pointer page 23 of 30
11:39:18.17 process pointer page 24 of 30
11:39:18.61 process pointer page 25 of 30
11:39:19.06 process pointer page 26 of 30
11:39:19.49 process pointer page 27 of 30
11:39:19.92 process pointer page 28 of 30
11:39:20.35 process pointer page 29 of 30
11:39:20.40 Index 1 (XQS_2100_3300_DOC_ID)
11:39:22.11 Index 2 (XQS_2100_3300_SND_ID)
11:39:23.59 Index 3 (XQS_2100_3300_RCV_ID)
11:39:25.45 Relation 270 (XQS_2100_3300) is ok
11:39:25.45 Relation 271 (XQS_3300_3400)
11:39:25.45 process pointer page 0 of 6
11:39:25.99 process pointer page 1 of 6
11:39:26.48 process pointer page 2 of 6
11:39:26.99 process pointer page 3 of 6
11:39:27.50 process pointer page 4 of 6
11:39:27.96 process pointer page 5 of 6
11:39:28.06 Index 1 (XQS_3300_3400_DOC_ID)
11:39:28.42 Index 2 (XQS_3300_3400_SND_ID)
11:39:28.81 Relation 271 (XQS_3300_3400) is ok
11:39:28.83 Validation finished
Done for 92850 ms, from 11:37:56.10 to 11:39:28.95.
Differences between old and current firebird.log
11:39:30.52. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-07-27 11:39 477 oltp40_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Thu Jul 27 11:37:56 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Thu Jul 27 11:39:28 2017
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-07-27 11:39:39.32 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html