Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Cache Purge

Received Response
301
Views
29
Comments
Rank 5 - Community Champion

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

Welcome!

It looks like you're new here. Sign in or register to get started.
«13

Answers

  • Rank 4 - Community Specialist

    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

  • Rank 5 - Community Champion

    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;

  • Rank 4 - Community Specialist

    Hi,

    Please check this link if it helps

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

    Regards,

    Akansh

  • Rank 8 - Analytics Strategist

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

  • Rank 5 - Community Champion

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

    cache.PNG

  • Rank 8 - Analytics Strategist

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

  • Rank 5 - Community Champion

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

  • Rank 5 - Community Champion

    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

  • Rank 10 - Analytics Guru

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

  • Rank 5 - Community Champion

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

Welcome!

It looks like you're new here. Sign in or register to get started.