Time ago I’ve added two Items:

  • DBFileSize
  • DBSize

Those two items are calculated with those following query


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: , ,

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this. To know all the policy detais click here.