Module: check_mk
Branch: master
Commit: 81b0aa1837e4dce869561a6b8055c22e5c52d09b
URL:
http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=81b0aa1837e4dc…
Author: Lars Michelsen <lm(a)mathias-kettner.de>
Date: Mon Feb 20 08:30:13 2012 +0100
Added missing table to linux oracle agent
---
agents/plugins/mk_oracle | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/agents/plugins/mk_oracle b/agents/plugins/mk_oracle
index 3f5ecb3..77b01ba 100755
--- a/agents/plugins/mk_oracle
+++ b/agents/plugins/mk_oracle
@@ -133,7 +133,7 @@ for SID in $SIDS; do
select f.file_name, f.tablespace_name, f.status, f.AUTOEXTENSIBLE,
f.blocks, f.maxblocks, f.USER_BLOCKS, f.INCREMENT_BY, 'TEMP',
t.BLOCK_SIZE, t.status, sum(sh.blocks_free) free_blocks
- from dba_temp_files f, dba_tablespaces t, v$temp_space_header sh
+ from v\$thread th, dba_temp_files f, dba_tablespaces t,
v\$temp_space_header sh
WHERE f.tablespace_name = t.tablespace_name and f.file_id = sh.file_id
GROUP BY th.instance, f.file_name, f.tablespace_name, f.status,
f.autoextensible, f.blocks, f.maxblocks, f.user_blocks, f.increment_by,