OS Blocksize on different Disks

From: N.Melchert <nico_hu_at_yahoo.com>
Date: 4 Apr 2002 23:58:24 -0800
Message-ID: <50518d38.0204042358.4e65e91b@posting.google.com>

Hi,
following circumstances:
big Oracle 8.0.6 DB (180GB), on different ufs formatted Drives (each 7 Gig) on Solaris 7.
But two of those drives are formatted in a different way and several datafiles of the biggest TS reside over the "right" formatted and the "wrong" formatted drives.
Wright means, they have the same Physical Block size and Oracle Block size (8k) The two disks that are formatted "wrong" have only physically 1K Blocks.

e.g.:
Oracle Block size is set to 8k

HD       Formatted   Tablespace/Datafile
         blocksize
-----------------------------------------------
drive1   8K          Tablespace1_datafile1
drive1   8K          Tablespace2_datafile1
drive2   1K          Tablespace1_datafile2
drive2   1K          Tablespace2_datafile2

Does this have a serious impact on performance ? Searched the web for this and found absolutely nothing - please help.

Thanx in advance
Nicolas

nico_hu_at_yahoo.com Received on Fri Apr 05 2002 - 01:58:24 CST