Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check if database reached max connections

720396Oct 14 2009 — edited Oct 14 2009
Hi:

I am on 10-.2.0.3; HP-UX B.11.23 Itanium.

One of my databases sometimes reaches the max connections (500) which is caused by an application issue. While working with the apps vendor, I'd like to catch this event in a monitoring script & recycle the database from this script (for now I recycle it manually).

It's easy to recycle - any suggestions on how to check this "max connection reached" thing? No new connections should be allowed...Anyway if anyone has done it already, I'll appreciate sharing the script.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2009
Added on Oct 14 2009
#general-database-discussions
7 comments
4,580 views