Cache purging in OAC

Kanaka Mohan

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

Brian666H

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

User_6K1A3

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