Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-05-13  6:52:31.27.
 
Server version: WI-V3.0.3.32721 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-05-13 06:49:35.2440  | 
 -1  | 
 <null>  | 
   | 
 ::1/62984  | 
 451329  | 
 9339  | 
 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:  | 
 6413.43  | 
 2619  | 
 1154418  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  customer order: creation  | 
 473.91  | 
 406  | 
 85304  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  customer order: refuse  | 
 37.91  | 
 216  | 
 6824  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  order to supplier: creation  | 
 121.56  | 
 1708  | 
 21881  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  order to supplier: removal  | 
 3.40  | 
 15619  | 
 612  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  invoice (draft): creation  | 
 122.36  | 
 2498  | 
 22024  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  invoice (draft): removal  | 
 45.49  | 
 364  | 
 8189  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  invoice accept: apply  | 
 67.53  | 
 8709  | 
 12156  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  invoice accept: cancel  | 
 19.99  | 
 2077  | 
 3598  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  customer reserve: creation  | 
 3680.79  | 
 129  | 
 662542  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  customer reserve: removal  | 
 1191.07  | 
 50  | 
 214392  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  realization accept: apply  | 
 216.33  | 
 414  | 
 38940  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  realization accept: cancel  | 
 93.39  | 
 126  | 
 16810  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  payment from customer: creation  | 
 158.59  | 
 757  | 
 28547  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  payment from customer: removal  | 
 14.82  | 
 108  | 
 2668  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  payment to supplier: creation  | 
 129.86  | 
 388  | 
 23374  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  payment to supplier: removal  | 
 8.86  | 
 116  | 
 1595  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  service: total inventory turnovers  | 
 10.24  | 
 2262  | 
 1844  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  service: total monetary turnovers  | 
 17.26  | 
 61  | 
 3106  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  service: refresh index statistics  | 
 0.07  | 
 13750  | 
 12  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
 
Done for 126300 ms, from  6:55:35.74 to  6:57:42.04.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 4909  | 
 102019  | 
 88368  | 
 13651  | 
 13.38  | 
 03:49:36  | 
 04:07:35  | 
|  interval #   2, overall  | 
 2  | 
 6968  | 
 140491  | 
 125423  | 
 15068  | 
 10.73  | 
 04:07:36  | 
 04:25:35  | 
|  interval #   3, overall  | 
 3  | 
 7071  | 
 147096  | 
 127282  | 
 19814  | 
 13.47  | 
 04:25:36  | 
 04:43:35  | 
|  interval #   4, overall  | 
 4  | 
 6657  | 
 135559  | 
 119831  | 
 15728  | 
 11.60  | 
 04:43:36  | 
 05:01:35  | 
|  interval #   5, overall  | 
 5  | 
 6267  | 
 140266  | 
 112809  | 
 27457  | 
 19.57  | 
 05:01:36  | 
 05:19:35  | 
|  interval #   6, overall  | 
 6  | 
 6988  | 
 154332  | 
 125778  | 
 28554  | 
 18.50  | 
 05:19:36  | 
 05:37:35  | 
|  interval #   7, overall  | 
 7  | 
 6499  | 
 132999  | 
 116982  | 
 16017  | 
 12.04  | 
 05:37:36  | 
 05:55:35  | 
|  interval #   8, overall  | 
 8  | 
 6278  | 
 131235  | 
 113012  | 
 18223  | 
 13.89  | 
 05:55:36  | 
 06:13:35  | 
|  interval #   9, overall  | 
 9  | 
 6011  | 
 121457  | 
 108191  | 
 13266  | 
 10.92  | 
 06:13:36  | 
 06:31:35  | 
|  interval #  10, overall  | 
 10  | 
 6486  | 
 128733  | 
 116742  | 
 11991  | 
 9.31  | 
 06:31:36  | 
 06:49:35  | 
 
Done for 312740 ms, from  7:02:50.65 to  7:08:03.39.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 3569.66  | 
 0.2708  | 
 1.5749  | 
 2061  | 
 72  | 
|  TEST_TIME  | 
 2  | 
 3685.13  | 
 0.7627  | 
 1.2447  | 
 1749  | 
 99  | 
|  TEST_TIME  | 
 3  | 
 3703.43  | 
 0.8258  | 
 1.2086  | 
 1820  | 
 99  | 
|  TEST_TIME  | 
 4  | 
 3804.74  | 
 0.8826  | 
 1.1244  | 
 1703  | 
 99  | 
|  TEST_TIME  | 
 5  | 
 3814.02  | 
 0.8983  | 
 1.1054  | 
 1801  | 
 99  | 
|  TEST_TIME  | 
 6  | 
 3849.88  | 
 0.9137  | 
 1.0956  | 
 1632  | 
 99  | 
|  TEST_TIME  | 
 7  | 
 3939.89  | 
 0.9177  | 
 1.0828  | 
 1579  | 
 99  | 
|  TEST_TIME  | 
 8  | 
 4107.22  | 
 0.9090  | 
 1.1031  | 
 2113  | 
 99  | 
|  TEST_TIME  | 
 9  | 
 4353.90  | 
 0.9251  | 
 1.0687  | 
 1584  | 
 99  | 
|  TEST_TIME  | 
 10  | 
 4476.32  | 
 0.9356  | 
 1.0687  | 
 1834  | 
 99  | 
|  TEST_TIME  | 
 11  | 
 4617.62  | 
 0.9419  | 
 1.0580  | 
 1830  | 
 99  | 
|  TEST_TIME  | 
 12  | 
 4726.92  | 
 0.9475  | 
 1.0455  | 
 1662  | 
 99  | 
|  TEST_TIME  | 
 13  | 
 4770.25  | 
 0.9564  | 
 1.0463  | 
 1700  | 
 99  | 
|  TEST_TIME  | 
 14  | 
 4816.84  | 
 0.9635  | 
 1.0370  | 
 1480  | 
 99  | 
|  TEST_TIME  | 
 15  | 
 4757.47  | 
 0.9800  | 
 1.0375  | 
 1545  | 
 99  | 
|  TEST_TIME  | 
 16  | 
 4763.94  | 
 0.9713  | 
 1.0274  | 
 1635  | 
 99  | 
|  TEST_TIME  | 
 17  | 
 4757.91  | 
 0.9687  | 
 1.0279  | 
 1538  | 
 98  | 
|  TEST_TIME  | 
 18  | 
 4880.64  | 
 0.9584  | 
 1.0416  | 
 1994  | 
 99  | 
|  TEST_TIME  | 
 19  | 
 4993.81  | 
 0.9644  | 
 1.0343  | 
 2173  | 
 99  | 
|  TEST_TIME  | 
 20  | 
 5099.15  | 
 0.9623  | 
 1.0386  | 
 1930  | 
 99  | 
|  TEST_TIME  | 
 21  | 
 5242.24  | 
 0.9622  | 
 1.0342  | 
 1759  | 
 99  | 
|  TEST_TIME  | 
 22  | 
 5331.87  | 
 0.9707  | 
 1.0271  | 
 1833  | 
 99  | 
|  TEST_TIME  | 
 23  | 
 5400.29  | 
 0.9700  | 
 1.0279  | 
 1867  | 
 99  | 
|  TEST_TIME  | 
 24  | 
 5463.70  | 
 0.9738  | 
 1.0264  | 
 1548  | 
 99  | 
|  TEST_TIME  | 
 25  | 
 5531.85  | 
 0.9733  | 
 1.0307  | 
 1552  | 
 99  | 
|  TEST_TIME  | 
 26  | 
 5611.03  | 
 0.9777  | 
 1.0190  | 
 1419  | 
 99  | 
|  TEST_TIME  | 
 27  | 
 5597.37  | 
 0.9837  | 
 1.0189  | 
 1518  | 
 99  | 
|  TEST_TIME  | 
 28  | 
 5598.98  | 
 0.9823  | 
 1.0200  | 
 1475  | 
 99  | 
|  TEST_TIME  | 
 29  | 
 5607.30  | 
 0.9834  | 
 1.0180  | 
 1268  | 
 99  | 
|  TEST_TIME  | 
 30  | 
 5622.27  | 
 0.9814  | 
 1.0175  | 
 1455  | 
 99  | 
|  TEST_TIME  | 
 31  | 
 5704.00  | 
 0.9705  | 
 1.0294  | 
 2070  | 
 99  | 
|  TEST_TIME  | 
 32  | 
 5800.80  | 
 0.9806  | 
 1.0201  | 
 2150  | 
 99  | 
|  TEST_TIME  | 
 33  | 
 5864.12  | 
 0.9785  | 
 1.0170  | 
 1682  | 
 99  | 
|  TEST_TIME  | 
 34  | 
 5873.94  | 
 0.9854  | 
 1.0150  | 
 1696  | 
 99  | 
|  TEST_TIME  | 
 35  | 
 5909.38  | 
 0.9837  | 
 1.0117  | 
 1835  | 
 99  | 
|  TEST_TIME  | 
 36  | 
 5888.48  | 
 0.9871  | 
 1.0174  | 
 1714  | 
 97  | 
|  TEST_TIME  | 
 37  | 
 5881.88  | 
 0.9910  | 
 1.0146  | 
 1157  | 
 99  | 
|  TEST_TIME  | 
 38  | 
 5882.30  | 
 0.9878  | 
 1.0143  | 
 1819  | 
 99  | 
|  TEST_TIME  | 
 39  | 
 5911.92  | 
 0.9834  | 
 1.0168  | 
 1499  | 
 99  | 
|  TEST_TIME  | 
 40  | 
 5934.49  | 
 0.9876  | 
 1.0140  | 
 1609  | 
 99  | 
|  TEST_TIME  | 
 41  | 
 5934.44  | 
 0.9893  | 
 1.0135  | 
 1547  | 
 99  | 
|  TEST_TIME  | 
 42  | 
 5950.52  | 
 0.9867  | 
 1.0136  | 
 1493  | 
 99  | 
|  TEST_TIME  | 
 43  | 
 5977.81  | 
 0.9858  | 
 1.0150  | 
 1429  | 
 99  | 
|  TEST_TIME  | 
 44  | 
 6002.17  | 
 0.9881  | 
 1.0107  | 
 1377  | 
 99  | 
|  TEST_TIME  | 
 45  | 
 6018.54  | 
 0.9856  | 
 1.0153  | 
 1246  | 
 99  | 
|  TEST_TIME  | 
 46  | 
 6072.75  | 
 0.9844  | 
 1.0157  | 
 2239  | 
 99  | 
|  TEST_TIME  | 
 47  | 
 6147.49  | 
 0.9820  | 
 1.0180  | 
 2432  | 
 99  | 
|  TEST_TIME  | 
 48  | 
 6217.54  | 
 0.9856  | 
 1.0179  | 
 2021  | 
 99  | 
|  TEST_TIME  | 
 49  | 
 6275.34  | 
 0.9880  | 
 1.0115  | 
 1840  | 
 99  | 
|  TEST_TIME  | 
 50  | 
 6301.39  | 
 0.9871  | 
 1.0109  | 
 1884  | 
 99  | 
|  TEST_TIME  | 
 51  | 
 6305.62  | 
 0.9905  | 
 1.0071  | 
 1798  | 
 99  | 
|  TEST_TIME  | 
 52  | 
 6305.17  | 
 0.9923  | 
 1.0076  | 
 1565  | 
 98  | 
|  TEST_TIME  | 
 53  | 
 6329.50  | 
 0.9848  | 
 1.0060  | 
 1380  | 
 99  | 
|  TEST_TIME  | 
 54  | 
 6294.60  | 
 0.9929  | 
 1.0098  | 
 1631  | 
 98  | 
|  TEST_TIME  | 
 55  | 
 6299.63  | 
 0.9907  | 
 1.0088  | 
 1383  | 
 99  | 
|  TEST_TIME  | 
 56  | 
 6313.18  | 
 0.9897  | 
 1.0085  | 
 1146  | 
 98  | 
|  TEST_TIME  | 
 57  | 
 6312.18  | 
 0.9910  | 
 1.0087  | 
 1488  | 
 99  | 
|  TEST_TIME  | 
 58  | 
 6319.62  | 
 0.9907  | 
 1.0099  | 
 1383  | 
 99  | 
|  TEST_TIME  | 
 59  | 
 6336.41  | 
 0.9902  | 
 1.0044  | 
 1323  | 
 99  | 
|  TEST_TIME  | 
 60  | 
 6324.79  | 
 0.9895  | 
 1.0089  | 
 1322  | 
 99  | 
|  TEST_TIME  | 
 61  | 
 6355.82  | 
 0.9875  | 
 1.0116  | 
 2329  | 
 99  | 
|  TEST_TIME  | 
 62  | 
 6404.33  | 
 0.9878  | 
 1.0122  | 
 1748  | 
 99  | 
|  TEST_TIME  | 
 63  | 
 6441.75  | 
 0.9904  | 
 1.0080  | 
 1538  | 
 99  | 
|  TEST_TIME  | 
 64  | 
 6459.15  | 
 0.9896  | 
 1.0084  | 
 1946  | 
 99  | 
|  TEST_TIME  | 
 65  | 
 6462.40  | 
 0.9924  | 
 1.0078  | 
 1828  | 
 99  | 
|  TEST_TIME  | 
 66  | 
 6462.95  | 
 0.9925  | 
 1.0051  | 
 1873  | 
 99  | 
|  TEST_TIME  | 
 67  | 
 6437.26  | 
 0.9940  | 
 1.0069  | 
 1712  | 
 95  | 
|  TEST_TIME  | 
 68  | 
 6429.35  | 
 0.9933  | 
 1.0065  | 
 1544  | 
 96  | 
|  TEST_TIME  | 
 69  | 
 6450.47  | 
 0.9887  | 
 1.0056  | 
 1265  | 
 99  | 
|  TEST_TIME  | 
 70  | 
 6432.54  | 
 0.9940  | 
 1.0057  | 
 1298  | 
 99  | 
|  TEST_TIME  | 
 71  | 
 6422.16  | 
 0.9931  | 
 1.0035  | 
 1497  | 
 99  | 
