How To Clear Cache On A Scheduled Basis In Oracle Analytics Cloud(OAC)
(Doc ID 2406210.1)
Last updated on NOVEMBER 09, 2022
Applies to:Oracle Analytics Cloud - Classic - Version 17.1.3 and later
Oracle Analytics Cloud - Version 105.4.5 and later
Information in this document applies to any platform.
The requirement is to clear the OBIEE Server Cache Files (.TBL files) on a scheduled basis. The following can be done to clear cache on a ad-hoc basis :
Login to DV URL > Console > Issue SQL > call sapurgeallcache();
This will clear all cache files. However using this approach you cannot schedule clearing cache.
Note : This document is applicable to OAC, OAC-Classic and BICS
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document