cancel
Showing results for 
Search instead for 
Did you mean: 

Catalog Cache Hit rate is going low as 45% in production system

former_member309586
Participant
0 Kudos
106

Hi Guru,

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,

Rajesh Kumar

View Entire Topic
DavidLY
Advisor
Advisor
0 Kudos

Hello,

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?

Regards,

David