Data Cache Hitrate
we are using MaxDB 7.5.00.32 on SLES 9 with 4.6.c. (All 64bit)
Our Data Cache Hitrate is decreasing from 99,5% to 97,3% during an 3/4 Year.
The Cache_Size is currently set to 505,41 MB.
There are up to 250 Users on this System. Database Size 65GB.
Unicode = No.
What are some real World Values for the Data_Cache for a DB like this?
I can increase the Data_Cache without any Problem. We have enough Memory free.
I just want to share some experiences. Maybe s.o.is using 1GB Cache for an DB Instance with the same size. =)