OBIEE 12.2.1.4.0 - Can we Cache queries for some analyses only, instead of turning it on Globally

3822729 May 8, 2019 9:04 PM

Helllo Experts,

We have OBIEE 12.2.1.4.0 installed on Linux. A vast majority of our system contains Dashboards using one or many analyses on each of the dashboard pages. We are trying to explore options to improve the performance of the dashboards in terms of response times. Is it possible to configure query caching for a handful of heavy duty analyses, instead of having the cache ON globally ? Can we just seed the query cache only for a select few analyses ? Can you please advise or suggest , if possible , how to do it ?

Thank You.

Rakesh

1. Re: OBIEE 12.2.1.4.0 - Can we Cache queries for some analyses only, instead of turning it on Globally

Joel Acha May 9, 2019 7:33 AM (in response to 3822729)

You can use an agent to seed the query of a specific analysis in cache:

https://docs.oracle.com/middleware/1221/biee/BIESG/querycaching.htm#BIESG290
Like Show 0 Likes(0)

Actions
2. Re: OBIEE 12.2.1.4.0 - Can we Cache queries for some analyses only, instead of turning it on Globally

3822729 May 9, 2019 6:32 PM (in response to Joel Acha)

Thanks Joel. Appreciate your help.

i have follow-up question - Can I seed the query cache while having the ENABLED flag set to NO ? If it is YES, then the space allocation will be used by all queries, which we are trying to avoid as we only want to cache those huge analyses where we can see tangible performance gains. Please advise.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.