Proactive Monitoring for Oracle database.

[malexand]

Thanks for reply. Yes, we would have to write a query/script to get the desired result. However, I am trying to figure out what can/cannot be done natively by Nagios. Here are the 15 KPIs ( Key performance indicators that we want monitored.) From the little research I've done, please confirm if the below "Y" are the only ones that Nagios can monitor natively out of the box?

KPIS Does Nagios Monitor
Current Logons Count Y
DB Block Changes Per Txn N
Database Time Per Sec N
Enqueue Requests Per Txn N
Executions Per Sec N
Logical Reads Per Txn Y
Network Traffic Volume Per Sec N
Physical Reads Per Sec Y
Physical Writes Per Sec N
Redo Generated Per Sec N
Response Time Per Txn N
SQL Service Response Time N
Total Parse Count Per Txn N
User Calls Per Sec N
User Transaction Per Sec N

[slansing]

Do you have a trial of nagios XI installed? The wizard's list all the "KPI's" that can be monitored by default:

Wizards -

Oracle Query

Oracle Serverspace

Oracle Tablespace

[malexand]

Hello,

Is Nagios an agentless install, or would a nagios agent need to be installed on the server for monitoring purposes.

thanks.
Mat

[slansing]

You can use many different protocols with Nagios XI, which is one of the great flexibilities. If you choose you could use several agentless methods. For example you could use SNMP Traps, NRDP, etc with a Linux server. You do not need to install Nagios Xi on servers you wish to monitor, that is where agents or agentless monitoring come into play.