Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OS Blocksize on different Disks
I believe there should be. Just Oracle writer will cause 8 writes issued
for each block.
Must better improvements can be achieved by checking you have directio enabled on ufs file system or upgrading to Solaris 8 (ufs is much improved there) and Oracle to may be 8.1.7.
HTH,
Sanjay
N.Melchert wrote:
> 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 - 03:23:11 CST