Read Stats Logs Splitter

(Sample)


11/21/2018 13:35 1542825302 rchar: 1350446563683 syscr: 130696931  pid: 9134 io_centisecs: 4948512 utime_centisecs: 663107 stime_centisecs: 724558

11/21/2018 13:40 1542825602 rchar: 1351572510400 syscr: 130808682  pid: 9134 io_centisecs: 4952359 utime_centisecs: 663666 stime_centisecs: 725240

11/21/2018 13:45 1542825901 rchar: 1352338647582 syscr: 130895789  pid: 9134 io_centisecs: 4955231 utime_centisecs: 664120 stime_centisecs: 725698

11/21/2018 13:50 1542826201 rchar: 1353476802428 syscr: 131104955  pid: 9134 io_centisecs: 4961566 utime_centisecs: 664734 stime_centisecs: 726684

Date and Time	Read Bytes	PReads and LReads	HVR Log Reader PID	IO Waits	User CPU	System CPU

DMS Result Splitter

Table Name	Source	Implementation Date	Rows	Duration

Partition Solver

-------------------------

Partition Value	Partition Row Count

HVR Read Speed

(Sample)


2020-05-18T11:02:53-04:00: lib_oa6p_m1-integ-sa6p2: Integrate cycle 34513.14 for 1119 transaction files (9997890 bytes).

2020-05-18T11:02:57-04:00: lib_oa6p_m1-integ-sa6p2: 4907 updates discarded because no columns changed.

2020-05-18T11:09:36-04:00: lib_oa6p_m1-integ-sa6p2: Moved 165099 deletes, 334395 inserts, 167879 updates (coalesced from 165507 deletes, 334803 inserts, 175494 updates) into 27 burst tables and took 6.71 minutes.

minutes ago took 9.52 seconds.

2020-05-18T11:10:05-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 4363 updates for table 'pbim' from between 1.14 hours and 54.67 minutes ago took 0.56 seconds.

2020-05-18T11:10:05-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 128 deletes for table 'plaf' from between 1.12 hours and 55.05 minutes ago took 0.25 seconds using 3 operations.

2020-05-18T11:10:05-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 675 updates for table 'plaf' from between 57.68 minutes and 54.75 minutes ago took 0.17 seconds.

2020-05-18T11:10:06-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 280 updates for table 'qals' from between 1.14 hours and 54.90 minutes ago took 0.18 seconds.

2020-05-18T11:10:06-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 61 inserts for table 'qals' from between 1.13 hours and 54.83 minutes ago took 0.04 seconds.

2020-05-18T11:10:07-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 1493 inserts for table 'vbbe' from between 1.13 hours and 54.80 minutes ago took 0.09 seconds.

2020-05-18T11:10:07-04:00: lib_oa6p_m1-integ-sa6p2: Integrate cycle for 27 tables of 667373 changes from between 1.14 hours and 54.70 minutes ago took 30.99 seconds.

2020-05-18T11:10:10-04:00: lib_oa6p_m1-integ-sa6p2: Integrate cycle 34513.15 for 1042 transaction files (9983066 bytes).

2020-05-18T11:10:14-04:00: lib_oa6p_m1-integ-sa6p2: 5249 updates discarded because no columns changed.

2020-05-18T11:16:45-04:00: lib_oa6p_m1-integ-sa6p2: Moved 123719 deletes, 340673 inserts, 210563 updates (coalesced from 124562 deletes, 341516 inserts, 216759 updates) into 24 burst tables and took 6.59 minutes.

2020-05-18T11:16:46-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 52 updates for table 'afko' from between 1.02 hours and 47.05 minutes ago took 0.18 seconds.

2020-05-18T11:16:48-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 51 inserts for table 'eket' from between 1.01 hours and 48.97 minutes ago took 0.03 seconds.

2020-05-18T11:16:48-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 6 updates for table 'ekko' from between 1.01 hours and 48.97 minutes ago took 0.10 seconds.

2020-05-18T11:16:48-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 21 inserts for table 'ekko' from between 1.02 hours and 50.82 minutes ago took 0.05 seconds.

