Disable Caching for the System
You can disable caching for the whole
system by setting the ENABLE parameter to NO in the
NQSConfig.INI file and restarting the
Oracle BI Server. Disabling
caching stops all new cache entries
and
stops any new queries from using the existing cache. Disabling caching allows
you to enable it
at
a later time without losing any entries already stored in the cache.
Caching and Cache Persistence Timing for Specified
Physical Tables
You can set a
cachable attribute for each physical table, allowing you to specify if queries
for a that
table will be
added to the cache to answer future queries. If you enable caching for a table,
any query
involving the
table is added to the cache.
[Vikas Arora]:
The NQSConfig.ini – Parameter ENABLE
controls the global level setting. If this is set to NO then even if we set
“Cache Never Expires” for individual tables then also the query that accesses
that table is not cached.
If the ENABLE parameter is set to YES
and then “Cache Never Expires” for individual table is checked then query
accessing the table is cached. The location of cache is mentioned in
NQSConfig.ini in parameter DATA_STORAGE_PATHS.
If
the ENABLE parameter is set to YES and then “Cache Never Expires” for
individual table is not checked then query accessing the table is not
cached.
