Re: AMD/64, SGA size

dm_at_belkam.com (Dmitry Melekhov) wrote in message news:<48f1f058.0406040229.549a78db_at_posting.google.com>...
> Hello!
>
> I can't get SGA size more that 1.7Gb on Mandrake 9.2/2.6.3
> with 9.2.0.4:
>
> SQL> startup
> ORACLE instance started.
>
> Total System Global Area 1796705872 bytes
> Fixed Size 745040 bytes
> Variable Size 1761607680 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 798720 bytes
> Database mounted.
> Database opened.
> SQL> alter system set shared_pool_size=1796705872;
> alter system set shared_pool_size=1796705872
> *
> ERROR at line 1:
> ORA-02097: parameter cannot be modified because specified value is invalid
> ORA-04033: Insufficient memory to grow pool
>
>
> shmmax value is very high
>
> any ideas?

I may be off my rocker asking this, or completely wrong, but, is the OS running in 32bit or 64bit mode? Or, did you install the 32bit version vs. the 64 bit of Oracle? I've seen this with the 32bit version of memory, to grow your SGA larger than 2GB, you need to use the 64 bit version.

HTH,
Pete's Received on Fri Jun 04 2004 - 11:04:44 CDT