I have been using several monitoring tools for production servers so far and I must admit, I am very satisfied with PRTG. I am still testing it though and we might buy it very soon.
More or less we are interested in Database and WMI Sensors. I have been trying to setup query on oracle database, but without luck so far. Basically, idea for query is to check if there are blocking locks on database with:
select * from v$lock or select * from v$lock where block > 0
Basically, what I did is that I several times produced blocking lock on my test database and used above queries on database SQL-Expression. Tried with all possible options (Process numerical result, Process string result...) But no luck :(
I always receive this alarm which does not satisfy my need. Could not perform query: Could not convert variant of type (Array Byte) into type (Double)
Even, when I produce lock I am able to manually connect to database and query/see blocking locks on database.
Is there any possible solution that you could suggest?