Friday, June 22, 2012

Presentation Server Cache in OBIEE

Presentation Server  has its own cache, stores the result set of queries in that cache. When the user requests any query, and if the query is similar to the one which is stored in cache memory, then the Presentation Server will retrieve the result for this query  from the cache and return the result to the user without contacting the BI Server. This improves the query response time, eliminates BI server processing time.

The files for the Presentation Services cache:
  • Have names such as nQS_xxxx_x_xxxxxx.TMP.
  • Are stored in the following directory:
         C:\OracleBIData\tmp
Refer the following link to know more about the presentation cache : 

No comments:

Post a Comment

Thanks for your comment.