So we have created a ram disk and you are now storing the repository cache, how can we automate the purging. 1. First we will create a file that we can run that will 1st load the BI environment, then we will clear the cache : - Create a file called purge.txt with the following contents: Call SAPurgeAllCache(); - Create a file called purge.sh with the following contents cd /u01/app/oracle/product/fmw/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup . ./bi-init.sh cd /u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin ./nqcmd -d "AnalyticsWeb" -uweblogic –p<place the password here> -s/home/oracle/TT_INSTALLERS/purge.txt 2. Update crontab to execute the file everyday: 00 23 * * * /home/oracle/TT_INSTALLERS/purge.sh > /home/oracle/TT_INSTALLERS/purged.log 2>&1 You now have automated purging of your cache.