Thanks Joel. Appreciate your help.
i have follow-up question - Can I seed the query cache while having the ENABLED flag set to NO ? If it is YES, then the space allocation will be used by all queries, which we are trying to avoid as we only want to cache those huge analyses where we can see tangible performance gains. Please advise.