Module: check_mk
Branch: master
Commit: d0d6b6e3c3d04bf37de61c1d67da8b59461cf156
URL:
http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=d0d6b6e3c3d04b…
Author: Lars Michelsen <lm(a)mathias-kettner.de>
Date: Tue Jan 31 16:32:48 2012 +0100
Changed file format to dos
---
agents/windows/plugins/mk_oracle.bat | 102 +++++++++++++++++-----------------
1 files changed, 51 insertions(+), 51 deletions(-)
diff --git a/agents/windows/plugins/mk_oracle.bat b/agents/windows/plugins/mk_oracle.bat
index 82b772d..8ce2262 100644
--- a/agents/windows/plugins/mk_oracle.bat
+++ b/agents/windows/plugins/mk_oracle.bat
@@ -1,51 +1,51 @@
-@echo off
-echo ^<^<^<oracle_sessions^>^>^>
-(echo.|set /p x=%ORACLE_SID%)
-(
-echo set cmdsep on
-echo set cmdsep '"'; --"
-echo "set pages 0"
-echo "set feedback off"
-echo "set head off"
-echo "select count(*) from v$session where status = 'ACTIVE';"
-) | sqlplus -S / as sysdba
-
-
-echo ^<^<^<oracle_logswitches^>^>^>
-(echo.|set /p x=%ORACLE_SID%)
-(
-echo set cmdsep on
-echo set cmdsep '"'; --"
-echo "set pages 0"
-echo "set feedback off"
-echo "set head off"
-echo "select count(*) from v$loghist where first_time > sysdate - 1/24;"
-) | sqlplus -S / as sysdba
-
-
-
-echo ^<^<^<oracle_tablespaces^>^>^>
-(
-echo set cmdsep on
-echo set cmdsep '"'; --"
-echo "set pages 0"
-echo "set linesize 900"
-echo "set tab off"
-echo "set feedback off"
-echo "set head off"
-echo "column instance format a10"
-echo "column file_name format a100"
-echo "select f.file_name, f.tablespace_name, f.status, f.AUTOEXTENSIBLE, f.blocks,
f.maxblocks, f.USER_BLOCKS, f.INCREMENT_BY, f.ONLINE_STATUS, t.BLOCK_SIZE, t.status,
decode(sum(fs.blocks), NULL, 0, sum(fs.blocks)) free_blocks from dba_data_files f,
dba_tablespaces t, dba_free_space fs where f.tablespace_name = t.tablespace_name and
f.file_id = fs.file_id(+) group by f.file_name, f.tablespace_name, f.status,
f.autoextensible, f.blocks, f.maxblocks, f.user_blocks, f.increment_by, f.online_status,
t.block_size, t.status UNION 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, 0 from dba_temp_files f, dba_tablespaces t where f.tablespace_name
= t.tablespace_name;"
-) | sqlplus -S / as sysdba
-
-echo ^<^<^<oracle_version^>^>^>
-REM (echo %ORACLE_SID%)
-(echo.|set /p x=%ORACLE_SID% )
-(
-echo set cmdsep on
-echo set cmdsep '"'; --"
-echo "set pages 0"
-echo "set feedback off"
-echo "set head off"
-echo "select * from v$version;"
-) | sqlplus -S / as sysdba
+@echo off
+echo ^<^<^<oracle_sessions^>^>^>
+(echo.|set /p x=%ORACLE_SID%)
+(
+echo set cmdsep on
+echo set cmdsep '"'; --"
+echo "set pages 0"
+echo "set feedback off"
+echo "set head off"
+echo "select count(*) from v$session where status = 'ACTIVE';"
+) | sqlplus -S / as sysdba
+
+
+echo ^<^<^<oracle_logswitches^>^>^>
+(echo.|set /p x=%ORACLE_SID%)
+(
+echo set cmdsep on
+echo set cmdsep '"'; --"
+echo "set pages 0"
+echo "set feedback off"
+echo "set head off"
+echo "select count(*) from v$loghist where first_time > sysdate - 1/24;"
+) | sqlplus -S / as sysdba
+
+
+
+echo ^<^<^<oracle_tablespaces^>^>^>
+(
+echo set cmdsep on
+echo set cmdsep '"'; --"
+echo "set pages 0"
+echo "set linesize 900"
+echo "set tab off"
+echo "set feedback off"
+echo "set head off"
+echo "column instance format a10"
+echo "column file_name format a100"
+echo "select f.file_name, f.tablespace_name, f.status, f.AUTOEXTENSIBLE, f.blocks,
f.maxblocks, f.USER_BLOCKS, f.INCREMENT_BY, f.ONLINE_STATUS, t.BLOCK_SIZE, t.status,
decode(sum(fs.blocks), NULL, 0, sum(fs.blocks)) free_blocks from dba_data_files f,
dba_tablespaces t, dba_free_space fs where f.tablespace_name = t.tablespace_name and
f.file_id = fs.file_id(+) group by f.file_name, f.tablespace_name, f.status,
f.autoextensible, f.blocks, f.maxblocks, f.user_blocks, f.increment_by, f.online_status,
t.block_size, t.status UNION 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, 0 from dba_temp_files f, dba_tablespaces t where f.tablespace_name
= t.tablespace_name;"
+) | sqlplus -S / as sysdba
+
+echo ^<^<^<oracle_version^>^>^>
+REM (echo %ORACLE_SID%)
+(echo.|set /p x=%ORACLE_SID% )
+(
+echo set cmdsep on
+echo set cmdsep '"'; --"
+echo "set pages 0"
+echo "set feedback off"
+echo "set head off"
+echo "select * from v$version;"
+) | sqlplus -S / as sysdba