Automation of clearing cache in Oracle BICS

Maddina Mallikarjuna

Summary

Automation of clearing cache in Oracle BICS

Content

Hi Team,

We have a requirement to clear the cache automatically in Oracle Business Intelligence Cloud Services( Oracle BICS).

Please let me know is there any automated scripts or documents to clearing the cache in automated way.

Thanks,

Mallikarjuna

[Deleted User]

It's a command. So you can call it. So you can script it. So you can schedule it. Not seeing the problem here.

[Deleted User]

https://docs.oracle.com/en/cloud/paas/bi-cloud/bicap/toc.htm

---> https://docs.oracle.com/en/cloud/paas/bi-cloud/bicap/Clearing%20Cached%20Data.html

Maddina Mallikarjuna

Thanks Berg for your reply.

REST API need Curl command line interface to run the API to clear the cache.This process involves manual effort.

We would be looking an automated process to clear the cache.Let me know if you have any thoughts on automate process.

Thanks,

Mallikarjuna

[Deleted User]

Let me google that for you... https://stackoverflow.com/questions/8318678/how-to-use-curl-in-a-shell-script

You put it in a shell and then create a cron job. Same concept works for Windows. It's just code not magic pixie dust.

Maddina Mallikarjuna

Hello Berg,Could you please help me with the scheduling code using API command.

Thank you very much in advance for your help.

Thanks,

Mallikarjuna