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

Template "Oracle by ODBC" - wrong SQL

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • None
    • None
    • 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"

       

       

            zabbix.support Zabbix Support Team
            ceinmart Cesar Inacio Martins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: