Disable Cache on Query Level

When testing it is often useful to disable the Cache in order to avoid Cache Hits and to see the SQL Generated by the BI Server. This can be achieved with the following code placed in the advanced Tab of BI Ansers 11g in the Prefix of the SQL Area:

SET VARIABLE DISABLE_CACHE_HIT=1;

Advertisements