-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|