Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Scheduled Cache Purging in OAC
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