Monitoring VP_MEMORY_CACHE_KB effectiveness

Hi folks! Does anybody knows where can I find an official document (or an IIUG presentation) that shows how to set and monitor "onstat -g vpcache" effectiveness?? Thanks in advance, Alberto.

The only tunable for this is the VP_MEMORY_CACHE_KB, the number of KB of memory to be retained by each CPU VP from the central pool between queries. This parameter and its usage are reported by onstat -g vpvache. The value is shown as: Number of <cpu memory block size> byte memory blocks requested for each CPU VP: <n> The vpu memory block size is usually 4096 bytes and is reported on the first line of the onstat report. The number reported is the number of such blocks. So on my server I have configured: VP_MEMORY_CACHE_KB 4095 onstat -g vpcache reports:CPU VP memory block cache statistics - 4096 byte blocks Number of 4096 byte memory blocks requested for each CPU VP:256 vpid pid Blocks held Hit percentage Free cache 1 1837 268 89.3 % 91.8 % Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Dec 27, 2012 at 12:03 PM, ALBERTO ROMEU PESSONIO FILHO < arfilho@orizonbrasil.com.br> wrote: > Hi folks! > > Does anybody knows where can I find an official document (or an IIUG > presentation) that shows how to set and monitor "onstat -g vpcache" > effectiveness?? > > Thanks in advance, > Alberto. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d0447f05e96af2104d1d8af87