Log File Analysis for Oracle 11g

Overview

Details

This add on is a basic step-by-step “how to” for Oracle DB monitoring using a variety of data inputs including various log files, the audit trail, trigger-based TCP inputs, shell scripts, and Splunk DB Connect. Common lookup tables, field extractions, reports, and dashboards are also examined. All methods are demonstrated using a virtual server environment based on Oracle VM VirtualBox that can be easily duplicated by the reader. The abstract of the paper is available on the Documentation tab.

The core of virtually every application that manipulates data is the database. It is vitally important, in both production and development environments, to understand at all times what the database is doing and why. There are a variety of commercial database monitoring solutions available in the market today; most rely on SQL monitoring and monitoring of the Oracle Alert Log. Few provide customizable search capabilities or allow easy correlation of events recorded in different files, within the database, from script output, from TCP feeds, or allow a DBA to correlate database events with events from other applications in the technology stack. In this paper I will describe a robust monitoring architecture that allows in-depth, real-time log file analysis and reporting of an individual Oracle database for virtually no cost.

Download the rest of "Real Time Oracle 11g Log File Analysis"

2,248

Downloads

Share Subscribe

Built by

Pete Magee

Support

Not Supported

Questions on Splunk Answers Flag as inappropriate

Category & Contents

Categories: IT Operations

App Type: Add-on

Subscribe Share

My Account

Support & Services