-
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
-
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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
|