Need more documentation

i need to check the sessions used in a oracle DB and alert if it exceeds. i have compiled your plugin successfully.

what i want i am listing below can you tell me how i cud do the follow: with your plugin if possible

My Oracle DB server details

operating System: Solaris
database: oracle
IP: 192.168.1.2 (not real ip)

My Nagios Server details
OS : Ubuntu
i have configured nagios 3.x

i connect to my db server from my nagios as follow:

ssh -Y [email protected]
Password: xxxxxxxxx
[root@vboxdb /]# su – oracle

Sun Microsystems Inc. SunOS 5.10 Generic January 2005
[oracle@vboxdb ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 30 04:53:48 2012

Connected to:
Oracle Database 11g Release 11.2.0.1.0 – 64bit Production

what i want to do i will list below ;

SQL> select current_utilization, max_utilization, limit_value from v$resource_limit where resource_name =’sessions’;

CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
——————- ————— ————————- —————

386 404 1528

if the current utilization reaches 1500 alert critical, 1450 warning state. else normal.
can you tell me how i can use your plugin to do this.