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

Adjust query for Oracle Go plugin

XMLWordPrintable

    • Sprint 95 (Dec 2022), Sprint 96 (Jan 2023)
    • 1

      For the Oracle Agent2 plugin: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/src/go/plugins/oracle/handler_tablespaces.go

      Plugin is using this query 

      ROUND(DECODE(SUM(df.MAX_BYTES), 0, 0, (SUM(df.BYTES) / SUM(df.MAX_BYTES) * 100)), 2) AS USED_PCT_MAX,

      Should use this query

      ROUND(DECODE(SUM(df.MAX_BYTES), 0, 0, ((SUM(df.BYTES)-SUM(f.FREE)) / SUM(df.MAX_BYTES) * 100)), 2) AS USED_PCT_MAX,

            esneiders Eriks Sneiders
            nfrancys Francys Nivea (Inactive)
            Team INT
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: