Monitoring Memory
| Monitoring Memory |
|
Utilization for the entire system, by pool name or session id. Pool Summary:
name class addr total free #alloc #free
size size frag frag
resident R a002018 622592 16240 2 2
res-buff R a09a018 2064384 14192 2 2
global V a29c018 204800 82248 480 13
mt V a2a0018 1359872 542464 1164 29
rsam V a2c8018 270336 6576 615 1
aio V a302018 294912 36408 161 19
gls V a306018 24576 2480 348 2
dictpool V a30a018 106496 9008 96 7
procpool V a30e018 147456 34936 111 10
XTF_mem V a32c018 8192 1096 4 1
main_loop() V a39e018 16384 5816 111 2
2 V a3aa018 8192 3544 7 1
shmcon M aa6c018 122880 16240 2 2
3 V a3b8018 8192 3544 7 1
4 V a3c4018 16384 3280 206 1
6 V a3d6018 8192 3544 7 1
7 V a3e2018 16384 3280 206 1
8 V a400018 8192 3544 7 1
btclean V a408018 16384 5816 111 1
onmode_mon V a416018 16384 6752 108 1
202 V a4ec018 180224 144632 332 15
247 V a4ca018 8192 3544 7 1
Blkpool Summary
name class addr size #blks
global V a40b810 0 0
4 V a4c1698 228800 150
4 V a455438 3103616 16248
4 V a455470 3038080 16240
4 V a4554a8 2740738 14983
4 V a4554e0 3046272 16241
4 V a455518 3005312 16236
More verbals here The onstat -g ses can be used to display the memory at a session level. It can also be used to help determine whether an application has a memory leak. session user tty pid hostname #RSAM total used id threads memory memory 247 informix - 0 - 0 8192 4648 202 informix 2 16606 eric 1 180224 35592 8 informix - 0 - 0 8192 4648 7 informix - 0 - 0 16384 13104 6 informix - 0 - 0 8192 4648 4 informix - 0 - 0 16384 13104 3 informix - 0 - 0 8192 4648 2 informix - 0 - 0 8192 4648 You can find the ses-id from first running onstat -g ses. The example below shows a snapshot of memory poois for a session performing a sort. onstat -g ses ses-id session user tty pid hostname #RSAM total used id threads memory memory 202 informix 2 16606 eric 1 180224 35592 tid name rstcb flags curstk status 221 sqlexec a2cbda0 Y--P--- 1800 a2cbda0 cond wait(sm_read) Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 202 V a4ec018 180224 144632 332 15 name free used name free used overhead 0 120 scb 0 96 opentable 0 5992 filetable 0 1032 ru 0 224 log 0 2136 temprec 0 1608 ralloc 0 1024 gentcb 0 8488 ostcb 0 2008 sort 0 56 sqscb 0 9792 rdahead 0 112 hashfiletab 0 280 osenv 0 928 sqtcb 0 1520 fragman 0 176 Sess SQL Current Iso Lock SQL ISAM FE Id Stmt type Database Lvl Mode ERR ERR Vers 202 - eric CR Not Wait 0 0 6.03 statement : insert into t_title values ( 0 , ? ) User-created Temp tables : partnum tabname rowsize 1000c3 t_title 6 |