Re: Session memory grows a lot
In article <67bm64$og9@cssun.mathcs.emory.edu>, Ivan Lopes
<ivan.lopes@rio.rsl.com.br> writes
>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
^^^^^
session id.
Try onstat -g ses 20588.
What does this show?
If it is mainly ralloc then are you using ODBC drivers? If so you may
be experiencing the same problems that I am?
PS Please note I have NEVER said it was a bug just a problem which is
under investigation by the ODBC Vendor.
>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
>;
>;
>;
>
>
--
David Williams