BLOCK SIZE QUESTION

My question is as follows:

Our application has a couple (4) of very big tables of which 2 are almost always querried by indexes. The other 2 are first under heavy fire of inserts (10 million) and updates (couple of million) and accordingly used for frequent querrying to check data againt other data previously acquirred data.
This querying of indexes I can almost certainly guarantee is pinpointing in blocks squattered all over the disk (using read 0). Currently we are using an Oracle blocksize of 8K and a NT disk blocksize of 4K with a striping size of 16K.

Is there anyone who can tell me what the result will be when I make the Oracle blocksize 2K?
And would it be usefull to also adjust the NT disk blocksize even when we can't change the stripe size?

As I look at things, I will have more blocks in memory (available 350MB) and frequently used blocks will be longer in memory than others. Rigth??

When doing lots of insert I quess reducing the Oracle/NT blocksize migth also be a bad idea or not??

Any help is appreciated.

John Received on Fri Jun 05 1998 - 16:37:00 CDT