From 94a3cf91b3548388a9b278273ac596203a4a9e75 Mon Sep 17 00:00:00 2001 From: Ton Voon Date: Thu, 26 Oct 2006 21:10:20 +0000 Subject: Fixed error if dba_free_space has no free segments (Florian Gleixner) git-svn-id: https://nagiosplug.svn.sourceforge.net/svnroot/nagiosplug/nagiosplug/trunk@1529 f882894a-f735-0410-b71e-b25c423dba1c --- plugins-scripts/check_oracle.sh | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'plugins-scripts/check_oracle.sh') diff --git a/plugins-scripts/check_oracle.sh b/plugins-scripts/check_oracle.sh index 99564917..02ca1114 100755 --- a/plugins-scripts/check_oracle.sh +++ b/plugins-scripts/check_oracle.sh @@ -244,13 +244,14 @@ EOF` result=`sqlplus -s ${3}/${4}@${2} << EOF set pagesize 0 set numf '9999999.99' -select b.free,a.total,100 - trunc(b.free/a.total * 1000) / 10 prc +select NVL(b.free,0.0),a.total,100 - trunc(NVL(b.free,0.0)/a.total * 1000) / 10 prc from ( select tablespace_name,sum(bytes)/1024/1024 total -from dba_data_files group by tablespace_name) A, +from dba_data_files group by tablespace_name) A +LEFT OUTER JOIN ( select tablespace_name,sum(bytes)/1024/1024 free from dba_free_space group by tablespace_name) B -where a.tablespace_name=b.tablespace_name and a.tablespace_name='${5}'; +ON a.tablespace_name=b.tablespace_name WHERE a.tablespace_name='${5}'; EOF` if [ -n "`echo $result | grep ORA-`" ] ; then -- cgit v1.2.3