Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Cache purging in OAC
Kanaka Mohan
Rank 3 - Community Apprentice
Summary
Cache purging in OAC
Content
Hello,
How does the cache gets purged in OAC. We want to schedule purging of cache in our oracle managed OAC instance, what are the options available (calling scripts/APIs etc).
Any suggestions?
Thanks,
Kanaka
0
Answers
-
If you ever get an answer I'd like to know too
0 -
To purge the cache manually, use this command in the "Issue Sql" in the Administration Console:
Call SAPurgeAllCache();
* and make sure to uncheck "Use Oracle BI Presentation Services Cache"
There are also additional purging options by DB, table and query... as well as continued reading about developing your cache strategy:
https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/querycaching.htm#BIESG244
0