Cache purging in OAC

Question

Summary

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

User_6K1A3 · Answer

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

Brian666H · Answer

If you ever get an answer I'd like to know too