Build precise queries to find exactly what you need
Press ESC to close
@cipher
Favorites0
Views
Projects0
hi, i have installed your yaonp-collector.pl in my oracle db machine. to test i have executed your script. #perl yaonp-collector.pl dictcachmisses|9.7|||Dict Cache Miss Ratio=%| libcachmisses|5.7|||Lib Cache Miss Ratio=%| dbblckbufmisses|2.6|||Block Buffer Cache Miss=%| redoentryretr|0|||redo buff alloc entries/retries=%| latchmisses|0|||Latch Miss=%| disksorts|0|||Disk Sort=%| rollbckwa|0|||Rollback Segment Waits=%| dispworkl|0|||Dispatcher Workload=%| numsessions|23|||Count Sessions=| numlckedobj|0|||Number of locked objects=| numlckblcklck|0|||Number of locks blocking other locks=| numblcksess|0|||Number of sessions blocked by other sessions=| tbspcuse|5|SYSAUX||Tablespace Usage=%| tbspcuse|59|SYSTEM||Tablespace Usage=%| tbspcuse|0|TEMP||Tablespace Usage=%| tbspcuse|0|UNDOTBS1||Tablespace Usage=%| tbspcuse|0|USERS||Tablespace Usage=%| those are the results but i want to modify your one to do the following; select current_utilization from v$resource_limit where resource_name ='sessions'; this would give a numeric number and i want to alert based on the number retrieved. i have tried to modify your plugin SQL's but yet no luck ,,,,, can you give me an idea. anyideas owner of the plugin?
Reviewed 13 years ago
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 Copyright (c) 1982, 2009, Oracle. All rights reserved. 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.