Learning About Splunk and Its Real-Time Capabilities for Oracle Applications

For organizations finding that monitoring Oracle Applications/EBS Systems is taking up too many cycles, or that are tired of getting caught off guard with what could have been preventable system outages, a recent DBTA webcast showcased two ways that Splunk can be used to mine KPI data.

“It’s more of a framework than a specific product,” said John Kennan, senior Oracle EBS DBA, Datavail, during a recent DBTA webinar. “It has a lot of tools in it that will help you easily build reports on your performance metrics.”

Splunk offers a real-time big data collection and reporting framework complete with its own search processing languages and ready to use point-and-click reporting tools. According to Kennan, this makes Splunk a beneficial tool for Oracle Applications DBAs and managers to have in their shops.

Splunk is a cross-platform performance monitoring tool that can forward log data from multiple sources to a central index. It can execute commands to pull and forward live performance data from multiple applications to central index, provide cross web based reporting, analysis and alerting tools, along with being trained to recognize key metrics and provide quick and easy ad hoc mining tools.

“This is the first go-to tool to see if there’s a problem of multiple tiers on multiple servers,” said Kennan. “I like to call it a ‘Swiss Army chainsaw,’ you can throw pretty much anything at it and it will try it’s best to process it as best as it can.”

The platform also has powerful data classification tools as well, Kennan explained.  “Once your data comes in you can make data models which power interactive pivot tables,” Kennan said. “Once your data is in you can classify it and make it available to users who may not be technical.”

To view a replay of this webinar, go here.