Ask The Real Tom

July 28, 2010



ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device

Problem:


SQL> startup nomount
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device

There are 64G physical memoray avaliable.

shmmax is set to 52G

But still its not possibel to start the Oracle instance with more than 30G SGA.

Solution:

kernel.shmall is set to small.


cat /proc/sys/kernel/shmall
8248733
getconf PAGE_SIZE
4096

This means that only 8248733 memory pages can be allocate.

4096 x 8248733 = 32G



To allocate 50G we need to set shmall to at least 13107200

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress