Re: high buffer wait ratio

Hi David, Here's partial of the onstat -g spi output, sorted by the number of loops. Hopefully you are able to help me identify the bottle neck of my database engine. Num Waits Num Loops Avg Loop/Wait Name 242914 13216219 54.41 shmcb sh_lock 2028414 9598634 4.73 "mutex lock, name = pt_7000ac" 234370 2064574 8.81 "vproc vp_lock, id = 1" 228267 1815500 7.95 "vproc vp_lock, id = 3" 231000 1797155 7.78 "vproc vp_lock, id = 4" 454333 1563471 3.44 "mutex lock, name = pt_70004b" 183432 1200451 6.54 "fast mutex, bf[8197]" 155966 1127036 7.23 "fast mutex, bf[18788]" 39500 903940 22.88 "fast mutex, bf[16223]" 107668 762510 7.08 "fast mutex, bf[18786]" 82838 695913 8.4 "fast mutex, bf[18559]" 105992 688875 6.5 "fast mutex, bf[16881]" 108695 665388 6.12 "fast mutex, bf[16958]" 94169 626811 6.66 "fast mutex, bf[6939]" 88704 578072 6.52 "fast mutex, bf[16936]" 64899 563221 8.68 "fast mutex, bf[18531]" 64169 408385 6.36 "fast mutex, bf[16904]" 98248 404525 4.12 "mutex lock, name = pt_700127" 95734 311553 3.25 "mutex lock, name = global cach" 35175 299463 8.51 "fast mutex, bf[17179]" 36472 296761 8.14 "fast mutex, lru-30" 43741 294424 6.73 "fast mutex, bf[16935]" 47917 245694 5.13 "mutex lock, name = pt_700002" 76919 243740 3.17 "mutex lock, name = pt_700120" 59812 226799 3.79 "mutex lock, name = pt_70007d" 20175 218361 10.82 "fast mutex, bf[5287]" __________________________________ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25' http://photos.yahoo.com/ph/print_splash sending to informix-list

miyaki wrote: > Hi David, > > Here's partial of the onstat -g spi output, sorted by > the number of loops. that's not quite sorted properly - try onstat -g spi | sort -n and it should come out numerically sorted...