how can i enable multiple shared memory segments??
682358Mar 10 2009 — edited Mar 15 2009Hi
i have Solaris 10 SPARC machine with Oracle 10 Database.
physical memory size=4G
SGA size=1.2G
when Oracle statrup he is allocate one big memory segment of 1.2GB.
i want him to allocate multiple small segment.
how can i do this?
whenever i tried to define the SHMMAX to size smaller than the SGA, the ORacle refused to startup due to out of memory issue.
in the alert log i can see he is trying to alocate memory segment of 1.2GB and due to the small SHMMAX he refused to startup.
i've read in oracle forum and i found that in order to enable the multiple segment of Oracle i need to enable internal Oracle parameter which called enableNUMA_optimization.
its supposed to be TRUE by default but i guess it doesnt in my case.
i'm a little afraif to define this parameter in the spfile(or init.ora i dont know where i need to define it).
does it could be harmful?
if i will enable this parameter, and define the SHMMAX for 32MB for example, the Oracle actually allocat multiple segment size which their toal size will be the SGA size?
Please help!