2020-05-18T11:17:16-04:00: lib_oa6p_m1-integ-sa6p2: Integrate cycle for 24 tables of 674955 changes from between 1.03 hours and 47.17 minutes ago took 31.04 seconds.

2020-05-18T11:17:19-04:00: lib_oa6p_m1-integ-sa6p2: Integrate cycle 34513.16 for 1064 transaction files (9994178 bytes).

2020-05-18T11:17:23-04:00: lib_oa6p_m1-integ-sa6p2: 249296 updates discarded because no columns changed.

2020-05-18T11:22:30-04:00: lib_oa6p_m1-integ-sa6p2: Moved 132265 deletes, 280461 inserts, 153349 updates (coalesced from 159361 deletes, 307557 inserts, 162410 updates) into 22 burst tables and took 21 seconds.

2020-05-18T11:22:31-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 30 updates for table 'afko' from between 52.30 minutes and 39.37 minutes ago took 0.16 seconds.

2020-05-18T11:22:31-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 1 insert for table 'afko' from 50.73 minutes ago took 0.02 seconds.

2020-05-18T11:22:31-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 146 updates for table 'afpo' from between 52.30 minutes and 39.03 minutes ago took 0.18 seconds.

2020-05-18T11:22:58-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 7537 inserts for table 'vbbe' from between 52.82 minutes and 39.38 minutes ago took 0.23 seconds.

2020-05-18T11:22:58-04:00: lib_oa6p_m1-integ-sa6p2: Integrate cycle for 22 tables of 566075 changes from between 52.87 minutes and 39.37 minutes ago took 27.93 seconds.

2020-05-18T11:23:01-04:00: lib_oa6p_m1-integ-sa6p2: Integrate cycle 34513.17 for 857 transaction files (9999236 bytes).

2020-05-18T11:23:06-04:00: lib_oa6p_m1-integ-sa6p2: 1031739 updates discarded because no columns changed.

2020-05-18T11:27:54-04:00: lib_oa6p_m1-integ-sa6p2: Moved 271779 deletes, 246111 inserts, 55820 updates (coalesced from 272078 deletes, 246410 inserts, 61041 updates) into 25 burst tables and took 8.1 seconds.

2020-05-18T11:27:55-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 18 updates for table 'afko' from between 44.32 minutes and 34.17 minutes ago took 0.15 seconds.

2020-05-18T11:28:20-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 2658 deletes for table 'vbbe' from between 44.68 minutes and 34.75 minutes ago took 0.96 seconds using 4 operations.

2020-05-18T11:28:20-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 3664 updates for table 'vbbe' from between 44.68 minutes and 34.33 minutes ago took 0.21 seconds.

2020-05-18T11:28:20-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 3523 inserts for table 'vbbe' from between 44.68 minutes and 34.27 minutes ago took 0.13 seconds.

2020-05-18T11:28:20-04:00: lib_oa6p_m1-integ-sa6p2: Integrate cycle for 25 tables of 573710 changes from between 44.73 minutes and 34 minutes ago took 26.15 seconds.

2020-05-18T11:28:23-04:00: lib_oa6p_m1-integ-sa6p2: Integrate cycle 34513.18 for 570 transaction files (9998146 bytes).

2020-05-18T11:28:27-04:00: lib_oa6p_m1-integ-sa6p2: 543652 updates discarded because no columns changed.

2020-05-18T11:33:44-04:00: lib_oa6p_m1-integ-sa6p2: Moved 387234 deletes, 88724 inserts, 73774 updates (coalesced from 387276 deletes, 88766 inserts, 78362 updates) into 25 burst tables and took 5.35 minutes.

2020-05-18T11:33:44-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 19 updates for table 'afko' from between 38.63 minutes and 31.92 minutes ago took 0.20 seconds.

2020-05-18T11:33:44-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 4 inserts for table 'afko' from between 35.82 minutes and 32.05 minutes ago took 0.03 seconds.

2020-05-18T11:33:44-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 99 updates for table 'afpo' from between 38.62 minutes and 31.78 minutes ago took 0.08 seconds.

