Oracle DB, heavy queries

XMLWordPrintable

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

      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

        1. OTT_zabbix_server_20161027.log.gz
          945 kB
        2. query1.sql
          72 kB
        3. query2.sql
          74 kB

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

              Created:
              Updated: