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"