Oracle Tips by Burleson

System Global Area (SGA) 

In some cases, the SGA may exceed the available shared memory segment size; if this occurs, the UNIX administrator must relink or reconfigure the kernel to allow larger programs. There are system-specific shared memory parameters that control the maximum size of the SGA. These should be reviewed under configurable kernel parameters for your version of UNIX. The installation guide for your Oracle system will delineate which parameters to look at for your UNIX system. Under the HP-UX implementation the size of the SGA is limited to the size of swap space on the available disk drives. On a Sun, True64, or HP-UX system, the parameters that control how the SGA grows are SHMMAX, the size of a shared memory area, and SHMSEG, the number of shared memory areas a process can access. On SuSE7.2 and RedHat Linux you can dynamically set the memory and semaphore processes or load them into the configuration header files and relink the kernel. On systems such as NT and AIX, you have no control over memory and semaphore parameters, as they are automatically set for you.

Expert Remote DBA BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call BC Remote DBA today.