i have oracle streams and messaging gateway setup to propagate the changes. what my concern is that i need to confirm the counts of the messages throughout the setup(capture, apply reader, coordinator, server, AQ q and destination).
i have been trying to get the synced counts from all the views available to ascertain that all the messages are propagating properly and there is no loss of messages. and the point i'm stuck at right now is why the no of messages dequeued in the apply reader view is not matching the no of messages applied in the apply server view, and where can i get the count of messages which were not counted in apply server count.
Please suggest me as to why there is a difference.