I’m happy to announce that Orabbix has received another AWARD!!!
This time from FamousWhy.com:
Congratulations!
Your product “Orabbix (http://download.famouswhy.com/orabbix/)” has been granted the “Famous Software Award” byDownload.FamousWhy.com.
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:
- dbsize
- dbfilesize
inside oracle template on zabbix as numeric
Orabbix 1.0.4 is out
- Improved dynamic rebuild of databaselist
- Correct a critical bug in some case can Orabbix send wrong values now send always right values
- Correct template to easy import
more news are coming stay tuned!
you can download here Orabbix
Orabbix 1.0.3 is out
- one items dbsize that shows the size of database in MB
- one item for db files size that graphs the size of files in MB
- added more log information on error
- correct archivelog query to run on every databases
- added a default value for uptime when Oracle is not available
