I am using JBoss Managed connection pooling for an application - this is done using oracle-ds.xml in the JBoss and configuring the datasource in applicationContext.xml . The connection is getting created properly and we are able to execute all the queries etc. But the problem is that multiple oracle process are getting created in the database server which is taking the memory usage to 98.5% or more than that.
e.g if 25 concurrent users are getting logged into the system then 25 oracle processes are getting created.
Any idea if this is an oracle connection configuration problem or an JBoss Connection pool problem.
Thanks a lot ...
subject: Multiple oracle processes getting created