OBIEE - Query Plan

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs) > OBIEE - Query Processing (What happens when you issue an Logical SQL Request (through Answers for instance) ?

1 - About

The query plan in OBIEE

3 - 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
Advertising