Scheduled Cache Purging in OAC

Vinithra B-Oracle

To clear the query cache in OAC, Administrators typically execute the ODBC call "Call SAPurgeAllCache();" from the Classic Analytics home > Administration > Issue SQL page.

To streamline and automate this process without requiring manual intervention, a custom script has been developed. This script, along with the necessary Java libraries, is available as a Zip file in the document mentioned below.

The overall process can be summarized as follows: 

Once the setup is completed, the script can be executed either manually or scheduled for automatic execution at specified intervals using the job-scheduler utilities of the respective operating systems. For a detailed step-by-step guide, please refer to the following video.

Video link: An automated approach to purge the OAC cache

Documentation link: How To Programmatically Clear Cache in Oracle Analytics Cloud(OAC) using JDBC