I am using Oracle Source Connector in CDC mode by which I mean:
I want to get just data being updated without any initial load. I have observed I am getting 10 seconds of delay to get data into Kafka after committing change in Oracle database.
How can I optimize this delay? I tried changing linger milliseconds but no change in result.