Getting Data In

When using Splunk to retrieve data from an Oracle database, how do I reduce the returned results to only the last 30 days?

karthi2809
Builder

Splunk database input query from oracle database ?

I am using Oracle database to retrieve data to Splunk and the database is getting slow because of searching from given data. So i need to reduce only last 30 days data.

Query :

SELECT test.request_ts FROM test WHERE  test.Request_Ts > '2018-10-05 00:00:00.000'
{{AND test.$rising_column$ > ? }}

Thanks in advance

0 Karma

iamarkaprabha
Contributor

Hi karthi2809,

You can use DB Connect app and index the whole db data into splunk.
After you index the data, it will resolve the performance issue

karthi2809
Builder

I am using db connect app only.but database getting slow

0 Karma

iamarkaprabha
Contributor

Did you index the data ?
or are you using just dbx query

0 Karma

karthi2809
Builder

indexed the data.

0 Karma

karthi2809
Builder

I need to fetch last 30 days data to splunk.

0 Karma

iamarkaprabha
Contributor

Hi ,

You can do one thing. Put the timestamp of the particular column in your DB table into Splunk. Any try that one out. It will index the data using the same timestamp of your DB.

Have you tried this method ??

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...