[Info-ingres] Memory Utilisation 98%

Steve s.anderson.au at gmail.com
Wed Sep 23 09:06:14 UTC 2020


On Thursday, September 10, 2020 at 12:32:03 PM UTC+10, Paul White wrote:
> Hi Steve. I would consider reducing DBMS cache. Do you know how to run a DM420 tracepoint which reports statistics for each cache.
> 
> Look at page calls versus hits. I aim for 90% to 95%. If you find a cache with 100% hit rate then it may be a candidate for reduction. And perhaps you have a cache which is not often used also can be reduced.

Thanks Paul. I will experiment with trace point DM420 God willing and see what I can deduce.

Thanks
Steve



More information about the Info-ingres mailing list