3 Replies Latest reply: Apr 18, 2013 9:47 PM by 1004045 RSS

    obiee 10g - schedule to clear cursor cache

    707781
      hi, experts, I applied the command line to clear cache.
      I found that it only clears cache at bi server level (cache entries in rpd).
      it does not clear the cursor cache (those are viewed in Web , Manage Session)
      can I set any schedule to clear cursor cache?
        • 1. Re: obiee 10g - schedule to clear cursor cache
          MKKrishna
          http://gerardnico.com/wiki/dat/obiee/presentation_service_cache
          http://gerardnico.com/wiki/dat/obiee/odbc_function

          Edited by: MK on Apr 21, 2012 9:35 AM
          • 2. Re: obiee 10g - schedule to clear cursor cache
            Satya Ranki Reddy
            Hi,


            OBIEE Cursor Cache clear from Dashboard Java Script
            OBIEE Cursor cache is normally cleared from the Administration - Manage Sessions Screen...

            Here is a way that a piece of java can be embedded into a dashboard and call an xframe so you cant see it being called and clear the OBIEE Cursor cache - Presentation cache in effect.

            1. Just insert a text box into Dashboard - Tick the "Contains HTML Markup"
            2. Paste the script below into the text box

            <script language="javascript">
            document.write(
            "<iframe width=0px height=0px src=" +
            document.location.href.match(/^[^?]+/) +
            "?ManageSessions" +
            document.location.href.match(/&_scid=[^&]+/) +
            "&Action=CloseAllCursors&Done=saw.dll%3fSessions',{ensureFreshUrl:true});return false;')></iframe>"
            );
            </script>

            Voila - when ever you click on the dashboard or refresh it the cursor cache will get cleared.

            Please refer the below links for more information on this.

            What Is Presentation Services Cache In Fact?

            http://prolynxuk.com/blog/?p=496

            how to seed n clear cache of obiee

            http://obiee101.blogspot.in/2008/03/obiee-manage-cache-part-1.html

            How to clear the cache daily automatically

            http://obiee10grevisited.blogspot.in/2012/02/cache-in-obiee.html

            Award points it is useful.

            Thanks,
            Satya
            • 3. Re: obiee 10g - schedule to clear cursor cache
              1004045
              hi,I do it refer your advice, but,it doesn't work. Could you provide a case which includes images to me .
              thanks very much.
              if possible,please post it to my e-mail:512897918@qq.com. thanks again