0 Replies Latest reply: Jul 8, 2012 10:04 PM by 948099 RSS

    how to config the parameter MAX_QUERY_PLAN_CACHE_ENTRY_SIZE?

      Dear BIEE experts,
      We're delivering a biee project which front query sql is relative complex and large (nearly about 2M), much time is cost for complianation.
      Since we have enough memory to cache the logical sql's query plan, we intend to do that. While we met below problems:

      1.if the MAX_QUERY_PLAN_CACHE_ENTRY_SIZE is still supported? I found it in the latest doc(http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/configfileref.htm#CACECAFJ) , while the other doc(http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/configfileref.htm#CACIDJIA) doesn't mention it all.

      And related question is in which version BIEE it is supported? I can't find the default value in my NQSconfig.INI file:(. Can I just add a new line of it and work? My BIEE version is 11g.

      2. How to set the value? is't int type or string type? Can I just set it as below:
      or some other int type like 1,2 ...means different cache sizes?

      Eagering for your experts' suggestions and thanks in advance!

      best regards,