I am trying to pull data from an Oracle DB that has very high volume of data, like hundreds of data per second. But the input is skipping some records intermittently.
I am pulling data using below configuration :
Query Timeout:120
Max Rows to Retrieve : 0
Fetch Size : 10000
Execution Frequency : */10 * * * *
I have tried using two inputs using two different rising column ( one of them is an Unique ID field, another is a time field), but both the inputs are skipping the same records. However, we are not finding any abnormalities with those records while checking from the DB.
Any idea what may be the cause of the issue or any suggestion on how to triage the issue?
Is there any pattern to the skipped records?
The databased receives hundreds of rows per second, yet the configuration reads 10,000 records every 10 minutes. In 10 minutes, the DB may have received more than 60,000 records. Expect to fall far behind quickly.