Re: Performance tuning approach for connection pooling apps !

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Mon, 6 Feb 2012 11:32:45 +0530
Message-ID: <CAEq4C0cOfoAstBC8w8encRNyeqEDgw78NU3tVqhimhKvr9iYkA_at_mail.gmail.com>

Hi,
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 <raja.s28_at_gmail.com>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 Mon Feb 06 2012 - 00:02:45 CST