How to set block size during DB creation??

From: Paul Woods <paulwoods_at_nospaminter-intelli.com>
Date: Fri, 16 Jul 1999 14:13:34 -0500
Message-ID: <wvLj3.130$n4.689@news1.iquest.net>

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 - 14:13:34 CDT