Skip to Main Content

Analytics 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!

Increase in essbase database size - no increase in number of blocks - Is this normal

user11256924Jan 9 2015 — edited Jan 13 2015

In my current project, we are seeing weird database size expansion issue on essbase in production, the size of the cube is increasing by almost 1 GB/day and we are performing defragmentation every weekend. As a test, we ran one of the consolidation scripts ( A planning business rule) on the test application, there was no activity on this cube except for script run and we noticed that the pag file size was increasing with each number even though there was no difference in the number of level 0 blocks and upper level blocks. Is the page file size increase happening due to fragmentation? Is this normal behaviour? Any help is appreciated.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2015
Added on Jan 9 2015
7 comments
1,941 views