[ZBX-17302] ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT Created: 2020 Feb 11  Updated: 2022 Jun 15  Resolved: 2022 Jun 15

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 3.0.29, 4.0.17, 4.4.5
Fix Version/s: None

Type: Problem report Priority: Critical
Reporter: Edgar Akhmetshin Assignee: Alexei Vladishev
Resolution: Won't fix Votes: 2
Labels: Oracle
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: File 790_session_id.sql    
Issue Links:
Causes
Duplicate
duplicates ZBXNEXT-5878 Enhance permission checking/handling Closed
Sub-task
depends on ZBX-7706 Slow queries when checking permissions Closed

 Description   

Steps to reproduce:
Zabbix 4.4.0-4.4.5, 900 NVPS, 3500 hosts, 200 000 items, 100 000 triggers;
Oracle >=12 with 32Gb of RAM and 8Gb PGA size;
Use frontend/Triggers page (include/classes/api/services/CTrigger.php);

Result:
Ineffective query caused PGA overrun and SWAP usage.

SQL query attached.

 Comments   
Comment by Alexei Vladishev [ 2022 Jun 15 ]

I am closing it for now, feel free to reopen if the problem re-occurs.

Generated at Tue May 27 20:02:16 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.