Re: Get database connection performance

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 27 Feb 2004 04:26:34 GMT
Message-ID: <_Fz%b.27575$AL.505304@attbi_s03>

"Tim Smith" <timasmith_at_hotmail.com> wrote in message news:a7234bb1.0402261908.39794a4d_at_posting.google.com...
> We have an 8.05 database on windows 2000 and a legacy app that is
> getting a new connection for many operations. Due to performance
> problems we need to speed up this operation now, before we can fix the
> code.
>
> Are there any database parameters that are non-intrusive that can
> speed up the operation of getting a connection?

You can edit the listener.ora file and prespawn some processes. You will have to read the docs. Clearly the app is poorly written. (also 8.0.5 was desupportted along time ago, move up to at least 8.1.7.4) Jim Received on Thu Feb 26 2004 - 22:26:34 CST