AMD64, SGA, offtopic 2004-06-04 - By Dmitry Melekhov
Zolotko A. Sergey wrote:
>Hi, Dmitry.
>
>You wrote 4.06.2004, 14:34:02:
>
>DM> Hello!
>
>DM> I can't get SGA size more that 1.7Gb on Mandrake 9.2/2.6.3
>DM> with 9.2.0.4:
>
>SQL>> startup
>DM> ORACLE instance started.
>
>DM> Total System Global Area 1796705872 bytes
>DM> Fixed Size 745040 bytes
>DM> Variable Size 1761607680 bytes
>DM> Database Buffers 33554432 bytes
>DM> Redo Buffers 798720 bytes
>DM> Database mounted.
>DM> Database opened.
>SQL>> alter system set shared_pool_size=1796705872;
>DM> alter system set shared_pool_size=1796705872
>DM> *
>DM> ERROR at line 1:
>DM> ORA-02097 (See ORA-02097.ora-code.com): parameter cannot be modified because specified value is invalid
>DM> ORA-04033 (See ORA-04033.ora-code.com): Insufficient memory to grow pool
>
>
>DM> shmmax value is very high.
>
>DM> May be this is Mandrake or 2.6.3 kernel? :-)
>
>DM> Or, may be I need to do something special? ;-)
>
>DM> any ideas?
>
>Check do you set SGA_MAX_SIZE.
>
Yes, it is high enough.
btw, when I try to start Oracle with lage shared pool I get:
SQL> startup
ORA-27123 (See ORA-27123.ora-code.com): unable to attach to shared memory segment
Linux-x86_64 Error: 22: Invalid argument
Additional information: 1
Additional information: 15269948
>But size shared_pool_size=1796705872 must be equal a multiple of
>granule size (16M in your case).
>
>
Thank you, but this doesn't help :-(
I guess that my problem is in my kernel (i.e. 2.6.3 from kernel.org,
well, with some patches), but don't shure.
Looks like I have to ask about Suse's kernel ( I mean it's difference
from kernel.org) in amd64 list.
>
>
>
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
