Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to set block size during DB creation??
There is a prompt during from DCA during the creation the process.
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
Received on Fri Jul 16 1999 - 21:20:06 CDT