How to tune local write wait?
Hi guys,
My DWH production db 5 top wait events are:
(HP-UX 9000,8.1.7.3)
Top 5 Wait Events
~~~~~~~~~~~~~~~~~ Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
free buffer waits 30,422 2,984,908 28.89
local write wait 22,796 2,293,273 22.19
rdbms ipc reply 9,810 1,323,370 12.81
write complete waits 8,291 818,288 7.92
log file parallel write 189,338 786,875 7.61
Has anyone ever faced or tuned the wait event "local write wait"?
Thanks in advance,
Nir
