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.

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 video linked below.

Video: An automated approach to purge the OAC cache

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