RE: Setting db_32k_cache_size breaks

From: Andre van Winssen <>
Date: Sun, 23 Nov 2008 09:19:19 +0100
Message-ID: <002801c94d44$3075ef40$9161cdc0$@com>

Hi Greg,
But what about below

SQL> show parameter k_cache_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- -----
db_16k_cache_size                    big integer 0
db_2k_cache_size                     big integer 0
db_32k_cache_size                    big integer 0 <<
db_4k_cache_size                     big integer 0
db_8k_cache_size                     big integer 0

appearantly db_32k_cache_size is an allowed value.

more importantly: oracle database should never crash because of this request to add a 32K buffer cache. It should say: sorry pal, I can't support this request for a 32k buffer cache. No, instead it crashes and we have to pick up the pieces.

My tests were on EL5 32-bit.


-----Original Message-----
From: Greg Rahn [] Sent: zondag 23 november 2008 6:30
Cc: Andre van Winssen; oracle-l
Subject: Re: Setting db_32k_cache_size breaks

Linux does not support a 32k block size. 16k is the max. This is why you get:

ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid ORA-00382: 32768 not a valid block size, valid range [..]

On Sat, Nov 22, 2008 at 1:59 PM, Stefan Knecht <> wrote:
> I filed an SR this afternoon.
> Are you on 32-bit linux as well ?

Greg Rahn

Received on Sun Nov 23 2008 - 02:19:19 CST

Original text of this message