Re: Proactive Monitoring for Oracle database.
Posted: Mon Jun 24, 2013 8:06 am
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
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