Re: Performance tuning approach for connection pooling apps !

  • From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • 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:
> 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
> --


Other related posts: