Access to the BI Server cache content

Jean-Pierre Hoedenaeken

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

RTBF

Description (Required):

We need the same function as the one that exist in OBIEE 11g. When opening the RPD on-line, the menu item Tools / Manage Cache gives us the ability to view and manage the cache content.

Use Case and Business Need (Required):

When we load the cache with an Agent, we need to control the cache content when the result is not the one expected

Enhancement Request / Service Request:

Pravin Janardanam-Oracle

Thank you for sharing this idea. If you are seeing stale data, there are a few options to purge cache without having to see the list of cache entries. You can purge the cache by query, table, database or purge all cache. You can find more details here.

https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-FFBB9B88-29D5-4572-A08D-D55062633B1F.htm#purging_cache_using_odbc

Please let us know if there is a use case to see all cache entries in the system if the primary objective is to clear the stale cache for the concerned query or table.