Hi,
DB_VERSION=10.2.0.4
OS_VERSION=Windows 2003 server
We often ecountering "Pipe get buffer length " wait event.
SQL> @wait
SID EVENT SECS_WAIT STATE P1 P2 P3 WAIT_TIME P1TEXT
----- ---------------------------------------------------------------- ---------- ------------------- ---------- ---------- ---------- ---------- -----------------------------------
P2TEXT P3TEXT
---------------------------------------------------------------- ----------------------------------------------------------------
148 pipe get 10 WAITING 1407483584 4096 86400000 0 handle address
buffer length timeout
157 SQL*Net message from client 0 WAITED SHORT TIME 1413697536 1 0 -1 driver id
#bytes
169 pipe get 8 WAITING 1408205168 4096 86400000 0 handle address
buffer length timeout
170 pipe get 9 WAITING 1378585472 4096 86400000 0 handle address
buffer length timeout
187 pipe get 9 WAITING 1378585816 4096 86400000 0 handle address
buffer length timeout
How to handle this wait event ?