This discussion is archived
5 Replies Latest reply: Sep 4, 2013 3:24 PM by user12268822 RSS

Database Restructure ignoring NUMBLOCKSTOEXTEND Configuration Setting

user12268822 Newbie
Currently Being Moderated

The default value for NUMBLOCKSTOEXTEND is 2048. I've set it to 1 for the purpose of testing how the cube will respond to various operations.

 

I loaded data to one block in my cube and the PAG file size is just a little larger than the 1 block size. However, when I restructure the database, the PAG file size grows to accommodate 2048 blocks. So it seems that the NUMBLOCKSTOEXTEND is being ignored by the explicit dense restructure.

 

Can anyone confirm that this is expected behavior and whether or not it's intended to be so?

 

I'm using version 11.1.2.2

Legend

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