We are able to integrate SQL DB and Oracle DB through ODBC, but we are facing some issue in log collecion from Oracle DB. The Oracle DB which we have configured has huge quantity of logs getting generated every minute. After integration, we are successfully collecting logs but the issue is in the count of logs that we are receiving. Lets say for 10 minute, 10000 logs got generated on the server but we received approx 200. We have verified with the DB team and there is no count threshold value applied to the user account used to pull data. We are not facing any such issue in SQL DB.
SA version used is 10.6.1
Need some suggestions to find the issue.