Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Onstat -a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g stm Statement Cache

The onstat -g stm command displays the current statemennt cache and the memory usage.

session   30 ---------------------------------------------------------------
 sdblock  heapsz  statement ('*' = Open cursor)
13af1018   47200 * select * from wbPages where ID = 'insart' and path = '/'
and extension = 'html';

session   29 ---------------------------------------------------------------
 sdblock  heapsz  statement ('*' = Open cursor)

session   28 ---------------------------------------------------------------
 sdblock  heapsz  statement ('*' = Open cursor)
13a4d018   12328  EXECUTE FUNCTION webexplode(?::html, ?::html);
13a4d3a8    6144  
13a4d4d8    6144  
13a4d608   12288  

session   27 ---------------------------------------------------------------
 sdblock  heapsz  statement ('*' = Open cursor)
13980018   12328  EXECUTE FUNCTION webexplode(?::html, ?::html);
139803a8    6144  
139804d8    6144  
13980608   12288  

session   26 ---------------------------------------------------------------
 sdblock  heapsz  statement ('*' = Open cursor)

session   24 ---------------------------------------------------------------
 sdblock  heapsz  statement ('*' = Open cursor)
13176018   12328  EXECUTE FUNCTION webexplode(?::html, ?::html);
131763a8    6144  
131764d8    6144  
13176608   12288  

Output Description

Field Description
sdblock Address of the statement descriptor block
heapsz Size of the statement memory heap
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.