All Apps and Add-ons

How to triage why DBConnect is skipping records from Oracle DB

goonie
Explorer

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? 

 
 

 

Labels (3)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

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.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Thanks for the Memories! Splunk University, .conf24, and Community Connections

Thank you to everyone in the Splunk Community who joined us for .conf24 – starting with Splunk University and ...

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...