Re: semaphores or lack there of

david, you didn't say if all this was in response to a problem. i assume if you have 24 to 30 threads in the wait queue that you are experiencing some performance problems, but not necessarily. > When I do a onstat -g wai and look at my sqlexec threads I see 24 to 30 > of my 40 to 45 sqlexec threads listed as cond wait(sm_read). Are they i don't know if that refers to semaphores or not. can someone with some knowledge here clear this up? i think that if the server ran out of semaphores that it would complain, and you should see a message in the log file. i would check there and see if you see anything, but also post back to say if you are actually experiencing any problems with this. mickm