Hello,
I have a problem with zabbix 3.2 avec a database monitor.
My Query SQL is:
select round(b.bytes_free) "free B"
from ( select f.tablespace_name,
sum(f.bytes) bytes_alloc,
sum(decode(f.autoextensible, 'YES',f.maxbytes,'NO',
f.bytes)) maxbytes
from dba_data_files f
group by tablespace_name) a,
( select f.tablespace_name,
sum(f.bytes) bytes_free
from dba_free_space f
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name and a.tablespace_name='CAT_DATA'
information
Numeric (unsigned)
Decimal
B
Now since the upgrade to zabbix 3.2 i have the following error (see attachment file)
Do you have an idea ?
Thanks in advance
I have a problem with zabbix 3.2 avec a database monitor.
My Query SQL is:
select round(b.bytes_free) "free B"
from ( select f.tablespace_name,
sum(f.bytes) bytes_alloc,
sum(decode(f.autoextensible, 'YES',f.maxbytes,'NO',
f.bytes)) maxbytes
from dba_data_files f
group by tablespace_name) a,
( select f.tablespace_name,
sum(f.bytes) bytes_free
from dba_free_space f
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name and a.tablespace_name='CAT_DATA'
information
Numeric (unsigned)
Decimal
B
Now since the upgrade to zabbix 3.2 i have the following error (see attachment file)
Do you have an idea ?
Thanks in advance
Comment