ORA-00020: maximum number of processes (500) exceeded" Java Connection Pooling
Posted on 2013-05-28
I have java web based application running against 11gr2 RHEL 5.5 and uses connection pooling to connect to DB.I want to understand how exactly the mapping is with connections to sessions.
500 is the value for processes parameter which would also include background processes(bg) along with app processes or user processes,Does this mean db could spwan 400 + sessions for the app or user process(excluding the bg process)?
In web based application there would be thousands of users connecting to the db then how would just 500 processes would sufficent?
I ran out of processes in Production db so wanted to understand the reason for it and got the error ORA-00020: maximum number of processes (500) exceeded"
Please help me understand how the connection pool works.