Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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