Billy Angers

Nice work

This plugin is very good in the way that you don't need the Oracle client. I did change the script to suit my needs: split the checks, add perfdata and variable thresholds. $host = $ARGV[0]; $port = $ARGV[1]; $sid = $ARGV[2]; $user = $ARGV[3]; $pass = $ARGV[4]; $check = $ARGV[5]; $thresholdw = $ARGV[6]; $thresholdc = $ARGV[7]; $ENV{LD_LIBRARY_PATH} = "/etc/oracle"; $sqlplus = '/etc/oracle/sqlplus'; sub trim($); my %ERRORS=('OK'=>0,'WARNING'=>1,'CRITICAL'=>2,'UNKNOWN'=>3); my %checks = ( 'dictionary' => 0, 'library' => 1, 'blockbuffer' => 2, 'latch' => 3, 'disk' => 4, 'rollback' => 5, 'dispatcher' => 6, ); my @param_array = ( [">","Dictionary Cache Hit Ratio",'SELECT (1 - (Sum(getmisses)/(Sum(gets) + Sum(getmisses)))) * 100 FROM v$rowcache;'], [">","Library Cache Hit Ratio",'SELECT (1 -(Sum(reloads)/(Sum(pins) + Sum(reloads)))) * 100 FROM v$librarycache;'], [">","DB Block Buffer Cache Hit Ratio",'SELECT (1 - (phys.value / (db.value + cons.value))) * 100 FROM v$sysstat phys,v$sysstat db,v$sysstat cons WHERE phys.name = 'physical reads' AND db.name = 'db block gets' AND cons.name = 'consistent gets';'], [">","Latch Hit Ratio",'SELECT (1 - (Sum(misses) / Sum(gets))) * 100 FROM v$latch;'], [" "unless (".$results.$param_array[$checks{$check}][0].$thresholdw.") {print"".$param_array[$checks{$check}][1]." on ".$sid." is WARNING ($results !$param_array[$checks{$check}][0] $thresholdw)\n| $perfcounter"; exit ".$ERRORS{"WARNING"}.";}"; print "$param_array[$checks{$check}][1] on $sid is OK ($results $param_array[$checks{$check}][0] $thresholdw)|$perfcounter"; exit $ERRORS{"OK"}; } else {print "Bad check - values are: dictionary,library,blockbuffer,latch,disk,rollback,dispatchern "; exit $ERRORS{"UNKNOWN"};}

Reviewed 12 years ago