|  TEST_TIME  | 
 72  | 
 6381.38  | 
 0.9959  | 
 1.0045  | 
 1441  | 
 98  | 
|  TEST_TIME  | 
 73  | 
 6383.60  | 
 0.9904  | 
 1.0048  | 
 1270  | 
 98  | 
|  TEST_TIME  | 
 74  | 
 6349.54  | 
 0.9966  | 
 1.0059  | 
 1099  | 
 98  | 
|  TEST_TIME  | 
 75  | 
 6337.90  | 
 0.9956  | 
 1.0056  | 
 1163  | 
 99  | 
|  TEST_TIME  | 
 76  | 
 6347.60  | 
 0.9909  | 
 1.0119  | 
 1857  | 
 99  | 
|  TEST_TIME  | 
 77  | 
 6376.68  | 
 0.9943  | 
 1.0062  | 
 2158  | 
 98  | 
|  TEST_TIME  | 
 78  | 
 6403.82  | 
 0.9890  | 
 1.0080  | 
 1744  | 
 98  | 
|  TEST_TIME  | 
 79  | 
 6425.40  | 
 0.9921  | 
 1.0063  | 
 1824  | 
 99  | 
|  TEST_TIME  | 
 80  | 
 6425.99  | 
 0.9936  | 
 1.0071  | 
 1798  | 
 99  | 
|  TEST_TIME  | 
 81  | 
 6428.42  | 
 0.9942  | 
 1.0038  | 
 1817  | 
 99  | 
|  TEST_TIME  | 
 82  | 
 6429.39  | 
 0.9915  | 
 1.0068  | 
 1670  | 
 98  | 
|  TEST_TIME  | 
 83  | 
 6417.71  | 
 0.9965  | 
 1.0068  | 
 1694  | 
 99  | 
|  TEST_TIME  | 
 84  | 
 6418.80  | 
 0.9949  | 
 1.0052  | 
 1607  | 
 99  | 
|  TEST_TIME  | 
 85  | 
 6413.00  | 
 0.9943  | 
 1.0026  | 
 1507  | 
 99  | 
|  TEST_TIME  | 
 86  | 
 6390.37  | 
 0.9944  | 
 1.0034  | 
 1325  | 
 95  | 
|  TEST_TIME  | 
 87  | 
 6364.20  | 
 0.9959  | 
 1.0067  | 
 1270  | 
 97  | 
|  TEST_TIME  | 
 88  | 
 6369.85  | 
 0.9944  | 
 1.0053  | 
 1318  | 
 99  | 
|  TEST_TIME  | 
 89  | 
 6357.31  | 
 0.9960  | 
 1.0041  | 
 1385  | 
 99  | 
|  TEST_TIME  | 
 90  | 
 6366.28  | 
 0.9916  | 
 1.0040  | 
 1162  | 
 99  | 
|  TEST_TIME  | 
 91  | 
 6347.95  | 
 0.9959  | 
 1.0040  | 
 2188  | 
 97  | 
|  TEST_TIME  | 
 92  | 
 6357.36  | 
 0.9916  | 
 1.0056  | 
 1860  | 
 98  | 
|  TEST_TIME  | 
 93  | 
 6349.94  | 
 0.9960  | 
 1.0059  | 
 1761  | 
 87  | 
|  TEST_TIME  | 
 94  | 
 6362.85  | 
 0.9932  | 
 1.0054  | 
 1623  | 
 98  | 
|  TEST_TIME  | 
 95  | 
 6365.21  | 
 0.9948  | 
 1.0061  | 
 1577  | 
 99  | 
|  TEST_TIME  | 
 96  | 
 6384.39  | 
 0.9927  | 
 1.0068  | 
 1690  | 
 99  | 
|  TEST_TIME  | 
 97  | 
 6410.51  | 
 0.9924  | 
 1.0072  | 
 1527  | 
 99  | 
|  TEST_TIME  | 
 98  | 
 6433.98  | 
 0.9933  | 
 1.0059  | 
 1486  | 
 99  | 
|  TEST_TIME  | 
 99  | 
 6443.13  | 
 0.9943  | 
 1.0055  | 
 1507  | 
 99  | 
|  TEST_TIME  | 
 100  | 
 6462.26  | 
 0.9925  | 
 1.0070  | 
 1338  | 
 99  | 
|  TEST_TIME  | 
 101  | 
 6473.22  | 
 0.9954  | 
 1.0059  | 
 1299  | 
 99  | 
|  TEST_TIME  | 
 102  | 
 6479.00  | 
 0.9953  | 
 1.0050  | 
 1201  | 
 99  | 
|  TEST_TIME  | 
 103  | 
 6461.31  | 
 0.9979  | 
 1.0021  | 
 1395  | 
 97  | 
|  TEST_TIME  | 
 104  | 
 6444.50  | 
 0.9950  | 
 1.0046  | 
 1261  | 
 98  | 
|  TEST_TIME  | 
 105  | 
 6433.05  | 
 0.9968  | 
 1.0042  | 
 1121  | 
 99  | 
|  TEST_TIME  | 
 106  | 
 6434.77  | 
 0.9945  | 
 1.0030  | 
 2015  | 
 99  | 
|  TEST_TIME  | 
 107  | 
 6429.91  | 
 0.9944  | 
 1.0058  | 
 1929  | 
 99  | 
|  TEST_TIME  | 
 108  | 
 6457.90  | 
 0.9922  | 
 1.0064  | 
 1983  | 
 99  | 
|  TEST_TIME  | 
 109  | 
 6471.70  | 
 0.9950  | 
 1.0031  | 
 1958  | 
 98  | 
|  TEST_TIME  | 
 110  | 
 6459.01  | 
 0.9960  | 
 1.0035  | 
 1751  | 
 97  | 
|  TEST_TIME  | 
 111  | 
 6447.62  | 
 0.9962  | 
 1.0058  | 
 1539  | 
 97  | 
|  TEST_TIME  | 
 112  | 
 6438.16  | 
 0.9983  | 
 1.0021  | 
 1487  | 
 82  | 
|  TEST_TIME  | 
 113  | 
 6445.25  | 
 0.9927  | 
 1.0024  | 
 1138  | 
 92  | 
|  TEST_TIME  | 
 114  | 
 6437.28  | 
 0.9949  | 
 1.0025  | 
 1421  | 
 91  | 
|  TEST_TIME  | 
 115  | 
 6418.26  | 
 0.9967  | 
 1.0069  | 
 1107  | 
 88  | 
|  TEST_TIME  | 
 116  | 
 6426.29  | 
 0.9969  | 
 1.0033  | 
 1258  | 
 96  | 
|  TEST_TIME  | 
 117  | 
 6410.58  | 
 0.9971  | 
 1.0040  | 
 1447  | 
 97  | 
|  TEST_TIME  | 
 118  | 
 6413.59  | 
 0.9951  | 
 1.0030  | 
 1396  | 
 98  | 
|  TEST_TIME  | 
 119  | 
 6406.29  | 
 0.9958  | 
 1.0044  | 
 1294  | 
 99  | 
|  TEST_TIME  | 
 120  | 
 6408.41  | 
 0.9957  | 
 1.0052  | 
 1242  | 
 99  | 
|  TEST_TIME  | 
 121  | 
 6424.15  | 
 0.9947  | 
 1.0055  | 
 1769  | 
 99  | 
|  TEST_TIME  | 
 122  | 
 6440.93  | 
 0.9946  | 
 1.0042  | 
 1948  | 
 99  | 
|  TEST_TIME  | 
 123  | 
 6457.76  | 
 0.9934  | 
 1.0064  | 
 1828  | 
 99  | 
|  TEST_TIME  | 
 124  | 
 6473.16  | 
 0.9961  | 
 1.0042  | 
 1770  | 
 99  | 
|  TEST_TIME  | 
 125  | 
 6467.32  | 
 0.9971  | 
 1.0037  | 
 1233  | 
 98  | 
|  TEST_TIME  | 
 126  | 
 6459.26  | 
 0.9970  | 
 1.0035  | 
 1574  | 
 94  | 
|  TEST_TIME  | 
 127  | 
 6462.27  | 
 0.9954  | 
 1.0091  | 
 1274  | 
 99  | 
|  TEST_TIME  | 
 128  | 
 6497.95  | 
 0.9957  | 
 1.0041  | 
 1436  | 
 99  | 
|  TEST_TIME  | 
 129  | 
 6494.54  | 
 0.9969  | 
 1.0026  | 
 1606  | 
 97  | 
|  TEST_TIME  | 
 130  | 
 6480.69  | 
 0.9970  | 
 1.0024  | 
 1578  | 
 97  | 
|  TEST_TIME  | 
 131  | 
 6468.76  | 
 0.9966  | 
 1.0036  | 
 1422  | 
 96  | 
|  TEST_TIME  | 
 132  | 
 6459.88  | 
 0.9974  | 
 1.0043  | 
 1362  | 
 97  | 
|  TEST_TIME  | 
 133  | 
 6449.66  | 
 0.9983  | 
 1.0045  | 
 1193  | 
 97  | 
|  TEST_TIME  | 
 134  | 
 6447.20  | 
 0.9974  | 
 1.0037  | 
 1226  | 
 99  | 
|  TEST_TIME  | 
 135  | 
 6444.68  | 
 0.9967  | 
 1.0026  | 
 1410  | 
 99  | 
|  TEST_TIME  | 
 136  | 
 6444.75  | 
 0.9953  | 
 1.0049  | 
 1939  | 
 99  | 
|  TEST_TIME  | 
 137  | 
 6452.09  | 
 0.9964  | 
 1.0042  | 
 2078  | 
 97  | 
|  TEST_TIME  | 
 138  | 
 6447.08  | 
 0.9977  | 
 1.0031  | 
 1970  | 
 94  | 
|  TEST_TIME  | 
 139  | 
 6454.22  | 
 0.9948  | 
 1.0033  | 
 1633  | 
 95  | 
|  TEST_TIME  | 
 140  | 
 6454.43  | 
 0.9961  | 
 1.0049  | 
 1430  | 
 96  | 
|  TEST_TIME  | 
 141  | 
 6464.59  | 
 0.9962  | 
 1.0041  | 
 1449  | 
 98  | 
|  TEST_TIME  | 
 142  | 
 6464.08  | 
 0.9971  | 
 1.0020  | 
 1594  | 
 99  | 
|  TEST_TIME  | 
 143  | 
 6448.11  | 
 0.9974  | 
 1.0053  | 
 1556  | 
 99  | 
|  TEST_TIME  | 
 144  | 
 6445.92  | 
 0.9987  | 
 1.0019  | 
 1500  | 
 98  | 
|  TEST_TIME  | 
 145  | 
 6449.50  | 
 0.9957  | 
 1.0020  | 
 1555  | 
 98  | 
|  TEST_TIME  | 
 146  | 
 6437.28  | 
 0.9971  | 
 1.0040  | 
 1419  | 
 98  | 
|  TEST_TIME  | 
 147  | 
 6438.61  | 
 0.9970  | 
 1.0043  | 
 1361  | 
 98  | 
|  TEST_TIME  | 
 148  | 
 6436.84  | 
 0.9978  | 
 1.0013  | 
 1338  | 
 99  | 
|  TEST_TIME  | 
 149  | 
 6417.75  | 
 0.9975  | 
 1.0027  | 
 1335  | 
 98  | 
|  TEST_TIME  | 
 150  | 
 6412.81  | 
 0.9967  | 
 1.0019  | 
 1385  | 
 88  | 
|  TEST_TIME  | 
 151  | 
 6404.24  | 
 0.9966  | 
 1.0026  | 
 1596  | 
 93  | 
|  TEST_TIME  | 
 152  | 
 6405.98  | 
 0.9957  | 
 1.0057  | 
 1869  | 
 96  | 
|  TEST_TIME  | 
 153  | 
 6421.47  | 
 0.9967  | 
 1.0039  | 
 1845  | 
 93  | 
|  TEST_TIME  | 
 154  | 
 6425.45  | 
 0.9968  | 
 1.0020  | 
 1755  | 
 98  | 
|  TEST_TIME  | 
 155  | 
 6420.02  | 
 0.9964  | 
 1.0024  | 
 1649  | 
 96  | 
|  TEST_TIME  | 
 156  | 
 6412.95  | 
 0.9986  | 
 1.0017  | 
 1452  | 
 93  | 
|  TEST_TIME  | 
 157  | 
 6407.20  | 
 0.9968  | 
 1.0026  | 
 1298  | 
 96  | 
|  TEST_TIME  | 
 158  | 
 6396.21  | 
 0.9980  | 
 1.0021  | 
 1335  | 
 88  | 
|  TEST_TIME  | 
 159  | 
 6395.10  | 
 0.9960  | 
 1.0047  | 
 1393  | 
 95  | 
|  TEST_TIME  | 
 160  | 
 6397.44  | 
 0.9980  | 
 1.0020  | 
 1526  | 
 95  | 
|  TEST_TIME  | 
 161  | 
 6393.40  | 
 0.9964  | 
 1.0015  | 
 1280  | 
 98  | 
|  TEST_TIME  | 
 162  | 
 6395.02  | 
 0.9963  | 
 1.0040  | 
 1409  | 
 97  | 
|  TEST_TIME  | 
 163  | 
 6394.68  | 
 0.9979  | 
 1.0026  | 
 1229  | 
 99  | 
|  TEST_TIME  | 
 164  | 
 6383.58  | 
 0.9982  | 
 1.0027  | 
 1370  | 
 98  | 
|  TEST_TIME  | 
 165  | 
 6398.74  | 
 0.9962  | 
 1.0020  | 
 1268  | 
 99  | 
|  TEST_TIME  | 
 166  | 
 6396.02  | 
 0.9964  | 
 1.0039  | 
 1626  | 
 96  | 
|  TEST_TIME  | 
 167  | 
 6398.88  | 
 0.9975  | 
 1.0026  | 
 1977  | 
 95  | 
|  TEST_TIME  | 
 168  | 
 6407.29  | 
 0.9953  | 
 1.0026  | 
 1702  | 
 92  | 
