Debezium 2.5 Oracle 12c – Strategy for Large-Scale Deployment

[Ramesh K]

Hi Chris,

Hope you're doing well.

We’re planning a Debezium 2.5 deployment for Oracle 12c, and I wanted to get your thoughts on the best strategy. The setup involves over 700 tables from a single Oracle database, with a total size of around 900 GB.

Given the scale, we’re evaluating whether to:

• Use a single Debezium connector to handle all tables, or

• Split the workload across multiple connectors, possibly grouped by schema or logical boundaries
  
  Would appreciate your input on which approach would be more scalable and resilient in this scenario
  
  
  

attached config below

Thanks,

Ramesh