RE: Problem with memory allocation

Yes, it is. The virtual pool is used for internal tables, session data, thread data, stored procedures caching, sorting. -----Original Message----- From: Aboobacker V V [mailto:aboo@syd-co.au.dhl.com] Sent: Thursday, January 04, 2001 5:20 PM To: John Carlson Cc: informix-list@iiug.org Subject: Re: Problem with memory allocation John, Thanks for this, Can you please tell me what is this global pool, Is that the pool used for sorting and indexing. Aboo John Carlson wrote: > See comments below . . . . > > -----Original Message----- > From: Aboobacker V V [mailto:aboo@syd-co.au.dhl.com] > Sent: Wednesday, January 03, 2001 6:10 PM > Cc: informix-list@iiug.org > Subject: Problem with memory allocatation > > Hi All, > > Can anybody please help me with the memory segments in Informix. > > My server keep on adding memory segments ( atleast two segments / day ) > while the number of users or sessions does not increase. > > JC> There are processes out there (sorts, index creates ??) that are > allocating this memory. > > Onstat -g mem shows that the global pool is the biggest usage. What is > this global pool. Also I tried onmode -F to free some segment but it is > not working. > > JC> onstat -g seg show that these memory blocks are being used. onmode -F > will not free them if they are in use. > > The statistics are as follows. > > . . .. stats clipped . . . . > > What are your settings for SHMVIRTSIZE? I'd recommend that you increase > SHMVIRTSIZE by (19 * SHMADD) so as to allow this virtual memory to be a > single memory segment. If you're running HP, you would probably even get a > performance increase, as HP doesn't really like more than three active > memory segments.