2020-05-18T11:33:44-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 4 inserts for table 'afpo' from between 35.82 minutes and 32.05 minutes ago took 0.03 seconds.

2020-05-18T11:33:44-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 17 updates for table 'aufk' from between 38.62 minutes and 31.92 minutes ago took 0.03 seconds.

2020-05-18T11:33:45-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 4 inserts for table 'aufk' from between 35.83 minutes and 32.07 minutes ago took 0.03 seconds.

2020-05-18T11:33:45-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 25 inserts for table 'eina' from between 39.33 minutes and 31.90 minutes ago took 0.03 seconds.

2020-05-18T11:33:45-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 25 inserts for table 'eine' from between 39.33 minutes and 31.90 minutes ago took 0.04 seconds.

2020-05-18T11:33:45-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 50 updates for table 'ekes' from between 39.35 minutes and 32.30 minutes ago took 0.09 seconds.

2020-05-18T11:33:45-04:00: lib_oa6p_m1-integ-sa6p2: Integrated 77 inserts for table 'ekes' from between 39.42 minutes and 32.17 minutes ago took 0.04 seconds.

Date and Time	Source	Source Inserts	Source Updates	Source Deletes	Total Source	Coalesced Inserts	Coalesced Updates	Coalesced Deletes	Total Coalesced	Burst Tables	Duration	Duration in Seconds

List Compare

Capture Read Speed Logs Splitter

(Sample)

2019-03-25T12:56:43+09:00: lib_oanp-cap-oanp: $ZIZ_FILE_TRACE: Open: '/oracle/ANP/oraarch/ANParch1_92018_967761788.dbf' normal using ZIZ_READ

2019-03-25T12:56:43+09:00: lib_oanp-cap-oanp: $ZIZ_FILE_TRACE: Open: '/oracle/ANP/oraarch/ANParch1_92018_967761788.dbf' normal using ZIZ_READ

2019-03-25T12:59:43+09:00: lib_oanp-cap-oanp: $ZIZ_FILE_TRACE: Open: '/oracle/ANP/oraarch/ANParch1_92019_967761788.dbf' normal using ZIZ_READ

2019-03-25T12:59:43+09:00: lib_oanp-cap-oanp: $ZIZ_FILE_TRACE: Open: '/oracle/ANP/oraarch/ANParch1_92019_967761788.dbf' normal using ZIZ_READ

2019-03-25T13:02:44+09:00: lib_oanp-cap-oanp: $ZIZ_FILE_TRACE: Open: '/oracle/ANP/oraarch/ANParch1_92020_967761788.dbf' normal using ZIZ_READ

2019-03-25T13:02:44+09:00: lib_oanp-cap-oanp: $ZIZ_FILE_TRACE: Open: '/oracle/ANP/oraarch/ANParch1_92020_967761788.dbf' normal using ZIZ_READ

2019-03-25T13:05:44+09:00: lib_oanp-cap-oanp: $ZIZ_FILE_TRACE: Open: '/oracle/ANP/oraarch/ANParch1_92021_967761788.dbf' normal using ZIZ_READ

2019-03-25T13:05:44+09:00: lib_oanp-cap-oanp: $ZIZ_FILE_TRACE: Open: '/oracle/ANP/oraarch/ANParch1_92021_967761788.dbf' normal using ZIZ_READ

2019-03-25T13:08:45+09:00: lib_oanp-cap-oanp: $ZIZ_FILE_TRACE: Open: '/oracle/ANP/oraarch/ANParch1_92022_967761788.dbf' normal using ZIZ_READ

2019-03-25T13:08:45+09:00: lib_oanp-cap-oanp: $ZIZ_FILE_TRACE: Open: '/oracle/ANP/oraarch/ANParch1_92022_967761788.dbf' normal using ZIZ_READ

Date and Time	File Name	Delay from previous file

Select which tool to use

Read Stats Logs Splitter

DMS Result Splitter

Partition Solver

HVR Read Speed

List Compare

Capture Read Speed Logs Splitter