Problem with memory allocatation
Posted in 2001
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.
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.
The statistics are as follows.
1. ( Onstat -g seg ).
Segment Summary:
id key addr size ovhd class blkused blkfree
27 1381779457 c58d3000 14319616 1644 R 1741 7
(shared) 1381779457 c667b000 33562624 1124 V 4097 0
36 1381779458 d3b9c000 16777216 864 V 2048 0
2085 1381779459 d4bba000 16777216 864 V 2048 0
1062 1381779460 d5bba000 16777216 864 V 2048 0
26663 1381779461 d6bc9000 16777216 864 V 2048 0
1064 1381779462 d7bc9000 16777216 864 V 2048 0
2089 1381779463 d8bc9000 16777216 864 V 2048 0
42 1381779464 d9bc9000 16777216 864 V 2048 0
11308 1381779465 dacec000 16777216 864 V 2048 0
55339 1381779466 dbcec000 16777216 864 V 2048 0
4142 1381779467 dccec000 16777216 864 V 2048 0
12333 1381779468 ddcec000 16777216 864 V 2048 0
49199 1381779469 decec000 16777216 864 V 2048 0
13360 1381779470 dfcec000 16777216 864 V 2048 0
313393 1381779471 e1629000 16777216 864 V 2048 0
72754 1381779472 e26cb000 16777216 864 V 2048 0
45107 1381779473 e36cb000 16777216 864 V 2048 0
16436 1381779474 e46cb000 16777216 864 V 2048 0
56373 1381779475 e56cb000 16777216 864 V 1527 521
Total: - - 349872128 - - 42181 528
2. onstat -g mem
name class addr totalsize freesize #allocfrag #freefrag
resident R c58d5018 12599296 12136 2 2
res-buff R c64d9018 1654784 14184 2 2
global V c667d018 237371392 51048 1876526 65
mt V c6681018 91963392 1090640 938797 20656
rsam V c6687018 393216 4200 1103 6
aio V c66cd018 303104 28224 172 20
gls V c66d3018 24576 2504 348 5
dictpool V c66d7018 507904 71304 390 72
procpool V c66db018 16384 7104 12 2
XTF_mem V c66f9018 409600 17432 4 3
main_loop() V c67e1018 32768 17464 116 3
2 V c67ef018 8192 3192 8 1
3 V c67fb018 16384 2888 207 1
lgflushpool V c681d018 8192 7800 5 1
aslogflush V c681f018 16384 6512 108 1
btclean V c6833018 16384 5824 111 1
onmode_mon V c685b018 16384 6512 108 1
171669 V e288b018 98304 39456 310 16
180841 V e289d018 131072 16880 450 16
191353 V dc82a018 32768 3064 275 1
192248 V e4221018 57344 7072 315 2
192249 V e3651018 8192 3192 8 1
Blkpool Summary:
name class addr size #blks
global V c667f178 0 0
3) onstat -g ses
session #RSAM total used
id user tty pid hostname threads memory memory
192280 informix - 0 - 0 8192 5000
192279 ediadm - 26980 redback 1 57344 50272
191353 ediadm - 17129 redback 1 32768 29704
180841 ediadm - 23188 redback 1 163840 118160
171669 ediadm - 13252 redback 1 98304 58848
3 informix - 0 - 0 16384 13496
2 informix - 0 - 0 8192 5000
4) onstat -u
Userthreads
address flags sessid user tty wait tout locks nreads
nwrites
c6689018 ---P--D 1 informix - 0 0 0 4464
16249
c66894cc ---P--F 0 informix - 0 0 0 0
140301
c6689980 ---P--- 5 informix - 0 0 0 0
766
c6689e34 ---P--B 6 informix - 0 0 0 922
851
c668ac50 ---P--D 9 informix - 0 0 0 0
0
c668cd3c Y--P--- 171669 ediadm - dba91458 0 1 2651
234
c668e00c ---P--- 192290 ediadm - 0 0 1 0
0
c668e974 Y--P--- 191353 ediadm - e49c4518 0 2 6
0
c668fc44 ---PR-- 180841 ediadm - 0 0 1 4908543
65491
9 active, 128 total, 20 maximum concurrent
Thanks in advance
Aboo