Re: Performance tuning approach for connection pooling apps !

From: Sriram Kumar <>
Date: Mon, 6 Feb 2012 11:32:45 +0530
Message-ID: <>

I am assuming that you are aware of the potenial operation that is slow (say 2 out of 10) and you are looking for a mechanism to isolate and trace/diagnose the operation but faced with the problem that you are not able to identify the session that corresponds to the slow opertion because the sessions/connections are pooled in the middle tier.

i can think of 2 strategies and you could use one of them

  1. trace all sessions for a period of x mins....5 mins/10 mins and search the trace files for the keywords of the SQL/table that is involved in the slow operation and then tkprof the specific trace file
  2. make an application change to use dbms_monitor api call for the specific slow operation and trace

hope this helps

best regards

sriram kumar

On Sat, Feb 4, 2012 at 8:13 PM, 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
> --

Received on Mon Feb 06 2012 - 00:02:45 CST

Original text of this message