Re: Database performance

From: Paul Jazwierski <uszko@earthlink.net> > >Yet another performance question: > >Here is an output of the command: onstat -g wai >which prints out all waiting and sleeping threads. It is consistently >this length. Question: >Is it normal to have this many sleeping and waiting threads, or is this >evidence of a bottleneck somwhere? Why are the AIO threads sleeping? >Shouldn't they be doing work, and then when they are done, just be >terminated? I consistently have 56 AIO threads running. Is that a Maybe you need to grab a manual or go on training. But the AIO threads never get killed, you define how many you want in tour onconfig file. >or is that normal. We have about 10GB database with moderate user >interaction (only about 30 users on it at peak time). Send us the output from onstat -g iov and I'll tell you. :-) It's way too many if you have KAIO enabled. (Which you don't) Post your onconfig file. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com