OBIEE Cache Monitoring

Question

Hi All,

Oracle Business Intelligence 12.2.1.1.0

Microsoft Windows x64 (64-bit)

We are using event polling for majority of the subject areas and cache persistance time for a few others. Sometimes these don't work as expected, thus leaving stale cache entries. Is there a way in which we can monitor the cache apart from manually going to RPD online ? We plan to include this as part of the daily process checklist to make sure user see the correct data.

Thanks

Ebin

Ebin Cherian · Answer

Hi Robert,

Yes, I have seen that link. But it didn't help. Our Cache Strategy is working fine most of the time... it failed few time. So we want to take corrective action whenever cache purge failed. I was wondering there is any way to capture the information in Manage cache in obiee rpd.

Robert Angel · Answer

Have you seen =>

https://www.rittmanmead.com/blog/2015/09/obiee-bi-server-cache-management-strategies/

Ebin Cherian · Answer

Hi Joel,

Thanks for the reply. I am not looking at the cache hit of the query. I am looking for a way to make sure cache is not stale. We had instances in past where event polling table and cache persistence time doesn't clear all the cache.

Thanks!