Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-3518

Oracle DB, heavy queries

    XMLWordPrintable

    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

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

          Activity

            People

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

              Dates

              Created:
              Updated: