Re: How configure block-size ?

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.

> To use the installer AND create a database with a size other than the
> default of 2K (other systems default already to 4K) is to edit your
> initx.orc file.
>
> 1. cd $ORACLE_HOME/rdbms/install/rdbms/initx.orc
> 2. vi initx.orc
> 3. add in db_block_size = 8192

        I personally recommend only loading the apps from the installation disk, and creating the db by hand. This allows you to control all the paramaters of the db, which is essential to good future db control. Takes more investigation up front, but when has good foreplanning failed to pay off in the long run?

> Thor HW
> Guido Hansen <hansen_at_omega.gmd.de> wrote in article
> <5r9tjp$u6u_at_omega.gmd.de>...
> > Hallo!
> >
> > Does anybody know how i can create a database with db_block_size = 8 K ?
> > The UNIX-Installer of the ORACLE-Server 7.3.3 uses 2K as default value,
 which
> > is a waste of disk space. So far i couldn't tell the installer to use 8
 K.
> > What must i do to drop the database created by default and create a new
> > database with the right db_block_size manually?
> >
> > thanks for any help
> >
> > Guido
> >
>
>

=Web Site:  http://www.ecst.csuchico.edu/~speck                    =
=email: speck_at_ecst.csuchico.edu or jberryhill_at_cepo.csuchico.edu    =
=                                                                  =
=BASIS Support Team.  College of Business SAP R/3 class Spr 97     =
=	California State University, Chico                         =
=                                                                  =
=  And He looked up and saw the rich putting their gifts into the  =
=treasury.  And He saw also a certain poor widow putting in two    =
=mites.  So He said, "Truly I say to you that this poor widow has  =
=put in more than all;                                             =
=  For all these out of their abundance have                       =
=put in offerings to God, but she out of her poverty put in all    =
=the livelihood that she had."                                     =
====================================================================