Re: DB_BLOCK_SIZE --- How ??

You can't change DB_BLOCK_SIZE after a database has been created. It must be done before. However, most of the install scripts make a (not well set up) default database called ORCL. This is not really suitable for the real world because DB_BLOCK_SIZE is wrong, everything is likely to be on the same disk (not a good idea if a head crash happens), all objects default to the system tablespace (not a good idea - much better to create tablespaces for rollback segements, users, temp etc.). Anyway, for all these reasons, it's better to make a proper DB after the installation is done.

If you do this, before making the DB, it is customary to copy the INITxxxx.ORA file to INITnewdb.ORA and edit the parameters. In this case, I would change DB_BLOCK_SIZE to be 4 or 8 or 16k, set the DB to do automatic archiving etc., then run the create database command in SVRMGRxx, or use one of the GUI tools to accomplish the same thing.

--
Steve Jones
stevej_at_getridofthisproact.net
Johnson <syner_at_pd.jaring.my> wrote in message
news:8h2kmg$era$1_at_news4.jaring.my...


> Hello,

>

> How am I going to make this DB_BLOCK_SIZE to 16K in windows NT server.

> During install, the database ORCL is created and the db_block_size is

> default to 1k.

>

> Do I change db_block_size during Oracle Installation or after the

> installation. How ??

>

>

>

>