RE: Unix Block Size

Now I have confirmed it from One of the Unix Gurus that the default Unix Block size of DEC Unix is 8K (which is the case right now). One can check it using command

disklabel /dev/rrz9c

But what about the Oracle Block size? Should I go for 8k or not? As I said the Maximum Row length of application's biggest table is not more than 400. Please advice.

        What could be the disadvantages if I still choose 2k/4k ?

Thanks,
Rajesh

-----Original Message-----
From: Rajesh Dayal
Sent: Wednesday, August 02, 2000 2:47 PM To: 'ORACLE-L_at_fatcity.com'
Subject: Unix Block Size

Hi All,

        I know this might have been discussed several times...... But still I would appreciate if some-one could tell me how to check the current Block size in Unix File System. I am on Digital Unix 4.0 D with UFS.

        I guess that the current Unix Block Size is 8K, but Oracle Block size is set to 2K, what are the disadvantages of this (there could rarely be any advantage)?? It's an old installation and I have a chance to rectify the (error in) block size (upgrading from 7.3.4 to 8.1.5). But the maxm avg_row_len is less than 400. Any other specific issues/concerns you would like to forewarn me ???

Appreciate all your replies, Received on Thu Aug 03 2000 - 08:06:54 CDT