HomeOracleOracle Error ORA-26840: Combined capture and apply optimization is disabled because string is unable to identify an apply for the source database “string”.

Oracle Error ORA-26840: Combined capture and apply optimization is disabled because string is unable to identify an apply for the source database “string”.

Oracle Error Message

ORA-26840: Combined capture and apply optimization is disabled because string is unable to identify an apply for the source database “string”.

Reason for the Error

There were multiple Streams apply processes using the same queue which made combined capture and apply (CCA) optimization not possible.

Solution

If Streams performance is an issue, check the “Combined Capture and Apply Optimization” chapter in the “Oracle Streams Concepts and Administration” book. Then reconfigure the Streams processes to meet this optimization’s requirements.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...