| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: Question about Connection Pooling...
Nuno,
Do you mean scalability issues when selectively enabling privs/roles within an existing database session based on application server userid?
Tanel.
> Sorry to push in to this one. Quick related question if
> anyone knows:
>
> With this trend to pooled connections/sessions, there is
> sometimes a need to make a given session behave with a specific
> user's "hat". Does anyone have any scalability info on things
> like SET ROLE or any recommendations on how to handle specific
> user identification issues? There was something about this a
> while ago on the Oracle mag but it was mostly to do with LDAP
> authentication and it was for 8i.
>
> Cheers
> Nuno Souto
> in sunny Sydney, Australia
> dbvision_at_optusnet.com.au
> ----- Original Message -----
> From: "Gudmundur Josepsson" <gbj_at_index.is>
> To: <oracle-l_at_freelists.org>
> Sent: Saturday, March 20, 2004 9:28 PM
> Subject: Re: Question about Connection Pooling...
>
>
> > Tanel,
> >
> > Thanks for the explanation about the difference between connection
> pooling
> > and session pooling. We always talk about connection pooling but
> according
> > to your definition we're using session pooling. The sessions are
> opened
> > when the app server starts and are kept open continuously. The
> apps then
> > come in on the first free session and might re-appear in a different
> session
> > on their next call. Makes it a bit tough when it comes to 10046
> tracing,
> > for example.
> >
> > Gummi
> >
> > ----- Original Message -----
> > From: "Tanel Poder" <tanel.poder.003_at_mail.ee>
> > To: <oracle-l_at_freelists.org>
> > Sent: Saturday, March 20, 2004 4:13 AM
> > Subject: Re: Question about Connection Pooling...
> >
> >
> > > 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
> > -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
>
-- 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 Sat Mar 20 2004 - 21:21:45 CST
 |
 |