This discussion is archived
3 Replies Latest reply: Apr 18, 2013 7:47 PM by 1004045 RSS

obiee 10g - schedule to clear cursor cache

707781 Newbie
Currently Being Moderated
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
    MK Pro
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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