Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Max. Connection & Connection Time out parameters

Max. Connection & Connection Time out parameters

From: saurangshu <saurangshu_at_gmail.com>
Date: 9 Feb 2006 12:19:44 -0800
Message-ID: <1139516384.408296.247780@g14g2000cwa.googlegroups.com>


Hi,

This is a basic question regarding the connections while building a connection pool on oracle 8.1.7 database on solaris 8.

  1. Is there any parameter in oracle (init.ora or some where else) which dictates the maximum no. of connections that ever can be opened from a database so that the java based connection pool can impose a limit on it's maximum pooled connection? If yes, then what is the parameter and how it can be tuned?
  2. How to determine a connection time out property so that the java based connection pool manager can close the coonection before this time period.

Thanks in advance for your time and patience.

Regards,

Received on Thu Feb 09 2006 - 14:19:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US