Re: What blocksize?

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 **