显示详细会话信息和内存使用情况

使用 onstat -g ses session-id 命令显示会话的详细信息，包括内存使用率。

以下 onstat-g ses session-id 输出列显示内存使用情况：
图 1 显示会话 16 当前分配 69632 字节，其中 11600 字节分配自 sscpool。

图: onstat -g ses 会话标识输出 

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
父主题： 监视每个会话的内存使用情况