What are the pros and cons of using a non-default block size for NTFS partitions? I am configuring NT as an application server to run Oracle and in Oracle I can control the database block size (2K, 4K, 8K, 16K, etc.) but it must be the same for the entire database, even if there are different sized drives. I suspect that response times will be best if both NT and Oracle use the same size blocks. I have read that the default block size in NT is 1/1,000,000 of the partition size (2K for 2gig, 4K for 4gig, etc.). I would like to use 4K blocks on 9gig partitions. Is this possible/advisable?
I am willing to give more points for a good answer, and/or to give credit to multiple responses.