OBIEE Queries cache hit or cache seeding can be simply disable by prefixing a clause setting a variable value in the logical SQL of the query. Logical SVP Prefix clauses can be added or edited at the bottom of the Advanced Tab of the AdHoc Query.
Cache functionality must be enabled in the system (WLS EM page) for this example to fully work.
DISABLE_CACHE_HIT = 1
DISABLE_CACHE_SEED = 1;
Thanks,
Sandeep Venu
0 comments:
Post a Comment