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.
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.
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.
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