1 – Introducion
This topic is meant to fully understand the OBIEE 10g cache mechanism.
The cache funcionalities provided by OBIEE 10g should be used in a production environment; in a development environment we usually want to see data changing whenever we modify data in the data source; for this reason, cache settings will be different for each environment.
2 – OBIEE 10g Server Cache Settings
The Server chache is activated by default when you installed OBIEE 10g; cached items correspond to files in the filesystem.
Obviously we can define the amount of space to be dedicated to this files by editing the <OBIEE_HOME>\OracleBI\server\Config\NQSConfig.INI file, changing the following parameter:
DATA_STORAGE_PATHS = “D:\oracle\product\10.1.3.4.1\OracleBIData\cache” 5000 MB;
We can also change the directory path for the cache files; if we take a look to the cache directory, we will find several files with a .TBL extension.
