Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How configure block-size ?

Re: How configure block-size ?

From: Thor HW <thor_at_echidna.net>
Date: 1997/07/25
Message-ID: <01bc9966$c1da62c0$c570248e@thor_hw>#1/1

Using a 2K blocksize is not a waste of disk ... your disks probably have the standard 512B blocksize anyways ....

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

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
>
Received on Fri Jul 25 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US