|  TEST_TIME  | 
 169  | 
 6408.65  | 
 0.9965  | 
 1.0021  | 
 1687  | 
 89  | 
|  TEST_TIME  | 
 170  | 
 6408.46  | 
 0.9962  | 
 1.0033  | 
 1480  | 
 87  | 
|  TEST_TIME  | 
 171  | 
 6407.22  | 
 0.9976  | 
 1.0041  | 
 1374  | 
 79  | 
|  TEST_TIME  | 
 172  | 
 6415.05  | 
 0.9970  | 
 1.0031  | 
 1297  | 
 85  | 
|  TEST_TIME  | 
 173  | 
 6407.59  | 
 0.9985  | 
 1.0021  | 
 1503  | 
 77  | 
|  TEST_TIME  | 
 174  | 
 6398.49  | 
 0.9978  | 
 1.0019  | 
 1260  | 
 81  | 
|  TEST_TIME  | 
 175  | 
 6394.51  | 
 0.9968  | 
 1.0024  | 
 1276  | 
 76  | 
|  TEST_TIME  | 
 176  | 
 6392.12  | 
 0.9971  | 
 1.0047  | 
 1180  | 
 91  | 
|  TEST_TIME  | 
 177  | 
 6404.43  | 
 0.9971  | 
 1.0019  | 
 1169  | 
 98  | 
|  TEST_TIME  | 
 178  | 
 6390.26  | 
 0.9985  | 
 1.0024  | 
 1284  | 
 95  | 
|  TEST_TIME  | 
 179  | 
 6392.21  | 
 0.9973  | 
 1.0035  | 
 1072  | 
 98  | 
|  TEST_TIME  | 
 180  | 
 6396.28  | 
 0.9973  | 
 1.0026  | 
 697  | 
 99  | 
 
Done for 10700 ms, from  7:08:05.03 to  7:08:15.73.  
 
 
|  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  | 
 57073  | 
 58794  | 
 61673  | 
 <null>  | 
 70992  | 
 127589  | 
 88729  | 
 112478  | 
 15819  | 
 82014  | 
 74070  | 
 53204  | 
 100054  | 
 142091  | 
 199017  | 
 <null>  | 
 88113  | 
 315433  | 
 <null>  | 
 03:49:36  | 
 04:07:35  | 
|  fetches per second  | 
 2  | 
 59467  | 
 158321  | 
 54987  | 
 <null>  | 
 64129  | 
 29390  | 
 78398  | 
 24867  | 
 98254  | 
 4374  | 
 62968  | 
 58401  | 
 115913  | 
 64209  | 
 109143  | 
 129166  | 
 66976  | 
 124728  | 
 <null>  | 
 04:07:36  | 
 04:25:35  | 
|  fetches per second  | 
 3  | 
 46472  | 
 83977  | 
 45242  | 
 103507  | 
 53644  | 
 20070  | 
 53832  | 
 126071  | 
 75204  | 
 20949  | 
 67019  | 
 41263  | 
 112682  | 
 54734  | 
 105274  | 
 22023  | 
 232698  | 
 106136  | 
 <null>  | 
 04:25:36  | 
 04:43:35  | 
|  fetches per second  | 
 4  | 
 30842  | 
 25460  | 
 42826  | 
 <null>  | 
 22690  | 
 113047  | 
 57145  | 
 <null>  | 
 18037  | 
 7014  | 
 31904  | 
 21902  | 
 51597  | 
 15828  | 
 55412  | 
 <null>  | 
 53360  | 
 47870  | 
 <null>  | 
 04:43:36  | 
 05:01:35  | 
|  fetches per second  | 
 5  | 
 27597  | 
 64610  | 
 20423  | 
 <null>  | 
 29461  | 
 142216  | 
 72244  | 
 58320  | 
 <null>  | 
 117787  | 
 35123  | 
 5082  | 
 29144  | 
 4668  | 
 64628  | 
 19388  | 
 152819  | 
 13710  | 
 <null>  | 
 05:01:36  | 
 05:19:35  | 
|  fetches per second  | 
 6  | 
 34263  | 
 115465  | 
 45128  | 
 <null>  | 
 39053  | 
 265000  | 
 72118  | 
 52697  | 
 3606  | 
 40298  | 
 62939  | 
 17687  | 
 59635  | 
 50703  | 
 84331  | 
 29831  | 
 265374  | 
 141882  | 
 <null>  | 
 05:19:36  | 
 05:37:35  | 
|  fetches per second  | 
 7  | 
 23280  | 
 26161  | 
 20081  | 
 <null>  | 
 24414  | 
 105603  | 
 41032  | 
 5176  | 
 4707  | 
 44660  | 
 39655  | 
 2327  | 
 39513  | 
 23016  | 
 39867  | 
 4808  | 
 323199  | 
 38909  | 
 <null>  | 
 05:37:36  | 
 05:55:35  | 
|  fetches per second  | 
 8  | 
 14553  | 
 10958  | 
 6171  | 
 <null>  | 
 15849  | 
 <null>  | 
 18969  | 
 5231  | 
 15396  | 
 11206  | 
 29033  | 
 6355  | 
 18231  | 
 73018  | 
 22172  | 
 2626  | 
 16169  | 
 174784  | 
 <null>  | 
 05:55:36  | 
 06:13:35  | 
|  fetches per second  | 
 9  | 
 3734  | 
 4061  | 
 11218  | 
 6398  | 
 18401  | 
 1488  | 
 50846  | 
 7291  | 
 1269  | 
 9324  | 
 10398  | 
 1192  | 
 11826  | 
 17854  | 
 90114  | 
 6473  | 
 <null>  | 
 94811  | 
 <null>  | 
 06:13:36  | 
 06:31:35  | 
|  fetches per second  | 
 10  | 
 10033  | 
 6676  | 
 7062  | 
 9997  | 
 14840  | 
 <null>  | 
 28689  | 
 10217  | 
 1660  | 
 3325  | 
 5331  | 
 713  | 
 12116  | 
 87484  | 
 20375  | 
 <null>  | 
 40308  | 
 70339  | 
 <null>  | 
 06:31:36  | 
 06:49:35  | 
|  marks per second  | 
 1  | 
 12356  | 
 7290  | 
 12976  | 
 <null>  | 
 15692  | 
 26028  | 
 11170  | 
 18736  | 
 2248  | 
 17447  | 
 11409  | 
 8221  | 
 5229  | 
 30363  | 
 7085  | 
 <null>  | 
 7292  | 
 39576  | 
 <null>  | 
 03:49:36  | 
 04:07:35  | 
|  marks per second  | 
 2  | 
 12492  | 
 19785  | 
 12112  | 
 <null>  | 
 14491  | 
 6731  | 
 9953  | 
 3941  | 
 10970  | 
 710  | 
 9711  | 
 8644  | 
 6856  | 
 9124  | 
 7259  | 
 20000  | 
 16556  | 
 7672  | 
 <null>  | 
 04:07:36  | 
 04:25:35  | 
|  marks per second  | 
 3  | 
 9320  | 
 11338  | 
 10039  | 
 25750  | 
 11963  | 
 3575  | 
 7112  | 
 17814  | 
 7659  | 
 3380  | 
 9840  | 
 6362  | 
 5969  | 
 8393  | 
 11147  | 
 3099  | 
 33613  | 
 15175  | 
 <null>  | 
 04:25:36  | 
 04:43:35  | 
|  marks per second  | 
 4  | 
 6498  | 
 2922  | 
 8345  | 
 <null>  | 
 4564  | 
 28142  | 
 6598  | 
 <null>  | 
 2294  | 
 1472  | 
 3912  | 
 3599  | 
 2596  | 
 3238  | 
 6524  | 
 <null>  | 
 3424  | 
 2811  | 
 <null>  | 
 04:43:36  | 
 05:01:35  | 
|  marks per second  | 
 5  | 
 5837  | 
 8699  | 
 4141  | 
 <null>  | 
 6308  | 
 31270  | 
 8378  | 
 8232  | 
 <null>  | 
 20017  | 
 5433  | 
 785  | 
 1345  | 
 730  | 
 9688  | 
 3849  | 
 18619  | 
 994  | 
 <null>  | 
 05:01:36  | 
 05:19:35  | 
|  marks per second  | 
 6  | 
 7042  | 
 13831  | 
 8875  | 
 <null>  | 
 8178  | 
 64933  | 
 7938  | 
 7531  | 
 319  | 
 6906  | 
 7778  | 
 2917  | 
 2037  | 
 7261  | 
 11674  | 
 4486  | 
 24516  | 
 14932  | 
 <null>  | 
 05:19:36  | 
 05:37:35  | 
|  marks per second  | 
 7  | 
 4771  | 
 3656  | 
 3967  | 
 <null>  | 
 5145  | 
 22155  | 
 4793  | 
 727  | 
 712  | 
 7439  | 
 4991  | 
 375  | 
 1484  | 
 3897  | 
 5533  | 
 949  | 
 13283  | 
 344  | 
 <null>  | 
 05:37:36  | 
 05:55:35  | 
|  marks per second  | 
 8  | 
 3133  | 
 1266  | 
 1144  | 
 <null>  | 
 3249  | 
 <null>  | 
 2176  | 
 729  | 
 1444  | 
 1657  | 
 3421  | 
 1090  | 
 640  | 
 12490  | 
 2850  | 
 445  | 
 1420  | 
 7417  | 
 <null>  | 
 05:55:36  | 
 06:13:35  | 
|  marks per second  | 
 9  | 
 774  | 
 512  | 
 1560  | 
 990  | 
 2561  | 
 345  | 
 4593  | 
 987  | 
 132  | 
 1423  | 
 728  | 
 127  | 
 314  | 
 2653  | 
 7190  | 
 1136  | 
 <null>  | 
 872  | 
 <null>  | 
 06:13:36  | 
 06:31:35  | 
|  marks per second  | 
 10  | 
 2097  | 
 789  | 
 972  | 
 1557  | 
 2302  | 
 <null>  | 
 2258  | 
 1694  | 
 171  | 
 481  | 
 829  | 
 104  | 
 264  | 
 6993  | 
 2287  | 
 <null>  | 
 444  | 
 522  | 
 <null>  | 
 06:31:36  | 
 06:49:35  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 03:49:36  | 
 04:07:35  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:07:36  | 
 04:25:35  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:25:36  | 
 04:43:35  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 04:43:36  | 
 05:01:35  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:01:36  | 
 05:19:35  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:19:36  | 
 05:37:35  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:37:36  | 
 05:55:35  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:55:36  | 
 06:13:35  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:13:36  | 
 06:31:35  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 06:31:36  | 
 06:49:35  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 3  | 
 0  | 
 <null>  | 
 03:49:36  | 
 04:07:35  | 
|  writes/marks*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 04:07:36  | 
 04:25:35  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:25:36  | 
 04:43:35  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 3  | 
 0  | 
 <null>  | 
 04:43:36  | 
 05:01:35  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:01:36  | 
 05:19:35  | 
|  writes/marks*100  | 
 6  | 
 1  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 05:19:36  | 
 05:37:35  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:37:36  | 
 05:55:35  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:55:36  | 
 06:13:35  | 
|  writes/marks*100  | 
 9  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:13:36  | 
 06:31:35  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 7  | 
 0  | 
 <null>  | 
 06:31:36  | 
 06:49:35  | 
 
