The output of the onstat -g mem command shows
the total amount of memory used by each session.
The totalsize column
of the onstat-g mem 16 output shows the total amount
of memory allocated to the session.
The output of the onstat -g stm command shows
the portion of the total memory allocated to the current prepared SQL statement.
The heapsz column of the onstat-g stm 16 output
in the following figure shows the amount of memory allocated for the
current prepared SQL statement.
Figure 1: onstat
-g mem and onstat -g stm to determine
session memory
onstat -g ses
session #RSAM total used
id user tty pid hostname threads memory memory
18 informix - 0 - 0 12288 8928
17 informix 12 28826 lyceum 1 45056 33752
16 virginia 6 28743 lyceum 1 90112 79504
14 virginia 7 28734 lyceum 1 45056 33096
3 informix - 0 - 0 12288 10168
2 informix - 0 - 0 12288 8928
onstat -g mem 16
Pool Summary:
name class addr totalsize freesize #allocfrag #freefrag
16 V a9ea020 90112 10608 159 5
...
onstat -g stm 16
session 16 ---------------------------------------------------------------
sdblock heapsz statement ('*' = Open cursor)
aa0d018 10056 *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
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.