Re: Session memory grows a lot
ivan.lopes@rio.rsl.com.br (Ivan Lopes) wrote:
>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
>;
>;
>;
We are seeing the same type problem with our PeopleSoft HR
application. The memory is all tied to the ralloc. Our system is an
HP9000 k400, HPUX 10.01 and Informix 7.14.UD1.
Barry Leb
National Linen Service
1420 Peachtree Street
MS #314
Atlanta, GA 30309
(404) 853-6119
(404) 853-6485 fax
e-mail: barryleb@mindspring.com