|Multiple Block Sizes - Improve efficiency by having multiple block sizes that relate more closely to the operations that are being performed.|
Arindam Mukherjee said...The portrayal is good enough albeit I think it would be more rich and enthralling if some live example like init.ora file contents were illustrated to take the essence fully.
Anyway thanks for your effort.
As requested, I've added a complete example.
I want to implement for my large indexes to be 32k block size, how do we test it
Tim... said...Create the 32K cache. Create a tablespace with a 32K block size. Create the index within the new tablespace. Once this is doen run your system and see if it improves performance.
PS. It's best to ask these sort of questions on the forum. The comments are really for comments on the article contents.
Ronald Brayan said...Hi Tim,
Indeed it is a good article. Definately it will help the DBA. But, it could be more interesting if you could explain with few examples.
There is an example at the end of the article. I'm not sure what else I can explain about this subject.