Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Cache Monitoring
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
Answers
-
The Usage Tracking tables have a cache flag (S_NQ_ACCT.CACHE_IND_FLAG) to indicate whether a query ran from cache.
0 -
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!
0 -
-
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.
0
