Re: How to set block size during DB creation??

Paul

Yes you can change the block size with DBCA. I think you need to do a custom install to allow this, though.

Optimal block size really is dependent on your system. 2K is still the appalling default, most OLTP systems are built with 4 or 8K and most DSS with 16 or 32K.

HTH. Pete

Paul Woods wrote:

> I am using Oracle 8i on NT. My understanding is that DB_BLOCK_SIZE must be
> set at the time of database creation and cannot be altered afterwards. Is
> there a way to set this using the Database Configuration Assistant, or do I
> need to create the database manually?
>
> A related question: What is the optimal DB_BLOCK_SIZE setting for NT? I
> know the default is 2048, but what is optimal? I have heard that 8192 is
> ideal but I'm confused about whether NT can support that. Doesn't NT itself
> use 4096 byte blocks?
>
> Paul
>
> --
> Paul R. Woods
> Webmaster
> Interactive Intelligence, Inc.
> paulwoods_at_inter-intelli.com
> http://www.inter-intelli.com

--
Regards

Pete

Received on Fri Jul 16 1999 - 14:39:54 CDT