Done for 10190 ms, from  7:08:17.07 to  7:08:27.26.  
 
 
|  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  | 
 2033865  | 
 1866301  | 
 167564  | 
 8.23  | 
 0  | 
 11466  | 
 37  | 
 167564  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  doc_list_biud  | 
 2034338  | 
 1866301  | 
 168037  | 
 8.26  | 
 0  | 
 7644  | 
 13  | 
 168037  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_add_invoice_to_stock  | 
 20403  | 
 12156  | 
 8247  | 
 40.42  | 
 15  | 
 135190  | 
 8709  | 
 8247  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_cancel_adding_invoice  | 
 4856  | 
 3598  | 
 1258  | 
 25.90  | 
 0  | 
 54444  | 
 2077  | 
 1258  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_cancel_client_order  | 
 6991  | 
 6824  | 
 167  | 
 2.38  | 
 0  | 
 4072  | 
 216  | 
 167  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_cancel_customer_reserve  | 
 372132  | 
 214392  | 
 157740  | 
 42.38  | 
 0  | 
 6489  | 
 50  | 
 157740  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_cancel_pay_from_customer  | 
 2684  | 
 2668  | 
 16  | 
 0.59  | 
 0  | 
 1669  | 
 108  | 
 16  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_cancel_pay_to_supplier  | 
 1599  | 
 1595  | 
 4  | 
 0.25  | 
 0  | 
 3915  | 
 116  | 
 4  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_cancel_supplier_invoice  | 
 10726  | 
 8189  | 
 2537  | 
 23.65  | 
 0  | 
 7894  | 
 364  | 
 2537  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_cancel_supplier_order  | 
 1662  | 
 612  | 
 1050  | 
 63.17  | 
 47  | 
 187170  | 
 15619  | 
 1050  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_cancel_write_off  | 
 24061  | 
 16810  | 
 7251  | 
 30.13  | 
 0  | 
 3744  | 
 126  | 
 7251  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_client_order  | 
 85304  | 
 85304  | 
 0  | 
 0.00  | 
 0  | 
 6427  | 
 406  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_customer_reserve  | 
 662542  | 
 662542  | 
 0  | 
 0.00  | 
 0  | 
 7457  | 
 129  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_fill_shopping_cart  | 
 129532  | 
 129209  | 
 323  | 
 0.24  | 
 0  | 
 3931  | 
 81  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_fill_shopping_cart_clo_res  | 
 662542  | 
 662542  | 
 0  | 
 0.00  | 
 0  | 
 2699  | 
 9  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_get_clo_for_invoice  | 
 12156  | 
 12156  | 
 0  | 
 0.00  | 
 0  | 
 4165  | 
 250  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_kill_cost_storno  | 
 32767  | 
 24671  | 
 8096  | 
 24.70  | 
 0  | 
 2137  | 
 17  | 
 8096  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 778700  | 
 454395  | 
 324305  | 
 41.64  | 
 0  | 
 7644  | 
 19  | 
 324305  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_kill_qty_storno  | 
 469461  | 
 301521  | 
 167940  | 
 35.77  | 
 0  | 
 7644  | 
 59  | 
 167940  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_lock_selected_doc  | 
 83592  | 
 71891  | 
 11701  | 
 13.99  | 
 0  | 
 3916  | 
 6  | 
 11701  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_make_cost_storno  | 
 103017  | 
 103017  | 
 0  | 
 0.00  | 
 0  | 
 8455  | 
 305  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_multiply_rows_for_pdistr  | 
 103017  | 
 103017  | 
 0  | 
 0.00  | 
 0  | 
 3697  | 
 47  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_multiply_rows_for_qdistr  | 
 85304  | 
 85304  | 
 0  | 
 0.00  | 
 0  | 
 4212  | 
 135  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_pay_from_customer  | 
 28547  | 
 28547  | 
 0  | 
 0.00  | 
 0  | 
 11872  | 
 757  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_pay_to_supplier  | 
 23374  | 
 23374  | 
 0  | 
 0.00  | 
 0  | 
 7707  | 
 388  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_payment_common  | 
 51921  | 
 51921  | 
 0  | 
 0.00  | 
 0  | 
 3697  | 
 55  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_qd_handle_on_cancel_clo  | 
 6990  | 
 6824  | 
 166  | 
 2.37  | 
 0  | 
 2200  | 
 92  | 
 166  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 16809  | 
 15754  | 
 1055  | 
 6.27  | 
 0  | 
 4727  | 
 289  | 
 1055  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 38940  | 
 38940  | 
 0  | 
 0.00  | 
 0  | 
 2683  | 
 43  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_reserve_write_off  | 
 40116  | 
 38940  | 
 1176  | 
 2.93  | 
 0  | 
 7332  | 
 414  | 
 1176  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_supplier_invoice  | 
 22150  | 
 22024  | 
 126  | 
 0.56  | 
 0  | 
 32932  | 
 2498  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  sp_supplier_order  | 
 22078  | 
 21881  | 
 197  | 
 0.89  | 
 0  | 
 14445  | 
 1708  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  srv_find_qd_qs_mism  | 
 1223371  | 
 1055819  | 
 167552  | 
 13.69  | 
 0  | 
 4399  | 
 20  | 
 167552  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  srv_make_invnt_saldo  | 
 1844  | 
 1844  | 
 0  | 
 0.00  | 
 31  | 
 44694  | 
 2262  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  srv_make_money_saldo  | 
 3106  | 
 3106  | 
 0  | 
 0.00  | 
 0  | 
 2184  | 
 61  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 2106  | 
 44959  | 
 13750  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 8247  | 
 8247  | 
 0  | 
 0.00  | 
 0  | 
 1685  | 
 86  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 779  | 
 779  | 
 0  | 
 0.00  | 
 0  | 
 1794  | 
 143  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_cancel_client_order  | 
 167  | 
 167  | 
 0  | 
 0.00  | 
 0  | 
 1732  | 
 87  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 105  | 
 105  | 
 0  | 
 0.00  | 
 0  | 
 951  | 
 48  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 16  | 
 16  | 
 0  | 
 0.00  | 
 0  | 
 297  | 
 43  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 4  | 
 4  | 
 0  | 
 0.00  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 649  | 
 649  | 
 0  | 
 0.00  | 
 0  | 
 1108  | 
 85  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 19081  | 
 19081  | 
 0  | 
 0.00  | 
 0  | 
 4025  | 
 87  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_cancel_write_off  | 
 20  | 
 20  | 
 0  | 
 0.00  | 
 0  | 
 234  | 
 52  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_reserve_write_off  | 
 1176  | 
 1176  | 
 0  | 
 0.00  | 
 0  | 
 1201  | 
 49  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_supplier_invoice  | 
 126  | 
 126  | 
 0  | 
 0.00  | 
 0  | 
 1217  | 
 100  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-abend:sp_supplier_order  | 
 197  | 
 197  | 
 0  | 
 0.00  | 
 0  | 
 1201  | 
 63  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 12156  | 
 12156  | 
 0  | 
 0.00  | 
 0  | 
 14243  | 
 488  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1384  | 
 1384  | 
 0  | 
 0.00  | 
 0  | 
 8440  | 
 584  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6824  | 
 6824  | 
 0  | 
 0.00  | 
 0  | 
 2605  | 
 63  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2699  | 
 2699  | 
 0  | 
 0.00  | 
 0  | 
 2652  | 
 64  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2668  | 
 2668  | 
 0  | 
 0.00  | 
 0  | 
 1919  | 
 46  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1595  | 
 1595  | 
 0  | 
 0.00  | 
 0  | 
 1763  | 
 46  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 971  | 
 971  | 
 0  | 
 0.00  | 
 0  | 
 1279  | 
 55  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 612  | 
 612  | 
 0  | 
 0.00  | 
 0  | 
 42167  | 
 1529  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_cancel_write_off  | 
 4042  | 
 4042  | 
 0  | 
 0.00  | 
 0  | 
 2387  | 
 65  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_client_order  | 
 85304  | 
 85304  | 
 0  | 
 0.00  | 
 0  | 
 3026  | 
 71  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_customer_reserve  | 
 3913  | 
 3913  | 
 0  | 
 0.00  | 
 0  | 
 1841  | 
 49  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_pay_from_customer  | 
 28547  | 
 28547  | 
 0  | 
 0.00  | 
 0  | 
 2215  | 
 63  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 23374  | 
 23374  | 
 0  | 
 0.00  | 
 0  | 
 2184  | 
 54  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_reserve_write_off  | 
 38940  | 
 38940  | 
 0  | 
 0.00  | 
 0  | 
 2714  | 
 65  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_supplier_invoice  | 
 22024  | 
 22024  | 
 0  | 
 0.00  | 
 0  | 
 3339  | 
 59  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:sp_supplier_order  | 
 21881  | 
 21881  | 
 0  | 
 0.00  | 
 0  | 
 2730  | 
 64  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 1844  | 
 1844  | 
 0  | 
 0.00  | 
 0  | 
 780  | 
 23  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:srv_make_money_saldo  | 
 3106  | 
 3106  | 
 0  | 
 0.00  | 
 0  | 
 982  | 
 27  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 936  | 
 136  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_add_invoice_to_stock  | 
 40806  | 
 24312  | 
 16494  | 
 40.42  | 
 0  | 
 3073  | 
 15  | 
 16494  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_all_customers  | 
 127888  | 
 127888  | 
 0  | 
 0.00  | 
 0  | 
 1778  | 
 5  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_all_suppliers  | 
 89708  | 
 89062  | 
 646  | 
 0.72  | 
 0  | 
 1778  | 
 5  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_all_wares  | 
 170608  | 
 170608  | 
 0  | 
 0.00  | 
 0  | 
 1919  | 
 4  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_cancel_adding_invoice  | 
 3302  | 
 2768  | 
 534  | 
 16.17  | 
 0  | 
 2449  | 
 134  | 
 534  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_cancel_client_order  | 
 13982  | 
 13648  | 
 334  | 
 2.38  | 
 0  | 
 1107  | 
 6  | 
 334  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_cancel_customer_prepayment  | 
 5368  | 
 5336  | 
 32  | 
 0.59  | 
 0  | 
 1404  | 
 7  | 
 32  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_cancel_customer_reserve  | 
 5608  | 
 5398  | 
 210  | 
 3.74  | 
 0  | 
 1701  | 
 9  | 
 210  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_cancel_payment_to_supplier  | 
 3198  | 
 3190  | 
 8  | 
 0.25  | 
 0  | 
 3900  | 
 9  | 
 8  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_cancel_supplier_invoice  | 
 3240  | 
 1942  | 
 1298  | 
 40.06  | 
 0  | 
 1061  | 
 15  | 
 1298  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_cancel_supplier_order  | 
 3324  | 
 1224  | 
 2100  | 
 63.17  | 
 0  | 
 1045  | 
 8  | 
 2100  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_cancel_write_off  | 
 8124  | 
 8084  | 
 40  | 
 0.49  | 
 0  | 
 2293  | 
 88  | 
 40  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_max_id_clo_ord  | 
 22078  | 
 21881  | 
 197  | 
 0.89  | 
 0  | 
 858  | 
 5  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_max_id_clo_res  | 
 3913  | 
 3913  | 
 0  | 
 0.00  | 
 0  | 
 1123  | 
 16  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_max_id_ord_sup  | 
 22150  | 
 22024  | 
 126  | 
 0.56  | 
 0  | 
 1186  | 
 5  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_max_non_paid_invoice  | 
 22748  | 
 22748  | 
 0  | 
 0.00  | 
 0  | 
 904  | 
 5  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_max_non_paid_realizn  | 
 28547  | 
 28547  | 
 0  | 
 0.00  | 
 0  | 
 1467  | 
 5  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_min_id_clo_ord  | 
 22078  | 
 21881  | 
 197  | 
 0.89  | 
 0  | 
 2106  | 
 7  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_min_id_clo_res  | 
 3913  | 
 3913  | 
 0  | 
 0.00  | 
 0  | 
 1747  | 
 9  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_min_id_ord_sup  | 
 22150  | 
 22024  | 
 126  | 
 0.56  | 
 0  | 
 2200  | 
 7  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_min_non_paid_invoice  | 
 23374  | 
 23374  | 
 0  | 
 0.00  | 
 0  | 
 1326  | 
 8  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_min_non_paid_realizn  | 
 28547  | 
 28547  | 
 0  | 
 0.00  | 
 0  | 
 1217  | 
 7  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_our_firm  | 
 42720  | 
 42720  | 
 0  | 
 0.00  | 
 0  | 
 1326  | 
 5  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  v_reserve_write_off  | 
 80232  | 
 77880  | 
 2352  | 
 2.93  | 
 0  | 
 2403  | 
 7  | 
 2352  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  x_lock_depdocs_on_canc_invoice  | 
 20831  | 
 10816  | 
 10015  | 
 48.07  | 
 0  | 
 1950  | 
 26  | 
 10015  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1660  | 
 612  | 
 1048  | 
 63.13  | 
 0  | 
 936  | 
 51  | 
 1048  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  x_make_qstorno_1000_1200  | 
 22078  | 
 21881  | 
 197  | 
 0.89  | 
 0  | 
 13712  | 
 1523  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  x_make_qstorno_1200_2000  | 
 22150  | 
 22024  | 
 126  | 
 0.56  | 
 0  | 
 32401  | 
 2312  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  x_make_qstorno_2100_3300  | 
 662542  | 
 662542  | 
 0  | 
 0.00  | 
 0  | 
 6474  | 
 108  | 
 0  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
 
Done for 460250 ms, from  7:15:59.78 to  7:23:40.03.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 70  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2017-05-13 03:50  | 
 2017-05-13 06:47  | 
|  deadlock  | 
 82  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2017-05-13 03:52  | 
 2017-05-13 06:48  | 
|  deadlock  | 
 2895  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  deadlock  | 
 166  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2017-05-13 03:50  | 
 2017-05-13 06:47  | 
|  deadlock  | 
 193  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2017-05-13 03:50  | 
 2017-05-13 06:44  | 
|  deadlock  | 
 63  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2017-05-13 03:51  | 
 2017-05-13 06:49  | 
|  deadlock  | 
 15  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2017-05-13 03:52  | 
 2017-05-13 06:30  | 
|  user_exc  | 
 197  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2017-05-13 03:49  | 
 2017-05-13 06:48  | 
|  user_exc  | 
 126  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2017-05-13 03:49  | 
 2017-05-13 06:47  | 
|  concurrent_transaction  | 
 7320  | 
 sp_lock_selected_doc  | 
 335544878  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  concurrent_transaction  | 
 649  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544878  | 
 2017-05-13 03:49  | 
 2017-05-13 06:49  | 
|  concurrent_transaction  | 
 240  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544878  | 
 2017-05-13 03:50  | 
 2017-05-13 06:47  | 
 
Done for 14960 ms, from  7:23:52.65 to  7:24:07.61.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          451771
 
MON$OLDEST_ACTIVE               451772
 
MON$OLDEST_SNAPSHOT             451772
 
MON$NEXT_TRANSACTION            451772
 
MON$PAGE_BUFFERS                786432
 
MON$SQL_DIALECT                 3
 
MON$SHUTDOWN_MODE               0
 
MON$SWEEP_INTERVAL              0
 
MON$READ_ONLY                   0
 
MON$FORCED_WRITES               1
 
MON$RESERVE_SPACE               1
 
MON$CREATION_DATE               2017-01-11 15:12:20.4040
 
MON$PAGES                       852672
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.3.32721 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32721 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32721 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32721 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		451926 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	451773 
 
Oldest active		451774 
 
Oldest snapshot		451774 
 
Next transaction	451775 
 
Sequence number		0 
 
Next attachment ID	9573 
 
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.13, total records: 2212895 
 
Average version length: 47.88, total versions: 2082, 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: 15, data page slots: 24024 
 
Data pages: 24024, average fill: 72% 
 
Primary pages: 24024, secondary pages: 0, swept pages: 14082 
 
Empty pages: 2, full pages: 20595 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 8 
 
40 - 59% = 169 
 
60 - 79% = 23840 
 
80 - 99% = 3 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 10787, nodes: 2212895 
 
Average node length: 19.37, total dup: 0, max dup: 0 
 
Average key length: 16.41, compression ratio: 1.65 
 
Average prefix length: 13.59, average data length: 13.41 
 
Clustering factor: 437969, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 747 
 
20 - 39% = 2468 
 
40 - 59% = 4809 
 
60 - 79% = 1291 
 
80 - 99% = 1472 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7933, nodes: 2212895 
 
Average node length: 11.64, total dup: 0, max dup: 0 
 
Average key length: 8.68, compression ratio: 1.04 
 
Average prefix length: 3.32, average data length: 5.68 
 
Clustering factor: 420239, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 3717 
 
40 - 59% = 4099 
 
60 - 79% = 102 
 
80 - 99% = 12 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 169166, depth: 3, leaf buckets: 3927, nodes: 2212895 
 
