Hello
I use Zabbix server 3.0
I have several oracle databases on separate hosts. If one of them is hanging (or have small performance), my items whith "database monitoring" type hanging too.
And I cannot recieve data from agent for this database and all another databases than does not have any problem, because I have a huge queue on monitoring database. In other words, I have problem with one database, but triggers fire for all databases on server
I have tried use Oracle Profile for zabbix user to limit connection and execution time, but it does not help for me.
How can I separate threads for different databases or set up time limit for execution query on database ?
I use Zabbix server 3.0
I have several oracle databases on separate hosts. If one of them is hanging (or have small performance), my items whith "database monitoring" type hanging too.
And I cannot recieve data from agent for this database and all another databases than does not have any problem, because I have a huge queue on monitoring database. In other words, I have problem with one database, but triggers fire for all databases on server
I have tried use Oracle Profile for zabbix user to limit connection and execution time, but it does not help for me.
How can I separate threads for different databases or set up time limit for execution query on database ?