If you are dealing with "Maximum open cursors exceeded." errors in your Oracle database, you must check how many cursors are open. To see how many open cursors you have, use the following query:

select * from v$sysstat where name = 'opened cursors current';

If this is higher than your predefined limit, then you need to change your initSID.ora file.
Increase the max_open_cursors value and then shutdown and restart your database.

Open cursor count is increasing continuously uncontrollable ?

Applications must close the cursors after its job done. Do not leave cursors open.

How to be notified when open cursor count reaches dangereous levels ?

If you want to be notified when open cursor count reaches dangereous levels, you can use netAlarm.
NetAlarm can check open cursors periodically for you. If it's count is greater than your predefined threshold, it can notify you without losing any time.

If you want to see additional monitoring features implemented in NetAlarm, we would please to hear.
Please Click here