Re: Performance tuning approach for connection pooling apps !

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Sat, 04 Feb 2012 12:03:48 -0700
Message-ID: <4F2D8114.3030704_at_gmail.com>

Based on the information detailed, including the performance goals, the platform, the application technique, and versions information provided, my current recommend action would be to rewrite the application.

Barring that, I'd use standard techniques to ensure the database is healthy and statistics are up to date, followed by a standard analysis of critical statements and their relative wait and execution information.

Step 1 - get Diagnostic Pack and use the AWR reports.

/Hans

On 04/02/2012 7:43 AM, Raja Subramaniyan wrote:
> Hi,
> Some one please share your ideas / methods for performance tuning approach
> for Oracle database ( specifically connection pooling application ) . i.e,
> If we are not able to identify the specific session, and the application
> using connection pooling mechanism, what is the best way to resolve
> performance issues.
>
> Thanks
> Raja.S
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Feb 04 2012 - 13:03:48 CST