Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

All partitions are re-aggregated

979482Feb 27 2013 — edited Mar 1 2013

Hi,

I have a cube that is partitioned on time and I load/aggregate data for the previous day using a view on the fact table and LOAD PRUNE, SOLVE PARALLEL. This works just fine most of the fine and takes about 2 hours to complete.

Sometimes - though - all partitions are re-aggregated and it takes about 2 hours per partition (right now I have 80 partitions so it takes quite some time even if I can run some processes in parallel). I have checked the cube build log if there were any changes to the dimensions but I can't find any.

Is it possible to find out why this re-aggregation occurs from some other log?

Regards /Magnus

Edited by: 976479 on Feb 26, 2013 11:57 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2013

Added on Feb 27 2013

#data-warehousing, #olap

5 comments

576 views