显示有关会话 SQL 语句的信息

使用 onstat -g sql session-id 命令来显示有关会话执行的 SQL 语句的信息。

下图表明 onstat -g sql session-id 所显示的信息与图 1 中 onstat -g ses session-id 命令底部的信息相同，包括从 sscpool 分配的字节数。

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

onstat -g sql 14


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