The rdbms ipc reply
460592Feb 25 2008 — edited Feb 26 2008Hi All,
I have examined in session. I found out that the rdbm ipc reply AVERAGE_WAIT up to 195.
below is the statistic table from session:
EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
rdbms ipc reply 13 13 2538 195
db file sequential read 1 0 0 0 0 96
SQL*Net message to client 8 0 0 0 0 17
SQL*Net more data to client 12 0 0 0 0 171
SQL*Net message from client 8 0 1 0 0 10126
When the rdbms ipc reply AVERAGE_WAIT time increase that much this cause my loading data too slow.
Anyone, pls help me with this?
Thanks
Lux