Display detailed session information and memory usage

Use the onstat -g ses session-id command to display detailed information for a session, including memory usage.

The following onstat -g ses session-id output columns display memory usage:

The Memory pools portion of the output
- The totalsize column shows the number of bytes currently allocated
- The freesize column shows the number of unallocated bytes
The last line of the output shows the number of bytes allocated from the sscpool.

Figure 1 shows that Session 16 has currently allocated 69632 bytes, of which 11600 bytes are allocated from the sscpool.

Figure 1. onstat -g ses session-id output

onstat -g ses 14


session                                      #RSAM    total      used
id       user     tty      pid      hostname threads  memory     memory
14       virginia 7        28734    lyceum   1        69632      67384     

tid      name     rstcb    flags    curstk   status
38       sqlexec  a3974d8  Y--P---  1656     cond wait(netnorm)

Memory pools    count 1
name         class addr      totalsize   freesize  #allocfrag #freefrag
14           V     a974020   69632       2248     156        2 

...
Sess  SQL            Current            Iso Lock       SQL  ISAM F.E.
Id    Stmt type      Database           Lvl Mode       ERR  ERR  Vers
14    SELECT         vjp_stores         CR  Not Wait   0    0    9.03

Current statement name : slctcur

Current SQL statement :
  SELECT C.customer_num, O.order_num FROM customer C, orders O, items I
    WHERE C.customer_num = O.customer_num AND O.order_num = I.order_num

Last parsed SQL statement :
  SELECT C.customer_num, O.order_num FROM customer C, orders O, items I
    WHERE C.customer_num = O.customer_num AND O.order_num = I.order_num

 11600 byte(s) of memory is allocated from the sscpool