OAC/OAAC : How To Clear Cache Files On A Scheduled Basis In Oracle Analytics Cloud Service(OAC) and Autonomous OAC (OAAC) (Doc ID 2406210.1)

Last updated on DECEMBER 07, 2018

Applies to:

Goal

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.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.