AMD/64, SGA size

From: Dmitry Melekhov <dm_at_belkam.com>
Date: 4 Jun 2004 03:29:23 -0700
Message-ID: <48f1f058.0406040229.549a78db@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? Received on Fri Jun 04 2004 - 05:29:23 CDT