Re: Dynamically adding shared memory segs

Bill Weaver wrote: > > Today for some reason we've added 5 shared memory segments dynamically. It almost never happens > that we even have 1 added since I've worked to size our initial segment to avoid this. How can > I tell what is causing us to add so many all of a sudden? > > Also our ready queue seems to be long today (we almost never have any processes in it when we do > onstat -g rea) even though our processor utilization is only around 60%. The cpuvps are> affinitied to physical processors (there are 8 cpus in the box and we run 6 cpuvps). Could this > be related to the problem above? What else could cause it? Would adding another cpuvp help > even though the physical cpus aren't at capacity? The combination of long ready queue and new segments may mean someone is running large queries using a high PDQPRIORITY value. Art S. Kagel