IDS Forum

Re: memory used by a session

Posted By: John Miller iii
Date: Wednesday, 18 July 2012, at 2:50 p.m.

In Response To: memory used by a session (FRANK)

it would be nice to see what these two users are currently doing:

onstat -g ses {session id}

onstat -g ses 17499439

Also to see how many current statements this application is using along
with how much memory each SQL statement is taking:

onstat -g stm {session id}

onstat -g stm 17499439

I am guessing you will find that a java programmer relied on the clean
up of the class to free the database statements. There is not specific
time table or requirement that the cleanup happens so the number of
statements grow and grow. In test it works great because there are
plenty of free cycles for the garbage collector to run.

John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)

ids-bounces@iiug.org wrote on 07/18/2012 10:50:09 AM:

> From: "FRANK" <yunyaoqu@gmail.com>
> To: ids@iiug.org,
> Date: 07/18/2012 11:01 AM
> Subject: memory used by a session [27657]
> Sent by: ids-bounces@iiug.org
>
> 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.
>

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.