The onstat -g stm command displays the current statemennt cache and the memory usage.
session 30 --------------------------------------------------------------- sdblock heapsz flags statement ('*' = Open cursor) 13af1018 47200 ----- * select * from wbPages where ID = 'insart' and path = '/' and extension = 'html'; session 29 --------------------------------------------------------------- sdblock heapsz flags statement ('*' = Open cursor) session 28 --------------------------------------------------------------- sdblock heapsz flags statement ('*' = Open cursor) 13a4d018 12328 ----- EXECUTE FUNCTION webexplode(?::html, ?::html); 13a4d3a8 6144 ----- <SPL statement> 13a4d4d8 6144 R---- <SPL statement> 13a4d608 12288 ----- <SPL statement> session 27 --------------------------------------------------------------- sdblock heapsz flags statement ('*' = Open cursor) 13980018 12328 EXECUTE FUNCTION webexplode(?::html, ?::html); 139803a8 6144 ----- <SPL statement> 139804d8 6144 ----- <SPL statement> 13980608 12288 ----- <SPL statement> session 26 --------------------------------------------------------------- sdblock heapsz flags statement ('*' = Open cursor) session 24 --------------------------------------------------------------- sdblock heapsz flags statement ('*' = Open cursor) 13176018 12328 ----- EXECUTE FUNCTION webexplode(?::html, ?::html); 131763a8 6144 ----- <SPL statement> 131764d8 6144 ----- <SPL statement> 13176608 12288 ----- <SPL statement>
Field | Description |
---|---|
sdblock | Address of the statement descriptor block |
heapsz | Size of the statement memory heap |
flags | R requires reoptimization |
statement | Query text |
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.