On 5/10/07, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> 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.