Oracle connector stuck and not emitting changes

The Oracle connector was retrofitted with a lastProcessedScn variable as a part of DBZ-4067 to fix a known issue with mining boundaries; however, its come to our attention that there are scenarios where this variable can cause a stall in mining.

In the event that the connector mines from B to C and this range returns no results likely due to the results being filtered out and the prior A to B did return at least one result, then the mining range will restart from B continually, giving the illusion of a stall.

We need to adjust the endScn to be equal to the lastProcessedScn only if the current mining loop returned no results and perhaps if the endScn is not within the maximum batch size window of the current SCN?