This discussion is archived
2 Replies Latest reply: Jan 5, 2012 1:37 PM by Next Level RSS

Increasing the data Cache size

Next Level Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points