Average node length: 6.85, total dup: 1601733, max dup: 49 
 
Average key length: 3.89, compression ratio: 2.31 
 
Average prefix length: 7.38, average data length: 1.62 
 
Clustering factor: 398357, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 199 
 
20 - 39% = 1228 
 
40 - 59% = 1626 
 
60 - 79% = 322 
 
80 - 99% = 552 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.47, total records: 679062 
 
Average version length: 36.19, total versions: 605, max versions: 3 
 
Average fragment length: 22.82, total fragments: 11, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 6, data page slots: 8608 
 
Data pages: 8608, average fill: 75% 
 
Primary pages: 8605, secondary pages: 3, swept pages: 7670 
 
Empty pages: 6, full pages: 7928 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 6 
 
40 - 59% = 46 
 
60 - 79% = 8531 
 
80 - 99% = 12 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 246960, depth: 3, leaf buckets: 2497, nodes: 679062 
 
Average node length: 11.68, total dup: 0, max dup: 0 
 
Average key length: 8.81, compression ratio: 1.02 
 
Average prefix length: 3.19, average data length: 5.81 
 
Clustering factor: 158338, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1342 
 
40 - 59% = 1108 
 
60 - 79% = 41 
 
80 - 99% = 6 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 715, nodes: 679062 
 
Average node length: 4.88, total dup: 679012, max dup: 45710 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 310713, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 607 
 
60 - 79% = 90 
 
80 - 99% = 18 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 329981, depth: 3, leaf buckets: 1944, nodes: 679062 
 
Average node length: 11.68, total dup: 0, max dup: 0 
 
Average key length: 8.81, compression ratio: 1.02 
 
Average prefix length: 3.19, average data length: 5.81 
 
Clustering factor: 158338, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 148 
 
20 - 39% = 470 
 
40 - 59% = 710 
 
60 - 79% = 308 
 
80 - 99% = 308 
 
 
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: 68.94, total records: 400 
 
Average version length: 33.84, total versions: 799, max versions: 2 
 
Average fragment length: 21.68, total fragments: 375, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.51 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 15, average fill: 73% 
 
Primary pages: 4, secondary pages: 11, swept pages: 0 
 
Empty pages: 3, full pages: 10 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 11 
 
 
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: 2.46, total records: 21216 
 
Average version length: 70.97, total versions: 20483, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 39.03 
 
Pointer pages: 2, data page slots: 552 
 
Data pages: 400, average fill: 69% 
 
Primary pages: 400, secondary pages: 0, swept pages: 7 
 
Empty pages: 46, full pages: 244 
 
Fill distribution: 
 
0 - 19% = 56 
 
20 - 39% = 18 
 
40 - 59% = 49 
 
60 - 79% = 55 
 
80 - 99% = 222 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 66, nodes: 21216 
 
Average node length: 13.81, total dup: 1580, max dup: 1 
 
Average key length: 11.50, compression ratio: 2.35 
 
Average prefix length: 18.43, average data length: 8.57 
 
Clustering factor: 15436, ratio: 0.73 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 2 
 
40 - 59% = 35 
 
60 - 79% = 26 
 
80 - 99% = 1 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.06, 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.12 
 
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: 32.61, total records: 351 
 
Average version length: 45.68, total versions: 106, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.96 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 21% 
 
Primary pages: 15, secondary pages: 1, swept pages: 9 
 
Empty pages: 1, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 2 
 
40 - 59% = 2 
 
60 - 79% = 0 
 
80 - 99% = 1 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 436137, depth: 2, leaf buckets: 1, nodes: 351 
 
Average node length: 5.65, total dup: 293, max dup: 37 
 
Average key length: 4.52, compression ratio: 4.20 
 
Average prefix length: 16.64, average data length: 2.36 
 
Clustering factor: 177, ratio: 0.50 
 
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.18, total records: 258668 
 
Average version length: 32.74, total versions: 3444, max versions: 6 
 
Average fragment length: 33.00, total fragments: 1, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.52 
 
Pointer pages: 2, data page slots: 3024 
 
Data pages: 3024, average fill: 64% 
 
Primary pages: 3006, secondary pages: 18, swept pages: 1931 
 
Empty pages: 23, full pages: 1363 
 
Fill distribution: 
 
0 - 19% = 96 
 
20 - 39% = 248 
 
40 - 59% = 292 
 
60 - 79% = 2379 
 
80 - 99% = 9 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 240, nodes: 258668 
 
Average node length: 4.60, total dup: 258619, max dup: 12523 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 43840, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 15 
 
40 - 59% = 100 
 
60 - 79% = 104 
 
80 - 99% = 21 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 290, nodes: 258668 
 
Average node length: 5.54, total dup: 233318, max dup: 197 
 
Average key length: 2.95, compression ratio: 7.47 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 57998, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 23 
 
40 - 59% = 127 
 
60 - 79% = 96 
 
80 - 99% = 44 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 287, nodes: 258668 
 
Average node length: 5.54, total dup: 233318, max dup: 197 
 
Average key length: 2.95, compression ratio: 7.47 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 58119, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 23 
 
40 - 59% = 113 
 
60 - 79% = 105 
 
80 - 99% = 45 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 278, nodes: 258668 
 
Average node length: 5.33, total dup: 233318, max dup: 197 
 
Average key length: 2.74, compression ratio: 3.29 
 
Average prefix length: 8.36, average data length: 0.64 
 
Clustering factor: 58068, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 15 
 
40 - 59% = 122 
 
60 - 79% = 101 
 
80 - 99% = 37 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.96, total records: 283521 
 
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: 2424 
 
Data pages: 2424, average fill: 64% 
 
Primary pages: 2424, secondary pages: 0, swept pages: 0 
 
Empty pages: 2, full pages: 2421 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 2421 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 80763, depth: 2, leaf buckets: 230, nodes: 283521 
 
Average node length: 4.55, total dup: 283340, max dup: 2431 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.57, average data length: 0.00 
 
Clustering factor: 33585, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 95 
 
60 - 79% = 70 
 
80 - 99% = 65 
 
 
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.69, total records: 12419973 
 
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.18 
 
Pointer pages: 181, data page slots: 294688 
 
Data pages: 294688, average fill: 87% 
 
Primary pages: 294688, secondary pages: 0, swept pages: 3 
 
Empty pages: 4, full pages: 294683 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 294683 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 14072, nodes: 12419973 
 
Average node length: 5.68, total dup: 11572192, max dup: 153 
 
Average key length: 2.16, compression ratio: 3.69 
 
Average prefix length: 7.87, average data length: 0.12 
 
Clustering factor: 3865026, ratio: 0.31 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 0 
 
40 - 59% = 7881 
 
60 - 79% = 4063 
 
80 - 99% = 2120 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 12411, nodes: 12419973 
 
Average node length: 4.62, total dup: 12419968, max dup: 11187347 
 
Average key length: 1.10, compression ratio: 0.45 
 
Average prefix length: 0.50, average data length: 0.00 
 
Clustering factor: 369829, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 12382 
 
60 - 79% = 3 
 
80 - 99% = 25 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 15195, nodes: 12419973 
 
Average node length: 5.74, total dup: 12041072, max dup: 24570 
 
Average key length: 2.23, compression ratio: 4.04 
 
Average prefix length: 8.80, average data length: 0.20 
 
Clustering factor: 958541, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 2 
 
40 - 59% = 11396 
 
60 - 79% = 2062 
 
80 - 99% = 1735 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 15088, nodes: 12419973 
 
Average node length: 5.59, total dup: 12393662, max dup: 1738890 
 
Average key length: 2.07, compression ratio: 18.30 
 
Average prefix length: 37.78, average data length: 0.07 
 
Clustering factor: 6533978, ratio: 0.53 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 1 
 
40 - 59% = 12917 
 
60 - 79% = 600 
 
80 - 99% = 1554 
 
 
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.10, total records: 438726 
 
Average version length: 55.86, total versions: 853, 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: 5232 
 
Data pages: 5232, average fill: 74% 
 
Primary pages: 5232, secondary pages: 0, swept pages: 3589 
 
Empty pages: 6, full pages: 4820 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 4 
 
40 - 59% = 35 
 
60 - 79% = 5185 
 
80 - 99% = 1 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 675676, depth: 3, leaf buckets: 588, nodes: 438726 
 
Average node length: 5.92, total dup: 369815, max dup: 443 
 
Average key length: 3.14, compression ratio: 2.87 
 
Average prefix length: 8.02, average data length: 0.98 
 
Clustering factor: 56424, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 53 
 
40 - 59% = 339 
 
60 - 79% = 130 
 
80 - 99% = 51 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2157, depth: 2, leaf buckets: 471, nodes: 438726 
 
Average node length: 5.60, total dup: 390767, max dup: 105 
 
Average key length: 2.82, compression ratio: 3.20 
 
Average prefix length: 8.29, average data length: 0.71 
 
Clustering factor: 106001, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 7 
 
40 - 59% = 210 
 
60 - 79% = 170 
 
80 - 99% = 83 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.00, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 336.00, compression ratio: 18.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 2% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_PDISTR_UNQ (0) 
 
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 11.50, total dup: 0, max dup: 0 
 
Average key length: 10.25, compression ratio: 0.88 
 
Average prefix length: 1.50, average data length: 7.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
RULES_FOR_QDISTR (139) 
 
Primary pointer page: 243, Index root page: 244 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.71, total records: 7 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 332.00, compression ratio: 10.15 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_RCVOP (1) 
 
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 5.29, total dup: 2, max dup: 2 
 
Average key length: 4.14, compression ratio: 0.72 
 
Average prefix length: 1.43, average data length: 1.57 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_UNQ (0) 
 
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 10.14, total dup: 0, max dup: 0 
 
Average key length: 8.86, compression ratio: 0.94 
 
Average prefix length: 2.14, average data length: 6.14 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SEMAPHORES (156) 
 
Primary pointer page: 315, Index root page: 316 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 9.00, total versions: 2, max versions: 2 
 
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: 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 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.59, total records: 2701 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 6.53 
 
Pointer pages: 1, data page slots: 40 
 
Data pages: 40, average fill: 62% 
 
Primary pages: 40, secondary pages: 0, swept pages: 0 
 
Empty pages: 7, full pages: 32 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 32 
 
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.02, total records: 9474 
 
Average version length: 72.12, total versions: 5922, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 5.03 
 
Pointer pages: 2, data page slots: 872 
 
Data pages: 392, average fill: 32% 
 
Primary pages: 391, secondary pages: 1, swept pages: 122 
 
Empty pages: 117, full pages: 79 
 
Fill distribution: 
 
0 - 19% = 196 
 
20 - 39% = 60 
 
40 - 59% = 42 
 
60 - 79% = 38 
 
80 - 99% = 56 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 21, nodes: 9474 
 
Average node length: 6.69, total dup: 8179, max dup: 14 
 
Average key length: 4.40, compression ratio: 8.42 
 
Average prefix length: 34.74, average data length: 2.26 
 
Clustering factor: 1479, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 13 
 
40 - 59% = 6 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.49, total records: 1060210 
 
Average version length: 71.51, total versions: 9754, 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: 10, data page slots: 16192 
 
Data pages: 16192, average fill: 72% 
 
Primary pages: 16192, secondary pages: 0, swept pages: 9444 
 
Empty pages: 53, full pages: 12360 
 
Fill distribution: 
 
0 - 19% = 185 
 
20 - 39% = 474 
 
40 - 59% = 1026 
 
60 - 79% = 14353 
 
80 - 99% = 154 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 472893, depth: 3, leaf buckets: 1227, nodes: 1060210 
 
Average node length: 5.13, total dup: 1030774, max dup: 122 
 
Average key length: 2.20, compression ratio: 4.08 
 
Average prefix length: 8.82, average data length: 0.18 
 
Clustering factor: 123603, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 111 
 
40 - 59% = 884 
 
60 - 79% = 46 
 
80 - 99% = 171 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 257811, depth: 3, leaf buckets: 1492, nodes: 1060210 
 
Average node length: 6.26, total dup: 924779, max dup: 16 
 
Average key length: 3.33, compression ratio: 11.12 
 
Average prefix length: 35.80, average data length: 1.20 
 
Clustering factor: 205701, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 17 
 
20 - 39% = 138 
 
40 - 59% = 1039 
 
60 - 79% = 145 
 
80 - 99% = 153 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 48.38, total records: 60293 
 
Average version length: 71.73, total versions: 19663, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.81 
 
Pointer pages: 4, data page slots: 5776 
 
Data pages: 1648, average fill: 44% 
 
Primary pages: 1648, secondary pages: 0, swept pages: 679 
 
Empty pages: 298, full pages: 498 
 
Fill distribution: 
 
0 - 19% = 543 
 
20 - 39% = 225 
 
40 - 59% = 223 
 
60 - 79% = 380 
 
80 - 99% = 277 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1095, depth: 2, leaf buckets: 106, nodes: 60293 
 
Average node length: 6.17, total dup: 52737, max dup: 49 
 
Average key length: 3.51, compression ratio: 10.53 
 
Average prefix length: 35.61, average data length: 1.39 
 
Clustering factor: 6648, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 50 
 
40 - 59% = 40 
 
60 - 79% = 13 
 
80 - 99% = 2 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 735, Index root page: 736 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.54, total records: 1683897 
 
Average version length: 71.83, total versions: 61708, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.96 
 
Pointer pages: 18, data page slots: 28336 
 
Data pages: 28224, average fill: 66% 
 
Primary pages: 28223, secondary pages: 1, swept pages: 16305 
 
Empty pages: 595, full pages: 16499 
 
Fill distribution: 
 
0 - 19% = 1187 
 
20 - 39% = 1846 
 
40 - 59% = 4036 
 
60 - 79% = 20201 
 
80 - 99% = 954 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 196768, depth: 3, leaf buckets: 2702, nodes: 1683897 
 
Average node length: 5.62, total dup: 1582297, max dup: 49 
 
Average key length: 2.66, compression ratio: 13.90 
 
Average prefix length: 36.40, average data length: 0.60 
 
Clustering factor: 217325, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 1298 
 
