On 5/10/07, Harvinder Singh <Harvinder.Singh_at_metratech.com> wrote:
>
> Problem statement is that "we are running one of the batch jobs from
> application server to database and it suppose to take about 2-3 min but
> taking about 20 min".
>
> So I ran the 10046 trace and since we are using connecting pooling we got
> lot of trace files and I thought there is a problem in trcsess so I am
> getting wrong result but then I ran the tkprof on individual files and
> following is the sample output of one of the files and it shows that this
> idle event is causing lot of delay and we need to know what can be the
> possible reason and it is not consistent on particular query and always
> takes longer time on some different query. Wait event is consistent about 2
> sec for every query and for one query time was 66 sec:
>
Is the client machine experiencing problems that is preventing a timely
response? As already stated earlier, the database is waiting for a response
from the client.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 10 2007 - 10:17:39 CDT
