Re: DB_BLOCK_SIZE for WinNT4

From: roblop <roblop_at_friko2.onet.pl>
Date: 2000/04/19
Message-ID: <kSbL4.16272$hK2.323819@news.tpnet.pl>#1/1

The best solution is set size block in the same value as the size of cluster on patition.
Partitions must have the same size of clusters. Generally, if db_block_size is higher, reading is faster.

Roblop

K Stahl napisa³(a) w wiadomoœci: <38FCB65A.5EF9C893_at_Unforgetable.com>...
>As a DBA I have mostly worked on systems which were UNIX based and for the
>most part I have always recommended a DB_BLOCK_SIZE of 4096 for
>moderate-sized systems. I'm now starting to work with some Oracle 8
>databases on WinNT4 and one of my co-workers has said that his
>understanding is that 2048 is often a better choice on NT. Is this true?
>Would database performance be degraded if the database were recreated using
>4096?
>
>I have several good books on tuning oracle for UNIX. Does anyone know of
>any titles which specifically address tuning of Oracle 8 and 8i on NT
>systems?
Received on Wed Apr 19 2000 - 00:00:00 CDT