ora-27102 out of memory [message #526632] |
Wed, 12 October 2011 02:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
crussed_sonu
Messages: 51 Registered: July 2007 Location: Delhi
|
Member |
|
|
Hi All,
Getting Error .. when trying to startup the database with some changes in the SGA ..
Current Values :-
NAME TYPE VALUE
---------------------------------------------------------
sga_target big integer 0
sga_max_size big integer 1952M
pga_aggregate_target big integer 0
memory_target big integer 2G
memory_max_target big integer 2G
made below changes as below :-
sga_target=4092m
memory_target=4831838208
I suspect that the problem is the shmmax and/or the shmall kernel parameters. went through documentation but nothing is very specific in calculating the parameter values for a very large system.
free
total used free shared buffers cached
Mem: 16628888 15630272 998616 0 104416 9901472
-/+ buffers/cache: 5624384 11004504
Swap: 17434828 1698236 15736592
Paramter value for shmmax & shmall
kernel.shmmax = 4294967295
kernel.shmall = 268435456
We have 16GB of RAM ... and CPU E5620 @ 2.40GHz ...
I'm not sure what to set and what the impact could be if I just max out shmmax & shmall parameters.
please suguest how to proceed ..
Regards,
Vimlendu
|
|
|
|
|
|
Re: ora-27102 out of memory [message #526670 is a reply to message #526652] |
Wed, 12 October 2011 06:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You are using 32bit Linux. Using more than about 2.7G for Oracle is complicated. Much easy to reinstall the server, using 64bit Linux, and start again.
|
|
|
|
Re: ora-27102 out of memory [message #526684 is a reply to message #526680] |
Wed, 12 October 2011 08:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Well, you don't have to use a 64bit operating system. Instead you can compile and boot the hugemem linux kernel, configure hugepages, and start using indirect data buffers instead of automatic memory management.
I know what I would do.
|
|
|