This discussion is archived
3 Replies Latest reply: Mar 27, 2011 10:40 PM by Diney RSS

How to clear the cache daily automatically

728601 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points