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 -> Re: Max. Connection & Connection Time out parameters

Re: Max. Connection & Connection Time out parameters

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 09 Feb 2006 22:13:38 +0100
Message-ID: <0ubnu1tu7a6eirjiqbvj6t2gknmvo2ba05@4ax.com>


On 9 Feb 2006 12:19:44 -0800, "saurangshu" <saurangshu_at_gmail.com> wrote:

>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,
>
>-- SP

1 the processes parameter in init<sid>.ora. Can be tuned by editing init<sid>.ora and bouncing the database. Remember semmns must reflect the number of processes or you will run into ora-12500

2 not do it. If the java connection pool closes the connection, the session will be left dangling at the oracle side, and the oracle resources will eventually get exhausted. Many DBAs are on a constant battle to close connections that have been left dangling by java connection pools.
Oracle has, when running Multithreaded Server, it's own connection pooling mechanism. Strangely enough no one uses it.  

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Feb 09 2006 - 15:13:38 CST

Original text of this message

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