[checkmk-commits] Check_MK Git: check_mk: FIX: mk_oracle: Fixed computation for TEMP table spaces

Module: check_mk Branch: master Commit: 181088f89b726cdb57c0c0b3eb9674d86e42f4c1 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=181088f89b726c… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Fri Apr 8 10:47:01 2011 +0200 FIX: mk_oracle: Fixed computation for TEMP table spaces --- ChangeLog | 1 + agents/plugins/mk_oracle | 2 +- 2 files changed, 2 insertions(+), 1 deletions(-) diff --git a/ChangeLog b/ChangeLog index 69fff94..6bd976f 100644 --- a/ChangeLog +++ b/ChangeLog @@ -35,6 +35,7 @@ * FIX: ucd_cpu_util: fix check in case of missing hi, si and st * FIX: mk_logwatch: improve implementation in order to save RAM * FIX: mk_oracle: Updated tablespace query to use 'used blocks' instead of 'user blocks' + * FIX: mk_oracle: Fixed computation for TEMP table spaces * FIX: bluecoat_sensors: Using scale parameter provided by the host for reported values * FIX: fjdarye60_devencs, fjdarye60_disks.summary: added snmp scan functions * FIX: decru_*: added snmp scan functions diff --git a/agents/plugins/mk_oracle b/agents/plugins/mk_oracle index e66dc53..18e7bcf 100644 --- a/agents/plugins/mk_oracle +++ b/agents/plugins/mk_oracle @@ -70,7 +70,7 @@ select f.file_name, f.tablespace_name, f.status, f.AUTOEXTENSIBLE, f.blocks, f.m from dba_data_files f, dba_tablespaces t ,(SELECT file_id, SUM(blocks) free_blocks FROM dba_free_space b GROUP BY file_id) b where f.tablespace_name = t.tablespace_name and f.file_id=b.file_id UNION -select f.file_name, f.tablespace_name, f.status, f.AUTOEXTENSIBLE, f.blocks, f.maxblocks, f.blocks - b.blocks_used as used_blocks, f.INCREMENT_BY, 'TEMP', t.BLOCK_SIZE, t.status +select f.file_name, f.tablespace_name, f.status, f.AUTOEXTENSIBLE, f.blocks, f.maxblocks, b.blocks_used as used_blocks, f.INCREMENT_BY, 'TEMP', t.BLOCK_SIZE, t.status from dba_temp_files f, dba_tablespaces t ,V\$TEMP_SPACE_HEADER b where f.tablespace_name = t.tablespace_name and f.file_id=b.file_id ; EOF