728x90
Problem(Abstract)
You may noticed a difference in amount of memory usage between 'onstat -g seg' and 'onstat -g mem' command outputs. For example; the virtual portion of memory in 'onstat -g seg' is showing about 4GB of memory used, but total of all the memory pools shown by 'onstat -g mem' is only about 1GB in virtual pools.
Cause
You cannot directly compare 'onstat -g seg' with 'onstat -g mem' for virtual memory usage. The 'onstat -g mem' output provides only memory pool information where as the virtual portion of shared memory for the database server includes the following components:
- Large buffers, which are used for large read and write I/O operations
- Sort-space pools
- Active thread-control blocks, stacks, and heaps
- User-session data
- Caches for SQL statements, data-dictionary information, and user-defined routines
- A global pool for network-interface message buffers and other information
http://www-01.ibm.com/support/docview.wss?uid=swg21655248&myns=swgimgmt&mynp=OCSSGU8G&mync=E
728x90
'Informix > informix reference' 카테고리의 다른 글
killed(MCMD_KILL) (0) | 2013.11.16 |
---|---|
Monitor Resource Contention (0) | 2013.11.16 |
How to rename chunks of current instance using external restore (0) | 2013.11.16 |
Verifying the last UPDATE STATISTICS executed with data distribution for a table using SQL (0) | 2013.09.26 |
How to retrieve when and for which columns the distributions were last built. (0) | 2013.09.26 |