Categories
Guidelines for Cache

Hello Expert,
We have been facing some issues with our Analytics. We have been observing some difference in Numbers while running dashboards after ETL refresh. It is not consistent for same Users running different time. We have got feedback from Technical support team that it is because of Cache. I just went through article and could see we have defined row level security as per Oracle guidelines. So wondering what are standard practice for cache?
Do we need to clear cache after every database refresh? and why? are there are standard documentation or check list for cache configuration which we can refer?
I have gone through document - Work With Row-Level Security. Thank you so much in advance.
Thank you
Best Answer
-
Hi Mangesh @User123456usa ,
You can review the following:
How To Programmatically Clear Cache in Oracle Analytics Cloud(OAC) using JDBC [Video Content] KB59916
Additionally, an Ideas Lab request (enhancement) can be up-voted and commented on
https://community.oracle.com/products/oracleanalytics/discussion/20955/oac-auto-cache-purge/p11
Answers
-
As part of your final ETL steps you should consider clearing the cache. Eg:
SAPurgeAllCache
There are some articles you can read that have details on the topic, eg
In the above Robin shows an example of adding the clear cache to the ODI ETL.
2 -
Thank you for response. I was hoping there is better cache management in OACS compare to OBIEE. If we clear cache every time after ETL, may impact on performance. So seems to be there is no way getting accurate data with speed. Thank you again.
0 -
The tools you need to address both concerns are at your fingertips.
The data consistency with clearing the cache, and the performance with seeding it.
2