Template "Oracle by ODBC" - wrong SQL

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Trivial
    • None
    • Affects Version/s: None
    • Component/s: None
    • Environment:
      any version of oracle

      The template "Oracle by ODBC" have a wrong SQL on the item:

      • uuid: 3839683749974cdeafd9178bdccb38d6
                  name: 'Oracle: Get system metrics

      The select below is wrong:

           SELECT 'REDO::Available', count(*) from v$log t where t.status in ('INACTIVE', 'UNUSED')

      Line 113 on current version of git: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/oracle_odbc/template_db_oracle_odbc.yaml

      That is wrong because the item should colect the # of available REDO and this select get the # of Unvailable REDOs..

      Should be modify the "in" to "not in"

       

       

            Assignee:
            Zabbix Support Team
            Reporter:
            Cesar Inacio Martins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: