Oracle

The Oracle Database Integration provides real-time visibility into the performance of your Oracle database system. This integration is useful for monitoring database instances, CPU utilization, transactions, and other Oracle-specific metrics.

For more information on the Oracle Integration, navigate to the Oracle Demo Project Repository.

Prerequisites

1 Infra Agent

Infrastructure Agent (Infra Agent) v1.6.1+. To install the Infra Agent, see our Installation Guide

2 Elastic Superuser

Oracle Server v10.2+

Setup

Step 1: Grant Permissions

Assign permissions according to the database user:

Step 2: Access Integrations

Log in to Middleware, navigate to the Installations Page in the bottom left corner, select integrations and click Oracle:

Step 3: Enable Oracle Integration

Click on Add Host and fill out your Oracle configuration details:

Navigate to the Host Configuration to learn more about the below input fields.

Visualize Your Data

Default Oracle Dashboard

Quickly access your Oracle data with Middleware’s default Oracle Dashboard. Navigate to the Dashboard Builder and select the Oracle Dashboard:

Create Oracle Widget

Create your own widget from scratch. Navigate to the Dashboard Builder and select the dashboard you would like to create a widget in. Select Add New Widget and choose the Oracle data source.

Metrics Collected

MetricDescription
oracledb.cpu_timeCumulative CPU time (in seconds)
oracledb.enqueue_deadlocksTotal number of deadlocks between table or row locks in different sessions
oracledb.exchange_deadlocksNumber of times that a process detected a potential deadlock when exchanging two buffers
oracledb.executionsTotal number of calls (user and recursive) that executed SQL statements
oracledb.logical_readsNumber of logical reads
oracledb.hard_parsesNumber of hard parses
oracledb.parse_callsTotal number of parse calls
oracledb.pga_memorySession PGA (Program Global Area) memory
oracledb.physical_readsNumber of physical reads
oracledb.user_commitsNumber of user commits
oracledb.user_rollbacksNumber of times users manually issue a ROLLBACK statement or an error occurs during a user's transaction
oracledb.sessions.usageCount of active sessions
oracledb.processes.usageCurrent count of active processes
oracledb.processes.limitMaximum limit of active processes, -1 if unlimited
oracledb.sessions.limitMaximum limit of active sessions, -1 if unlimited
oracledb.enqueue_locks.usageCurrent count of active enqueue locks
oracledb.enqueue_locks.limitMaximum limit of active enqueue locks, -1 if unlimited
oracledb.dml_locks.usageCurrent count of active DML (Data Manipulation Language) locks
oracledb.dml_locks.limitMaximum limit of active DML (Data Manipulation Language) locks, -1 if unlimited
oracledb.enqueue_resources.usageCurrent count of active enqueue resources
oracledb.enqueue_resources.limitMaximum limit of active enqueue resources, -1 if unlimited
oracledb.transactions.usageCurrent count of active transactions
oracledb.transactions.limitMaximum limit of active transactions, -1 if unlimited
oracledb.tablespace_size.limitMaximum size of tablespace in bytes, -1 if unlimited
oracledb.tablespace_size.usageUsed tablespace in bytes
oracledb.db_block_getsNumber of times a current block was requested from the buffer cache (Disabled)
oracledb.consistent_getsNumber of times a consistent read was requested for a block from the buffer cache (Disabled)

Host Configuration

Input FieldDescription
endpointEndpoint used to connect to the Oracle server. Must be in the format of host:port
passwordPassword for the Oracle connection (special characters are allowed)
serviceOracle Service that the receiver connects to
usernameUsername for the Oracle connection

Next Steps

Need assistance or want to learn more about Middleware? Contact our support team in Slack.