Re: Question about Connection Pooling...

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sat, 20 Mar 2004 06:13:43 +0200
Message-Id: <200403200413.i2K4Dh510929@mail-fe81.tele2.ee>

There is a difference between connection pooling and session pooling in Oracle. You might have a pre-allocated pool of connections, but every app server request to database still creates a new session using one of the connections in connection pool.

If you want even better scalability, go with session pooling (done either by app server code or OCI), but if you got need for stateful sessions, then you can't use PL/SQL package variables for saving the states of a session, global application contexts and client_id should be used instead.

OCI supports both connection and session pooling, I don't know about IIS.

Tanel.

> We are using Microsoft IIS for our middle tier. I
> did some tests by using a logon trigger and recording the Sid. I
> found that
> every query results in a new connection. Our software engineers tell
> me that the
> middle tier is reusing the same connections. I'm not seeing that.
> What are your
> experiences with connection pooling?
>
>
>

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Mar 19 2004 - 22:10:09 CST