Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-11-06 6:57:33.35.
Server version: WI-V3.0.2.32627 Firebird 3.0
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperClassic 3.0.2 |
D:\OLTP-EMUL\OLTP30-SMALL.FDB |
ON |
0 |
384 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp30_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB30.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp30-small.fdb |
host |
localhost |
port |
3333 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp30 |
working_mode |
small_03 |
warm_time |
10 |
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 |
0 |
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 |
ak30 |
upload_report |
1 |
max_snapshots_to_store |
180 |
replace_instance |
1 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2016-11-06 06:56:00.6890 |
-1 |
<null> |
|
::1/62427 |
261087 |
4758 |
2 |
CATEGORY |
SETTING |
VAL |
COMMON |
TRACED_UNITS |
,, |
COMMON |
HALT_TEST_ON_ERRORS |
,CK, |
COMMON |
LOG_PK_VIOLATION |
0 |
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 |
COMMON |
ENABLE_MON_QUERY |
0 |
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: |
3350.46 |
4145 |
603083 |
2016-11-06 03:56 |
2016-11-06 06:56 |
customer order: creation |
283.95 |
197 |
51111 |
2016-11-06 03:56 |
2016-11-06 06:56 |
customer order: refuse |
22.76 |
45 |
4074 |
2016-11-06 03:56 |
2016-11-06 06:56 |
order to supplier: creation |
73.24 |
5982 |
13183 |
2016-11-06 03:56 |
2016-11-06 06:56 |
order to supplier: removal |
1.61 |
16933 |
289 |
2016-11-06 03:56 |
2016-11-06 06:56 |
invoice (draft): creation |
73.95 |
4370 |
13311 |
2016-11-06 03:56 |
2016-11-06 06:56 |
invoice (draft): removal |
21.88 |
413 |
3916 |
2016-11-06 03:56 |
2016-11-06 06:56 |
invoice accept: apply |
41.79 |
26843 |
7523 |
2016-11-06 03:56 |
2016-11-06 06:56 |
invoice accept: cancel |
9.59 |
2916 |
1717 |
2016-11-06 03:56 |
2016-11-06 06:56 |
customer reserve: creation |
1981.23 |
522 |
356622 |
2016-11-06 03:56 |
2016-11-06 06:56 |
customer reserve: removal |
458.55 |
43 |
82081 |
2016-11-06 03:56 |
2016-11-06 06:56 |
realization accept: apply |
133.53 |
200 |
24035 |
2016-11-06 03:56 |
2016-11-06 06:56 |
realization accept: cancel |
40.85 |
68 |
7312 |
2016-11-06 03:56 |
2016-11-06 06:56 |
payment from customer: creation |
95.52 |
1178 |
17193 |
2016-11-06 03:56 |
2016-11-06 06:56 |
payment from customer: removal |
8.98 |
31 |
1608 |
2016-11-06 03:56 |
2016-11-06 06:56 |
payment to supplier: creation |
78.90 |
1820 |
14202 |
2016-11-06 03:56 |
2016-11-06 06:56 |
payment to supplier: removal |
5.34 |
38 |
956 |
2016-11-06 03:56 |
2016-11-06 06:56 |
service: total inventory turnovers |
5.45 |
9017 |
981 |
2016-11-06 03:56 |
2016-11-06 06:56 |
service: total monetary turnovers |
16.43 |
40 |
2958 |
2016-11-06 03:56 |
2016-11-06 06:56 |
service: refresh index statistics |
0.07 |
8105 |
11 |
2016-11-06 03:56 |
2016-11-06 06:56 |
Done for 82100 ms, from 6:59:04.43 to 7:00:26.53.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
2722 |
52887 |
48993 |
3894 |
7.36 |
03:56:01 |
04:14:01 |
interval # 2, overall |
2 |
3521 |
67116 |
63386 |
3730 |
5.56 |
04:14:02 |
04:32:02 |
interval # 3, overall |
3 |
3494 |
67501 |
62898 |
4603 |
6.82 |
04:32:03 |
04:50:03 |
interval # 4, overall |
4 |
3032 |
61007 |
54575 |
6432 |
10.54 |
04:50:04 |
05:08:04 |
interval # 5, overall |
5 |
3476 |
68247 |
62575 |
5672 |
8.31 |
05:08:05 |
05:26:05 |
interval # 6, overall |
6 |
3834 |
71625 |
69007 |
2618 |
3.66 |
05:26:06 |
05:44:06 |
interval # 7, overall |
7 |
3448 |
65108 |
62056 |
3052 |
4.69 |
05:44:07 |
06:02:07 |
interval # 8, overall |
8 |
3750 |
71276 |
67498 |
3778 |
5.30 |
06:02:08 |
06:20:08 |
interval # 9, overall |
9 |
3419 |
63860 |
61548 |
2312 |
3.62 |
06:20:09 |
06:38:09 |
interval # 10, overall |
10 |
2808 |
54218 |
50547 |
3671 |
6.77 |
06:38:10 |
06:56:10 |
Done for 111060 ms, from 7:02:13.19 to 7:04:04.25.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
WARM_TIME |
1 |
3560.49 |
0.6737 |
1.4057 |
1333 |
100 |
WARM_TIME |
2 |
2962.76 |
0.8448 |
1.1472 |
1410 |
100 |
WARM_TIME |
3 |
2486.76 |
0.9113 |
1.1058 |
1070 |
87 |
WARM_TIME |
4 |
2234.34 |
0.9230 |
1.0884 |
787 |
76 |
WARM_TIME |
5 |
2137.17 |
0.9104 |
1.1008 |
849 |
72 |
WARM_TIME |
6 |
2121.71 |
0.9240 |
1.0674 |
875 |
73 |
WARM_TIME |
7 |
2137.40 |
0.9083 |
1.0915 |
1024 |
78 |
WARM_TIME |
8 |
2198.74 |
0.9284 |
1.0693 |
967 |
68 |
WARM_TIME |
9 |
2219.64 |
0.9415 |
1.0650 |
1027 |
72 |
WARM_TIME |
10 |
2261.24 |
0.9409 |
1.0572 |
955 |
74 |
TEST_TIME |
11 |
2268.56 |
0.9580 |
1.0351 |
895 |
88 |
TEST_TIME |
12 |
2255.49 |
0.9559 |
1.0431 |
948 |
86 |
TEST_TIME |
13 |
2266.17 |
0.9584 |
1.0452 |
960 |
91 |
TEST_TIME |
14 |
2288.05 |
0.9613 |
1.0419 |
1034 |
90 |
TEST_TIME |
15 |
2304.42 |
0.9655 |
1.0333 |
832 |
98 |
TEST_TIME |
16 |
2308.54 |
0.9670 |
1.0311 |
839 |
92 |
TEST_TIME |
17 |
2310.53 |
0.9696 |
1.0318 |
808 |
97 |
TEST_TIME |
18 |
2311.36 |
0.9742 |
1.0266 |
854 |
100 |
TEST_TIME |
19 |
2285.67 |
0.9836 |
1.0161 |
1152 |
89 |
TEST_TIME |
20 |
2266.56 |
0.9735 |
1.0319 |
1404 |
86 |
TEST_TIME |
21 |
2299.24 |
0.9688 |
1.0315 |
1177 |
88 |
TEST_TIME |
22 |
2329.58 |
0.9718 |
1.0305 |
1126 |
82 |
TEST_TIME |
23 |
2371.52 |
0.9683 |
1.0259 |
1245 |
82 |
TEST_TIME |
24 |
2391.72 |
0.9748 |
1.0264 |
1160 |
87 |
TEST_TIME |
25 |
2430.76 |
0.9696 |
1.0286 |
1286 |
90 |
TEST_TIME |
26 |
2462.37 |
0.9764 |
1.0299 |
1097 |
93 |
TEST_TIME |
27 |
2519.62 |
0.9693 |
1.0333 |
1035 |
90 |
TEST_TIME |
28 |
2543.69 |
0.9869 |
1.0135 |
933 |
95 |
TEST_TIME |
29 |
2531.98 |
0.9831 |
1.0145 |
1172 |
91 |
TEST_TIME |
30 |
2522.63 |
0.9843 |
1.0143 |
1308 |
73 |
TEST_TIME |
31 |
2513.77 |
0.9850 |
1.0157 |
909 |
67 |
TEST_TIME |
32 |
2525.78 |
0.9792 |
1.0237 |
1273 |
78 |
TEST_TIME |
33 |
2586.40 |
0.9694 |
1.0272 |
1293 |
89 |
TEST_TIME |
34 |
2624.99 |
0.9824 |
1.0208 |
1305 |
89 |
TEST_TIME |
35 |
2647.59 |
0.9831 |
1.0155 |
1216 |
84 |
TEST_TIME |
36 |
2652.89 |
0.9854 |
1.0168 |
1027 |
86 |
TEST_TIME |
37 |
2667.76 |
0.9838 |
1.0168 |
969 |
81 |
TEST_TIME |
38 |
2678.67 |
0.9860 |
1.0179 |
1124 |
84 |
TEST_TIME |
39 |
2699.43 |
0.9847 |
1.0160 |
1093 |
83 |
TEST_TIME |
40 |
2720.47 |
0.9829 |
1.0227 |
1186 |
89 |
TEST_TIME |
41 |
2797.07 |
0.9711 |
1.0179 |
928 |
96 |
TEST_TIME |
42 |
2813.45 |
0.9878 |
1.0090 |
1015 |
100 |
TEST_TIME |
43 |
2809.62 |
0.9869 |
1.0090 |
1070 |
94 |
TEST_TIME |
44 |
2810.52 |
0.9857 |
1.0159 |
1508 |
87 |
TEST_TIME |
45 |
2839.73 |
0.9831 |
1.0160 |
1355 |
89 |
TEST_TIME |
46 |
2866.96 |
0.9845 |
1.0166 |
1281 |
85 |
TEST_TIME |
47 |
2894.25 |
0.9855 |
1.0149 |
1263 |
83 |
TEST_TIME |
48 |
2916.57 |
0.9862 |
1.0135 |
1185 |
82 |
TEST_TIME |
49 |
2935.12 |
0.9865 |
1.0118 |
1209 |
78 |
TEST_TIME |
50 |
2948.35 |
0.9871 |
1.0128 |
1209 |
82 |
TEST_TIME |
51 |
2960.31 |
0.9889 |
1.0107 |
1175 |
75 |
TEST_TIME |
52 |
2971.15 |
0.9877 |
1.0115 |
1097 |
80 |
TEST_TIME |
53 |
2972.77 |
0.9918 |
1.0082 |
976 |
74 |
TEST_TIME |
54 |
2973.35 |
0.9894 |
1.0103 |
1059 |
78 |
TEST_TIME |
55 |
2978.15 |
0.9904 |
1.0106 |
1218 |
81 |
TEST_TIME |
56 |
2979.60 |
0.9921 |
1.0119 |
1178 |
76 |
TEST_TIME |
57 |
3000.00 |
0.9874 |
1.0102 |
1162 |
80 |
TEST_TIME |
58 |
3006.27 |
0.9907 |
1.0099 |
1119 |
81 |
TEST_TIME |
59 |
3016.58 |
0.9894 |
1.0105 |
1087 |
79 |
TEST_TIME |
60 |
3038.81 |
0.9864 |
1.0129 |
1019 |
92 |
TEST_TIME |
61 |
3046.46 |
0.9938 |
1.0086 |
895 |
77 |
TEST_TIME |
62 |
3044.77 |
0.9929 |
1.0073 |
1016 |
78 |
TEST_TIME |
63 |
3046.40 |
0.9908 |
1.0079 |
996 |
85 |
TEST_TIME |
64 |
3048.40 |
0.9915 |
1.0063 |
1064 |
68 |
TEST_TIME |
65 |
3046.98 |
0.9913 |
1.0059 |
943 |
51 |
TEST_TIME |
66 |
3040.84 |
0.9927 |
1.0060 |
863 |
45 |
TEST_TIME |
67 |
3032.83 |
0.9937 |
1.0063 |
894 |
53 |
TEST_TIME |
68 |
3023.96 |
0.9946 |
1.0074 |
978 |
47 |
TEST_TIME |
69 |
3029.61 |
0.9910 |
1.0066 |
1111 |
55 |
TEST_TIME |
70 |
3031.74 |
0.9916 |
1.0095 |
961 |
54 |
TEST_TIME |
71 |
3042.92 |
0.9916 |
1.0076 |
995 |
44 |
TEST_TIME |
72 |
3043.99 |
0.9932 |
1.0068 |
894 |
42 |
TEST_TIME |
73 |
3042.83 |
0.9934 |
1.0062 |
790 |
50 |
TEST_TIME |
74 |
3039.87 |
0.9936 |
1.0063 |
895 |
46 |
TEST_TIME |
75 |
3037.61 |
0.9937 |
1.0069 |
881 |
51 |
TEST_TIME |
76 |
3039.62 |
0.9930 |
1.0073 |
1029 |
50 |
TEST_TIME |
77 |
3044.40 |
0.9926 |
1.0078 |
972 |
55 |
TEST_TIME |
78 |
3052.05 |
0.9924 |
1.0101 |
1018 |
60 |
TEST_TIME |
79 |
3065.96 |
0.9928 |
1.0048 |
1030 |
41 |
TEST_TIME |
80 |
3060.43 |
0.9941 |
1.0065 |
760 |
46 |
TEST_TIME |
81 |
3058.16 |
0.9948 |
1.0040 |
805 |
34 |
TEST_TIME |
82 |
3048.96 |
0.9947 |
1.0056 |
877 |
44 |
TEST_TIME |
83 |
3048.25 |
0.9937 |
1.0056 |
907 |
46 |
TEST_TIME |
84 |
3043.85 |
0.9951 |
1.0054 |
853 |
42 |
TEST_TIME |
85 |
3047.45 |
0.9924 |
1.0086 |
901 |
58 |
TEST_TIME |
86 |
3061.22 |
0.9924 |
1.0069 |
1071 |
69 |
TEST_TIME |
87 |
3060.87 |
0.9954 |
1.0071 |
955 |
57 |
TEST_TIME |
88 |
3068.47 |
0.9932 |
1.0068 |
968 |
54 |
TEST_TIME |
89 |
3076.49 |
0.9929 |
1.0058 |
947 |
52 |
TEST_TIME |
90 |
3077.84 |
0.9942 |
1.0054 |
879 |
42 |
TEST_TIME |
91 |
3081.51 |
0.9931 |
1.0052 |
903 |
46 |
TEST_TIME |
92 |
3076.50 |
0.9959 |
1.0045 |
517 |
45 |
TEST_TIME |
93 |
3067.33 |
0.9966 |
1.0028 |
392 |
35 |
TEST_TIME |
94 |
3063.84 |
0.9933 |
1.0060 |
695 |
60 |
TEST_TIME |
95 |
3074.30 |
0.9920 |
1.0061 |
755 |
70 |
TEST_TIME |
96 |
3081.03 |
0.9935 |
1.0047 |
889 |
76 |
TEST_TIME |
97 |
3081.02 |
0.9943 |
1.0042 |
1012 |
73 |
TEST_TIME |
98 |
3079.95 |
0.9943 |
1.0060 |
993 |
71 |
TEST_TIME |
99 |
3083.40 |
0.9947 |
1.0049 |
915 |
73 |
TEST_TIME |
100 |
3086.46 |
0.9939 |
1.0057 |
914 |
73 |
TEST_TIME |
101 |
3093.63 |
0.9935 |
1.0063 |
1102 |
76 |
TEST_TIME |
102 |
3109.95 |
0.9912 |
1.0063 |
1128 |
83 |
TEST_TIME |
103 |
3111.97 |
0.9959 |
1.0058 |
869 |
81 |
TEST_TIME |
104 |
3113.21 |
0.9958 |
1.0038 |
925 |
74 |
TEST_TIME |
105 |
3118.31 |
0.9926 |
1.0093 |
881 |
90 |
TEST_TIME |
106 |
3133.39 |
0.9949 |
1.0040 |
632 |
79 |
TEST_TIME |
107 |
3142.29 |
0.9918 |
1.0062 |
638 |
76 |
TEST_TIME |
108 |
3147.18 |
0.9953 |
1.0029 |
800 |
89 |
TEST_TIME |
109 |
3138.97 |
0.9963 |
1.0029 |
839 |
93 |
TEST_TIME |
110 |
3136.73 |
0.9944 |
1.0035 |
880 |
93 |
TEST_TIME |
111 |
3129.26 |
0.9968 |
1.0043 |
1221 |
81 |
TEST_TIME |
112 |
3130.87 |
0.9948 |
1.0061 |
1165 |
79 |
TEST_TIME |
113 |
3141.41 |
0.9939 |
1.0070 |
1183 |
84 |
TEST_TIME |
114 |
3149.73 |
0.9955 |
1.0060 |
1162 |
78 |
TEST_TIME |
115 |
3159.10 |
0.9943 |
1.0050 |
1141 |
80 |
TEST_TIME |
116 |
3165.67 |
0.9943 |
1.0057 |
1081 |
77 |
TEST_TIME |
117 |
3179.09 |
0.9929 |
1.0065 |
1199 |
79 |
TEST_TIME |
118 |
3193.00 |
0.9937 |
1.0054 |
1156 |
80 |
TEST_TIME |
119 |
3204.99 |
0.9932 |
1.0063 |
1054 |
77 |
TEST_TIME |
120 |
3212.76 |
0.9955 |
1.0045 |
1050 |
77 |
TEST_TIME |
121 |
3216.26 |
0.9951 |
1.0045 |
990 |
75 |
TEST_TIME |
122 |
3220.50 |
0.9949 |
1.0049 |
997 |
76 |
TEST_TIME |
123 |
3221.21 |
0.9966 |
1.0039 |
908 |
69 |
TEST_TIME |
124 |
3220.52 |
0.9960 |
1.0042 |
873 |
72 |
TEST_TIME |
125 |
3226.26 |
0.9944 |
1.0059 |
945 |
74 |
TEST_TIME |
126 |
3229.92 |
0.9968 |
1.0035 |
885 |
74 |
TEST_TIME |
127 |
3225.21 |
0.9970 |
1.0029 |
868 |
71 |
TEST_TIME |
128 |
3220.19 |
0.9966 |
1.0036 |
871 |
74 |
TEST_TIME |
129 |
3216.89 |
0.9969 |
1.0048 |
778 |
70 |
TEST_TIME |
130 |
3225.15 |
0.9945 |
1.0047 |
919 |
76 |
TEST_TIME |
131 |
3233.67 |
0.9944 |
1.0058 |
751 |
86 |
TEST_TIME |
132 |
3240.18 |
0.9962 |
1.0037 |
670 |
86 |
TEST_TIME |
133 |
3248.81 |
0.9935 |
1.0116 |
749 |
78 |
TEST_TIME |
134 |
3278.67 |
0.9949 |
1.0038 |
725 |
69 |
TEST_TIME |
135 |
3280.24 |
0.9958 |
1.0029 |
651 |
60 |
TEST_TIME |
136 |
3277.48 |
0.9964 |
1.0027 |
673 |
79 |
TEST_TIME |
137 |
3270.44 |
0.9976 |
1.0033 |
488 |
66 |
TEST_TIME |
138 |
3264.54 |
0.9978 |
1.0019 |
499 |
70 |
TEST_TIME |
139 |
3252.20 |
0.9985 |
1.0020 |
567 |
88 |
TEST_TIME |
140 |
3251.36 |
0.9951 |
1.0049 |
864 |
72 |
TEST_TIME |
141 |
3248.80 |
0.9985 |
1.0014 |
1113 |
95 |
TEST_TIME |
142 |
3237.51 |
0.9978 |
1.0035 |
1041 |
72 |
TEST_TIME |
143 |
3238.97 |
0.9960 |
1.0045 |
1046 |
75 |
TEST_TIME |
144 |
3248.25 |
0.9947 |
1.0037 |
902 |
66 |
TEST_TIME |
145 |
3251.10 |
0.9959 |
1.0036 |
1030 |
78 |
TEST_TIME |
146 |
3254.98 |
0.9956 |
1.0044 |
1043 |
83 |
TEST_TIME |
147 |
3260.33 |
0.9960 |
1.0045 |
1006 |
79 |
TEST_TIME |
148 |
3267.90 |
0.9954 |
1.0037 |
1095 |
78 |
TEST_TIME |
149 |
3270.35 |
0.9963 |
1.0039 |
1124 |
78 |
TEST_TIME |
150 |
3272.48 |
0.9966 |
1.0042 |
1047 |
74 |
TEST_TIME |
151 |
3276.75 |
0.9962 |
1.0028 |
928 |
68 |
TEST_TIME |
152 |
3278.17 |
0.9957 |
1.0047 |
938 |
72 |
TEST_TIME |
153 |
3284.48 |
0.9962 |
1.0028 |
1024 |
78 |
TEST_TIME |
154 |
3284.04 |
0.9965 |
1.0038 |
945 |
72 |
TEST_TIME |
155 |
3290.60 |
0.9953 |
1.0036 |
859 |
72 |
TEST_TIME |
156 |
3290.42 |
0.9972 |
1.0036 |
912 |
72 |
TEST_TIME |
157 |
3292.08 |
0.9967 |
1.0026 |
899 |
69 |
TEST_TIME |
158 |
3289.65 |
0.9970 |
1.0034 |
834 |
73 |
TEST_TIME |
159 |
3290.76 |
0.9968 |
1.0024 |
758 |
70 |
TEST_TIME |
160 |
3287.98 |
0.9969 |
1.0028 |
752 |
68 |
TEST_TIME |
161 |
3284.78 |
0.9975 |
1.0032 |
871 |
74 |
TEST_TIME |
162 |
3285.23 |
0.9969 |
1.0027 |
1051 |
74 |
TEST_TIME |
163 |
3289.19 |
0.9954 |
1.0039 |
1001 |
75 |
TEST_TIME |
164 |
3290.78 |
0.9973 |
1.0027 |
840 |
69 |
TEST_TIME |
165 |
3290.83 |
0.9966 |
1.0041 |
824 |
65 |
TEST_TIME |
166 |
3297.50 |
0.9960 |
1.0033 |
938 |
67 |
TEST_TIME |
167 |
3296.33 |
0.9977 |
1.0026 |
760 |
65 |
TEST_TIME |
168 |
3296.13 |
0.9967 |
1.0028 |
899 |
72 |
TEST_TIME |
169 |
3293.67 |
0.9976 |
1.0023 |
766 |
68 |
TEST_TIME |
170 |
3289.94 |
0.9975 |
1.0030 |
851 |
65 |
TEST_TIME |
171 |
3290.02 |
0.9971 |
1.0023 |
786 |
65 |
TEST_TIME |
172 |
3287.77 |
0.9972 |
1.0031 |
669 |
65 |
TEST_TIME |
173 |
3287.76 |
0.9973 |
1.0024 |
669 |
63 |
TEST_TIME |
174 |
3286.42 |
0.9970 |
1.0033 |
758 |
69 |
TEST_TIME |
175 |
3287.42 |
0.9973 |
1.0029 |
568 |
70 |
TEST_TIME |
176 |
3284.71 |
0.9980 |
1.0011 |
696 |
60 |
TEST_TIME |
177 |
3278.30 |
0.9974 |
1.0023 |
872 |
66 |
TEST_TIME |
178 |
3277.28 |
0.9970 |
1.0028 |
884 |
75 |
TEST_TIME |
179 |
3274.91 |
0.9979 |
1.0016 |
830 |
70 |
TEST_TIME |
180 |
3269.73 |
0.9976 |
1.0021 |
786 |
67 |
TEST_TIME |
181 |
3268.57 |
0.9970 |
1.0025 |
858 |
63 |
TEST_TIME |
182 |
3266.82 |
0.9975 |
1.0021 |
814 |
67 |
TEST_TIME |
183 |
3263.21 |
0.9977 |
1.0020 |
651 |
61 |
TEST_TIME |
184 |
3262.78 |
0.9967 |
1.0027 |
842 |
70 |
TEST_TIME |
185 |
3260.00 |
0.9981 |
1.0019 |
789 |
64 |
TEST_TIME |
186 |
3255.42 |
0.9976 |
1.0022 |
835 |
63 |
TEST_TIME |
187 |
3252.23 |
0.9979 |
1.0030 |
679 |
72 |
TEST_TIME |
188 |
3249.68 |
0.9984 |
1.0015 |
680 |
55 |
TEST_TIME |
189 |
3246.44 |
0.9972 |
1.0020 |
746 |
69 |
TEST_TIME |
190 |
3242.46 |
0.9979 |
1.0142 |
111 |
100 |
Done for 12460 ms, from 7:04:06.71 to 7:04:19.17.
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 |
5550 |
1648 |
4103 |
1659 |
6357 |
<null> |
12452 |
2967 |
15496 |
7206 |
6288 |
6161 |
7768 |
<null> |
18593 |
4059 |
82449 |
201742 |
<null> |
03:56:01 |
04:14:01 |
fetches per second |
2 |
2057 |
4144 |
6030 |
<null> |
7686 |
<null> |
4044 |
1807 |
5659 |
5991 |
2037 |
5057 |
5290 |
820 |
19083 |
<null> |
32538 |
64281 |
<null> |
04:14:02 |
04:32:02 |
fetches per second |
3 |
1101 |
1342 |
9337 |
<null> |
9591 |
<null> |
4375 |
<null> |
5064 |
1067 |
2766 |
906 |
11822 |
850 |
24894 |
819 |
65794 |
37846 |
<null> |
04:32:03 |
04:50:03 |
fetches per second |
4 |
10173 |
38308 |
12988 |
<null> |
16391 |
9501 |
3778 |
1834 |
3146 |
<null> |
10944 |
20600 |
71185 |
22022 |
66895 |
13131 |
<null> |
480632 |
<null> |
04:50:04 |
05:08:04 |
fetches per second |
5 |
9493 |
17332 |
8019 |
<null> |
14717 |
24637 |
2963 |
2055 |
3509 |
<null> |
12636 |
3124 |
57035 |
20694 |
41733 |
12026 |
49078 |
742447 |
<null> |
05:08:05 |
05:26:05 |
fetches per second |
6 |
1366 |
1743 |
4848 |
1834 |
12678 |
<null> |
6730 |
<null> |
6549 |
1768 |
3992 |
2958 |
17002 |
<null> |
21756 |
<null> |
<null> |
221101 |
<null> |
05:26:06 |
05:44:06 |
fetches per second |
7 |
3121 |
4762 |
8098 |
24712 |
15706 |
<null> |
17461 |
1681 |
5788 |
1286 |
6875 |
774 |
32891 |
<null> |
30111 |
<null> |
43606 |
150677 |
<null> |
05:44:07 |
06:02:07 |
fetches per second |
8 |
1777 |
3813 |
7527 |
2154 |
13641 |
<null> |
14943 |
<null> |
8957 |
<null> |
9464 |
829 |
18266 |
<null> |
18693 |
1150 |
65106 |
91337 |
<null> |
06:02:08 |
06:20:08 |
fetches per second |
9 |
1149 |
1330 |
14027 |
<null> |
17054 |
3009 |
6675 |
<null> |
15831 |
1280 |
2253 |
1309 |
11121 |
1619 |
35938 |
<null> |
<null> |
156405 |
<null> |
06:20:09 |
06:38:09 |
fetches per second |
10 |
1058 |
1295 |
10438 |
<null> |
17357 |
<null> |
6357 |
1151 |
6984 |
<null> |
1772 |
981 |
14723 |
545 |
33373 |
894 |
<null> |
205505 |
<null> |
06:38:10 |
06:56:10 |
marks per second |
1 |
925 |
160 |
372 |
168 |
395 |
<null> |
435 |
318 |
964 |
1206 |
754 |
637 |
273 |
<null> |
204 |
365 |
748 |
1649 |
<null> |
03:56:01 |
04:14:01 |
marks per second |
2 |
353 |
374 |
419 |
<null> |
508 |
<null> |
236 |
186 |
560 |
753 |
267 |
560 |
141 |
72 |
131 |
<null> |
271 |
211 |
<null> |
04:14:02 |
04:32:02 |
marks per second |
3 |
176 |
106 |
524 |
<null> |
533 |
<null> |
169 |
<null> |
182 |
99 |
160 |
99 |
138 |
72 |
187 |
73 |
331 |
115 |
<null> |
04:32:03 |
04:50:03 |
marks per second |
4 |
1751 |
3409 |
693 |
<null> |
971 |
1324 |
151 |
195 |
616 |
<null> |
1590 |
2443 |
473 |
2085 |
884 |
1482 |
<null> |
1378 |
<null> |
04:50:04 |
05:08:04 |
marks per second |
5 |
1558 |
1481 |
533 |
<null> |
769 |
3623 |
125 |
211 |
242 |
<null> |
1463 |
330 |
420 |
1981 |
1357 |
1243 |
342 |
1552 |
<null> |
05:08:05 |
05:26:05 |
marks per second |
6 |
222 |
160 |
380 |
166 |
804 |
<null> |
216 |
<null> |
206 |
216 |
257 |
337 |
189 |
<null> |
309 |
<null> |
<null> |
507 |
<null> |
05:26:06 |
05:44:06 |
marks per second |
7 |
488 |
464 |
393 |
3433 |
582 |
<null> |
457 |
152 |
124 |
149 |
776 |
70 |
262 |
<null> |
412 |
<null> |
858 |
327 |
<null> |
05:44:07 |
06:02:07 |
marks per second |
8 |
296 |
363 |
482 |
228 |
734 |
<null> |
323 |
<null> |
244 |
<null> |
323 |
88 |
365 |
<null> |
391 |
104 |
453 |
228 |
<null> |
06:02:08 |
06:20:08 |
marks per second |
9 |
194 |
124 |
495 |
<null> |
530 |
488 |
158 |
<null> |
1265 |
149 |
139 |
137 |
152 |
260 |
475 |
<null> |
<null> |
243 |
<null> |
06:20:09 |
06:38:09 |
marks per second |
10 |
170 |
167 |
273 |
<null> |
442 |
<null> |
119 |
103 |
56 |
<null> |
112 |
75 |
120 |
53 |
252 |
80 |
<null> |
277 |
<null> |
06:38:10 |
06:56:10 |
reads/fetches*100 |
1 |
11 |
10 |
11 |
5 |
12 |
<null> |
7 |
3 |
9 |
6 |
11 |
9 |
8 |
<null> |
7 |
9 |
13 |
1 |
<null> |
03:56:01 |
04:14:01 |
reads/fetches*100 |
2 |
12 |
9 |
11 |
<null> |
9 |
<null> |
7 |
5 |
7 |
7 |
13 |
10 |
8 |
10 |
6 |
<null> |
17 |
1 |
<null> |
04:14:02 |
04:32:02 |
reads/fetches*100 |
3 |
13 |
9 |
8 |
<null> |
7 |
<null> |
5 |
<null> |
7 |
11 |
13 |
13 |
7 |
12 |
5 |
11 |
16 |
0 |
<null> |
04:32:03 |
04:50:03 |
reads/fetches*100 |
4 |
10 |
7 |
8 |
<null> |
7 |
7 |
7 |
9 |
5 |
<null> |
11 |
7 |
5 |
7 |
5 |
8 |
<null> |
1 |
<null> |
04:50:04 |
05:08:04 |
reads/fetches*100 |
5 |
11 |
9 |
8 |
<null> |
7 |
6 |
8 |
5 |
9 |
<null> |
12 |
13 |
6 |
7 |
5 |
8 |
17 |
0 |
<null> |
05:08:05 |
05:26:05 |
reads/fetches*100 |
6 |
13 |
9 |
10 |
5 |
7 |
<null> |
6 |
<null> |
8 |
10 |
13 |
12 |
7 |
<null> |
6 |
<null> |
<null> |
1 |
<null> |
05:26:06 |
05:44:06 |
reads/fetches*100 |
7 |
13 |
10 |
8 |
5 |
7 |
<null> |
5 |
5 |
7 |
11 |
13 |
13 |
5 |
<null> |
6 |
<null> |
18 |
0 |
<null> |
05:44:07 |
06:02:07 |
reads/fetches*100 |
8 |
13 |
10 |
9 |
4 |
7 |
<null> |
5 |
<null> |
5 |
<null> |
13 |
13 |
5 |
<null> |
5 |
9 |
14 |
0 |
<null> |
06:02:08 |
06:20:08 |
reads/fetches*100 |
9 |
12 |
10 |
7 |
<null> |
6 |
10 |
5 |
<null> |
5 |
12 |
14 |
12 |
6 |
9 |
5 |
<null> |
<null> |
0 |
<null> |
06:20:09 |
06:38:09 |
reads/fetches*100 |
10 |
13 |
11 |
7 |
<null> |
6 |
<null> |
5 |
5 |
6 |
<null> |
16 |
12 |
5 |
9 |
5 |
10 |
<null> |
0 |
<null> |
06:38:10 |
06:56:10 |
writes/marks*100 |
1 |
0 |
0 |
1 |
6 |
2 |
<null> |
5 |
3 |
1 |
0 |
1 |
1 |
3 |
<null> |
3 |
0 |
39 |
0 |
<null> |
03:56:01 |
04:14:01 |
writes/marks*100 |
2 |
0 |
0 |
2 |
<null> |
3 |
<null> |
3 |
3 |
1 |
0 |
1 |
0 |
3 |
0 |
5 |
<null> |
57 |
0 |
<null> |
04:14:02 |
04:32:02 |
writes/marks*100 |
3 |
0 |
0 |
4 |
<null> |
3 |
<null> |
4 |
<null> |
0 |
0 |
2 |
0 |
6 |
0 |
5 |
0 |
47 |
0 |
<null> |
04:32:03 |
04:50:03 |
writes/marks*100 |
4 |
0 |
0 |
3 |
<null> |
4 |
0 |
3 |
0 |
0 |
<null> |
1 |
1 |
7 |
1 |
4 |
0 |
<null> |
0 |
<null> |
04:50:04 |
05:08:04 |
writes/marks*100 |
5 |
0 |
0 |
3 |
<null> |
4 |
0 |
3 |
5 |
1 |
<null> |
0 |
0 |
6 |
0 |
3 |
0 |
56 |
0 |
<null> |
05:08:05 |
05:26:05 |
writes/marks*100 |
6 |
0 |
0 |
2 |
5 |
4 |
<null> |
4 |
<null> |
5 |
0 |
2 |
0 |
6 |
<null> |
4 |
<null> |
<null> |
0 |
<null> |
05:26:06 |
05:44:06 |
writes/marks*100 |
7 |
0 |
0 |
3 |
4 |
5 |
<null> |
5 |
3 |
2 |
0 |
2 |
0 |
5 |
<null> |
4 |
<null> |
53 |
0 |
<null> |
05:44:07 |
06:02:07 |
writes/marks*100 |
8 |
0 |
0 |
3 |
3 |
4 |
<null> |
5 |
<null> |
4 |
<null> |
3 |
0 |
5 |
<null> |
5 |
0 |
45 |
0 |
<null> |
06:02:08 |
06:20:08 |
writes/marks*100 |
9 |
0 |
0 |
5 |
<null> |
5 |
19 |
5 |
<null> |
1 |
0 |
1 |
0 |
6 |
0 |
4 |
<null> |
<null> |
0 |
<null> |
06:20:09 |
06:38:09 |
writes/marks*100 |
10 |
0 |
1 |
4 |
<null> |
5 |
<null> |
5 |
2 |
10 |
<null> |
1 |
0 |
7 |
0 |
4 |
0 |
<null> |
1 |
<null> |
06:38:10 |
06:56:10 |
Done for 9730 ms, from 7:04:20.13 to 7:04:29.86.
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 |
1018639 |
985914 |
32725 |
3.21 |
0 |
134958 |
63 |
32725 |
2016-11-06 03:56 |
2016-11-06 06:56 |
doc_list_biud |
1019066 |
985914 |
33152 |
3.25 |
0 |
66721 |
13 |
33152 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_add_invoice_to_stock |
12220 |
7523 |
4697 |
38.43 |
78 |
580232 |
26843 |
4697 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_cancel_adding_invoice |
2133 |
1717 |
416 |
19.50 |
15 |
84802 |
2916 |
416 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_cancel_client_order |
4344 |
4074 |
270 |
6.21 |
0 |
1778 |
45 |
270 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_cancel_customer_reserve |
111236 |
82081 |
29155 |
26.21 |
0 |
4072 |
43 |
29155 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_cancel_pay_from_customer |
1642 |
1608 |
34 |
2.07 |
0 |
1108 |
31 |
34 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_cancel_pay_to_supplier |
971 |
956 |
15 |
1.54 |
0 |
765 |
38 |
15 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_cancel_supplier_invoice |
4714 |
3916 |
798 |
16.92 |
0 |
8595 |
413 |
798 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_cancel_supplier_order |
986 |
289 |
697 |
70.68 |
78 |
212193 |
16933 |
697 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_cancel_write_off |
10352 |
7312 |
3040 |
29.36 |
0 |
2496 |
68 |
3040 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_client_order |
51111 |
51111 |
0 |
0.00 |
0 |
7691 |
197 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_customer_reserve |
356622 |
356622 |
0 |
0.00 |
0 |
28439 |
522 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_fill_shopping_cart |
77605 |
77605 |
0 |
0.00 |
0 |
85442 |
538 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_fill_shopping_cart_clo_res |
356622 |
356622 |
0 |
0.00 |
0 |
358 |
3 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_get_clo_for_invoice |
7523 |
7523 |
0 |
0.00 |
0 |
6318 |
185 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_kill_cost_storno |
14807 |
11593 |
3214 |
21.70 |
0 |
3728 |
15 |
3214 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_kill_qstorno_ret_qs2qd |
237253 |
175679 |
61574 |
25.95 |
0 |
8534 |
26 |
61574 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_kill_qty_storno |
163988 |
130947 |
33041 |
20.14 |
0 |
59561 |
97 |
33041 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_lock_selected_doc |
50866 |
43869 |
6997 |
13.75 |
0 |
78 |
1 |
6997 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_make_cost_storno |
62953 |
62953 |
0 |
0.00 |
0 |
134256 |
819 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_multiply_rows_for_pdistr |
62953 |
62953 |
0 |
0.00 |
0 |
1107 |
31 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_multiply_rows_for_qdistr |
51111 |
51111 |
0 |
0.00 |
0 |
4914 |
107 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_pay_from_customer |
17193 |
17193 |
0 |
0.00 |
46 |
102041 |
1178 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_pay_to_supplier |
14202 |
14202 |
0 |
0.00 |
31 |
136113 |
1820 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_payment_common |
31395 |
31395 |
0 |
0.00 |
0 |
7987 |
60 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_qd_handle_on_cancel_clo |
4344 |
4074 |
270 |
6.21 |
0 |
1732 |
23 |
270 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_qd_handle_on_invoice_upd_sts |
9520 |
9240 |
280 |
2.94 |
0 |
49546 |
757 |
280 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_qd_handle_on_reserve_upd_sts |
24035 |
24035 |
0 |
0.00 |
0 |
952 |
19 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_reserve_write_off |
24675 |
24035 |
640 |
2.59 |
15 |
96566 |
200 |
640 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_supplier_invoice |
13311 |
13311 |
0 |
0.00 |
31 |
97593 |
4370 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
sp_supplier_order |
13183 |
13183 |
0 |
0.00 |
31 |
329818 |
5982 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
srv_find_qd_qs_mism |
574188 |
541486 |
32702 |
5.69 |
0 |
14149 |
15 |
32702 |
2016-11-06 03:56 |
2016-11-06 06:56 |
srv_make_invnt_saldo |
981 |
981 |
0 |
0.00 |
218 |
55833 |
9017 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
srv_make_money_saldo |
2958 |
2958 |
0 |
0.00 |
0 |
671 |
40 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
3697 |
16475 |
8105 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-abend:sp_add_invoice_to_stock |
4697 |
4697 |
0 |
0.00 |
0 |
3417 |
654 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-abend:sp_cancel_adding_invoice |
492 |
492 |
0 |
0.00 |
15 |
16895 |
4531 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-abend:sp_cancel_client_order |
270 |
270 |
0 |
0.00 |
15 |
3167 |
1124 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-abend:sp_cancel_customer_reserve |
40 |
40 |
0 |
0.00 |
31 |
1482 |
642 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-abend:sp_cancel_pay_from_customer |
34 |
34 |
0 |
0.00 |
31 |
2028 |
1267 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-abend:sp_cancel_pay_to_supplier |
15 |
15 |
0 |
0.00 |
687 |
1872 |
1259 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-abend:sp_cancel_supplier_invoice |
371 |
371 |
0 |
0.00 |
0 |
1857 |
688 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-abend:sp_cancel_supplier_order |
3992 |
3992 |
0 |
0.00 |
0 |
17924 |
4712 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-abend:sp_cancel_write_off |
46 |
46 |
0 |
0.00 |
0 |
1357 |
702 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-abend:sp_reserve_write_off |
640 |
640 |
0 |
0.00 |
0 |
2152 |
728 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_add_invoice_to_stock |
7530 |
7530 |
0 |
0.00 |
15 |
237457 |
44528 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_cancel_adding_invoice |
798 |
798 |
0 |
0.00 |
46 |
184535 |
34722 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_cancel_client_order |
4074 |
4074 |
0 |
0.00 |
0 |
3058 |
1035 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_cancel_customer_reserve |
1590 |
1590 |
0 |
0.00 |
0 |
3042 |
1144 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_cancel_pay_from_customer |
1608 |
1608 |
0 |
0.00 |
0 |
2277 |
821 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_cancel_pay_to_supplier |
956 |
956 |
0 |
0.00 |
0 |
2278 |
799 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_cancel_supplier_invoice |
625 |
625 |
0 |
0.00 |
0 |
2824 |
1029 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_cancel_supplier_order |
289 |
289 |
0 |
0.00 |
16 |
1515007 |
155185 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_cancel_write_off |
2371 |
2371 |
0 |
0.00 |
0 |
3916 |
1161 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_client_order |
51111 |
51111 |
0 |
0.00 |
0 |
4868 |
1382 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_customer_reserve |
2369 |
2369 |
0 |
0.00 |
0 |
3370 |
685 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_pay_from_customer |
17193 |
17193 |
0 |
0.00 |
0 |
4119 |
891 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_pay_to_supplier |
14202 |
14202 |
0 |
0.00 |
0 |
3042 |
904 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_reserve_write_off |
24035 |
24035 |
0 |
0.00 |
0 |
4415 |
1261 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_supplier_invoice |
13385 |
13385 |
0 |
0.00 |
0 |
4727 |
1369 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:sp_supplier_order |
13191 |
13191 |
0 |
0.00 |
0 |
4212 |
1365 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:srv_make_invnt_saldo |
982 |
982 |
0 |
0.00 |
0 |
717 |
102 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:srv_make_money_saldo |
2958 |
2958 |
0 |
0.00 |
0 |
780 |
104 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
t$perf-norm:srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
31 |
10670 |
5372 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_add_invoice_to_stock |
24440 |
15046 |
9394 |
38.43 |
0 |
63 |
2 |
9394 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_all_customers |
76276 |
76276 |
0 |
0.00 |
0 |
109 |
1 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_all_suppliers |
52988 |
52988 |
0 |
0.00 |
0 |
78 |
1 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_all_wares |
102222 |
102222 |
0 |
0.00 |
0 |
78 |
1 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_cancel_adding_invoice |
1970 |
1596 |
374 |
18.98 |
0 |
234 |
24 |
374 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_cancel_client_order |
8688 |
8148 |
540 |
6.21 |
0 |
94 |
2 |
540 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_cancel_customer_prepayment |
3284 |
3216 |
68 |
2.07 |
0 |
63 |
3 |
68 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_cancel_customer_reserve |
3260 |
3180 |
80 |
2.45 |
0 |
94 |
4 |
80 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_cancel_payment_to_supplier |
1942 |
1912 |
30 |
1.54 |
0 |
63 |
3 |
30 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_cancel_supplier_invoice |
1992 |
1250 |
742 |
37.24 |
0 |
62 |
3 |
742 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_cancel_supplier_order |
1972 |
578 |
1394 |
70.68 |
0 |
78 |
4 |
1394 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_cancel_write_off |
4834 |
4742 |
92 |
1.90 |
0 |
156 |
12 |
92 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_max_id_clo_ord |
13183 |
13183 |
0 |
0.00 |
0 |
2293 |
58 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_max_id_clo_res |
2369 |
2369 |
0 |
0.00 |
0 |
109 |
7 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_max_id_ord_sup |
13312 |
13312 |
0 |
0.00 |
0 |
10187 |
32 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_max_non_paid_invoice |
14202 |
14202 |
0 |
0.00 |
0 |
561 |
3 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_max_non_paid_realizn |
17193 |
17193 |
0 |
0.00 |
0 |
219 |
2 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_min_id_clo_ord |
13183 |
13183 |
0 |
0.00 |
0 |
3245 |
63 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_min_id_clo_res |
2369 |
2369 |
0 |
0.00 |
0 |
1014 |
7 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_min_id_ord_sup |
13311 |
13311 |
0 |
0.00 |
0 |
1404 |
39 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_min_non_paid_invoice |
14202 |
14202 |
0 |
0.00 |
0 |
7534 |
50 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_min_non_paid_realizn |
17193 |
17193 |
0 |
0.00 |
0 |
1341 |
10 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_our_firm |
25946 |
25946 |
0 |
0.00 |
0 |
47 |
1 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
v_reserve_write_off |
49350 |
48070 |
1280 |
2.59 |
0 |
266 |
3 |
1280 |
2016-11-06 03:56 |
2016-11-06 06:56 |
x_lock_depdocs_on_canc_invoice |
7757 |
5008 |
2749 |
35.43 |
0 |
343 |
8 |
2749 |
2016-11-06 03:56 |
2016-11-06 06:56 |
x_lock_depdocs_on_canc_sup_ord |
985 |
289 |
696 |
70.65 |
0 |
62 |
10 |
696 |
2016-11-06 03:56 |
2016-11-06 06:56 |
x_make_qstorno_1000_1200 |
13186 |
13186 |
0 |
0.00 |
0 |
250319 |
4031 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
x_make_qstorno_1200_2000 |
13321 |
13321 |
0 |
0.00 |
15 |
72010 |
3227 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
x_make_qstorno_2100_3300 |
356622 |
356622 |
0 |
0.00 |
0 |
28439 |
512 |
0 |
2016-11-06 03:56 |
2016-11-06 06:56 |
Done for 193750 ms, from 7:07:43.18 to 7:10:56.93.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
68 |
sp_kill_cost_storno |
335544336 |
2016-11-06 03:57 |
2016-11-06 06:55 |
deadlock |
4 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2016-11-06 04:42 |
2016-11-06 06:06 |
deadlock |
17 |
sp_lock_selected_doc |
335544336 |
2016-11-06 03:56 |
2016-11-06 06:51 |
deadlock |
270 |
sp_qd_handle_on_cancel_clo |
335544336 |
2016-11-06 03:57 |
2016-11-06 06:55 |
deadlock |
102 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2016-11-06 03:56 |
2016-11-06 06:48 |
deadlock |
1 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2016-11-06 06:06 |
2016-11-06 06:06 |
concurrent_transaction |
5806 |
sp_lock_selected_doc |
335544878 |
2016-11-06 03:56 |
2016-11-06 06:56 |
concurrent_transaction |
370 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2016-11-06 03:56 |
2016-11-06 06:55 |
concurrent_transaction |
357 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2016-11-06 03:57 |
2016-11-06 06:55 |
Done for 8300 ms, from 7:11:03.63 to 7:11:11.93.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 261636
MON$OLDEST_ACTIVE 261637
MON$OLDEST_SNAPSHOT 261637
MON$NEXT_TRANSACTION 261637
MON$PAGE_BUFFERS 384
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 2015-12-11 13:07:49.8140
MON$PAGES 615648
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.2.32627 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.2.32627 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.2.32627 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.2.32627 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 262500
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 261638
Oldest active 261639
Oldest snapshot 261639
Next transaction 261640
Sequence number 0
Next attachment ID 4923
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 13:07:49
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 34.24, 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.05
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 45
Average key length: 2.04, compression ratio: 0.53
Average prefix length: 1.02, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.92, total dup: 0, max dup: 0
Average key length: 16.60, compression ratio: 0.92
Average prefix length: 1.34, average data length: 13.92
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 103.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: 996.00, compression ratio: 9.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 28%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 40.05, total records: 1550210
Average version length: 46.63, total versions: 224620, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.60
Pointer pages: 11, data page slots: 16560
Data pages: 16560, average fill: 76%
Primary pages: 16560, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 16557
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 15215
80 - 99% = 1343
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 6903, nodes: 1550210
Average node length: 19.75, total dup: 0, max dup: 0
Average key length: 16.81, compression ratio: 1.61
Average prefix length: 13.19, average data length: 13.81
Clustering factor: 223296, ratio: 0.14
Fill distribution:
0 - 19% = 535
20 - 39% = 0
40 - 59% = 4847
60 - 79% = 800
80 - 99% = 721
Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 4599, nodes: 1550210
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.29, average data length: 5.71
Clustering factor: 185292, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4598
60 - 79% = 1
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 149779, depth: 3, leaf buckets: 2523, nodes: 1550210
Average node length: 7.04, total dup: 1085873, max dup: 49
Average key length: 4.11, compression ratio: 2.19
Average prefix length: 7.19, average data length: 1.81
Clustering factor: 213094, ratio: 0.14
Fill distribution:
0 - 19% = 146
20 - 39% = 0
40 - 59% = 2051
60 - 79% = 78
80 - 99% = 248
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 55.63, total records: 449411
Average version length: 39.08, total versions: 74962, max versions: 5
Average fragment length: 16.89, total fragments: 99, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.73
Pointer pages: 4, data page slots: 5664
Data pages: 5664, average fill: 80%
Primary pages: 5652, secondary pages: 12, swept pages: 0
Empty pages: 0, full pages: 5647
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 1
60 - 79% = 3647
80 - 99% = 2012
Index DOC_LIST_ID_DESC (1)
Root page: 244403, depth: 3, leaf buckets: 1526, nodes: 449411
Average node length: 11.79, total dup: 0, max dup: 0
Average key length: 8.98, compression ratio: 1.00
Average prefix length: 3.02, average data length: 5.98
Clustering factor: 92349, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 407
40 - 59% = 1115
60 - 79% = 4
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 466, nodes: 449411
Average node length: 4.82, total dup: 449361, max dup: 38081
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 206508, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 415
60 - 79% = 28
80 - 99% = 23
Index PK_DOC_LIST (0)
Root page: 286907, depth: 3, leaf buckets: 1297, nodes: 449411
Average node length: 11.79, total dup: 0, max dup: 0
Average key length: 8.98, compression ratio: 1.00
Average prefix length: 3.02, average data length: 5.98
Clustering factor: 92349, ratio: 0.21
Fill distribution:
0 - 19% = 153
20 - 39% = 201
40 - 59% = 630
60 - 79% = 45
80 - 99% = 268
DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 1
Average record length: 62.30, total records: 400
Average version length: 18.75, total versions: 370731, max versions: 971
Average fragment length: 15.93, total fragments: 383, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.67
Pointer pages: 2, data page slots: 2128
Data pages: 2128, average fill: 78%
Primary pages: 10, secondary pages: 2118, swept pages: 0
Empty pages: 6, full pages: 2121
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1301
80 - 99% = 821
Index PK_INVNT_SALDO (0)
Root page: 281, 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: 262, ratio: 0.66
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 4.03, total records: 382535
Average version length: 70.99, total versions: 360699, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 23.82
Pointer pages: 4, data page slots: 5552
Data pages: 5336, average fill: 91%
Primary pages: 5336, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 5231
Fill distribution:
0 - 19% = 7
20 - 39% = 15
40 - 59% = 43
60 - 79% = 275
80 - 99% = 4996
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 192781, depth: 3, leaf buckets: 1209, nodes: 382535
Average node length: 13.72, total dup: 33534, max dup: 5
Average key length: 10.93, compression ratio: 2.47
Average prefix length: 18.98, average data length: 8.02
Clustering factor: 315243, ratio: 0.82
Fill distribution:
0 - 19% = 4
20 - 39% = 327
40 - 59% = 517
60 - 79% = 193
80 - 99% = 168
MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 15.08, total records: 49
Average version length: 9.00, total versions: 37041, max versions: 2855
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.12
Pointer pages: 1, data page slots: 128
Data pages: 128, average fill: 92%
Primary pages: 1, secondary pages: 127, swept pages: 0
Empty pages: 0, full pages: 127
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 127
Index PK_MONEY_SALDO (0)
Root page: 272, 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: 259, Index root page: 260
Total formats: 1, used formats: 1
Average record length: 1.36, total records: 17000
Average version length: 45.15, total versions: 16514, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 46.95
Pointer pages: 1, data page slots: 184
Data pages: 184, average fill: 89%
Primary pages: 184, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 178
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 8
80 - 99% = 172
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 102782, depth: 2, leaf buckets: 12, nodes: 17000
Average node length: 4.02, total dup: 16906, max dup: 2527
Average key length: 2.07, compression ratio: 9.17
Average prefix length: 18.93, average data length: 0.07
Clustering factor: 6455, ratio: 0.38
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 2
60 - 79% = 5
80 - 99% = 4
MON_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 2, 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: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 359, 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 (165)
Primary pointer page: 364, Index root page: 365
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: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 368, 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: 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_TABLE_STATS_TN_UNIT (3)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
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
OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 25.69, total records: 338700
Average version length: 33.37, total versions: 197794, max versions: 11
Average fragment length: 33.19, total fragments: 27, max fragments: 1
Average unpacked length: 64.00, compression ratio: 2.49
Pointer pages: 3, data page slots: 3600
Data pages: 3600, average fill: 83%
Primary pages: 3551, secondary pages: 49, swept pages: 0
Empty pages: 2, full pages: 3579
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 3
60 - 79% = 1376
80 - 99% = 2216
Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 313, nodes: 338700
Average node length: 4.71, total dup: 338651, max dup: 44566
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 36371, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 11
40 - 59% = 160
60 - 79% = 98
80 - 99% = 44
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 376, nodes: 338700
Average node length: 5.69, total dup: 304358, max dup: 69
Average key length: 2.99, compression ratio: 7.36
Average prefix length: 21.11, average data length: 0.89
Clustering factor: 43516, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 180
60 - 79% = 96
80 - 99% = 79
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 401, nodes: 338700
Average node length: 5.69, total dup: 304358, max dup: 69
Average key length: 2.99, compression ratio: 7.35
Average prefix length: 21.11, average data length: 0.89
Clustering factor: 45040, ratio: 0.13
Fill distribution:
0 - 19% = 2
20 - 39% = 17
40 - 59% = 214
60 - 79% = 109
80 - 99% = 59
Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 382, nodes: 338700
Average node length: 5.46, total dup: 304358, max dup: 69
Average key length: 2.76, compression ratio: 3.26
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 43605, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 31
40 - 59% = 184
60 - 79% = 120
80 - 99% = 46
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.87, total records: 182826
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 1, data page slots: 1568
Data pages: 1568, average fill: 64%
Primary pages: 1568, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 1560
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1560
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 597246, depth: 2, leaf buckets: 145, nodes: 182826
Average node length: 4.30, total dup: 182635, max dup: 2225
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 65365, ratio: 0.36
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 50
60 - 79% = 71
80 - 99% = 24
PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (162)
Primary pointer page: 348, Index root page: 349
Total formats: 2, used formats: 2
Average record length: 147.01, total records: 6377491
Average version length: 96.00, total versions: 1, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1432.67, compression ratio: 9.75
Pointer pages: 91, data page slots: 147368
Data pages: 147368, average fill: 87%
Primary pages: 147368, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 147360
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 147360
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 6530, nodes: 6377491
Average node length: 5.37, total dup: 5316313, max dup: 53
Average key length: 2.33, compression ratio: 3.43
Average prefix length: 7.74, average data length: 0.25
Clustering factor: 4543809, ratio: 0.71
Fill distribution:
0 - 19% = 15
20 - 39% = 0
40 - 59% = 3097
60 - 79% = 2123
80 - 99% = 1295
Index PERF_LOG_GDSCODE (3)
Root page: 150457, depth: 3, leaf buckets: 5718, nodes: 6377491
Average node length: 4.09, total dup: 6377486, max dup: 6086930
Average key length: 1.05, compression ratio: 0.22
Average prefix length: 0.23, average data length: 0.00
Clustering factor: 245587, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 5691
60 - 79% = 3
80 - 99% = 23
Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 6658, nodes: 6377491
Average node length: 5.31, total dup: 6149568, max dup: 11319
Average key length: 2.26, compression ratio: 3.98
Average prefix length: 8.77, average data length: 0.23
Clustering factor: 4017779, ratio: 0.63
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 3767
60 - 79% = 1720
80 - 99% = 1167
Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 7138, nodes: 6377491
Average node length: 5.17, total dup: 6326108, max dup: 975080
Average key length: 2.12, compression ratio: 17.71
Average prefix length: 37.51, average data length: 0.12
Clustering factor: 3964006, ratio: 0.62
Fill distribution:
0 - 19% = 28
20 - 39% = 2
40 - 59% = 5798
60 - 79% = 508
80 - 99% = 802
PHRASES (145)
Primary pointer page: 265, Index root page: 266
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: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 45.34, total records: 265179
Average version length: 54.28, total versions: 44592, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.76
Pointer pages: 2, data page slots: 3104
Data pages: 3104, average fill: 78%
Primary pages: 3104, secondary pages: 0, swept pages: 0
Empty pages: 1, full pages: 3101
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2481
80 - 99% = 620
Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 324, nodes: 265179
Average node length: 5.99, total dup: 216728, max dup: 1217
Average key length: 3.35, compression ratio: 2.69
Average prefix length: 7.84, average data length: 1.16
Clustering factor: 15857, ratio: 0.06
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 183
60 - 79% = 113
80 - 99% = 26
Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 256, nodes: 265179
Average node length: 5.36, total dup: 240606, max dup: 353
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.38, average data length: 0.62
Clustering factor: 45658, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 92
60 - 79% = 103
80 - 99% = 61
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 4362, max versions: 3167
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 87%
Primary pages: 1, secondary pages: 15, swept pages: 0
Empty pages: 0, full pages: 15
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 15
Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.32, 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: 81%
Primary pages: 2, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.07, total dup: 0, max dup: 0
Average key length: 26.06, compression ratio: 1.70
Average prefix length: 21.23, average data length: 23.07
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 2, 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: 358, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (276)
Primary pointer page: 557, Index root page: 68921
Total formats: 1, used formats: 1
Average record length: 58.58, total records: 1898
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: 136.00, compression ratio: 2.32
Pointer pages: 1, data page slots: 24
Data pages: 24, average fill: 73%
Primary pages: 24, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 23
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 23
80 - 99% = 0
WARES (144)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 77.53, 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.78
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: 374, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 64
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 273, 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: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 275, 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: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 52.95, total dup: 0, max dup: 0
Average key length: 51.92, compression ratio: 0.99
Average prefix length: 2.65, average data length: 48.95
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (259)
Primary pointer page: 254, Index root page: 284
Total formats: 1, used formats: 1
Average record length: 0.68, total records: 515733
Average version length: 72.17, total versions: 510813, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 198.57
Pointer pages: 5, data page slots: 7248
Data pages: 7248, average fill: 92%
Primary pages: 7248, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 7240
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 0
60 - 79% = 118
80 - 99% = 7122
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 132042, depth: 3, leaf buckets: 651, nodes: 515733
Average node length: 6.13, total dup: 451419, max dup: 29
Average key length: 3.28, compression ratio: 11.28
Average prefix length: 35.84, average data length: 1.16
Clustering factor: 71635, ratio: 0.14
Fill distribution:
0 - 19% = 153
20 - 39% = 22
40 - 59% = 146
60 - 79% = 19
80 - 99% = 311
XQD_1000_3300 (261)
Primary pointer page: 708, Index root page: 709
Total formats: 1, used formats: 1
Average record length: 58.30, total records: 1371877
Average version length: 69.73, total versions: 253367, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.33
Pointer pages: 12, data page slots: 19264
Data pages: 19264, average fill: 80%
Primary pages: 19264, secondary pages: 0, swept pages: 0
Empty pages: 13, full pages: 18987
Fill distribution:
0 - 19% = 39
20 - 39% = 44
40 - 59% = 80
60 - 79% = 12705
80 - 99% = 6396
Index XQD_1000_3300_DOC (1)
Root page: 263602, depth: 3, leaf buckets: 1224, nodes: 1371877
Average node length: 5.14, total dup: 1335553, max dup: 177
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 79774, ratio: 0.06
Fill distribution:
0 - 19% = 6
20 - 39% = 49
40 - 59% = 586
60 - 79% = 39
80 - 99% = 544
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 115465, depth: 3, leaf buckets: 1931, nodes: 1371877
Average node length: 6.28, total dup: 1197833, max dup: 38
Average key length: 3.33, compression ratio: 11.11
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 215387, ratio: 0.16
Fill distribution:
0 - 19% = 12
20 - 39% = 120
40 - 59% = 1496
60 - 79% = 159
80 - 99% = 144
XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 4.91, total records: 813842
Average version length: 71.83, total versions: 757363, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 27.71
Pointer pages: 8, data page slots: 11680
Data pages: 11672, average fill: 89%
Primary pages: 11671, secondary pages: 1, swept pages: 0
Empty pages: 82, full pages: 11275
Fill distribution:
0 - 19% = 190
20 - 39% = 88
40 - 59% = 79
60 - 79% = 603
80 - 99% = 10712
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 131111, depth: 3, leaf buckets: 1090, nodes: 813842
Average node length: 5.99, total dup: 731505, max dup: 94
Average key length: 3.08, compression ratio: 12.02
Average prefix length: 36.02, average data length: 0.98
Clustering factor: 99068, ratio: 0.12
Fill distribution:
0 - 19% = 9
20 - 39% = 73
40 - 59% = 755
60 - 79% = 123
80 - 99% = 130
XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 21.32, total records: 3592233
Average version length: 70.34, total versions: 2527219, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 6.38
Pointer pages: 31, data page slots: 50168
Data pages: 50168, average fill: 88%
Primary pages: 50168, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 50019
Fill distribution:
0 - 19% = 20
20 - 39% = 33
40 - 59% = 53
60 - 79% = 12125
80 - 99% = 37937
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 116964, depth: 3, leaf buckets: 4579, nodes: 3592233
Average node length: 5.75, total dup: 3333544, max dup: 113
Average key length: 2.77, compression ratio: 13.34
Average prefix length: 36.30, average data length: 0.70
Clustering factor: 404097, ratio: 0.11
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 4269
60 - 79% = 164
80 - 99% = 143
XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 0.66, total records: 579041
Average version length: 71.05, total versions: 573507, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 205.13
Pointer pages: 6, data page slots: 8296
Data pages: 8256, average fill: 90%
Primary pages: 8255, secondary pages: 1, swept pages: 0
Empty pages: 147, full pages: 7948
Fill distribution:
0 - 19% = 184
20 - 39% = 31
40 - 59% = 40
60 - 79% = 214
80 - 99% = 7787
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 395082, depth: 3, leaf buckets: 644, nodes: 579041
Average node length: 5.75, total dup: 532262, max dup: 149
Average key length: 2.89, compression ratio: 12.81
Average prefix length: 36.19, average data length: 0.81
Clustering factor: 59070, ratio: 0.10
Fill distribution:
0 - 19% = 3
20 - 39% = 6
40 - 59% = 283
60 - 79% = 230
80 - 99% = 122
XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 41.55, total records: 2634061
Average version length: 69.57, total versions: 1091911, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.27
Pointer pages: 23, data page slots: 36520
Data pages: 36520, average fill: 83%
Primary pages: 36519, secondary pages: 1, swept pages: 19
Empty pages: 4, full pages: 36474
Fill distribution:
0 - 19% = 13
20 - 39% = 4
40 - 59% = 7
60 - 79% = 10928
80 - 99% = 25568
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 3899, nodes: 2634061
Average node length: 6.82, total dup: 2149525, max dup: 29
Average key length: 3.85, compression ratio: 9.62
Average prefix length: 35.34, average data length: 1.66
Clustering factor: 443983, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 4
40 - 59% = 3311
60 - 79% = 375
80 - 99% = 207
XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 76.84, total records: 3105767
Average version length: 82.02, total versions: 225882, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.77
Pointer pages: 29, data page slots: 46936
Data pages: 46936, average fill: 82%
Primary pages: 46936, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 46933
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 1
60 - 79% = 5448
80 - 99% = 41485
Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3038, nodes: 3105767
Average node length: 5.15, total dup: 3035797, max dup: 149
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 489136, ratio: 0.16
Fill distribution:
0 - 19% = 11
20 - 39% = 0
40 - 59% = 1112
60 - 79% = 1529
80 - 99% = 386
Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 3309, nodes: 3105767
Average node length: 5.69, total dup: 2781487, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 153570, ratio: 0.05
Fill distribution:
0 - 19% = 40
20 - 39% = 0
40 - 59% = 2116
60 - 79% = 96
80 - 99% = 1057
Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 3377, nodes: 3105767
Average node length: 5.79, total dup: 2721747, max dup: 44
Average key length: 2.82, compression ratio: 3.20
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 526816, ratio: 0.17
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 1208
60 - 79% = 1671
80 - 99% = 492
XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 53.91, total records: 1575085
Average version length: 80.97, total versions: 535448, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.52
Pointer pages: 15, data page slots: 23712
Data pages: 23712, average fill: 85%
Primary pages: 23712, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 23697
Fill distribution:
0 - 19% = 12
20 - 39% = 2
40 - 59% = 2
60 - 79% = 2346
80 - 99% = 21350
Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1421, nodes: 1575085
Average node length: 5.09, total dup: 1548748, max dup: 492
Average key length: 2.13, compression ratio: 4.22
Average prefix length: 8.88, average data length: 0.12
Clustering factor: 213374, ratio: 0.14
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 466
60 - 79% = 537
80 - 99% = 414
Index XQS_1000_3300_RCV_ID (2)
Root page: 107901, depth: 3, leaf buckets: 1784, nodes: 1575085
Average node length: 6.19, total dup: 1300549, max dup: 14
Average key length: 3.23, compression ratio: 2.78
Average prefix length: 7.94, average data length: 1.06
Clustering factor: 69327, ratio: 0.04
Fill distribution:
0 - 19% = 90
20 - 39% = 0
40 - 59% = 929
60 - 79% = 2
80 - 99% = 763
Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 1537, nodes: 1575085
Average node length: 5.56, total dup: 1436253, max dup: 92
Average key length: 2.61, compression ratio: 3.45
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 276772, ratio: 0.18
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 426
60 - 79% = 650
80 - 99% = 454
XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 60.92, total records: 4101791
Average version length: 82.84, total versions: 1090022, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.23
Pointer pages: 39, data page slots: 62408
Data pages: 62408, average fill: 84%
Primary pages: 62408, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 62407
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 8574
80 - 99% = 53833
Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 3832, nodes: 4101791
Average node length: 5.03, total dup: 4083369, max dup: 1268
Average key length: 2.04, compression ratio: 4.41
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 592686, ratio: 0.14
Fill distribution:
0 - 19% = 13
20 - 39% = 10
40 - 59% = 1561
60 - 79% = 1453
80 - 99% = 795
Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 4492, nodes: 4101791
Average node length: 5.54, total dup: 3766336, max dup: 49
Average key length: 2.56, compression ratio: 3.52
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 239134, ratio: 0.06
Fill distribution:
0 - 19% = 46
20 - 39% = 1
40 - 59% = 3094
60 - 79% = 256
80 - 99% = 1095
Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 4228, nodes: 4101791
Average node length: 5.52, total dup: 3777650, max dup: 247
Average key length: 2.54, compression ratio: 3.55
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 668510, ratio: 0.16
Fill distribution:
0 - 19% = 9
20 - 39% = 5
40 - 59% = 1777
60 - 79% = 1563
80 - 99% = 874
XQS_2000_3300 (268)
Primary pointer page: 757, Index root page: 758
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: 760, 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: 762, 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: 761, 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 (269)
Primary pointer page: 763, Index root page: 764
Total formats: 1, used formats: 1
Average record length: 60.45, total records: 2652070
Average version length: 81.65, total versions: 710849, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.25
Pointer pages: 25, data page slots: 40640
Data pages: 40640, average fill: 83%
Primary pages: 40640, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 40623
Fill distribution:
0 - 19% = 10
20 - 39% = 7
40 - 59% = 0
60 - 79% = 6035
80 - 99% = 34588
Index XQS_2100_3300_DOC_ID (0)
Root page: 82214, depth: 3, leaf buckets: 2529, nodes: 2652070
Average node length: 5.01, total dup: 2640944, max dup: 1560
Average key length: 2.04, compression ratio: 4.41
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 483675, ratio: 0.18
Fill distribution:
0 - 19% = 4
20 - 39% = 19
40 - 59% = 1172
60 - 79% = 793
80 - 99% = 541
Index XQS_2100_3300_RCV_ID (2)
Root page: 94033, depth: 3, leaf buckets: 3481, nodes: 2652070
Average node length: 6.27, total dup: 2163979, max dup: 14
Average key length: 3.30, compression ratio: 2.73
Average prefix length: 7.89, average data length: 1.11
Clustering factor: 207375, ratio: 0.08
Fill distribution:
0 - 19% = 181
20 - 39% = 43
40 - 59% = 2291
60 - 79% = 43
80 - 99% = 923
Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 2737, nodes: 2652070
Average node length: 5.50, total dup: 2452352, max dup: 140
Average key length: 2.52, compression ratio: 3.57
Average prefix length: 8.55, average data length: 0.45
Clustering factor: 525135, ratio: 0.20
Fill distribution:
0 - 19% = 3
20 - 39% = 10
40 - 59% = 1212
60 - 79% = 911
80 - 99% = 601
XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 47.39, total records: 581051
Average version length: 68.72, total versions: 181980, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.87
Pointer pages: 5, data page slots: 7872
Data pages: 7872, average fill: 82%
Primary pages: 7872, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 7869
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3534
80 - 99% = 4335
Index XQS_3300_3400_DOC_ID (0)
Root page: 419583, depth: 3, leaf buckets: 570, nodes: 581051
Average node length: 5.29, total dup: 549034, max dup: 181
Average key length: 2.43, compression ratio: 3.71
Average prefix length: 8.63, average data length: 0.37
Clustering factor: 40279, ratio: 0.07
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 222
60 - 79% = 228
80 - 99% = 119
Index XQS_3300_3400_SND_ID (1)
Root page: 328231, depth: 3, leaf buckets: 627, nodes: 581051
Average node length: 5.90, total dup: 497972, max dup: 29
Average key length: 3.04, compression ratio: 2.96
Average prefix length: 8.10, average data length: 0.90
Clustering factor: 49779, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 240
60 - 79% = 232
80 - 99% = 154
ZDOC_DATA (229)
Primary pointer page: 632, Index root page: 633
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 (228)
Primary pointer page: 630, Index root page: 631
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 (230)
Primary pointer page: 634, Index root page: 635
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 (233)
Primary pointer page: 640, Index root page: 641
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 650, 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 (234)
Primary pointer page: 642, Index root page: 643
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 651, 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 (231)
Primary pointer page: 636, Index root page: 637
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: 644, 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: 645, 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 (232)
Primary pointer page: 638, Index root page: 639
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: 647, 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: 646, 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: 649, 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: 648, 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 (227)
Primary pointer page: 628, Index root page: 629
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 (226)
Primary pointer page: 625, Index root page: 626
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: 267, Index root page: 268
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: 280, 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 33470 ms, from 7:11:12.42 to 7:11:45.89.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
1550210 |
224620 |
14.4896 |
DOC_LIST |
449411 |
74962 |
16.6800 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
370731 |
92682.7500 |
INVNT_TURNOVER_LOG |
382535 |
360699 |
94.2917 |
MONEY_SALDO |
49 |
37041 |
75593.8775 |
MONEY_TURNOVER_LOG |
17000 |
16514 |
97.1411 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
338700 |
197794 |
58.3979 |
PERF_ESTIMATED |
182826 |
0 |
0.0000 |
PERF_LOG |
6377491 |
1 |
0.0000 |
PSTORNED |
265179 |
44592 |
16.8158 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
4362 |
109050.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
1898 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
515733 |
510813 |
99.0460 |
XQD_1000_3300 |
1371877 |
253367 |
18.4686 |
XQD_1200_2000 |
813842 |
757363 |
93.0602 |
XQD_2000_3300 |
3592233 |
2527219 |
70.3523 |
XQD_2100_3300 |
579041 |
573507 |
99.0442 |
XQD_3300_3400 |
2634061 |
1091911 |
41.4535 |
XQS_1000_1200 |
3105767 |
225882 |
7.2729 |
XQS_1000_3300 |
1575085 |
535448 |
33.9948 |
XQS_1200_2000 |
4101791 |
1090022 |
26.5742 |
XQS_2100_3300 |
2652070 |
710849 |
26.8035 |
XQS_3300_3400 |
581051 |
181980 |
31.3191 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2480 ms, from 7:11:55.91 to 7:11:58.39.
07:11:58.50 Validation started
07:11:58.50 Relation 140 (DOC_LIST)
07:11:58.50 process pointer page 0 of 4
07:11:58.61 process pointer page 1 of 4
07:11:58.73 process pointer page 2 of 4
07:11:58.89 process pointer page 3 of 4
07:11:58.94 Index 1 (PK_DOC_LIST)
07:11:59.14 Index 2 (DOC_LIST_ID_DESC)
07:11:59.36 Index 3 (FK_DOC_LIST_AGENTS)
07:11:59.48 Relation 140 (DOC_LIST) is ok
07:11:59.48 Relation 141 (DOC_DATA)
07:11:59.48 process pointer page 0 of 11
07:11:59.56 process pointer page 1 of 11
07:11:59.61 process pointer page 2 of 11
07:11:59.68 process pointer page 3 of 11
07:11:59.83 process pointer page 4 of 11
07:11:59.97 process pointer page 5 of 11
07:12:00.11 process pointer page 6 of 11
07:12:00.23 process pointer page 7 of 11
07:12:00.36 process pointer page 8 of 11
07:12:00.39 process pointer page 9 of 11
07:12:00.43 process pointer page 10 of 11
07:12:00.43 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:12:01.20 Index 3 (DOC_DATA_ID_DESC)
07:12:01.84 Index 4 (FK_DOC_DATA_DOC_LIST)
07:12:02.37 Relation 141 (DOC_DATA) is ok
07:12:02.37 Relation 147 (INVNT_SALDO)
07:12:02.37 process pointer page 0 of 2
07:12:08.28 process pointer page 1 of 2
07:12:08.30 Index 1 (PK_INVNT_SALDO)
07:12:08.30 Relation 147 (INVNT_SALDO) is ok
07:12:08.30 Relation 150 (PDISTR)
07:12:08.30 process pointer page 0 of 3
07:12:08.51 process pointer page 1 of 3
07:12:08.80 process pointer page 2 of 3
07:12:08.86 Index 2 (PDISTR_SND_ID)
07:12:08.97 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:12:09.09 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:12:09.20 Index 5 (PDISTR_AGENT_ID)
07:12:09.31 Relation 150 (PDISTR) is ok
07:12:09.31 Relation 151 (PSTORNED)
07:12:09.31 process pointer page 0 of 2
07:12:09.43 process pointer page 1 of 2
07:12:09.54 Index 2 (PSTORNED_SND_ID)
07:12:09.62 Index 3 (PSTORNED_RCV_ID)
07:12:09.70 Relation 151 (PSTORNED) is ok
07:12:09.70 Relation 156 (SEMAPHORES)
07:12:09.70 process pointer page 0 of 1
07:12:09.72 Index 1 (PK_SEMAPHORES)
07:12:09.72 Index 2 (SEMAPHORES_TASK_UNQ)
07:12:09.72 Relation 156 (SEMAPHORES) is ok
07:12:09.72 Relation 157 (INVNT_TURNOVER_LOG)
07:12:09.72 process pointer page 0 of 4
07:12:09.97 process pointer page 1 of 4
07:12:10.15 process pointer page 2 of 4
07:12:10.37 process pointer page 3 of 4
07:12:10.50 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:12:10.79 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:12:10.79 Relation 160 (PERF_ESTIMATED)
07:12:10.79 process pointer page 0 of 1
07:12:10.89 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:12:10.95 Relation 160 (PERF_ESTIMATED) is ok
07:12:10.95 Relation 161 (PERF_ISQL_STAT)
07:12:10.95 process pointer page 0 of 1
07:12:10.95 Index 1 (PERF_ISQL_STAT_TRN)
07:12:10.95 Relation 161 (PERF_ISQL_STAT) is ok
07:12:10.95 Relation 162 (PERF_LOG)
07:12:10.95 process pointer page 0 of 91
07:12:11.01 process pointer page 1 of 91
07:12:11.09 process pointer page 2 of 91
07:12:11.15 process pointer page 3 of 91
07:12:11.23 process pointer page 4 of 91
07:12:11.29 process pointer page 5 of 91
07:12:11.37 process pointer page 6 of 91
07:12:11.42 process pointer page 7 of 91
07:12:11.45 process pointer page 8 of 91
07:12:11.48 process pointer page 9 of 91
07:12:11.51 process pointer page 10 of 91
07:12:11.53 process pointer page 11 of 91
07:12:11.56 process pointer page 12 of 91
07:12:11.59 process pointer page 13 of 91
07:12:11.63 process pointer page 14 of 91
07:12:11.71 process pointer page 15 of 91
07:12:11.77 process pointer page 16 of 91
07:12:11.84 process pointer page 17 of 91
07:12:11.92 process pointer page 18 of 91
07:12:11.98 process pointer page 19 of 91
07:12:12.06 process pointer page 20 of 91
07:12:12.12 process pointer page 21 of 91
07:12:12.20 process pointer page 22 of 91
07:12:12.26 process pointer page 23 of 91
07:12:12.32 process pointer page 24 of 91
07:12:12.40 process pointer page 25 of 91
07:12:12.46 process pointer page 26 of 91
07:12:12.54 process pointer page 27 of 91
07:12:12.60 process pointer page 28 of 91
07:12:12.66 process pointer page 29 of 91
07:12:12.71 process pointer page 30 of 91
07:12:12.74 process pointer page 31 of 91
07:12:12.77 process pointer page 32 of 91
07:12:12.80 process pointer page 33 of 91
07:12:12.82 process pointer page 34 of 91
07:12:12.85 process pointer page 35 of 91
07:12:12.87 process pointer page 36 of 91
07:12:12.90 process pointer page 37 of 91
07:12:12.94 process pointer page 38 of 91
07:12:13.02 process pointer page 39 of 91
07:12:13.09 process pointer page 40 of 91
07:12:13.15 process pointer page 41 of 91
07:12:13.23 process pointer page 42 of 91
07:12:13.29 process pointer page 43 of 91
07:12:13.37 process pointer page 44 of 91
07:12:13.43 process pointer page 45 of 91
07:12:13.49 process pointer page 46 of 91
07:12:13.57 process pointer page 47 of 91
07:12:13.62 process pointer page 48 of 91
07:12:13.65 process pointer page 49 of 91
07:12:13.69 process pointer page 50 of 91
07:12:13.76 process pointer page 51 of 91
07:12:13.83 process pointer page 52 of 91
07:12:13.90 process pointer page 53 of 91
07:12:13.97 process pointer page 54 of 91
07:12:14.04 process pointer page 55 of 91
07:12:14.08 process pointer page 56 of 91
07:12:14.10 process pointer page 57 of 91
07:12:14.13 process pointer page 58 of 91
07:12:14.16 process pointer page 59 of 91
07:12:14.19 process pointer page 60 of 91
07:12:14.21 process pointer page 61 of 91
07:12:14.24 process pointer page 62 of 91
07:12:14.29 process pointer page 63 of 91
07:12:14.36 process pointer page 64 of 91
07:12:14.43 process pointer page 65 of 91
07:12:14.50 process pointer page 66 of 91
07:12:14.57 process pointer page 67 of 91
07:12:14.63 process pointer page 68 of 91
07:12:14.71 process pointer page 69 of 91
07:12:14.75 process pointer page 70 of 91
07:12:14.79 process pointer page 71 of 91
07:12:14.82 process pointer page 72 of 91
07:12:14.83 process pointer page 73 of 91
07:12:14.86 process pointer page 74 of 91
07:12:14.89 process pointer page 75 of 91
07:12:14.94 process pointer page 76 of 91
07:12:15.00 process pointer page 77 of 91
07:12:15.08 process pointer page 78 of 91
07:12:15.14 process pointer page 79 of 91
07:12:15.22 process pointer page 80 of 91
07:12:15.28 process pointer page 81 of 91
07:12:15.35 process pointer page 82 of 91
07:12:15.43 process pointer page 83 of 91
07:12:15.49 process pointer page 84 of 91
07:12:15.57 process pointer page 85 of 91
07:12:15.63 process pointer page 86 of 91
07:12:15.69 process pointer page 87 of 91
07:12:15.77 process pointer page 88 of 91
07:12:15.83 process pointer page 89 of 91
07:12:15.91 process pointer page 90 of 91
07:12:15.92 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:12:18.67 Index 2 (PERF_LOG_UNIT)
07:12:21.34 Index 3 (PERF_LOG_TRN_DESC)
07:12:24.07 Index 4 (PERF_LOG_GDSCODE)
07:12:25.69 Relation 162 (PERF_LOG) is ok
07:12:25.69 Relation 166 (V_STOPTEST)
07:12:25.69 Relation 166 (V_STOPTEST) is ok
07:12:25.69 Relation 183 (V_QDISTR_SOURCE)
07:12:25.69 Relation 183 (V_QDISTR_SOURCE) is ok
07:12:25.69 Relation 184 (V_QSTORNED_SOURCE)
07:12:25.69 Relation 184 (V_QSTORNED_SOURCE) is ok
07:12:25.69 Relation 259 (XQD_1000_1200)
07:12:25.69 process pointer page 0 of 5
07:12:25.86 process pointer page 1 of 5
07:12:26.08 process pointer page 2 of 5
07:12:26.36 process pointer page 3 of 5
07:12:26.64 process pointer page 4 of 5
07:12:26.75 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:12:26.94 Relation 259 (XQD_1000_1200) is ok
07:12:26.94 Relation 260 (XQD_1200_2000)
07:12:26.94 process pointer page 0 of 8
07:12:27.20 process pointer page 1 of 8
07:12:27.44 process pointer page 2 of 8
07:12:27.70 process pointer page 3 of 8
07:12:27.97 process pointer page 4 of 8
07:12:28.25 process pointer page 5 of 8
07:12:28.50 process pointer page 6 of 8
07:12:28.76 process pointer page 7 of 8
07:12:28.80 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:12:29.09 Relation 260 (XQD_1200_2000) is ok
07:12:29.09 Relation 261 (XQD_1000_3300)
07:12:29.09 process pointer page 0 of 12
07:12:29.20 process pointer page 1 of 12
07:12:29.31 process pointer page 2 of 12
07:12:29.36 process pointer page 3 of 12
07:12:29.50 process pointer page 4 of 12
07:12:29.64 process pointer page 5 of 12
07:12:29.73 process pointer page 6 of 12
07:12:29.83 process pointer page 7 of 12
07:12:29.92 process pointer page 8 of 12
07:12:30.03 process pointer page 9 of 12
07:12:30.14 process pointer page 10 of 12
07:12:30.25 process pointer page 11 of 12
07:12:30.32 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:12:30.62 Index 2 (XQD_1000_3300_DOC)
07:12:30.95 Relation 261 (XQD_1000_3300) is ok
07:12:30.95 Relation 262 (XQD_2000_3300)
07:12:30.95 process pointer page 0 of 31
07:12:31.20 process pointer page 1 of 31
07:12:31.46 process pointer page 2 of 31
07:12:31.73 process pointer page 3 of 31
07:12:32.01 process pointer page 4 of 31
07:12:32.17 process pointer page 5 of 31
07:12:32.45 process pointer page 6 of 31
07:12:32.57 process pointer page 7 of 31
07:12:32.85 process pointer page 8 of 31
07:12:33.04 process pointer page 9 of 31
07:12:33.29 process pointer page 10 of 31
07:12:33.54 process pointer page 11 of 31
07:12:33.80 process pointer page 12 of 31
07:12:34.05 process pointer page 13 of 31
07:12:34.19 process pointer page 14 of 31
07:12:34.44 process pointer page 15 of 31
07:12:34.65 process pointer page 16 of 31
07:12:34.85 process pointer page 17 of 31
07:12:35.10 process pointer page 18 of 31
07:12:35.25 process pointer page 19 of 31
07:12:35.47 process pointer page 20 of 31
07:12:35.66 process pointer page 21 of 31
07:12:35.88 process pointer page 22 of 31
07:12:36.10 process pointer page 23 of 31
07:12:36.30 process pointer page 24 of 31
07:12:36.46 process pointer page 25 of 31
07:12:36.60 process pointer page 26 of 31
07:12:36.74 process pointer page 27 of 31
07:12:36.86 process pointer page 28 of 31
07:12:36.99 process pointer page 29 of 31
07:12:37.09 process pointer page 30 of 31
07:12:37.17 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:12:38.47 Relation 262 (XQD_2000_3300) is ok
07:12:38.47 Relation 263 (XQD_2100_3300)
07:12:38.47 process pointer page 0 of 6
07:12:38.75 process pointer page 1 of 6
07:12:39.00 process pointer page 2 of 6
07:12:39.28 process pointer page 3 of 6
07:12:39.54 process pointer page 4 of 6
07:12:39.82 process pointer page 5 of 6
07:12:39.84 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:12:40.04 Relation 263 (XQD_2100_3300) is ok
07:12:40.04 Relation 264 (XQD_3300_3400)
07:12:40.04 process pointer page 0 of 23
07:12:40.26 process pointer page 1 of 23
07:12:40.51 process pointer page 2 of 23
07:12:40.75 process pointer page 3 of 23
07:12:40.95 process pointer page 4 of 23
07:12:41.17 process pointer page 5 of 23
07:12:41.37 process pointer page 6 of 23
07:12:41.57 process pointer page 7 of 23
07:12:41.74 process pointer page 8 of 23
07:12:41.93 process pointer page 9 of 23
07:12:42.07 process pointer page 10 of 23
07:12:42.13 process pointer page 11 of 23
07:12:42.24 process pointer page 12 of 23
07:12:42.41 process pointer page 13 of 23
07:12:42.57 process pointer page 14 of 23
07:12:42.71 process pointer page 15 of 23
07:12:42.85 process pointer page 16 of 23
07:12:42.99 process pointer page 17 of 23
07:12:43.10 process pointer page 18 of 23
07:12:43.23 process pointer page 19 of 23
07:12:43.33 process pointer page 20 of 23
07:12:43.44 process pointer page 21 of 23
07:12:43.54 process pointer page 22 of 23
07:12:43.57 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:12:44.71 Relation 264 (XQD_3300_3400) is ok
07:12:44.71 Relation 265 (XQS_1000_1200)
07:12:44.71 process pointer page 0 of 29
07:12:44.80 process pointer page 1 of 29
07:12:44.89 process pointer page 2 of 29
07:12:44.97 process pointer page 3 of 29
07:12:45.07 process pointer page 4 of 29
07:12:45.16 process pointer page 5 of 29
07:12:45.25 process pointer page 6 of 29
07:12:45.36 process pointer page 7 of 29
07:12:45.47 process pointer page 8 of 29
07:12:45.58 process pointer page 9 of 29
07:12:45.69 process pointer page 10 of 29
07:12:45.78 process pointer page 11 of 29
07:12:45.89 process pointer page 12 of 29
07:12:46.00 process pointer page 13 of 29
07:12:46.10 process pointer page 14 of 29
07:12:46.21 process pointer page 15 of 29
07:12:46.30 process pointer page 16 of 29
07:12:46.39 process pointer page 17 of 29
07:12:46.50 process pointer page 18 of 29
07:12:46.60 process pointer page 19 of 29
07:12:46.69 process pointer page 20 of 29
07:12:46.78 process pointer page 21 of 29
07:12:46.88 process pointer page 22 of 29
07:12:46.97 process pointer page 23 of 29
07:12:47.05 process pointer page 24 of 29
07:12:47.09 process pointer page 25 of 29
07:12:47.13 process pointer page 26 of 29
07:12:47.16 process pointer page 27 of 29
07:12:47.23 process pointer page 28 of 29
07:12:47.30 Index 1 (XQS_1000_1200_DOC_ID)
07:12:48.28 Index 2 (XQS_1000_1200_SND_ID)
07:12:49.22 Index 3 (XQS_1000_1200_RCV_ID)
07:12:49.92 Relation 265 (XQS_1000_1200) is ok
07:12:49.92 Relation 266 (XQS_1200_2000)
07:12:49.92 process pointer page 0 of 39
07:12:50.01 process pointer page 1 of 39
07:12:50.04 process pointer page 2 of 39
07:12:50.07 process pointer page 3 of 39
07:12:50.12 process pointer page 4 of 39
07:12:50.20 process pointer page 5 of 39
07:12:50.29 process pointer page 6 of 39
07:12:50.42 process pointer page 7 of 39
07:12:50.57 process pointer page 8 of 39
07:12:50.74 process pointer page 9 of 39
07:12:50.92 process pointer page 10 of 39
07:12:51.06 process pointer page 11 of 39
07:12:51.12 process pointer page 12 of 39
07:12:51.20 process pointer page 13 of 39
07:12:51.34 process pointer page 14 of 39
07:12:51.49 process pointer page 15 of 39
07:12:51.63 process pointer page 16 of 39
07:12:51.77 process pointer page 17 of 39
07:12:51.91 process pointer page 18 of 39
07:12:52.07 process pointer page 19 of 39
07:12:52.26 process pointer page 20 of 39
07:12:52.43 process pointer page 21 of 39
07:12:52.60 process pointer page 22 of 39
07:12:52.77 process pointer page 23 of 39
07:12:52.91 process pointer page 24 of 39
07:12:53.08 process pointer page 25 of 39
07:12:53.24 process pointer page 26 of 39
07:12:53.37 process pointer page 27 of 39
07:12:53.49 process pointer page 28 of 39
07:12:53.65 process pointer page 29 of 39
07:12:53.80 process pointer page 30 of 39
07:12:53.94 process pointer page 31 of 39
07:12:54.05 process pointer page 32 of 39
07:12:54.15 process pointer page 33 of 39
07:12:54.24 process pointer page 34 of 39
07:12:54.33 process pointer page 35 of 39
07:12:54.43 process pointer page 36 of 39
07:12:54.52 process pointer page 37 of 39
07:12:54.60 process pointer page 38 of 39
07:12:54.63 Index 1 (XQS_1200_2000_DOC_ID)
07:12:55.74 Index 2 (XQS_1200_2000_SND_ID)
07:12:57.06 Index 3 (XQS_1200_2000_RCV_ID)
07:12:58.23 Relation 266 (XQS_1200_2000) is ok
07:12:58.23 Relation 267 (XQS_1000_3300)
07:12:58.23 process pointer page 0 of 15
07:12:58.33 process pointer page 1 of 15
07:12:58.39 process pointer page 2 of 15
07:12:58.45 process pointer page 3 of 15
07:12:58.54 process pointer page 4 of 15
07:12:58.72 process pointer page 5 of 15
07:12:58.87 process pointer page 6 of 15
07:12:59.04 process pointer page 7 of 15
07:12:59.20 process pointer page 8 of 15
07:12:59.34 process pointer page 9 of 15
07:12:59.48 process pointer page 10 of 15
07:12:59.62 process pointer page 11 of 15
07:12:59.73 process pointer page 12 of 15
07:12:59.84 process pointer page 13 of 15
07:12:59.93 process pointer page 14 of 15
07:12:59.98 Index 1 (XQS_1000_3300_DOC_ID)
07:13:00.51 Index 2 (XQS_1000_3300_SND_ID)
07:13:01.06 Index 3 (XQS_1000_3300_RCV_ID)
07:13:01.51 Relation 267 (XQS_1000_3300) is ok
07:13:01.51 Relation 268 (XQS_2000_3300)
07:13:01.51 process pointer page 0 of 1
07:13:01.51 Index 1 (XQS_2000_3300_DOC_ID)
07:13:01.51 Index 2 (XQS_2000_3300_SND_ID)
07:13:01.51 Index 3 (XQS_2000_3300_RCV_ID)
07:13:01.51 Relation 268 (XQS_2000_3300) is ok
07:13:01.51 Relation 269 (XQS_2100_3300)
07:13:01.51 process pointer page 0 of 25
07:13:01.65 process pointer page 1 of 25
07:13:01.81 process pointer page 2 of 25
07:13:01.96 process pointer page 3 of 25
07:13:02.12 process pointer page 4 of 25
07:13:02.27 process pointer page 5 of 25
07:13:02.43 process pointer page 6 of 25
07:13:02.55 process pointer page 7 of 25
07:13:02.62 process pointer page 8 of 25
07:13:02.69 process pointer page 9 of 25
07:13:02.82 process pointer page 10 of 25
07:13:02.98 process pointer page 11 of 25
07:13:03.10 process pointer page 12 of 25
07:13:03.24 process pointer page 13 of 25
07:13:03.37 process pointer page 14 of 25
07:13:03.49 process pointer page 15 of 25
07:13:03.61 process pointer page 16 of 25
07:13:03.69 process pointer page 17 of 25
07:13:03.77 process pointer page 18 of 25
07:13:03.82 process pointer page 19 of 25
07:13:03.85 process pointer page 20 of 25
07:13:03.96 process pointer page 21 of 25
07:13:04.07 process pointer page 22 of 25
07:13:04.16 process pointer page 23 of 25
07:13:04.25 process pointer page 24 of 25
07:13:04.32 Index 1 (XQS_2100_3300_DOC_ID)
07:13:05.27 Index 2 (XQS_2100_3300_SND_ID)
07:13:06.14 Index 3 (XQS_2100_3300_RCV_ID)
07:13:06.77 Relation 269 (XQS_2100_3300) is ok
07:13:06.77 Relation 270 (XQS_3300_3400)
07:13:06.77 process pointer page 0 of 5
07:13:06.92 process pointer page 1 of 5
07:13:07.09 process pointer page 2 of 5
07:13:07.23 process pointer page 3 of 5
07:13:07.37 process pointer page 4 of 5
07:13:07.47 Index 1 (XQS_3300_3400_DOC_ID)
07:13:07.64 Index 2 (XQS_3300_3400_SND_ID)
07:13:07.83 Relation 270 (XQS_3300_3400) is ok
07:13:07.83 Relation 276 (TRACE_STAT)
07:13:07.83 process pointer page 0 of 1
07:13:07.83 Relation 276 (TRACE_STAT) is ok
07:13:07.83 Validation finished
Done for 69430 ms, from 7:11:58.41 to 7:13:07.84.
Differences between old and current firebird.log
7:13:08.75. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-11-06 07:13 504 oltp30_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Sun Nov 06 07:11:58 2016
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sun Nov 06 07:13:07 2016
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2016-11-06 7:13:16.92 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html