Re: AMD/64, SGA size

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 4 Jun 2004 22:02:56 +1000
Message-ID: <40c064dd$0$13783$afc38c87@news.optusnet.com.au>

"Dmitry Melekhov" <dm_at_belkam.com> 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?

And your SGA_MAX_SIZE is set to what?

Regards
HJR Received on Fri Jun 04 2004 - 07:02:56 CDT