Large SGA’s and ORA-2710 on Linux X86_64

Sometimes when you try to enable large SGA’s on X86_64 linux you might run into ora-2710 errors when starting up the database. This could be because of low value being set for the linux kernel parameter shmall.

You should set the value for shmall as follows.

– Total up the sizes for SGA’s for all the databases you are going to run on the machine
– run the linux command getconf PAGE_SIZE to get your linux page size
– Set shmall equal to the sum of all the SGA’s on the system, divided by the page size

Review metalink note 301830.1 for more info.

Leave a Reply

Your email address will not be published. Required fields are marked *