Re: What drives DB_BLOCK_SIZE

From: Andreas Michler <Andreas.Michler_at_adicom.de>
Date: Tue, 11 Jan 2000 16:25:25 +0100
Message-ID: <387B4B65.86126D34@adicom.de>

The DB_BLOCK_SIZE should be as large as your largest record in your database.
If it is too small oracle must splitt records into several database blocks.

a_andy_at_my-deja.com wrote:

> 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.

--

---

ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-57,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de

---

Received on Tue Jan 11 2000 - 09:25:25 CST