dcsimg
connection pooling
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   devang_parikh
Posted On:   Wednesday, August 13, 2003 05:38 AM

I am using oracle 9ias as an application server and oracle 8i as a database. Can anybody tell me how many maximum connections oracle 9ias can support and connections per datasource?

Re: connection pooling

Posted By:   Anonymous  
Posted On:   Wednesday, August 13, 2003 06:00 AM

Hi Devang,

I dont think that there is any 'maximum # of connections'. This number depends the performance that you need. After a certain number, as the no. of DB coonections increase, the performance of an application keeps degrading. So when we see that the response time for an application is more, we should think of reducing the no. of DB connections(optimization on the DB side).
About | Sitemap | Contact