Catalog Cache Hit rate is going low as 45% in production system
I see CAT_CACHE_SUPPLY is 10000 and i see MAX USER =90. I still see alerts that hit rate is going down to 45%.
Memory is good enough and i see occupancy is only 2% which is good.
Please suggest if anyone have any idea which will be helpful.
Thanks & Regards,
David Liu replied
The catalog cache holds user specific and global data from the database
catalog. Data is pushed aside from the catalog cache to the data
cache. For this reason the catalog cache hitrate is not so important,
as long as the data cache hitrate is around 99%.
Do you experience any performance issues?