Skip to content

oracledb

Module monitor oracledb performance and health metrics.

Requirements: - cx_Oracle package. - Oracle Client (using cx_Oracle requires Oracle Client libraries to be installed).

It produces following charts: - session activity - Session Count - Session Limit Usage - Logons - disk activity - Physical Disk Reads/Writes - Sorts On Disk - Full Table Scans - database and buffer activity - Database Wait Time Ratio - Shared Pool Free Memory - In-Memory Sorts Ratio - SQL Service Response Time - User Rollbacks - Enqueue Timeouts - cache - Cache Hit Ratio - Global Cache Blocks Events - activities - Activities - wait time - Wait Time - tablespace - Size - Usage - Usage In Percent

prerequisite

To use the Oracle module do the following:

  1. Install cx_Oracle package (link).

  2. Install Oracle Client libraries (link).

  3. Create a read-only netdata user with proper access to your Oracle Database Server.

Connect to your Oracle database with an administrative user and execute:

ALTER SESSION SET "_ORACLE_SCRIPT"=true;

CREATE USER netdata IDENTIFIED BY <PASSWORD>;

GRANT CONNECT TO netdata;
GRANT SELECT_CATALOG_ROLE TO netdata;

configuration

local:
  user: 'netdata'
  password: 'secret'
  server: 'localhost:1521'
  service: 'XE'

remote:
  user: 'netdata'
  password: 'secret'
  server: '10.0.0.1:1521'
  service: 'XE'

All parameters are required. Without them module will fail to start.