Question

How to tune Oracle CDC parameters to get best performance?

  • 17 July 2023
  • 0 replies
  • 45 views

Badge

Following parameters can be tuned to get the optimal performance from the Oracle CDC:-

  1. Max Batch Size (records) = 20000
  2. Batch Wait Time (secs) = 15 - 30 seconds 
  3. JDBC Fetch Size for Current Window = 25000 at least
  4. JDBC Fetch Size for Past Windows = 25000 at least
  5. Time between Session Windows (ms) = 1 ms
  6. Time after Session Window Start (ms) = 1ms
  7. Parsing Thread Pool Size = 8 (up to 2x the number of CPUs available) 

NOTE:- Performance depends on the ENV, Infrastructure, Resources, so the values for every environment/use cases may differ. Above mentioned values can be used as a starting point. Tuning performance is trial and error method. Once the optimal values found for the specific environment/use case, those values can be applied. 


0 replies

Be the first to reply!

Reply