OBIEE Cache Purge

7688438

Hi All, OBIEE-Oracle Business Intelligence Product Version 11.1.1.7.150120 (Build 150111.1659 64-bit) Our cache files are purging automatically.we did not purged cache.no other automated program is purging it. Based on what basis it purges usually ? please give some inputs... Presentation services cache: /appshr/obiee/MW_HOME/instances/instance1/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/obis_temp BI server cache:- /appshr/obiee/MW_HOME/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/cache Thanks R

AkanshAgarwal

Hi,

The Presentation services cache is a run time cache. It will clear automatically when the report is rendered.

Presentation services cache: /appshr/obiee/MW_HOME/instances/instance1/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/obis_temp

Regards,

Akansh Agarwal

7688438

Akansh, thanks for your response.! What about BI server cache?We are not purging it manually and we don't have any program to purge it.But all the files in /appshr/obiee/MW_HOME/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/cache ...are purging.. Is the based on some capacity? the below is our nqsconfig.ini(cache section).. [CACHE] ENABLE = YES;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control # A comma separated list of pair(s). # These are relative to the process instance directory. #  e.g. DATA_STORAGE_PATHS = "nQSCache" 500 MB; #  resolves to #  $(ORACLE_INSTANCE)/bifoundation/OracleBIServerComponent//nQSCache DATA_STORAGE_PATHS = "cache" 500 MB;  MAX_ROWS_PER_CACHE_ENTRY = 100000;  # 0 is unlimited size MAX_CACHE_ENTRY_SIZE = 40 MB;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control MAX_CACHE_ENTRIES = 2000;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control POPULATE_AGGREGATE_ROLLUP_HITS = NO;  USE_ADVANCED_HIT_DETECTION = NO;  MAX_SUBEXPR_SEARCH_DEPTH = 7;  DISABLE_SUBREQUEST_CACHING = NO;  #Cache file buffer size.Default is 128 KB CACHE_FILE_BUFFER_SIZE = 128 KB;  # Cluster-aware cache. # Note that since this is a network share, the directory should not be # relative. GLOBAL_CACHE_STORAGE_PATH = "" 0 MB;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control MAX_GLOBAL_CACHE_ENTRIES = 1000;  CACHE_POLL_SECONDS = 300;  CLUSTER_AWARE_CACHE_LOGGING = NO;

AkanshAgarwal

Hi,

Please check this link if it helps

http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/querycaching.htm#BIESG290

Regards,

Akansh

Thomas Dodds

check the cache settings on your individual physical tables/aliases in the RPD ... perhaps they were set up to expire daily/hourly/etc

7688438

Thomas, For all the tables the cache options are below:-

Thomas Dodds

ok good ... so how are you determining that your cache is being purged?

7688438

Based on the .tbl files in the path /appshr/obiee/MW_HOME/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/cache>

7688438

Thomas, Why did the above .tbl files purged? 1)We did not purged manually. 2)We don't have any automated program to purge these .tbl files Thanks R

[Deleted User]

Sure that no one has a cron job somewhere with SAPurgeAllcache() for example?

7688438

Chris, No cron job is scheduled on the server with SAPurgeALLcache(). It is very strange to me. Thanks R