My Oracle Support Banner

How To Clear Cache On A Scheduled Basis In Oracle Analytics Cloud(OAC) and BI Cloud Service(BICS) (Doc ID 2406210.1)

Last updated on FEBRUARY 24, 2021

Applies to:

Oracle Analytics Cloud - Classic - Version 17.1.3 and later
Oracle Analytics Cloud - Version 18.2.1 and later
Oracle Business Intelligence Cloud Service - Version 18.1.5 and later
Information in this document applies to any platform.

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('all');

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

Solution

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
Goal
Solution
References

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