Details

    • Type: Change Request
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.2.1
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              dimitri.bellini Dimitri Bellini
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: