| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How configure block-size ?
On 25 Jul 1997 12:02:33 +0200, hansen_at_omega.gmd.de (Guido Hansen) wrote:
>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
If you are using the installer to create databases, then you can edit the files in $ORACLE_HOME/rdbms/install/rdbms. In particular, you can change the initx.orc file which is used to build the init$ORACLE_SID.ora file. If you edit this and add
db_block_size = 8192
to the end of it, all new databases created with the installer will have an 8k block instead of the default 2k block.
the other files of interest might be crdb.orc and crdb2.orc. They are templates used to create databases. You can change other defaults in the create database statement in these as well as configure what scripts run during the database create.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |