Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
OBIEE Cache Purge

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
Answers
-
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
0 -
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;
0 -
Hi,
Please check this link if it helps
http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/querycaching.htm#BIESG290
Regards,
Akansh
0 -
check the cache settings on your individual physical tables/aliases in the RPD ... perhaps they were set up to expire daily/hourly/etc
0 -
Thomas, For all the tables the cache options are below:-
0 -
ok good ... so how are you determining that your cache is being purged?
0 -
Based on the .tbl files in the path /appshr/obiee/MW_HOME/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/cache>
0 -
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
0 -
Sure that no one has a cron job somewhere with SAPurgeAllcache() for example?
0 -
Chris, No cron job is scheduled on the server with SAPurgeALLcache(). It is very strange to me. Thanks R
0