Page 2 of 2

Re: Proactive Monitoring for Oracle database.

Posted: Mon Jun 24, 2013 8:06 am
by 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

Re: Proactive Monitoring for Oracle database.

Posted: Mon Jun 24, 2013 9:45 am
by 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

Re: Proactive Monitoring for Oracle database.

Posted: Sat Jul 13, 2013 9:17 am
by malexand
Hello,

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

thanks.
Mat

Re: Proactive Monitoring for Oracle database.

Posted: Mon Jul 15, 2013 10:36 am
by 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.