DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: regaring wait events

Threaded View

  1. #3
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Any comments after having a look at this:
    Code:
                                                                         Avg
                                                         Total Wait    wait       Waits
    Event                                  Waits   Timeouts      Time (s)   (ms)     /txn
    ---------------------------- ------------ ---------- ---------- ------ --------
    db file sequential read           15,425           0        121           8         2.1
    direct path read                  190,330          0        109           1        25.5
    log file parallel write               13,674          0         34           2          1.8
    log file sync                           5,922          0         30           5          0.8
    Don't be lazy and use the code tags
    Last edited by davey23uk; 02-05-2010 at 12:07 PM.
    lucky

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