Yaonp seems fine, but can do better if i can

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?