Zolotko A. Sergey wrote:
>You wrote 4.06.2004, 14:34:02:
>DM> I can't get SGA size more that 1.7Gb on Mandrake 9.2/2.6.3
>DM> with 188.8.131.52:
>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> ERROR at line 1:
: parameter cannot be modified because specified value is invalid
: 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:
: 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