I have replicated 46 e-Business R12 schema to create Target DB from Source Db, then configured Downstream process in Target DB to replicate 46 schemas.
The problem I am facing that Apply Process is running to slow and getting stuck, I set parallelism parameter to 10.
At source side everyafter 20 mins large transactions (around 2 millions LCR ) and batch processing is executing with out any intermitent commit,
So Apply is getting stuck and capture process is PAUSE FOR FLOW CONTROL.
Can you plese suggest,
1. How to boost Apply process so that any change will replicate to target within 5 min?
2. Does Stream capable enough to handle this large transaction and batch processing? If Stream cant handle it then what is the work around?
I will appreciate your early response.
Streams is capable enough to handle large amounts of transactions.
In your case, we need to understand more in actual problem, hence require more inputs from you as below:
what is the Oracle version you are using?
Capture & apply parameters? what you have set..
streams pool size ?
no. of CPU's on server?