Re: What drives DB_BLOCK

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Wed, 12 Jan 2000 12:36:00 GMT
Message-ID: <387c6ff8.1728426@news-server>

On Tue, 11 Jan 2000 14:28:12 GMT, 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 ??
>

Heaps of considerations. But in general (and I stress the "general"), you can set the block size of the database to the block size of the OS without too much hassle. I think HP-UX 11.00 uses 4K file system block size. You can confirm this with Perl, there is a function that gives you the block size of the file system you're using.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Jan 12 2000 - 06:36:00 CST

Re: What drives DB_BLOCK_SIZE