Re: Get database connection performance

From: Hans Forbrich <hforbric_at_yahoo.net>
Date: Tue, 02 Mar 2004 06:18:12 GMT
Message-ID: <EGV0c.59226$Ff2.3736@clgrps12>

Tim Smith wrote:
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1077907925.802977_at_yasure>...
>

>>Tim Smith wrote:
>>
>>
>>>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?
>>
>>Upgrade to 9.2.0.4
>>
>>You are running an unsupported version of Oracle that was never
>>certified on that operating system; and likely not on the hardware.

>
>
> I dont really understand how your comment helps. I already indicated
> it was a legacy app and we can't fix the code right now. Do really
> think we can swap out the database with a new version? Do you realize
> how much work that can be to retest an entire application on a new
> database?
>
> This reply comes too fast and too easily in this group...

Flip side: many in your position are not aware of, or not willing to look at, the compatibility settings available in the init.ora While not 100% effective (especially for features introduced at the 'compatible' version), for the vast majority of situations it is worth checking.

/Hans Received on Tue Mar 02 2004 - 00:18:12 CST