Do you want to monitor OracleDB in Netdata? Our Support Engineers are here to teach you the tricks of the trade.

Monitoring the health metrics and performance of the Oracle database is no longer a concern with the Support Team at Bobcares by your side. Read on how to tackle this easy task.

Monitoring OracleDB with Netdata

The ex-Oracle package and the Oracle Client offers you access to the following charts:

• disk activity
  • Sorts on disk
  • Physical disk reads/writes
  • Full table scans
• session activity
  • Logons
  • Session limit usage
  • Session count
• cache
  • Global cache blocks events
  • Cache hit ratio
• database and buffer activity
  • Shared pool free memory
  • Database wait time ratio
  • User rollback
  • SQL service response time
  • Enqueue timeouts
  • In-memory sorts ratio
• tablespace
  • Usage
  • Size
  • Usage in Percent

In order to use the Oracle module, you need to :

1. First, install the ox-Oracle package from https://cx-oracle.readthedocs.io/en/latest/installation.html#install-cx-oracle.
2. Then, install Oracle Client libraries from https://cx-oracle.readthedocs.io/en/latest/installation.html#install-oracle-client.
3. After that, create a netdata user that is read-only. Moreover, it should have proper access to the Oracle Database Server.

Then, connect to the Oracle database via administrative user and execute:

ALTER SESSION SET "_ORACLE_SCRIPT"=true; CREATE USER netdata IDENTIFIED BY ; GRANT CONNECT TO netdata; GRANT SELECT_CATALOG_ROLE TO netdata;

Remember to edit the configuration as seen below:

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

Furthermore, without these parameters, the module will not start successfully.

[Need a hand? We are here at your service.]

Conclusion

In brief, we saw how to monitor OracleDB with Netdata. Moreover, the Support Team at Bobcares has several more tricks up their sleeves that make Server Management smoother.