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

Details

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

    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.

      Attachments

        Issue Links

          depends on

          Problem report - Problem report ZBX-7706 Slow queries when checking permissions

          • Major - Major loss of function.
          • Closed
          duplicates

          New Feature Request - A new feature request of the product, which has yet to be developed. ZBXNEXT-5878 Enhance permission checking/handling

          • Blocker - Blocks development and/or testing work, production could not run.
          • Confirmed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: