IDS Forum

RE: memory used by a session

Posted By: Alexandre Marini
Date: Wednesday, 18 July 2012, at 2:49 p.m.

In Response To: RE: memory used by a session (Link, David A)

Also check onstat -g ses [sid] to see if those sessions are using PDQ.
That could set much more memory than regular sessions, depending on your onconfig PDQ settings.

Regards.

Alexandre Marini

> To: ids@iiug.org
> From: DALink@west.com
> Subject: RE: memory used by a session [27659]
> Date: Wed, 18 Jul 2012 14:35:10 -0400
>
> You could check to see if they are holding open prepared statements. Issuing
> onstat -g stm <sid> would show you the statements that they have prepared and
> not freed.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK
> Sent: Wednesday, July 18, 2012 12:50 PM
> To: ids@iiug.org
> Subject: memory used by a session [27657]
>
> Folks,
> You can see the two sessions below occupied excessive amount of memory (
> marked ). It is a Java application.
>
> Any guess/ideas... what the big memory are holding for? Why IDS need so big
> memory size for the two guys? ( what possible data/info in it?)
>
> ( Many Virtual memory segments were added for it)
>
> Thanks,
> Frank
>
> [informix@maggie ~]$ onstat -g ses
> IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 31 days
> 20:18:19 -- 7596160 Kbytes
> session #RSAM total used
> dynamic
> id user tty pid hostname threads memory memory explain
> 17661248 informix - 0 - 0 12288 11872
> off
> 17661218 saapmgr - 11880 olive 1 122880 87816 off
> 17661214 saapmgr - 11864 olive 1 126976 87776 off
> 17661213 saapmgr - 11860 olive 1 131072 87920 off
> 17499445 saapmgr - -1 olympia- 1 81920 65928 off
> 17499441 saapmgr - -1 olympia- 1 81920 65928 off
>
> 17499439 saapmgr - -1 olympia- 1 223924224 212080344 off <====This ONE
>
> 17499183 saapmgr - -1 olympia- 1 81920 65928 off
> 17499180 saapmgr - -1 olympia- 1 81920 65928 off
> 17499173 saapmgr - -1 olympia- 1 81920 65928 off
> 17499168 saapmgr - -1 olympia- 1 81920 65928 off
> 17499162 saapmgr - -1 olympia- 1 81920 65928 off
> 17499156 saapmgr - -1 olympia- 1 81920 65928 off
> 17499151 saapmgr - -1 olympia- 1 81920 65928 off
>
> 17499145 saapmgr - -1 olympia- 1 226394112 211701616 off <====This ONE
>
> 17495850 saapmgr - 22386 marvin 1 151552 105920 off
> 17495812 saapmgr - 22188 marvin 1 155648 105792 off
> 17495783 saapmgr - 22010 marvin 1 155648 105552 off
>
> --e89a8f6426f435cc3504c51e4b56
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• memory used by a session
  FRANK -- Wednesday, 18 July 2012, at 1:50 p.m.
  • RE: memory used by a session
    Link, David A -- Wednesday, 18 July 2012, at 2:35 p.m.
    • RE: memory used by a session
      Alexandre Marini -- Wednesday, 18 July 2012, at 2:49 p.m.
  • Re: memory used by a session
    John Miller iii -- Wednesday, 18 July 2012, at 2:50 p.m.
    • Re: memory used by a session
      malc_p -- Wednesday, 18 July 2012, at 3:35 p.m.
      • Re: memory used by a session
        FRANK -- Wednesday, 18 July 2012, at 7:14 p.m.
    • Re: memory used by a session
      FRANK -- Wednesday, 18 July 2012, at 7:11 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.