Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.