netdata/collectors/python.d.plugin/oracledb

OracleDB collector

Monitors the performance and health metrics of the Oracle database.

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
• allocated space
  • 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

Edit the python.d/oracledb.conf configuration file using edit-config from the Netdata config directory, which is typically at /etc/netdata.

cd /etc/netdata   # Replace this path with your Netdata config directory, if different
sudo ./edit-config python.d/oracledb.conf

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.

Troubleshooting

To troubleshoot issues with the oracledb module, run the python.d.plugin with the debug option enabled. The output will give you the output of the data collection job or error messages on why the collector isn't working.

First, navigate to your plugins directory, usually they are located under /usr/libexec/netdata/plugins.d/. If that's not the case on your system, open netdata.conf and look for the setting plugins directory. Once you're in the plugin's directory, switch to the netdata user.

cd /usr/libexec/netdata/plugins.d/
sudo su -s /bin/bash netdata

Now you can manually run the oracledb module in debug mode:

./python.d.plugin oracledb debug trace