40 - 59% = 1059 
 
60 - 79% = 216 
 
80 - 99% = 120 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 12.52, total records: 43855 
 
Average version length: 71.58, total versions: 36001, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 10.87 
 
Pointer pages: 4, data page slots: 3088 
 
Data pages: 824, average fill: 67% 
 
Primary pages: 821, secondary pages: 3, swept pages: 118 
 
Empty pages: 133, full pages: 585 
 
Fill distribution: 
 
0 - 19% = 175 
 
20 - 39% = 30 
 
40 - 59% = 21 
 
60 - 79% = 60 
 
80 - 99% = 538 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 62, nodes: 43855 
 
Average node length: 6.08, total dup: 38336, max dup: 67 
 
Average key length: 3.61, compression ratio: 10.24 
 
Average prefix length: 35.51, average data length: 1.49 
 
Clustering factor: 6098, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 10 
 
40 - 59% = 32 
 
60 - 79% = 15 
 
80 - 99% = 5 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.99, total records: 2850781 
 
Average version length: 71.23, total versions: 21249, 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: 26, data page slots: 41280 
 
Data pages: 41280, average fill: 75% 
 
Primary pages: 41280, secondary pages: 0, swept pages: 30947 
 
Empty pages: 57, full pages: 34851 
 
Fill distribution: 
 
0 - 19% = 110 
 
20 - 39% = 201 
 
40 - 59% = 1185 
 
60 - 79% = 39267 
 
80 - 99% = 517 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5921, nodes: 2850781 
 
Average node length: 6.88, total dup: 2306892, max dup: 21 
 
Average key length: 3.90, compression ratio: 9.48 
 
Average prefix length: 35.29, average data length: 1.71 
 
Clustering factor: 518314, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 3046 
 
40 - 59% = 2425 
 
60 - 79% = 288 
 
80 - 99% = 154 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.74, total records: 4856479 
 
Average version length: 84.46, total versions: 1880, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.62 
 
Pointer pages: 46, data page slots: 74648 
 
Data pages: 74648, average fill: 80% 
 
Primary pages: 74648, secondary pages: 0, swept pages: 27718 
 
Empty pages: 2, full pages: 74333 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 8 
 
40 - 59% = 25 
 
60 - 79% = 21378 
 
80 - 99% = 53231 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4947, nodes: 4856479 
 
Average node length: 5.16, total dup: 4745392, max dup: 124 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 771202, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 19 
 
20 - 39% = 85 
 
40 - 59% = 2140 
 
60 - 79% = 2124 
 
80 - 99% = 579 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 5229, nodes: 4856479 
 
Average node length: 5.70, total dup: 4347492, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.39, average data length: 0.61 
 
Clustering factor: 238494, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 47 
 
20 - 39% = 155 
 
40 - 59% = 2828 
 
60 - 79% = 303 
 
80 - 99% = 1896 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5491, nodes: 4856479 
 
Average node length: 5.81, total dup: 4248215, max dup: 25 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 827016, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 26 
 
20 - 39% = 87 
 
40 - 59% = 2308 
 
60 - 79% = 2228 
 
80 - 99% = 842 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.36, total records: 2629914 
 
Average version length: 84.13, total versions: 33984, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.65 
 
Pointer pages: 26, data page slots: 41248 
 
Data pages: 41248, average fill: 79% 
 
Primary pages: 41248, secondary pages: 0, swept pages: 28200 
 
Empty pages: 45, full pages: 39008 
 
Fill distribution: 
 
0 - 19% = 72 
 
20 - 39% = 82 
 
40 - 59% = 495 
 
60 - 79% = 16733 
 
80 - 99% = 23866 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2821, nodes: 2629914 
 
Average node length: 5.15, total dup: 2568446, max dup: 190 
 
Average key length: 2.18, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 414325, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 50 
 
40 - 59% = 1669 
 
60 - 79% = 824 
 
80 - 99% = 273 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4398, nodes: 2629914 
 
Average node length: 6.24, total dup: 2153260, max dup: 14 
 
Average key length: 3.26, compression ratio: 2.76 
 
Average prefix length: 7.92, average data length: 1.08 
 
Clustering factor: 245787, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 118 
 
20 - 39% = 1609 
 
40 - 59% = 1820 
 
60 - 79% = 544 
 
80 - 99% = 307 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 3180, nodes: 2629914 
 
Average node length: 5.81, total dup: 2300769, max dup: 29 
 
Average key length: 2.84, compression ratio: 3.17 
 
Average prefix length: 8.29, average data length: 0.71 
 
Clustering factor: 497768, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 64 
 
40 - 59% = 1886 
 
60 - 79% = 869 
 
80 - 99% = 349 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.36, total records: 5142286 
 
Average version length: 85.85, total versions: 33162, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.63 
 
Pointer pages: 51, data page slots: 81992 
 
Data pages: 81896, average fill: 78% 
 
Primary pages: 81896, secondary pages: 0, swept pages: 26193 
 
Empty pages: 683, full pages: 74278 
 
Fill distribution: 
 
0 - 19% = 1020 
 
20 - 39% = 1053 
 
40 - 59% = 2272 
 
60 - 79% = 17412 
 
80 - 99% = 60139 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5446, nodes: 5142286 
 
Average node length: 5.04, total dup: 5112069, max dup: 647 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 764348, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 273 
 
40 - 59% = 3064 
 
60 - 79% = 1527 
 
80 - 99% = 577 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 6255, nodes: 5142286 
 
Average node length: 5.52, total dup: 4739701, max dup: 49 
 
Average key length: 2.54, compression ratio: 3.55 
 
Average prefix length: 8.54, average data length: 0.46 
 
Clustering factor: 265280, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 117 
 
20 - 39% = 1575 
 
40 - 59% = 2533 
 
60 - 79% = 689 
 
80 - 99% = 1341 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 6101, nodes: 5142286 
 
Average node length: 5.68, total dup: 4614283, max dup: 86 
 
Average key length: 2.70, compression ratio: 3.34 
 
Average prefix length: 8.41, average data length: 0.59 
 
Clustering factor: 843807, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 196 
 
40 - 59% = 3526 
 
60 - 79% = 1697 
 
80 - 99% = 675 
 
 
XQS_2000_3300 (269) 
 
Primary pointer page: 761, Index root page: 762 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_DOC_ID (0) 
 
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_RCV_ID (2) 
 
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_SND_ID (1) 
 
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQS_2100_3300 (270) 
 
Primary pointer page: 767, Index root page: 776 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.61, total records: 3523071 
 
Average version length: 84.24, total versions: 43990, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.65 
 
Pointer pages: 35, data page slots: 55504 
 
Data pages: 55504, average fill: 79% 
 
Primary pages: 55504, secondary pages: 0, swept pages: 37923 
 
Empty pages: 64, full pages: 51103 
 
Fill distribution: 
 
0 - 19% = 102 
 
20 - 39% = 133 
 
40 - 59% = 846 
 
60 - 79% = 21110 
 
80 - 99% = 33313 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3862, nodes: 3523071 
 
Average node length: 5.03, total dup: 3505942, max dup: 1327 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 705046, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 418 
 
40 - 59% = 2128 
 
60 - 79% = 886 
 
80 - 99% = 415 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 5941, nodes: 3523071 
 
Average node length: 6.25, total dup: 2880247, max dup: 14 
 
Average key length: 3.27, compression ratio: 2.75 
 
Average prefix length: 7.91, average data length: 1.09 
 
Clustering factor: 360547, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 198 
 
20 - 39% = 2222 
 
40 - 59% = 2378 
 
60 - 79% = 685 
 
80 - 99% = 458 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 4251, nodes: 3523071 
 
Average node length: 5.58, total dup: 3217228, max dup: 74 
 
Average key length: 2.60, compression ratio: 3.46 
 
Average prefix length: 8.48, average data length: 0.52 
 
Clustering factor: 751483, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 20 
 
20 - 39% = 450 
 
40 - 59% = 2239 
 
60 - 79% = 1097 
 
80 - 99% = 445 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.17, total records: 652825 
 
Average version length: 70.15, total versions: 3276, 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: 8968 
 
Data pages: 8968, average fill: 77% 
 
Primary pages: 8968, secondary pages: 0, swept pages: 6334 
 
Empty pages: 1, full pages: 8763 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 10 
 
40 - 59% = 29 
 
60 - 79% = 8833 
 
80 - 99% = 91 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 176029, depth: 3, leaf buckets: 787, nodes: 652825 
 
Average node length: 5.32, total dup: 614704, max dup: 116 
 
Average key length: 2.44, compression ratio: 3.68 
 
Average prefix length: 8.61, average data length: 0.39 
 
Clustering factor: 56001, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 182 
 
40 - 59% = 317 
 
60 - 79% = 195 
 
80 - 99% = 92 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 885, nodes: 652825 
 
Average node length: 5.93, total dup: 557436, max dup: 21 
 
Average key length: 3.05, compression ratio: 2.95 
 
Average prefix length: 8.09, average data length: 0.91 
 
Clustering factor: 59146, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 209 
 
40 - 59% = 368 
 
60 - 79% = 209 
 
80 - 99% = 98 
 
 
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 93150 ms, from  7:24:07.97 to  7:25:41.12. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 2212895  | 
 2082  | 
 0.0940  | 
|  DOC_LIST  | 
 679062  | 
 605  | 
 0.0890  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 799  | 
 199.7500  | 
|  INVNT_TURNOVER_LOG  | 
 21216  | 
 20483  | 
 96.5450  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 351  | 
 106  | 
 30.1994  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 258668  | 
 3444  | 
 1.3314  | 
|  PERF_ESTIMATED  | 
 283521  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 12419973  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 438726  | 
 853  | 
 0.1944  | 
|  RULES_FOR_PDISTR  | 
 4  | 
 0  | 
 0.0000  | 
|  RULES_FOR_QDISTR  | 
 7  | 
 0  | 
 0.0000  | 
|  SEMAPHORES  | 
 4  | 
 2  | 
 50.0000  | 
|  SETTINGS  | 
 114  | 
 0  | 
 0.0000  | 
|  TRACE_STAT  | 
 2701  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 9474  | 
 5922  | 
 62.5079  | 
|  XQD_1000_3300  | 
 1060210  | 
 9754  | 
 0.9200  | 
|  XQD_1200_2000  | 
 60293  | 
 19663  | 
 32.6124  | 
|  XQD_2000_3300  | 
 1683897  | 
 61708  | 
 3.6645  | 
|  XQD_2100_3300  | 
 43855  | 
 36001  | 
 82.0909  | 
|  XQD_3300_3400  | 
 2850781  | 
 21249  | 
 0.7453  | 
|  XQS_1000_1200  | 
 4856479  | 
 1880  | 
 0.0387  | 
|  XQS_1000_3300  | 
 2629914  | 
 33984  | 
 1.2922  | 
|  XQS_1200_2000  | 
 5142286  | 
 33162  | 
 0.6448  | 
|  XQS_2100_3300  | 
 3523071  | 
 43990  | 
 1.2486  | 
|  XQS_3300_3400  | 
 652825  | 
 3276  | 
 0.5018  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 2730 ms, from  7:25:52.97 to  7:25:55.70.  
07:25:55.84 Validation started 
 
 
07:25:55.87 Relation 140 (DOC_LIST) 
 
07:25:55.87   process pointer page    0 of    6 
 
07:25:55.98   process pointer page    1 of    6 
 
07:25:56.08   process pointer page    2 of    6 
 
07:25:56.17   process pointer page    3 of    6 
 
07:25:56.28   process pointer page    4 of    6 
 
07:25:56.36   process pointer page    5 of    6 
 
07:25:56.37 Index 1 (PK_DOC_LIST) 
 
07:25:56.64 Index 2 (DOC_LIST_ID_DESC) 
 
07:25:56.89 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:25:57.00 Relation 140 (DOC_LIST) is ok 
 
 
07:25:57.00 Relation 141 (DOC_DATA) 
 
07:25:57.00   process pointer page    0 of   15 
 
07:25:57.03   process pointer page    1 of   15 
 
07:25:57.06   process pointer page    2 of   15 
 
07:25:57.09   process pointer page    3 of   15 
 
07:25:57.12   process pointer page    4 of   15 
 
07:25:57.15   process pointer page    5 of   15 
 
07:25:57.18   process pointer page    6 of   15 
 
07:25:57.20   process pointer page    7 of   15 
 
07:25:57.23   process pointer page    8 of   15 
 
07:25:57.26   process pointer page    9 of   15 
 
07:25:57.29   process pointer page   10 of   15 
 
07:25:57.32   process pointer page   11 of   15 
 
07:25:57.34   process pointer page   12 of   15 
 
07:25:57.37   process pointer page   13 of   15 
 
07:25:57.40   process pointer page   14 of   15 
 
07:25:57.42 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:25:58.38 Index 3 (DOC_DATA_ID_DESC) 
 
07:25:59.32 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:26:00.07 Relation 141 (DOC_DATA) is ok 
 
 
07:26:00.07 Relation 147 (INVNT_SALDO) 
 
07:26:00.07   process pointer page    0 of    1 
 
07:26:00.07 Index 1 (PK_INVNT_SALDO) 
 
07:26:00.07 Relation 147 (INVNT_SALDO) is ok 
 
 
07:26:00.07 Relation 150 (PDISTR) 
 
07:26:00.07   process pointer page    0 of    2 
 
07:26:00.16   process pointer page    1 of    2 
 
07:26:00.24 Index 2 (PDISTR_SND_ID) 
 
07:26:00.32 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:26:00.41 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:26:00.51 Index 5 (PDISTR_AGENT_ID) 
 
07:26:00.58 Relation 150 (PDISTR) is ok 
 
 
07:26:00.58 Relation 151 (PSTORNED) 
 
07:26:00.58   process pointer page    0 of    4 
 
07:26:00.68   process pointer page    1 of    4 
 
07:26:00.77   process pointer page    2 of    4 
 
07:26:00.85   process pointer page    3 of    4 
 
07:26:00.88 Index 2 (PSTORNED_SND_ID) 
 
07:26:01.02 Index 3 (PSTORNED_RCV_ID) 
 
