Re: What drives DB_BLOCK

From: Vincent Wittlin <vincent.wittlin_at_libertysurf.fr>
Date: Tue, 11 Jan 2000 17:12:15 +0100
Message-ID: <85fkg8$hrh$1@jaydee.iway.fr>

The kind of use drives de db_block_size

If you are creating an OLTP database, you will have a lot of little transactions
If you are creating Business Intelligence Database, you'll have less transactions and bigger

If your block size is too small, you'll have too much I/O Reads, but the proportion of usefull data will be high If your block size is too large, and you need only few bytes, you'll read too much data.

Usually, we use a 4Ko block for olpt database and 8ko for decisionnal ones.

<a_andy_at_my-deja.com> a écrit dans le message : 85felc$4fo$1_at_nnrp1.deja.com...
> I am installing Oracle 7.3.4 on HP-UX 10.20. I want to set an optimal
> DB_BLCOK_SIZE. What drives this decision ?? How can I decide whether to
> set 2k or 4k or 8k ?
>
> Would that change if I install 8i on HP-UX 11.00 ??
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 11 2000 - 10:12:15 CST

Re: What drives DB_BLOCK_SIZE