RE: Setting db_32k_cache_size breaks 11.1.0.7

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.

Regards,
Andre

-----Original Message-----
From: Greg Rahn [mailto:greg_at_structureddata.org] Sent: zondag 23 november 2008 6:30
To: knecht.stefan_at_gmail.com
Cc: Andre van Winssen; oracle-l
Subject: Re: Setting db_32k_cache_size breaks 11.1.0.7

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 <knecht.stefan_at_gmail.com> wrote:
> I filed an SR this afternoon.
>
> Are you on 32-bit linux as well ?

-- 
Regards,
Greg Rahn
http://structureddata.org

--
http://www.freelists.org/webpage/oracle-l