Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-17302

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Critical Critical
    • None
    • 3.0.29, 4.0.17, 4.4.5
    • Frontend (F)

      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.

        1. 790_session_id.sql
          547 kB
          Edgar Akhmetshin

            alexei Alexei Vladishev
            edgar.akhmetshin Edgar Akhmetshin
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: