The onstat -g prc Option

The onstat -g prc option prints the number of sessions currently using the UDR or SPL routine.

Example Output

Figure 80. onstat -g prc Output

IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 01:59:00 -- 101376 Kbytes
Stored Procedure Cache: 
    Number of lists        : 31
    PC_POOLSIZE            : 50
    Number of entries        : 0
    Number of inuse entries    : 0
Stored Procedure Cache Entries: 
list#  id  ref_cnt   dropped?   heap_ptr     procedure name
--------------------------------------------------------------
Stored Procedure Cache is empty.