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.