Re: Increasing SGA

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Mon, 21 Sep 1998 21:32:43 -0700
Message-ID: <6u790e$1ov@dfw-ixnews5.ix.netcom.com>

Okey.. The first thing you need to check is a parameter called SHMMAX. On solaris, it is in /etc/system. Look for something like SHMSEG:SHMMAX in that file and see how big the parameter it set to be. This parameter is the maximum size of the memory segment that the system can get. You will want the SGA to be smaller than that parameter. I heard that if solaris, if you want to increase the SGA to more than 256MB (I read from the Oracle metalink..), you will have to rewrite the address of the memory segment, havn't tried that before, so not sure. Oracle suggest that the SGA to be around 1/3 or the acutally physical RAM of the system.

Hope it can help.
Winnie

justvrk_at_my-dejanews.com wrote in message <6u5d3f$k13$1_at_nnrp1.dejanews.com>...
>I am working on Oracle 8 loaded on to sun solaris.
>I am facing problems in increasing the size of SGA.
>whenever I change the settings in initefs02.ora (efs02 is the SID)
>I get an error while Database startup
> Shared memory realm already exists.
>Can anbody explain what this means. Also I need some standard steps to be
>followed while increasing the size of SGA
>Thanks in Advance..
>vrk.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Sep 21 1998 - 23:32:43 CDT