This content has been marked as final. Show 1 reply
In 11.2, the queue table is mainly used for storing failed transactions in the error queue - and this is probably where you will find all of your missing UPDATES, too.
Check the view DBA_APPLY_ERROR to see which transaction(s) failed. This view will give you information about the source transaction id, which LCR caused the problem, the Oracle error number and message. Most likely the UPDATEs are failing due to conflict detection: the data at the target database does not match the BEFORE IMAGE of the source row Logical Change Record (LCR).
The Oracle Streams Concepts and Administration manual includes some pl/sql procedures to actually view the transactions and LCRs that are stored in the error queue in Chapter 26 in the subsection labeled "Displaying Detailed Information about Apply Errors"