Orabbix 1.0.4 two missing items

Time ago I’ve added two Items:

• DBFileSize
• DBSize

Those two items are calculated with those following query

DBSize

SELECT sum(  NVL(a.bytes/1024/1024/10 – NVL(f.bytes/1024/1024/10, 0), 0)) retvalue
FROM sys.dba_tablespaces d,
(SELECT  tablespace_name, sum(bytes) bytes
FROM  dba_data_files
GROUP BY tablespace_name) a,
(SELECT  tablespace_name, sum(bytes) bytes
FROM  dba_free_space
GROUP BY tablespace_name) f
WHERE d.tablespace_name = a.tablespace_name(+)
AND d.tablespace_name = f.tablespace_name(+)
AND NOT (d.extent_management like ‘LOCAL’ AND d.contents like ‘TEMPORARY’);

and DBFileSize

select sum(bytes/1024/1024/10) retvalue
FROM dba_data_files;

There is a lack on export of items on template of mine so you can download now the 1.0.4 release of Orabbix
or add those two Items:

1. dbsize
2. dbfilesize

inside oracle template on zabbix as numeric

Tags: linkedin, orabbix, oracle