Re: What blocksize?

From: Jared Hecker <jhecker_at_iago.nac.net>
Date: Tue, 24 Aug 1999 14:50:39 GMT
Message-ID: <3jyw3.1132$3B4.95589@nntp1>

Oracle reads five blocks at a time - so doubling your block size, while potentially wasting some space, allowed it to process more in one read. Important for batch processing.

In comp.databases.oracle.server Kenneth C Stahl <BluesSax_at_Unforgettable.com> wrote:

> At some point it was decided that that our application should use the same
> block size as other Oracle 7.3 instances in the data center so we exported the
> data and rebuilt the database using a 4096 blocksize and everything else
> remaining basically the same. We then found that the time that it took to run
> the monthly cycle was about 60% of what it had been before - and the only thing
> that had really changed was the block size.

Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **

Received on Tue Aug 24 1999 - 09:50:39 CDT