The onstat -g stm Option

Home | Previous Page | Next Page Administrative Utilities > The onstat Utility > onstat -g Monitoring Options >

The onstat -g stm Option

Displays the memory that each prepared SQL statement uses. To display the memory for only one session, specify the session ID in the onstat -g stm option.

Example Output

Figure 96. onstat -g stm Output

onstat -g stm 65
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 00:26:46 -- 29696 Kbytes
session   65 ----------------------------------------------------------
 sdblock  heapsz  statement ('*' = Open cursor)
 aad8028   16544   SELECT COUNT ( * ) FROM ssc1 WHERE t1_char = ? 
 AND t1_key = ? AND t1_short = ?

Output Description

sdblock: Address of the statement descriptor block
heapsz: Size of the statement memory heap
statement: Query text