07:26:01.16 Relation 151 (PSTORNED) is ok 
 
 
07:26:01.16 Relation 156 (SEMAPHORES) 
 
07:26:01.16   process pointer page    0 of    1 
 
07:26:01.16 Index 1 (PK_SEMAPHORES) 
 
07:26:01.16 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:26:01.16 Relation 156 (SEMAPHORES) is ok 
 
 
07:26:01.16 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:26:01.16   process pointer page    0 of    2 
 
07:26:01.19   process pointer page    1 of    2 
 
07:26:01.21 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:26:01.22 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:26:01.22 Relation 160 (PERF_ESTIMATED) 
 
07:26:01.22   process pointer page    0 of    2 
 
07:26:01.32   process pointer page    1 of    2 
 
07:26:01.36 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:26:01.44 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:26:01.44 Relation 161 (PERF_ISQL_STAT) 
 
07:26:01.44   process pointer page    0 of    1 
 
07:26:01.44 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:26:01.44 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:26:01.44 Relation 162 (TRACE_STAT) 
 
07:26:01.44   process pointer page    0 of    1 
 
07:26:01.44 Relation 162 (TRACE_STAT) is ok 
 
 
07:26:01.44 Relation 163 (PERF_LOG) 
 
07:26:01.44   process pointer page    0 of  181 
 
07:26:01.52   process pointer page    1 of  181 
 
07:26:01.60   process pointer page    2 of  181 
 
07:26:01.69   process pointer page    3 of  181 
 
07:26:01.77   process pointer page    4 of  181 
 
07:26:01.85   process pointer page    5 of  181 
 
07:26:01.94   process pointer page    6 of  181 
 
07:26:02.02   process pointer page    7 of  181 
 
07:26:02.10   process pointer page    8 of  181 
 
07:26:02.18   process pointer page    9 of  181 
 
07:26:02.27   process pointer page   10 of  181 
 
07:26:02.35   process pointer page   11 of  181 
 
07:26:02.43   process pointer page   12 of  181 
 
07:26:02.50   process pointer page   13 of  181 
 
07:26:02.60   process pointer page   14 of  181 
 
07:26:02.67   process pointer page   15 of  181 
 
07:26:02.75   process pointer page   16 of  181 
 
07:26:02.85   process pointer page   17 of  181 
 
07:26:02.92   process pointer page   18 of  181 
 
07:26:03.00   process pointer page   19 of  181 
 
07:26:03.08   process pointer page   20 of  181 
 
07:26:03.17   process pointer page   21 of  181 
 
07:26:03.25   process pointer page   22 of  181 
 
07:26:03.33   process pointer page   23 of  181 
 
07:26:03.41   process pointer page   24 of  181 
 
07:26:03.49   process pointer page   25 of  181 
 
07:26:03.56   process pointer page   26 of  181 
 
07:26:03.64   process pointer page   27 of  181 
 
07:26:03.72   process pointer page   28 of  181 
 
07:26:03.81   process pointer page   29 of  181 
 
07:26:03.89   process pointer page   30 of  181 
 
07:26:03.97   process pointer page   31 of  181 
 
07:26:04.05   process pointer page   32 of  181 
 
07:26:04.13   process pointer page   33 of  181 
 
07:26:04.20   process pointer page   34 of  181 
 
07:26:04.30   process pointer page   35 of  181 
 
07:26:04.38   process pointer page   36 of  181 
 
07:26:04.45   process pointer page   37 of  181 
 
07:26:04.53   process pointer page   38 of  181 
 
07:26:04.61   process pointer page   39 of  181 
 
07:26:04.69   process pointer page   40 of  181 
 
07:26:04.77   process pointer page   41 of  181 
 
07:26:04.84   process pointer page   42 of  181 
 
07:26:04.92   process pointer page   43 of  181 
 
07:26:05.00   process pointer page   44 of  181 
 
07:26:05.09   process pointer page   45 of  181 
 
07:26:05.17   process pointer page   46 of  181 
 
07:26:05.25   process pointer page   47 of  181 
 
07:26:05.33   process pointer page   48 of  181 
 
07:26:05.40   process pointer page   49 of  181 
 
07:26:05.48   process pointer page   50 of  181 
 
07:26:05.56   process pointer page   51 of  181 
 
07:26:05.64   process pointer page   52 of  181 
 
07:26:05.73   process pointer page   53 of  181 
 
07:26:05.81   process pointer page   54 of  181 
 
07:26:05.89   process pointer page   55 of  181 
 
07:26:05.97   process pointer page   56 of  181 
 
07:26:06.04   process pointer page   57 of  181 
 
07:26:06.12   process pointer page   58 of  181 
 
07:26:06.20   process pointer page   59 of  181 
 
07:26:06.28   process pointer page   60 of  181 
 
07:26:06.36   process pointer page   61 of  181 
 
07:26:06.43   process pointer page   62 of  181 
 
07:26:06.51   process pointer page   63 of  181 
 
07:26:06.61   process pointer page   64 of  181 
 
07:26:06.68   process pointer page   65 of  181 
 
07:26:06.76   process pointer page   66 of  181 
 
07:26:06.84   process pointer page   67 of  181 
 
07:26:06.92   process pointer page   68 of  181 
 
07:26:07.01   process pointer page   69 of  181 
 
07:26:07.09   process pointer page   70 of  181 
 
07:26:07.17   process pointer page   71 of  181 
 
07:26:07.25   process pointer page   72 of  181 
 
07:26:07.32   process pointer page   73 of  181 
 
07:26:07.40   process pointer page   74 of  181 
 
07:26:07.48   process pointer page   75 of  181 
 
07:26:07.57   process pointer page   76 of  181 
 
07:26:07.65   process pointer page   77 of  181 
 
07:26:07.73   process pointer page   78 of  181 
 
07:26:07.82   process pointer page   79 of  181 
 
07:26:07.90   process pointer page   80 of  181 
 
07:26:07.98   process pointer page   81 of  181 
 
07:26:08.07   process pointer page   82 of  181 
 
07:26:08.15   process pointer page   83 of  181 
 
07:26:08.21   process pointer page   84 of  181 
 
07:26:08.24   process pointer page   85 of  181 
 
07:26:08.32   process pointer page   86 of  181 
 
07:26:08.42   process pointer page   87 of  181 
 
07:26:08.49   process pointer page   88 of  181 
 
07:26:08.57   process pointer page   89 of  181 
 
07:26:08.65   process pointer page   90 of  181 
 
07:26:08.73   process pointer page   91 of  181 
 
07:26:08.82   process pointer page   92 of  181 
 
07:26:08.90   process pointer page   93 of  181 
 
07:26:08.98   process pointer page   94 of  181 
 
07:26:09.07   process pointer page   95 of  181 
 
07:26:09.15   process pointer page   96 of  181 
 
07:26:09.23   process pointer page   97 of  181 
 
07:26:09.30   process pointer page   98 of  181 
 
07:26:09.34   process pointer page   99 of  181 
 
07:26:09.40   process pointer page  100 of  181 
 
07:26:09.43   process pointer page  101 of  181 
 
07:26:09.51   process pointer page  102 of  181 
 
07:26:09.54   process pointer page  103 of  181 
 
07:26:09.62   process pointer page  104 of  181 
 
07:26:09.69   process pointer page  105 of  181 
 
07:26:09.77   process pointer page  106 of  181 
 
07:26:09.85   process pointer page  107 of  181 
 
07:26:09.93   process pointer page  108 of  181 
 
07:26:10.01   process pointer page  109 of  181 
 
07:26:10.10   process pointer page  110 of  181 
 
07:26:10.18   process pointer page  111 of  181 
 
07:26:10.26   process pointer page  112 of  181 
 
07:26:10.33   process pointer page  113 of  181 
 
07:26:10.41   process pointer page  114 of  181 
 
07:26:10.49   process pointer page  115 of  181 
 
07:26:10.57   process pointer page  116 of  181 
 
07:26:10.66   process pointer page  117 of  181 
 
07:26:10.74   process pointer page  118 of  181 
 
07:26:10.82   process pointer page  119 of  181 
 
07:26:10.90   process pointer page  120 of  181 
 
07:26:10.97   process pointer page  121 of  181 
 
07:26:11.07   process pointer page  122 of  181 
 
07:26:11.15   process pointer page  123 of  181 
 
07:26:11.22   process pointer page  124 of  181 
 
07:26:11.30   process pointer page  125 of  181 
 
07:26:11.38   process pointer page  126 of  181 
 
07:26:11.46   process pointer page  127 of  181 
 
07:26:11.55   process pointer page  128 of  181 
 
07:26:11.63   process pointer page  129 of  181 
 
07:26:11.71   process pointer page  130 of  181 
 
07:26:11.79   process pointer page  131 of  181 
 
07:26:11.86   process pointer page  132 of  181 
 
07:26:11.94   process pointer page  133 of  181 
 
07:26:12.03   process pointer page  134 of  181 
 
07:26:12.11   process pointer page  135 of  181 
 
07:26:12.19   process pointer page  136 of  181 
 
07:26:12.27   process pointer page  137 of  181 
 
07:26:12.35   process pointer page  138 of  181 
 
07:26:12.42   process pointer page  139 of  181 
 
07:26:12.52   process pointer page  140 of  181 
 
07:26:12.60   process pointer page  141 of  181 
 
07:26:12.67   process pointer page  142 of  181 
 
07:26:12.75   process pointer page  143 of  181 
 
07:26:12.83   process pointer page  144 of  181 
 
07:26:12.91   process pointer page  145 of  181 
 
07:26:12.99   process pointer page  146 of  181 
 
07:26:13.08   process pointer page  147 of  181 
 
07:26:13.16   process pointer page  148 of  181 
 
07:26:13.20   process pointer page  149 of  181 
 
07:26:13.25   process pointer page  150 of  181 
 
07:26:13.33   process pointer page  151 of  181 
 
07:26:13.41   process pointer page  152 of  181 
 
07:26:13.49   process pointer page  153 of  181 
 
07:26:13.56   process pointer page  154 of  181 
 
07:26:13.66   process pointer page  155 of  181 
 
07:26:13.74   process pointer page  156 of  181 
 
07:26:13.81   process pointer page  157 of  181 
 
07:26:13.89   process pointer page  158 of  181 
 
07:26:13.97   process pointer page  159 of  181 
 
07:26:14.06   process pointer page  160 of  181 
 
07:26:14.14   process pointer page  161 of  181 
 
07:26:14.22   process pointer page  162 of  181 
 
07:26:14.30   process pointer page  163 of  181 
 
07:26:14.37   process pointer page  164 of  181 
 
07:26:14.45   process pointer page  165 of  181 
 
07:26:14.55   process pointer page  166 of  181 
 
07:26:14.62   process pointer page  167 of  181 
 
07:26:14.70   process pointer page  168 of  181 
 
07:26:14.78   process pointer page  169 of  181 
 
07:26:14.86   process pointer page  170 of  181 
 
07:26:14.95   process pointer page  171 of  181 
 
07:26:15.03   process pointer page  172 of  181 
 
07:26:15.11   process pointer page  173 of  181 
 
07:26:15.19   process pointer page  174 of  181 
 
07:26:15.28   process pointer page  175 of  181 
 
07:26:15.36   process pointer page  176 of  181 
 
07:26:15.44   process pointer page  177 of  181 
 
07:26:15.51   process pointer page  178 of  181 
 
07:26:15.61   process pointer page  179 of  181 
 
07:26:15.69   process pointer page  180 of  181 
 
07:26:15.73 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:26:20.22 Index 2 (PERF_LOG_UNIT) 
 
07:26:26.37 Index 3 (PERF_LOG_TRN_DESC) 
 
07:26:29.91 Index 4 (PERF_LOG_GDSCODE) 
 
07:26:32.46 Relation 163 (PERF_LOG) is ok 
 
 
07:26:32.47 Relation 167 (V_STOPTEST) 
 
07:26:32.47 Relation 167 (V_STOPTEST) is ok 
 
 
07:26:32.47 Relation 184 (V_QDISTR_SOURCE) 
 
07:26:32.47 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:26:32.47 Relation 185 (V_QSTORNED_SOURCE) 
 
07:26:32.47 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:26:32.47 Relation 260 (XQD_1000_1200) 
 
07:26:32.47   process pointer page    0 of    2 
 
07:26:32.47   process pointer page    1 of    2 
 
07:26:32.47 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:26:32.49 Relation 260 (XQD_1000_1200) is ok 
 
 
07:26:32.49 Relation 261 (XQD_1200_2000) 
 
07:26:32.49   process pointer page    0 of    4 
 
07:26:32.49   process pointer page    1 of    4 
 
07:26:32.49   process pointer page    2 of    4 
 
07:26:32.50   process pointer page    3 of    4 
 
07:26:32.52 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:26:32.52 Relation 261 (XQD_1200_2000) is ok 
 
 
07:26:32.52 Relation 262 (XQD_1000_3300) 
 
07:26:32.52   process pointer page    0 of   10 
 
07:26:32.58   process pointer page    1 of   10 
 
07:26:32.66   process pointer page    2 of   10 
 
07:26:32.69   process pointer page    3 of   10 
 
07:26:32.75   process pointer page    4 of   10 
 
07:26:32.80   process pointer page    5 of   10 
 
07:26:32.83   process pointer page    6 of   10 
 
07:26:32.91   process pointer page    7 of   10 
 
07:26:32.99   process pointer page    8 of   10 
 
07:26:33.06   process pointer page    9 of   10 
 
07:26:33.14 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:26:33.47 Index 2 (XQD_1000_3300_DOC) 
 
07:26:33.80 Relation 262 (XQD_1000_3300) is ok 
 
 
07:26:33.80 Relation 263 (XQD_2000_3300) 
 
07:26:33.80   process pointer page    0 of   18 
 
07:26:33.89   process pointer page    1 of   18 
 
07:26:33.98   process pointer page    2 of   18 
 
07:26:34.09   process pointer page    3 of   18 
 
07:26:34.20   process pointer page    4 of   18 
 
07:26:34.28   process pointer page    5 of   18 
 
