not clear on how to calculate the wait time
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: not clear on how to calculate the wait time

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    not clear on how to calculate the wait time

    I am reading on TOm Kyte performance tuning workshop and I am not on this on top 5 events on statspack report:
    Code:
    events                       wait         time          %Total elapsed
    
    Direct path write            5168         279           20.5

    and he mentioned that there was 120 waits for direct path writes, totalling three thousandth second (as opposed to 279 seconds)

    the question is how does he get 120 waits and 3,000 second???
    Last edited by learning_bee; 01-05-2005 at 03:18 PM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331

    Re: not clear on how to calculate the wait time

    Originally posted by learning_bee
    I am reading on TOm Kyte performance tuning workshop and I am not on this on top 5 events on statspack report:
    Code:
    events                       wait         time          %Total elapsed
    
    Direct path write            5168         279           20.5

    and he mentioned that there was 120 waits for direct path writes, totalling three thousandth second (as opposed to 279 seconds)

    the question is how does he get 120 waits and 3,000 second???
    link?

  3. #3
    Join Date
    Oct 2003
    Posts
    312
    Davey,

    I found the PFD file from one of the thread in this forum and unfortunately, I don't remember which thread it's on; however I have the PDF file and please see the attached file on STATSPACK portion.

    thanks,

  4. #4
    Join Date
    Oct 2003
    Posts
    312
    unfortunately, I can't upload pdf neither the zip file b/c it's too big. Anyway, attached is the snapshot of what he said
    Attached Files Attached Files

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136

    NEVER EVER LOOK INTO THE TOP 5 EVENTS OF STATSPACK REPORT.
    THEY ARE ALL WRONG


    Tamil

  6. #6
    Join Date
    Oct 2003
    Posts
    312
    tamilselvan,

    I am confused, I read so many docs and even Tom Kyte mentioned that top 5 events is one of the most important areas, plus some of the guys who really knows what they are doing in here would say the same thing.

    Please let me know b/c I don't want to keep doing the wrong thing.

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: not clear on how to calculate the wait time

    Originally posted by learning_bee
    and he mentioned that there was 120 waits for direct path writes, totalling three thousandth second (as opposed to 279 seconds)

    the question is how does he get 120 waits and 3,000 second???
    These were the values after making changes (pga_aggregate_taget) - he does not show the new report.

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Originally posted by tamilselvan

    NEVER EVER LOOK INTO THE TOP 5 EVENTS OF STATSPACK REPORT.
    THEY ARE ALL WRONG


    Tamil
    you can't say that and not qualify your statements with examples

  9. #9
    Join Date
    Oct 2003
    Posts
    312
    I can't update the whole pdf file for your guys and it's so annoying to capture and miss some other part, any way, I captured the 5 events after making the changes.

    I still like to undertand how to calculate those numbers
    Attached Files Attached Files

  10. #10
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Read it very carefully: three reports are mentioned, he prints #1 and #3. You'll just have to take his word about report #2.

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