2 Replies Latest reply: Jan 5, 2012 3:37 PM by Next Level RSS

    Increasing the data Cache size

    Next Level
      This is the error

      Reading Rule SQL Information For Database [RFP]
      Reading Rules From Rule Object For Database [RFP]
      Parallel dataload enabled: [32] block prepare threads, [32] block write threads.
      Data cache is full. Please increase the data cache size for database [RFP].
      Unexpected Essbase error 1006023

      Increase the data cache size to hold at least 100 blocks.
      If necessary, decrease the block size.
      Ensure that memory is adequate.


      my data Data cache setting (KB)= 3072 kb
      Data cache current value (KB) = 3000 kb

      what is the foumula

      Thanks

      Edited by: Next Level on Jan 5, 2012 12:42 PM

      Edited by: Next Level on Jan 5, 2012 12:46 PM
        • 1. Re: Increasing the data Cache size
          SR
          Read this link for cache settings.

          http://docs.oracle.com/cd/E10530_01/doc/epm.931/html_esb_dbag/frameset.htm?dstcache.htm



          For data cache :

          0.125 * the value of data file cache size. Increase value if any of these conditions exist:

          1.Many concurrent users are accessing different data blocks.
          2.Calculation scripts contain functions on sparse ranges, and the functions require all members of a range to be in memory (for example, when using @RANK and @RANGE).

          Edited by: Sundeep on Jan 5, 2012 1:05 PM
          • 2. Re: Increasing the data Cache size
            Next Level
            Thanks