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

Adjust query for Oracle Go plugin

    XMLWordPrintable

Details

    • Team A
    • Sprint 95 (Dec 2022)
    • 1

    Description

      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, 

      Attachments

        Activity

          People

            vso Vladislavs Sokurenko
            nfrancys Francys Nivea
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: