What confuses me is, that the Data Cache size is only ~32GB and that there are 34'796 MB assigned to "Misc". Has anybody an idea what kind of cache "Misc." is or how I can assign more memory to the Data Cache? Is there a maximum limit of 32GB for the Data cache?

Thanks for the quick response. The question is, why the Data Cache size is "only" 32GB although CacheMemorySize is set to 66GB. In this document (as well as in all others I've seen) the Data Cache is always the biggest part of the I/O Buffer Cache. For my LiveCache DB the "Misc." part is even bigger than the Data Cache size and Data Cache is only about half of the I/O Buffer Cache.

The way that the memory gets utilized is a function of the processes accessing livecache, so there's nothing technically "wrong" with how the memory is being allocated. I've seen customer situations where the Catalog cache is 3x the the data cache regularly for example as well as a current system where the Other or Miscellaneous cache is larger than the data cache. From a basis standpoint, as long as your hit rates are good (>=96-97%) that's what you're after.

The Catalog Cache size can be customized manually (CAT_CACHE_SUPPLY) which may be the reason why you've seen databases where the Catalog Cache is 3x the data cache.

The ammount of memory assigned to "Misc" and the fact that the Data Cache size is not growing beyond 32GB doesn't give me the feeling that there's nothing techincally "wrong". It appears that ~33GB of the I/O Buffer Cache are not used at all...

The Data Cache occupancy reaches 100% from time to time and is constantly >95%. So there are good reasons for the DB to occupy more than 32GB Data Cache. The Cache Hit Ratio is ~99.9%, but that's not my question...

The initial question was and still is, why "only" 32GB Data Cache out of 66GB I/O Buffer Size are assigned and what kind of "Misc" Cache(s) are using ~34GB of memory.