Statistics

This statistic shows the number of unique individual batches that has been prepared by the reader and sent to all writers.

This statistic shows the number of insert items passed to the Status table insert writer.

This statistic shows the number of update items passed to the Status table update writer.

This statistic shows the number of delete items passed to the Status table delete writer.

This statistic shows the number of journal items passed to the Journal table insert writer.

This statistic shows the number of details items passed to the Details table insert writer.

This statistic shows the average event rate per second. An event is defined by the reader to be any insert/update/delete SQL action constructed and prepared by the reader and sent to one of the writers. Its value defines the average data rate for the current statistics calculation period. If the statistics period is 60 seconds and 60 events were prepared the average receive rate for the period is one event a second, even if all of the data was prepared in just one of the seconds in the period.

This statistic shows the number of unique individual batches that have been received from the reader and applied to the target table within the Oracle database.

This statistic shows the number of rows received from the reader and successfully inserted into the target Status table.

This statistic shows the number of rows received from the reader that failed to be inserted in to the target Status table.

This statistic shows the number of updates received from the reader and successfully applied to the target Status table.

This statistic shows the number of updates received from the reader that could not be applied to the target Status table. In reporter mode, this figure will also reflect the number of updates that were successfully applied, but did not effect any rows in the target table.

This statistic shows the number of deletion updates received from the reader and successfully applied to the target Status table.

This statistic shows the number of deletion updates received from the reader that could not be applied to the target Status table. In reporter mode, this figure will also reflect the number of updates that were successfully applied, but did not affect any rows in the target table.

This statistic shows the number of journal inserts received from the reader and successfully inserted into the target Journal table.

This statistic shows the number of journal inserts received from the reader which could not be inserted into the target Journal table.

This statistic shows the number of detail inserts received from the reader and successfully inserted into the target Details table.

This statistic shows the number of detail inserts received from the reader that could not be inserted into the target Details table.

This statistic provides the average event rate a second. An event is defined by the writer to be an individual insert/update/delete SQL action received in a batch from the reader. Its value defines the average data send rate for the current statistics calculation period. If the statistics period is 60 seconds and 60 events are sent to the Oracle database, the average send rate for the period is one event a second, even if all of the data was sent in just one of the seconds of the period.

This statistic shows the amount of data that has yet to be sent to the Oracle database expressed as a percentage of all data requiring sending. This is effectively a measure of the gateway’s backlog. This figure is calculated as an average over five statistic periods.