1
Download Performance Guide for IBM Informix Dynamic Server
Transcript
Monitoring Memory Utilization Monitoring Memory Utilization Use the following onstat -g arguments to monitor memory utilization. For overall memory information, omit table name, pool name, or session id from the commands that permit those optional parameters. Argument Description ffr pool name | session id Displays free fragments for a pool of shared memory or by session dic table name Displays one line of information for each table cached in the shared-memory dictionary If you provide a specific table name as a parameter, this argument displays internal SQL information about that table. dsc Displays one line of information for each column of distribution statistics cached in the data distribution cache. mem pool name | session id Displays memory statistics for the pools that are associated with a session If you omit pool_name | session id, this argument displays pool information for all sessions. mgm Displays memory grant manager resource information nsc client id Displays shared-memory status by client ID If you omit client id, this argument displays all client status areas. nsd Displays network shared-memory data for poll threads nss session id Displays network shared-memory status by session id If you omit session id, this argument displays all session status areas. prc Displays one line of information for each user-defined routine (SPL routine or external routine written in C or Java programming language) cached in the UDR cache seg Displays shared-memory-segment statistics This argument shows the number and size of all attached segments. (1 of 2) Performance Monitoring 2-13
