Max Sessions Exceeded / Sessions Not Dying

From: Ed_Zep <ed_zep_at_ntlworld.com>
Date: 20 Jun 2005 10:17:25 -0700
Message-ID: <1119287845.445244.27700@o13g2000cwo.googlegroups.com>

Hi DBAs,

we've got 3 x 9.0.4.1 Oracle Apps Servers connecting to an Oracle 9.2.0.4 database. Unfortunately, not enough time was set aside for stress-testing...

We now have a situation where the maximum processes was reached and then obviously we had to increase this and restart the db.

What is the best resolution for this? (yes, I know it should have been tested more). Would setting up Shared Server on another listener help?

What's worrying particularly is that processes that are inactive just sit there and are not killed off. Is that something that's best dealt with by the database or the apps servers and if so how?!

Many thanks for any help.

Ed. Received on Mon Jun 20 2005 - 12:17:25 CDT