RE: Setting db_32k_cache_size breaks 11.1.0.7
- From: "Andre van Winssen" <dreveewee@xxxxxxxxx>
- To: "'Greg Rahn'" <greg@xxxxxxxxxxxxxxxxxx>, <knecht.stefan@xxxxxxxxx>
- Date: Sun, 23 Nov 2008 09:19:19 +0100
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@xxxxxxxxxxxxxxxxxx]
Sent: zondag 23 november 2008 6:30
To: knecht.stefan@xxxxxxxxx
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@xxxxxxxxx>
wrote:
> I filed an SR this afternoon.
>
> Are you on 32-bit linux as well ?
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
