Session memory grows a lot
Hi,
I am having serious problems because the session memory grows too much.
Some sessions at the end of the day have 20 Mb!!!!
We use a lot stored procedures, cursors and temp tables, but I don't think this could cause
this HUGE memory allocation.( Informix 7.23 on DEC Unix 4.0)
TIA,
Ivan Lopes
DB Solution - Rio de Janeiro - Brazil
--
Part of onstat -g ses (note that some sessions have 8Mb of total memory).
INFORMIX-OnLine Version 7.23.FC1X3 -- On-Line -- Up 2 days 12:48:47 -- 165216 Kb
ytes
session #RSAM total used
id user tty pid hostname threads memory memory
26662 informix - 0 - 0 8192 5912
20588 38830 - -1 ac100846 1 4833280 3840032
15574 37508 - -1 ac100845 1 98304 44936
12830 45543 - -1 ac100854 1 835584 125496
10169 37508 - -1 ac100845 1 8069120 3944344
7119 26662 - -1 ac100844 1 835584 103952
3028 48810 - -1 ac100847 1 98304 44840
2425 37737 - -1 ac100848 1 2621440 2524168
61758 48810 - -1 ac100847 1 8241152 4259736
59974 33740 - -1 ac1008a2 1 5087232 3586400
55704 35980 - -1 ac10084a 1 180224 131112
;
;
;