Re:Testing connection pooling feature

From: <Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com>
Date: Thu, 2 Nov 2000 12:56:21 -0500
Message-Id: <10668.120992@fatcity.com>

Most likely this developer creates a pool of connections to Oracle in his application and gives them out to processes as they need them. Once the process is done using Oracle connection it returns the connection to the pool.

This is basically how any application driven connection pooling works (actually this is part of JDBC 2.0 and is available as of Oracle JDBC 8.1.6 drivers).

MTS is a way to manage large number of connection on the Oracle side.

Both models can be used.

As a DBA you can not control the number of connections in the applicaiton pool. You can however limit the number of processes (init.ora parameter) which will effectively limit number of connections.

Val Gamerman.

To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:        (bcc: Val Gamerman/Victoria Financial)
From:     dgoulet_at_vicr.com @ NOTES NET
Date:     11/02/2000 03:01:03 PM GMT

Subject: Re:Testing connection pooling feature

Ranganath

To run connection pooling you need to be running Oracle 8.0 or better and
have both MTS and Connection manager up and running. There is really very little that the developer can do on this. Dick Goulet

____________________Reply Separator____________________
Author: RanganathK_at_lgcommerznow.com
Date:       11/2/00 3:46 AM
Dear DBA gurus,
     One of our developers has setup the connection pooling feature using

java programs. He doesn't know whether whatever he has implemented is right or not? As a DBA how do I test whether Oracle is using the connection pooling feature or not? Also how do I limit the number of connections to a database as a DBA? Any useful information regarding this query will be highly appreciated.
TIA,
Ranganath
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: RanganathK_at_lgcommerznow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message