C
ChUIMonster
Guest
I disagree with the notion that there is a strong argument for setting RPB to 1 for LOB areas. (I will confess that I used to think this.) That thinking comes from the observation that the LOB can be broken into many pieces the size of a block. So superficially a 1:1 ratio seems like a good idea. But there is also going to be that last bit of the LOB. And that last little bit will probably be a random size (for most data, of course someone will have an example where all the data just happens to be a nice multiple of block size...) For that last bit of the LOB you would benefit from a larger RPB value. Also -- LOB data is stored away from the rest of the record. It isn't mixed with the rest of the record. When you add a LOB field you are asked what storage area to put it in and only the LOB part of the record goes into that area.
Continue reading...
Continue reading...