[Nagiosplug-devel] new oracle plugins
Dietmar Ruzicka
druzicka at cube1.cubit.at
Sat Feb 1 14:38:33 CET 2003
Hi all,
I did an nagios project. Therefore it was necessary to implement some new
oracle plugins. I wrote them by using perl DBI.
check_oracle_sql:
connects to an instance executes "select user from dual" to check if an
instance is up and running.
check_oracle_tablespace_status:
checks if a tablesspace is online by using DBA_TABLESPACES
check_oracle_tablespace:
checks the usage off a tablespace by using SM$TS_AVAIL SM$TS_FREE
SM$TS_USED
check_oracle_cache_hit_ratio:
calculates the cache hit ratio by using V_$SYSSTAT
(see Oracle8i Designing and Tuning for Performance, 19 Tuning Memory
Allocation)
The plugins should meet the Nagios plug-in development guidelines. You can
add them if you want to.
best regards
Dietmar
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oracle_plugins.tgz
Type: application/x-gtar
Size: 2684 bytes
Desc:
URL: <http://nagios-plugins.org/archive/devel/attachments/20030201/7dddbb90/attachment.gtar>
More information about the Devel
mailing list