title: How to clear OBIEE cursor cache (presentation server)
body: <p>I'm having an issue with a prompt in OBIEE 10g, such that it displays old database value due to the prompt query being serviced from cursor cache (presentation service). For example, if the prompt drop-down shows 1 value initially since there is 1 database row and when i delete this row from database, the prompt still shows the same database value unless i manually delete the cursor cache through analytics
  <em><strong>Setting &gt; Administration &gt; Manage sessions &gt; clear cache/cursors</strong></em></p>
  <p>Tried checking OBIEE presentation service config file <em><strong>instanceconfig.xml</strong></em>, however there is no such parameter to permanently disable this cache. I referenced the following link, <a href="http://gerardnico.com/wiki/dat/obiee/presentation_service_cache" rel="nofollow noreferrer">OBIEE 10G/11G - Presentation Service (Query|Result|Cursor) Cache</a></p>
  <p>Resetting these parameters didn't seem to have any impact on the cursor cache, these are still getting generated and are not cleared after the timeouts set. (I have restarted the OBIEE services after changing these parameters). Am I missing something here.</p>
  <p>Would appreciate any pointers to get this done i.e. getting cursor cache cleared/disabled without manual intervention as mentioned above (through Settings &gt; Administration).</p>