How to tune local write wait?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to tune local write wait?

  1. #1
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233

    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

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  3. #3
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Thanks joveri!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width