Re: How configure block-size ?

From: Thor HW <thor_at_echidna.net>
Date: 1997/08/06
Message-ID: <01bca2bd$3b7fef50$c570248e@thor_hw>#1/1

Hmmm... thought I'd responded to the group.

Jason Berryhill <speck_at_ecst.csuchico.edu> wrote in article <Pine.HPP.3.95.970728090952.16371A-100000_at_yosemite.ecst.csuchico.edu>...
> On 25 Jul 1997, Thor HW wrote:
>
> > Using a 2K blocksize is not a waste of disk ... your disks probably
have
> > the standard 512B blocksize anyways ....
>
> Using a 2K blocksize IS a waste of disk space. Each oracle block has a
> header for oracle's own use which is roughly 2K is size for a 4K
> blocksize and 1K for the 2K block size. This header size is relatively
> static for 4K block sizes and up. Therefore with a 2K block size, there
> is 50% overhead in storage. With an 8K block size, the header comprises
> 25% overhead. It is not hard to see the space savings.
These estimates do not seem to jive with the Oracle documentation. You could see some of this as a result of poor choices for PCTUSED/PCTFREE. There is some fixed overhead per block ... but not 50%!!! Thor HW Received on Wed Aug 06 1997 - 00:00:00 CDT