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