Skip to Content
0
Former Member
Jan 10, 2011 at 09:17 AM

Rule of thumb for CACHE_SIZE

33 Views

Hi all,

I do have a system outsourced, where the DB (MAXDB 7.6.05) runs on a single SLES 10 server.

This server has got 16 GB RAM. The CACHE_SIZE is configured to 20 GB (2500000 pages) and a top shows me, that from the 40 GB swap 20 GB are used (file system cache is so low, that it can be ignored) ... and swapd runs with at least 6% CPU all the time.

Is this a good situation? Not for me! Does anybody have a rule of thumb for CACHE_SIZE?

I would say 75 % of RAM should be the highest value... any othe suggestion?

Thank you!

Christian