可以使用 onstat -g prc 命令显示当前使用 UDR 或 SPL 例程的会话数。
图: onstat -g prc 命令输出
UDR Cache: Number of lists : 31 PC_POOLSIZE : 127 UDR Cache Entries: list id ref drop hits heap_ptr udr name -------------------------------------------------------- 0 80 0 0 702 4c589020 syscdr@amsterdam:.ifx_allow_newline 0 494 1 0 3 4c1e6820 syscdr@amsterdam:.compare 0 219 0 0 2 4bfd1020 syscdr@amsterdam:.streamread 0 297 0 0 8 4bb99020 syscdr@amsterdam:.ifx_checksum 0 134 0 0 10214 4bb5f020 syscdr@amsterdam:.destroy 0 232 0 0 34 4bd62820 syscdr@amsterdam:.cdrcmd 0 364 0 0 1 4c345020 syscdr@amsterdam:.rci_insert 0 180 0 0 1 4bcba020 syscdr@amsterdam:.gist_drop 0 91 0 0 9 4bd2e020 sysha@amsterdam:.rlt_open 0 500 0 0 76 4bb9f020 sysadmin@amsterdam:.admin 0 27 0 0 1478 4c0ec020 sysadmin@amsterdam:.destroy ... Total number of udr entries : 254 Number of entries in use : 9