Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12.2.1.4.0 - Can we Cache queries for some analyses only, instead of turning it on Globally
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
Answers
-
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
0 -
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.
0
