Oracle Database Discussions

Dear All,

I am facing a performance issue in a particular operation ( which was completed in 21 Minutes earlier). Now the same operation takes more than 35 Minutes. I took a trace for those session ( 10046 level 12 trace ) and found Lot of waits in SQL*Net message from client.

Elapsed times include waiting on following events:

Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------

SQLNet message from client 611927 10.00 1121.35*

I copied only the highest wait in the tkprof output.

And I found from the tkprof and even in raw trace file this event waits more time after excuting

SELECT sysdate AS SERVERDATE from dual;

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 115 0.00 0.00
SQLNet message from client 115 10.00 724.52*

Please help me to find out why this wait taking long time, especially on the above query..

Regards,
Vinodh