Re: How configure block-size ?

Additional note:

Once the database has been created do not change this setting in the init.ora file. The only way to change
this setting after DB creation is to export the database recreate your DB then reimport. This is assuming you
have data which you do not which to lose.

Greg Vitetzakis
DBA. 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.
>
> > 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." =
> ====================================================================
>
>
Received on Wed Jul 30 1997 - 00:00:00 CDT