Proactive Monitoring for Oracle database.

[malexand]

Hi,

Would Nagios be able to proactive monitor a select list of KPIs in an Oracle database? The KPIs I have are listed below:

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

[abrist]

Have you taken a look at: http://labs.consol.de/lang/en/nagios/ch ... le_health/
There are a number of metrics, though not everything you were looking for.

[malexand]

Thanks, I looked at the link. Although, I am curious to find out if it can be configured to respond to a delta in the 15 Kpis listed?
Thanks.
Mat

[abrist]

If you are looking for a delta, you will have to code a custom script that calls that plugin to get the single delta/metric for your purposes. Most of the oracle checks through this plugin are singular checks.

[malexand]

Can these be shell scripts, pl/sql? Or, is there a specific language that is used.

Thanks.
Mat

[sreinhardt]

They can be any language you wish to use that can communicate with oracle! You might want to take a look at our developer guidelines for how best to send responses, and data back to nagios.

[malexand]

Sounds good. Is there a free trail that we could download and test things out.

Also, what are the licensing fees involved?

Thanks.
Mat

[slansing]

Yes you may download Nagios XI 2012 as a free 60 day trial:

http://www.nagios.com/products/nagiosxi/try

For licensing information please email our sales department at:

[email protected]

let us know if you have any other questions!

[malexand]

If I could just go back to the 15 kpis that I had pasted earlier. Without having to do much coding/scripting.

Here is what i think Nagios monitors:

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

Please confirm that I have the above information correct, or please amend as necessary. I am just trying to figure out which of the above 15 Kpis can be monitored without any extra effort.

Thanks.
Mat

[sreinhardt]

Please confirm that I have the above information correct, or please amend as necessary. I am just trying to figure out which of the above 15 Kpis can be monitored without any extra effort.

If the check_oracle_health plugin or another does not do it natively, you likely can write a query with the standard oracle query wizard to get most if not all of this information. It will require some minor query creation or finding of the right plugin. Alternatively, we could create you a custom plugin if you contact [email protected], we would be happy to help.