We have experienced some heavy and resource consuming queries on Oracle databases, in a Zabbix installation with a very high amount of active triggers.
You can find some examples in attached files, together with a dump of the Zabbix server log in which it got disconnected from database because of no more available memory.
These kind of queries hang waiting for latch shared pool events.
Any suggestion? Thanks