3 Replies Latest reply: Mar 28, 2011 12:42 AM by Aravind Addala RSS

    How to clear the cache daily automatically

    728601
      i have one requirement to clear the cache on the production server daily(at midnight like that).anyone tell the wat are all the ways we can implement the clearence ofn cache in the production server.

      which one is the best way,if there are multiple ways.and how to implement this...


      anybody explain me clearly>..?

      Thanks in Advance....
        • 1. Re: How to clear the cache daily automatically
          833627
          Hi,
          you can clear the cache either by enableing polling table in rpd or by making the cache time persistent.
          You can define a polling table by going to Utilites>Oracle BI Event Tables in the Admin Tool. The polling table monitor any changes in

          the backend database and purge the cache. You can seed the cache at a specified time by the use of ibots. Refer to these links-
          http://gerardnico.com/wiki/dat/obiee/event_table
          http://obiee101.blogspot.com/2008/07/obiee-managing-cache-emptyingpurging.html
          • 2. Re: How to clear the cache daily automatically
            Diney
            Hi User,
            Refer these links
            http://polydata.calpoly.edu/dashboards/obiee_conf/presentations/MigrationCaching.ppt
            http://gerardnico.com/wiki/dat/obiee/query_cache_purging
            • 3. Re: How to clear the cache daily automatically
              Aravind Addala
              Hi User,

              Refer following links for purging cache automatically.

              http://oraclebi.blog.com/automating-cache-purging-without-using-obiee-scheduler/
              http://vivekkulthe.blogspot.com/2008/08/purging-cache-using-ibots.html
              http://obiee101.blogspot.com/2008/07/obiee-managing-cache-emptyingpurging.html

              Thanks
              Aravind