OracleDB collector
Monitors the performance and health metrics of the Oracle database.
Requirements
oracledb
package.
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:
Install
oracledb
package (link).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:
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
Do you have any feedback for this page? If so, you can open a new issue on our netdata/learn repository.