Re: Block size issue
From: Hadar Paiss <hpaiss_at_netvision.net.il>
Date: 1996/03/19
Message-ID: <314F9455.246B_at_netvision.net.il>#1/1
Date: 1996/03/19
Message-ID: <314F9455.246B_at_netvision.net.il>#1/1
Darin Strait wrote:
>
> I've got an Oracle 7.1.3.3 Enterprise server running on NT 3.51 SP3.
>
> As far as I can tell, the operating system blocksize for NT is 4KB.
>
> The database was set up with a 2KB blocksize.
>
> How bad is this, and why?
Hi,
The bad side is that you are read unnececery data from the disk into the OS cache, which over write old data and you are loosing time waiting for I/O's to complete.
It is not so bad, especially for small DB which I asume is the case.
In large DB you will be losing the benefits of the OS cache
Hadar Paiss Received on Tue Mar 19 1996 - 00:00:00 CET