orabbix无法获取oracle db size和db files size的解决方法,这几天在研究orabbix时发现在zabbix中无法获取db size和db files size
orabbix无法获取oracle db size和db files size的解决方法
这几天在研究orabbix时发现在zabbix中无法获取db size和db files size的大小，，后来发现问题出在/opt/orabbix/conf/query.props文件的配置上：
因为最新的orabbix 1.2.3版本在解压安装后，默认的query.props文件内没有配置这两个选项的检测，所以需要手动加上，分别在此文件中两个地方加入配置，具体如下：
1. 在“querylist=”的最后加上“,dbfilesize,dbsize”，注意要用逗号格开；
2. 另外加上,dbfilesize,dbsize的检测语句，如下：
dbfilesize.query=select to_char(sum(bytes/1024/1024/10), 'fm99999999999999990') retvalue from dba_data_files
dbsize.query=select to_char(sum(  nvl(a.bytes/1024/1024/10 - nvl(f.bytes/1024/1024/10, 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')
休改后结果如下：
querylist=archive,audit,dbblockgets,dbconsistentgets,dbhitratio,dbphysicalread,dbversion,hitratio_body,hitratio_sqlarea,hitratio_table_proc, \
lio_current_read,locks,maxprocs,maxsession,miss_latch,pga_aggregate_target, pga,phio_datafile_reads,phio_datafile_writes,phio_redo_writes,pinhitratio_body,pinhitratio_sqlarea,pinhitratio_table-proc,pinhitratio_trigger, \pool_dict_cache,pool_free_mem,pool_lib_cache,pool_misc,pool_sql_area,procnum,session_active,session_inactive,session,session_system,sga_buffer_cache, \ sga_fixed,sga_java_pool,sga_large_pool,sga_log_buffer,sga_shared_pool,tbl_space,userconn,waits_controfileio,waits_directpath_read, \ waits_file_io,waits_latch,waits_logwrite,waits_multiblock_read,waits_singleblock_read,hitratio_trigger,lio_block_changes,lio_consistent_read,waits_other,
waits_sqlnet,users_locked,uptime,dbfilesize,dbsize
dataguardprimaryquerylist=dg_error,dg_sequence_number
dataguardstandbyquerylist=dg_sequence_number_stby
rmanquerylist=rman_check_status
dbfilesize.query=select to_char(sum(bytes/1024/1024/10), 'fm99999999999999990') retvalue from dba_data_files
dbsize.query=select to_char(sum(  nvl(a.bytes/1024/1024/10 - nvl(f.bytes/1024/1024/10, 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')
更多oracle相关信息见oracle 专题页面 ?tid=12