Re: connection pooling

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 14 Oct 2002 10:06:47 +0100
Message-ID: <3daa8928$0$1286$ed9e5944@reading.news.pipex.net>

"Tobias Herrmann" <tobias_at_myherrmann.de> wrote in message news:3DA86AC1.B7E807C_at_myherrmann.de...
> Can somebody tell me something about connection pooling
> with ORACLE and ODBC.

connection pooling means that the same connection gets reused for different sessions.

> Is it working, how is it working and how do I use it?

If you are using ODBC connection pooling for an application server/web server then you configure the connection pooling in the odbc applet in control panel on your app server/web server. However connection pooling will be enabled by default with any recent odbc drivers for oracle and a reasonably up to date version of MDAC.

If you are talking about Oracle connection pooling where the Oracle server itself pools connections then you need to read up on multi-threaded server at
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/network.817 /a76933/mts.htm#450520

>Is it really
> making your connection faster?

No it is enabling more coinnections to be served with fewer resources. Think of it as a scalability feature not a performance boost.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Mon Oct 14 2002 - 04:06:47 CDT