Re: Dynamically adding shared memory segs

Mark D. Stock schrieb: > > Martin Berns wrote: > > > > Bill Weaver schrieb: > > > > > > 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? > > [snip] > > > > Run 'onstat -g ses' and have a look at the 'total memory' column. This may indicate who is using > > the additional memory. Remember, sessions don't free memory by themselves: So if there is a big > > difference between 'total memory' and 'used memory' you should think about running 'onmode -F' > > every x minutes/hours by cron. > > Don't do that! > > If you have a one-off allocation of virtual segments, then free them > with a one-off onmode -F. > > If you have regular allocation of virtual segments, then tune the > SHMVIRTSIZE & SHMADD parameters.> > Cheers, > -- > Mark. [snip] Hi Mark, can you tell us why not to do that by cron? I can understand that the engine isn't doing this itself. But if I can't get more physical memory, i would prefer to do some cronjobs instead of paging! hth martin