Re: Get database connection performance

From: <sybrandb_at_yahoo.com>
Date: 27 Feb 2004 03:19:57 -0800
Message-ID: <a1d154f4.0402270319.3fa0f55d@posting.google.com>

timasmith_at_hotmail.com (Tim Smith) 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?

Set up Oracle Names and switch from tnsnames.ora to Oracle Names. Other than that: no, not really
But your question heavily smells of symptom fighting.

Sybrand Bakker
Senior Oracle DBA Received on Fri Feb 27 2004 - 05:19:57 CST