Good Evening,
Below are the list of wait events with 17.7 days the top wait event "SQL*Net message from client".
How can I reduce it?
Code:EVENT TOTAL_WAITS TIME_WAITED ------------------------------ ----------- ----------- SQL*Net message from client 4298474 63977240 rdbms ipc message 87695 9830470 PX Deq: Execution Msg 310670 8080779 pmon timer 7135 2035552 virtual circuit status 647 2031403 dispatcher timer 323 2021496 PX Idle Wait 279360 1998518 smon timer 68 1971965 wakeup time manager 611 1957159 enqueue 275521 558988 SQL*Net more data from client 3949 44848 PX Deq: Join ACK 270437 32571 db file sequential read 86321 27344 PX Deq: Table Q Normal 59714 11390 PX Deq: Execute Reply 1217 6311 db file scattered read 34101 5654 PX Deq Credit: send blkd 28541 5213 latch free 1328 3208 direct path read 8744 2229 PX Deq Credit: need buffer 17004 1913 log file sync 16344 1579 direct path write 5268 1406 log file parallel write 19410 1148




Reply With Quote