OBIEE - Query Plan

Bi Server Architecture

About

The query plan in OBIEE

Cache

To disable the query cache plan:

DISABLE_PLAN_CACHE_HIT=1
  • For the whole system, set the MAX_QUERY_PLAN_CACHE_ENTRIES to zero in the nqsconfig.ini
MAX_QUERY_PLAN_CACHE_ENTRIES=0





Discover More
Obiee Initialization Block Caching
OBIEE - All the caches

in OBIEE. Obiee have two main caches mechanisms : The query cache (Bi Server cache) which is a data set cache The presentation server cache (Presentation Server Cache) which is an ODBC data set cache...



Share this page:
Follow us:
Task Runner