Re: How configure block-size ?

From: SatarNag <satarnag_at_aol.com>
Date: 1997/08/06
Message-ID: <19970806181201.OAA12340@ladder02.news.aol.com>#1/1

>An Oracle instructor told me to ALWAYS use 8k blocks for best
>performance.

>If there is some unknown-hidden-special-secret command available to
>change the block size without re-creating the database, please share it
>with all of us. Thanks.
>
>Kirk Lashbrook

Kirk,
I was mistaken about being able to change the DB_block_size, there is no way of doing it without re-creating the database.

As far as determining the size of your DB_Block_Size, it is recommended to keep it at least equal to your OS block size. If you are running a data warehouse database, then keep the block size fairly large, with little free space.

Satar Naghshineh Received on Wed Aug 06 1997 - 00:00:00 CDT