I want to query data within a specific rowid range through JDBC, but found that the returned dataset contains more records than the actual count, with duplicated entries.
Additionally, I noticed that when adjusting the fetchSize, smaller values result in more duplicate data, while larger fetchSize reduces duplication.
So far, I've tested this on versions 12C and 19C.
Some databases with the same version don't exhibit similar issues, so I'm unsure whether it relates to certain configuration parameters in Oracle.
I'd like to ask if anyone has encountered similar problems? What could be the cause? And how can it be resolved?