RE: Unix Block Size

create a directory tmp

mkdir tmp
ls -l |grep tmp

check the size, that is ur block size.

if oracle block size is 2k and os block size is 8k, minimum allocateble blocks on oracle are 4 always!!
you can experiment this phonemeno by creating a table with 2k as initial extent and then query from dba_tables, you can see 8k as intial extent for the table you have created now!!!

Srini

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rajesh Dayal
Sent: Wednesday, August 02, 2000 5:24 PM To: Multiple recipients of list ORACLE-L 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,

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).