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.

analytics