Automation of clearing cache in Oracle BICS

Maddina Mallikarjuna · Jun 29, 2017 7:00AM

Summary

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] · Jun 29, 2017 7:00AM

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] · Jun 29, 2017 7:00AM

Maddina Mallikarjuna · Jun 29, 2017 7:00AM

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] · Jun 30, 2017 7:00AM

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 · Jun 30, 2017 7:00AM

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