Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: What drives DB_BLOCK_SIZE
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
![]() |
![]() |