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.
/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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
