Execution times for queries and/or UserParameter

[Sven]

Hi all,

I have started a position in a customers site, and one of the things that they require is some way to monitor their Oracle databases.

They currently have an old product from CA, but it does the minimum for what they need. It can connect to all of the databases and instances, report on tablespace information, buffer caches, etc.

My job (ok... one of my jobs) is to look at options of replacing this. My obvious choice is Zabbix. I've been using it since v1.8 and I have installed it at many clients, but this is the first time I have needed to perform metric analysis on Oracle.

I know that queries from Zabbix timeout at 30 seconds, but I need to report on how long they actually take... as well as the results from them This helps to show just how busy the database is.

I'll be doing autodiscovery for the tablespace information, that's easy enough, but the query execution time is stumping me.

Any suggestions?

Cheers,
Sven

[dimir]

Interesting use case. Unfortunately there's no such functionality in Zabbix at the moment. You are welcome to create a feature request. For now, I can only think of using some formatted result (e. g. JSON) from the "master item" in which you have both the value and the execution time (that you will calculate yourself), that will be fetched by dependent items.

[Sven]

Thanks, Dimir! Feature request made: https://support.zabbix.com/browse/ZBXNEXT-5617

Extra meta data sent back from the agents to be stored in the database in an extra column would be ideal!!

Yes, the json route seem like it's the only feasible way at the moment. I'm thinking:

* Agent installed on the oracle database appliance
* UserParameter kicks off a script
* Script formats data into json, 1st item being execution time, 2nd (3rd, 4th, etc) as the next data....

... Not sure how I'm going to structure it yet. ... not sure what I can do regarding timeouts and scripts producing errors yet.

Any thoughts?