High wait on SQL*Net message from client
I have run a trace on a sql, the following are the waited time:
=================================================================
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 49 0.00 0.00
SQL*Net message from client 49 1154.95 2329.21
latch: shared pool 6 5.09 6.00
db file sequential read 10814 0.53 151.55
SQL*Net break/reset to client 2 0.08 0.08
latch: row cache objects 58 0.14 1.58
Disk file operations I/O 76 0.08 0.18
asynch descriptor resize 18 0.00 0.00
latch: cache buffers chains 2 0.30 0.31
latch: cache buffer handles 367 0.50 7.63
db file scattered read 12 0.08 0.33
latch free 2 0.03 0.06
log file sync 1 0.00 0.00
direct path write temp 7 0.00 0.02
direct path read temp 181 0.28 2.01
latch: object queue header operation 1 0.00 0.00
=================================================================
The longest wait is "SQL*Net message from client" 2329.21