Re: Performance tuning approach for connection pooling apps !
Date: Sat, 04 Feb 2012 12:03:48 -0700
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.
On 04/02/2012 7:43 AM, Raja Subramaniyan wrote:
> 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.