RE: Unix Block Size

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Fri, 4 Aug 2000 03:58:45 +1000
Message-Id: <10578.113769@fatcity.com>

Hi Rajesh,

The database block size should ALWAYS be 8K on ALL Unix operating systems unless raw datafiles or QuickIO are being used. The main problem with doing otherwise is "partial block writes". Please see my web site for details.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

-----Original Message-----

From: Rajesh Dayal [mailto:Rajesh_at_ohitelecom.com] Sent: Friday, 4 August 2000 0:13
To: Multiple recipients of list ORACLE-L Subject: 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-----

Sent: Wednesday, August 02, 2000 2:47 PM To: 'ORACLE-L_at_fatcity.com'

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,

Greets,

Rajesh
--

Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Aug 03 2000 - 12:58:45 CDT