07:26:34.39   process pointer page    6 of   18 
 
07:26:34.47   process pointer page    7 of   18 
 
07:26:34.56   process pointer page    8 of   18 
 
07:26:34.66   process pointer page    9 of   18 
 
07:26:34.73   process pointer page   10 of   18 
 
07:26:34.83   process pointer page   11 of   18 
 
07:26:34.90   process pointer page   12 of   18 
 
07:26:34.98   process pointer page   13 of   18 
 
07:26:35.08   process pointer page   14 of   18 
 
07:26:35.15   process pointer page   15 of   18 
 
07:26:35.22   process pointer page   16 of   18 
 
07:26:35.26   process pointer page   17 of   18 
 
07:26:35.26 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:26:35.54 Relation 263 (XQD_2000_3300) is ok 
 
 
07:26:35.54 Relation 264 (XQD_2100_3300) 
 
07:26:35.54   process pointer page    0 of    4 
 
07:26:35.59   process pointer page    1 of    4 
 
07:26:35.64   process pointer page    2 of    4 
 
07:26:35.64   process pointer page    3 of    4 
 
07:26:35.64 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:26:35.65 Relation 264 (XQD_2100_3300) is ok 
 
 
07:26:35.65 Relation 265 (XQD_3300_3400) 
 
07:26:35.65   process pointer page    0 of   26 
 
07:26:35.75   process pointer page    1 of   26 
 
07:26:35.84   process pointer page    2 of   26 
 
07:26:35.93   process pointer page    3 of   26 
 
07:26:36.01   process pointer page    4 of   26 
 
07:26:36.11   process pointer page    5 of   26 
 
07:26:36.20   process pointer page    6 of   26 
 
07:26:36.29   process pointer page    7 of   26 
 
07:26:36.39   process pointer page    8 of   26 
 
07:26:36.46   process pointer page    9 of   26 
 
07:26:36.56   process pointer page   10 of   26 
 
07:26:36.65   process pointer page   11 of   26 
 
07:26:36.75   process pointer page   12 of   26 
 
07:26:36.82   process pointer page   13 of   26 
 
07:26:36.92   process pointer page   14 of   26 
 
07:26:37.01   process pointer page   15 of   26 
 
07:26:37.10   process pointer page   16 of   26 
 
07:26:37.18   process pointer page   17 of   26 
 
07:26:37.28   process pointer page   18 of   26 
 
07:26:37.37   process pointer page   19 of   26 
 
07:26:37.46   process pointer page   20 of   26 
 
07:26:37.54   process pointer page   21 of   26 
 
07:26:37.63   process pointer page   22 of   26 
 
07:26:37.71   process pointer page   23 of   26 
 
07:26:37.81   process pointer page   24 of   26 
 
07:26:37.88   process pointer page   25 of   26 
 
07:26:37.92 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:26:39.15 Relation 265 (XQD_3300_3400) is ok 
 
 
07:26:39.15 Relation 266 (XQS_1000_1200) 
 
07:26:39.16   process pointer page    0 of   46 
 
07:26:39.24   process pointer page    1 of   46 
 
07:26:39.34   process pointer page    2 of   46 
 
07:26:39.43   process pointer page    3 of   46 
 
07:26:39.51   process pointer page    4 of   46 
 
07:26:39.60   process pointer page    5 of   46 
 
07:26:39.69   process pointer page    6 of   46 
 
07:26:39.79   process pointer page    7 of   46 
 
07:26:39.87   process pointer page    8 of   46 
 
07:26:39.96   process pointer page    9 of   46 
 
07:26:40.05   process pointer page   10 of   46 
 
07:26:40.13   process pointer page   11 of   46 
 
07:26:40.22   process pointer page   12 of   46 
 
07:26:40.32   process pointer page   13 of   46 
 
07:26:40.40   process pointer page   14 of   46 
 
07:26:40.49   process pointer page   15 of   46 
 
07:26:40.58   process pointer page   16 of   46 
 
07:26:40.66   process pointer page   17 of   46 
 
07:26:40.75   process pointer page   18 of   46 
 
07:26:40.85   process pointer page   19 of   46 
 
07:26:40.93   process pointer page   20 of   46 
 
07:26:41.02   process pointer page   21 of   46 
 
07:26:41.11   process pointer page   22 of   46 
 
07:26:41.19   process pointer page   23 of   46 
 
07:26:41.29   process pointer page   24 of   46 
 
07:26:41.38   process pointer page   25 of   46 
 
07:26:41.46   process pointer page   26 of   46 
 
07:26:41.55   process pointer page   27 of   46 
 
07:26:41.64   process pointer page   28 of   46 
 
07:26:41.72   process pointer page   29 of   46 
 
07:26:41.82   process pointer page   30 of   46 
 
07:26:41.91   process pointer page   31 of   46 
 
07:26:41.99   process pointer page   32 of   46 
 
07:26:42.08   process pointer page   33 of   46 
 
07:26:42.17   process pointer page   34 of   46 
 
07:26:42.28   process pointer page   35 of   46 
 
07:26:42.44   process pointer page   36 of   46 
 
07:26:42.72   process pointer page   37 of   46 
 
07:26:43.00   process pointer page   38 of   46 
 
07:26:43.30   process pointer page   39 of   46 
 
07:26:43.58   process pointer page   40 of   46 
 
07:26:43.86   process pointer page   41 of   46 
 
07:26:44.23   process pointer page   42 of   46 
 
07:26:44.56   process pointer page   43 of   46 
 
07:26:44.94   process pointer page   44 of   46 
 
07:26:45.26   process pointer page   45 of   46 
 
07:26:45.51 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:26:48.15 Index 2 (XQS_1000_1200_SND_ID) 
 
07:26:50.68 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:26:53.11 Relation 266 (XQS_1000_1200) is ok 
 
 
07:26:53.11 Relation 267 (XQS_1200_2000) 
 
07:26:53.11   process pointer page    0 of   51 
 
07:26:53.20   process pointer page    1 of   51 
 
07:26:53.31   process pointer page    2 of   51 
 
07:26:53.42   process pointer page    3 of   51 
 
07:26:53.52   process pointer page    4 of   51 
 
07:26:53.62   process pointer page    5 of   51 
 
07:26:53.72   process pointer page    6 of   51 
 
07:26:53.83   process pointer page    7 of   51 
 
07:26:53.94   process pointer page    8 of   51 
 
07:26:54.05   process pointer page    9 of   51 
 
07:26:54.45   process pointer page   10 of   51 
 
07:26:54.87   process pointer page   11 of   51 
 
07:26:55.31   process pointer page   12 of   51 
 
07:26:55.79   process pointer page   13 of   51 
 
07:26:56.23   process pointer page   14 of   51 
 
07:26:56.60   process pointer page   15 of   51 
 
07:26:57.01   process pointer page   16 of   51 
 
07:26:57.38   process pointer page   17 of   51 
 
07:26:57.82   process pointer page   18 of   51 
 
07:26:58.27   process pointer page   19 of   51 
 
07:26:58.73   process pointer page   20 of   51 
 
07:26:59.13   process pointer page   21 of   51 
 
07:26:59.58   process pointer page   22 of   51 
 
07:26:59.99   process pointer page   23 of   51 
 
07:27:00.41   process pointer page   24 of   51 
 
07:27:00.82   process pointer page   25 of   51 
 
07:27:01.24   process pointer page   26 of   51 
 
07:27:01.69   process pointer page   27 of   51 
 
07:27:02.10   process pointer page   28 of   51 
 
07:27:02.49   process pointer page   29 of   51 
 
07:27:02.91   process pointer page   30 of   51 
 
07:27:03.37   process pointer page   31 of   51 
 
07:27:03.84   process pointer page   32 of   51 
 
07:27:04.31   process pointer page   33 of   51 
 
07:27:04.78   process pointer page   34 of   51 
 
07:27:05.25   process pointer page   35 of   51 
 
07:27:05.70   process pointer page   36 of   51 
 
07:27:06.14   process pointer page   37 of   51 
 
07:27:06.57   process pointer page   38 of   51 
 
07:27:07.01   process pointer page   39 of   51 
 
07:27:07.43   process pointer page   40 of   51 
 
07:27:07.87   process pointer page   41 of   51 
 
07:27:08.32   process pointer page   42 of   51 
 
07:27:08.73   process pointer page   43 of   51 
 
07:27:09.12   process pointer page   44 of   51 
 
07:27:09.55   process pointer page   45 of   51 
 
07:27:09.94   process pointer page   46 of   51 
 
07:27:10.36   process pointer page   47 of   51 
 
07:27:10.75   process pointer page   48 of   51 
 
07:27:11.08   process pointer page   49 of   51 
 
07:27:11.50   process pointer page   50 of   51 
 
07:27:11.58 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:27:14.44 Index 2 (XQS_1200_2000_SND_ID) 
 
07:27:17.66 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:27:20.36 Relation 267 (XQS_1200_2000) is ok 
 
 
07:27:20.36 Relation 268 (XQS_1000_3300) 
 
07:27:20.36   process pointer page    0 of   26 
 
07:27:20.86   process pointer page    1 of   26 
 
07:27:21.36   process pointer page    2 of   26 
 
07:27:21.88   process pointer page    3 of   26 
 
07:27:22.39   process pointer page    4 of   26 
 
07:27:22.87   process pointer page    5 of   26 
 
07:27:23.37   process pointer page    6 of   26 
 
07:27:23.83   process pointer page    7 of   26 
 
07:27:24.31   process pointer page    8 of   26 
 
07:27:24.81   process pointer page    9 of   26 
 
07:27:25.31   process pointer page   10 of   26 
 
07:27:25.79   process pointer page   11 of   26 
 
07:27:26.29   process pointer page   12 of   26 
 
07:27:26.77   process pointer page   13 of   26 
 
07:27:27.27   process pointer page   14 of   26 
 
07:27:27.76   process pointer page   15 of   26 
 
07:27:28.24   process pointer page   16 of   26 
 
07:27:28.71   process pointer page   17 of   26 
 
07:27:29.19   process pointer page   18 of   26 
 
07:27:29.68   process pointer page   19 of   26 
 
07:27:30.18   process pointer page   20 of   26 
 
07:27:30.64   process pointer page   21 of   26 
 
07:27:31.10   process pointer page   22 of   26 
 
07:27:31.55   process pointer page   23 of   26 
 
07:27:31.99   process pointer page   24 of   26 
 
07:27:32.39   process pointer page   25 of   26 
 
07:27:32.50 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:27:33.90 Index 2 (XQS_1000_3300_SND_ID) 
 
07:27:35.70 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:27:37.55 Relation 268 (XQS_1000_3300) is ok 
 
 
07:27:37.55 Relation 269 (XQS_2000_3300) 
 
07:27:37.55   process pointer page    0 of    1 
 
07:27:37.55 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:27:37.55 Index 2 (XQS_2000_3300_SND_ID) 
 
07:27:37.55 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:27:37.55 Relation 269 (XQS_2000_3300) is ok 
 
 
07:27:37.55 Relation 270 (XQS_2100_3300) 
 
07:27:37.55   process pointer page    0 of   35 
 
07:27:38.04   process pointer page    1 of   35 
 
07:27:38.54   process pointer page    2 of   35 
 
07:27:39.04   process pointer page    3 of   35 
 
07:27:39.54   process pointer page    4 of   35 
 
07:27:40.02   process pointer page    5 of   35 
 
07:27:40.52   process pointer page    6 of   35 
 
07:27:40.97   process pointer page    7 of   35 
 
07:27:41.45   process pointer page    8 of   35 
 
07:27:41.95   process pointer page    9 of   35 
 
07:27:42.45   process pointer page   10 of   35 
 
07:27:42.97   process pointer page   11 of   35 
 
07:27:43.44   process pointer page   12 of   35 
 
07:27:43.89   process pointer page   13 of   35 
 
07:27:44.37   process pointer page   14 of   35 
 
07:27:44.84   process pointer page   15 of   35 
 
07:27:45.32   process pointer page   16 of   35 
 
07:27:45.79   process pointer page   17 of   35 
 
07:27:46.31   process pointer page   18 of   35 
 
07:27:46.77   process pointer page   19 of   35 
 
07:27:47.23   process pointer page   20 of   35 
 
07:27:47.68   process pointer page   21 of   35 
 
07:27:48.12   process pointer page   22 of   35 
 
07:27:48.58   process pointer page   23 of   35 
 
07:27:49.04   process pointer page   24 of   35 
 
07:27:49.49   process pointer page   25 of   35 
 
07:27:49.96   process pointer page   26 of   35 
 
07:27:50.39   process pointer page   27 of   35 
 
07:27:50.83   process pointer page   28 of   35 
 
07:27:51.27   process pointer page   29 of   35 
 
07:27:51.69   process pointer page   30 of   35 
 
07:27:52.11   process pointer page   31 of   35 
 
07:27:52.53   process pointer page   32 of   35 
 
07:27:52.87   process pointer page   33 of   35 
 
07:27:53.20   process pointer page   34 of   35 
 
07:27:53.20 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:27:55.35 Index 2 (XQS_2100_3300_SND_ID) 
 
07:27:57.29 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:27:59.77 Relation 270 (XQS_2100_3300) is ok 
 
 
07:27:59.77 Relation 271 (XQS_3300_3400) 
 
07:27:59.77   process pointer page    0 of    6 
 
07:28:00.25   process pointer page    1 of    6 
 
07:28:00.72   process pointer page    2 of    6 
 
07:28:01.17   process pointer page    3 of    6 
 
07:28:01.64   process pointer page    4 of    6 
 
07:28:02.11   process pointer page    5 of    6 
 
07:28:02.30 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:28:02.67 Index 2 (XQS_3300_3400_SND_ID) 
 
07:28:03.08 Relation 271 (XQS_3300_3400) is ok 
 
 
07:28:03.11 Validation finished 
 
Done for 127470 ms, from  7:25:55.73 to  7:28:03.20. 
 
 Differences between old and current firebird.log 
7:28:04.75. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2017-05-13  07:28               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 May 13 07:25:55 2017 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Sat May 13 07:28:03 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-05-13  7:28:14.62 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html