[#ZBXNEXT-3518] Oracle DB, heavy queries

[ZBXNEXT-3518] Oracle DB, heavy queries Created: 2016 Oct 28 Updated: 2017 May 31
Status:	Open
Project:	ZABBIX FEATURE REQUESTS
Component/s:	Server (S)
Affects Version/s:	3.2.1
Fix Version/s:	None

Type:

Change Request

Priority:

Major

Reporter:

Dimitri Bellini

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

database, oracle

Remaining Estimate:

Not Specified

Time Spent:

Not Specified

Original Estimate:

Not Specified

Environment:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

Attachments:

OTT_zabbix_server_20161027.log.gz

query1.sql

query2.sql

Description

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

Generated at Fri Apr 26 14:56:13 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.

[ZBXNEXT-3518] Oracle DB, heavy queries Created: 2016 Oct 28 Updated: 2017 May 31