Re: lots of Virtual portion memory with less used
Additional virtual memory spaces (class 'V') are allocated for two reasons: One
is if the initial segment is not configured to be large enough (sized by
SHMVIRTSIZE), the second is to provide additional virtual memory (sized by
SHMADD) to support large or complex queries or large in-memory sorts for
queries, update statistics, or index or hash table building. The first use is
normally seen as mostly used. If you are seeing several additional virtual
memory segments it is likely the latter. If you see these often, for either
reason, it would be a good thing to increase SHMVIRTSIZE to include the extra
query/sort memory into the primary virtual segment for efficiency. On most
UNIXes it takes a relatively long time to create a new segment on the fly.
Art S. Kagel
----- Original Message -----
From: Nadine Dieltjens <ids@iiug.org>
At: 9/05 9:08:27
An onstat -g seg gives following output. What is configured wrong or whats
going wrong on the system. Why is informix using few space in each memory
segment ?
Informix Dynamic Server 2000 Version 9.21.UC3 -- On-Line -- Up 69 days
17:58:55 -- 1867776 Kbytes
Segment Summary:
id key addr size ovhd class blkused blkfree
102 1381386241 a000000 1168113664 250928 R 284996 188
107 1381386246 4fa00000 356515840 11480 V 37374 49666
2024 1381386248 64e00000 1048576 632 M 133 123
201 1381386249 64f00000 33554432 1624 V 7 8185
225 1381386250 66f00000 33554432 1624 V 20 8172
126 1381386251 68f00000 33554432 1624 V 9 8183
127 1381386252 6af00000 33554432 1624 V 6 8186
128 1381386253 6cf00000 33554432 1624 V 9 8183
129 1381386254 6ef00000 33554432 1624 V 5 8187
2630 1381386255 70f00000 45088768 1976 V 1 11007
731 1381386256 73a00000 45088768 1976 V 1 11007
432 1381386257 76500000 48234496 2072 V 1 11775
433 1381386258 79300000 48234496 2072 V 1 11775
Total: - - 1913651200 - - 322563 144637
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.