Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC Connection Pooling & Oracle
"Justin Cave" <jocave_at_yahoo.com> wrote in message
news:233b7a65.0208280003.3d996a64_at_posting.google.com...
> "Jennifer" <Jennifer_at_DAG[DELETEME].ca> wrote in message
news:<HbRa9.10174$V21.212590_at_news>...
> > Hello All,
> > Does anyone know of any Server side parameters that could be set in the
> > sqlnet.ora or init.ora that would disable ODBC connections pooling?
>
> Assuming that you're using the Oracle ODBC driver (I assume the same
> goes for the Microsoft driver), no server side parameters could
> possibly interfere with ODBC connection pooling.
>
> > I've been working on a project for months and everything seemed fine
until I
> > moved the application to the client site. It seems to take a really
long
> > time to just connect to the database through the application. Once I am
in
> > and execute a select statement, it returns quickly but, if I close the
> > connection to the database and issue another select statement again I
wait a
> > long time for the connection and then eventually after the connection is
> > established the record set is returned quickly.
> >
> > Anyone have any idea what might be going on?
> > Oracle version is 8.1.6
>
> Can you verify that connection pooling is actually turned on in the
> ODBC Data Source Administrator?
And also that the connection string really is the same for subsequent selects (i.e. same username and password, tnsnames entry connection options etc).
-- 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 Wed Aug 28 2002 - 06:47:36 CDT