About
The query plan in OBIEE
Articles Related
Cache
To disable the query cache plan:
- For on query or session, you can set the following system session variable to 1
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