Orabbix:"Another way to monitor Oracle reloaded"

[Keitamax]

mmm right... on 9i don't work this kind of query...
I don't have any more Oracle 9i here to make some test but i think that you can change your query so:

dbversion.Query=select * from v$version where banner like 'Oracle%'
dbversion.Period=720

I know that is "restrictive" but this should work right

OK, works fine now! All eventwait statistics actually work, my mistake sorry.
For DB Size and DB Files Size, I found that they were actually not in query.props.
Thank you!

[dalle]

OK, works fine now! All eventwait statistics actually work, my mistake sorry.
For DB Size and DB Files Size, I found that they were actually not in query.props.
Thank you!

DBSize and DB Fil Size are missing on distribution?
I'm going to check sorry

[Keitamax]

I added some items that could be useful (sga_java_pool_free,sga_java_pool_busy,sga_large_p ool_free,sga_large_pool_busy,sga_shared_pool_free, sga_shared_pool_busy)
feel free to have a look if you wish

[dalle]

you are right for dbsize and dbfilesize you should add on query.props


dbfilesize.Query=select to_char(sum(bytes/1024/1024), 'FM99999999999999990') retvalue from dba_data_files

dbsize.Query=SELECT to_char(sum( NVL(a.bytes/1024/1024 - NVL(f.bytes/1024/1024, 0), 0)), 'FM99999999999999990') 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')

[dalle]

I added some items that could be useful (sga_java_pool_free,sga_java_pool_busy,sga_large_p ool_free,sga_large_pool_busy,sga_shared_pool_free, sga_shared_pool_busy)
feel free to have a look if you wish

cool you have exactly understood how it work!
and thanks for queryes