useful oracle checks

[Phil Costelloe]

Morris, Patrick wrote:
>>> I'm not sure how the tablespace check would work
>>> with auto-extending tablespaces if you use them.
>> 
>> I'm curous about that myself. Anybody know?
> 
> It doesn't work well. :)
> 
> Because auto-extending tables tend to live n the edge of their
> available space, this check will almost always report the table is
> nearly full, making it pretty useless as an alerting tool.  

I've just been looking at the Oracle check Perl scripts in the contrib
directory of the plugins distribution and it looks like check_oracle_tbs
does the Right Thing with regard to calculating free space.
check_oracle_instance.pl uses similar logic to the check_oracle shell
script and doesn't take into account the tablespace's extensibility;
check_ora_table_space.pl I'm not sure about, I couldn't decode the SQL
logic without a bit more investigation.

Of course all these require you to install the DBD and DBI::Oracle Perl
modules so it would still be nice to have a shell script that does the
right thing.

-- 
Phil Costelloe
Foundation IT, Hermitage Berkshire RG18 9SE 

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null